Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.query AS query_4,
  t0.keyword AS keyword_5,
  t0.archived AS archived_6,
  t0.language_id AS language_id_7,
  t0.domain_id AS domain_id_8
FROM
  seo_url t0
WHERE
  t0.query = ?
  AND t0.language_id = ?
  AND t0.archived = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = 'product_id=2932' AND t0.language_id = 1 AND t0.archived = 0 LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.created AS created_1,
  r0_.updated AS updated_2,
  r0_.updated_by_time AS updated_by_time_3,
  r0_.type AS type_4,
  r0_.name AS name_5,
  r0_.text AS text_6,
  r0_.stars AS stars_7,
  r0_.approved AS approved_8,
  r0_.show_at_homepage AS show_at_homepage_9,
  r0_.created_by AS created_by_10,
  r0_.updated_by AS updated_by_11,
  r0_.language_id AS language_id_12,
  r0_.product_id AS product_id_13,
  r0_.customer_id AS customer_id_14,
  r0_.order_id AS order_id_15
FROM
  reviews r0_
  LEFT JOIN products p1_ ON r0_.product_id = p1_.id
WHERE
  r0_.type = ?
  AND p1_.name = ?
  AND r0_.language_id IN (?, ?)
  AND r0_.approved = 1
ORDER BY
  r0_.created DESC

SELECT r0_.id AS id_0, r0_.created AS created_1, r0_.updated AS updated_2, r0_.updated_by_time AS updated_by_time_3, r0_.type AS type_4, r0_.name AS name_5, r0_.text AS text_6, r0_.stars AS stars_7, r0_.approved AS approved_8, r0_.show_at_homepage AS show_at_homepage_9, r0_.created_by AS created_by_10, r0_.updated_by AS updated_by_11, r0_.language_id AS language_id_12, r0_.product_id AS product_id_13, r0_.customer_id AS customer_id_14, r0_.order_id AS order_id_15 FROM reviews r0_ LEFT JOIN products p1_ ON r0_.product_id = p1_.id WHERE r0_.type = 2 AND p1_.name = 'Z24i' AND r0_.language_id IN (1, 3) AND r0_.approved = 1 ORDER BY r0_.created DESC;

SELECT
  d0_.id AS id_0,
  d0_.created AS created_1,
  d0_.updated AS updated_2,
  d0_.sort_index AS sort_index_3,
  d0_.type AS type_4,
  d0_.name AS name_5,
  d0_.currency AS currency_6,
  d0_.price_factor AS price_factor_7,
  d0_.price_precision AS price_precision_8,
  d0_.price_end AS price_end_9,
  d0_.price_end2 AS price_end2_10,
  d0_.price_end2_under AS price_end2_under_11,
  d0_.vat AS vat_12,
  d0_.warranty AS warranty_13,
  d0_.url AS url_14,
  d0_.title AS title_15,
  d0_.short_title AS short_title_16,
  d0_.ga_id AS ga_id_17,
  d0_.blog_url AS blog_url_18,
  d0_.facebook_url AS facebook_url_19,
  d0_.twitter_url AS twitter_url_20,
  d0_.youtube_url AS youtube_url_21,
  d0_.gplus_url AS gplus_url_22,
  d0_.livechat_username AS livechat_username_23,
  d0_.javascripts AS javascripts_24,
  l1_.id AS id_25,
  l1_.created AS created_26,
  l1_.updated AS updated_27,
  l1_.sort_index AS sort_index_28,
  l1_.code AS code_29,
  l1_.name AS name_30,
  t2_.id AS id_31,
  t2_.created AS created_32,
  t2_.updated AS updated_33,
  t2_.tr_key AS tr_key_34,
  t2_.value AS value_35,
  d0_.language_id AS language_id_36,
  d0_.company_id AS company_id_37,
  d0_.default_sales_manager_id AS default_sales_manager_id_38,
  t2_.language_id AS language_id_39
FROM
  domains d0_
  LEFT JOIN languages l1_ ON d0_.language_id = l1_.id
  LEFT JOIN translations t2_ ON l1_.id = t2_.language_id
WHERE
  d0_.id = ?

SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.sort_index AS sort_index_3, d0_.type AS type_4, d0_.name AS name_5, d0_.currency AS currency_6, d0_.price_factor AS price_factor_7, d0_.price_precision AS price_precision_8, d0_.price_end AS price_end_9, d0_.price_end2 AS price_end2_10, d0_.price_end2_under AS price_end2_under_11, d0_.vat AS vat_12, d0_.warranty AS warranty_13, d0_.url AS url_14, d0_.title AS title_15, d0_.short_title AS short_title_16, d0_.ga_id AS ga_id_17, d0_.blog_url AS blog_url_18, d0_.facebook_url AS facebook_url_19, d0_.twitter_url AS twitter_url_20, d0_.youtube_url AS youtube_url_21, d0_.gplus_url AS gplus_url_22, d0_.livechat_username AS livechat_username_23, d0_.javascripts AS javascripts_24, l1_.id AS id_25, l1_.created AS created_26, l1_.updated AS updated_27, l1_.sort_index AS sort_index_28, l1_.code AS code_29, l1_.name AS name_30, t2_.id AS id_31, t2_.created AS created_32, t2_.updated AS updated_33, t2_.tr_key AS tr_key_34, t2_.value AS value_35, d0_.language_id AS language_id_36, d0_.company_id AS company_id_37, d0_.default_sales_manager_id AS default_sales_manager_id_38, t2_.language_id AS language_id_39 FROM domains d0_ LEFT JOIN languages l1_ ON d0_.language_id = l1_.id LEFT JOIN translations t2_ ON l1_.id = t2_.language_id WHERE d0_.id = 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.updated_by_time AS updated_by_time_4,
  t0.title AS title_5,
  t0.long_title AS long_title_6,
  t0.private AS private_7,
  t0.in_short_desc AS in_short_desc_8,
  t0.archived AS archived_9,
  t0.sort_index AS sort_index_10,
  t0.created_by AS created_by_11,
  t0.updated_by AS updated_by_12,
  t0.attribute_id AS attribute_id_13,
  t0.parent_id AS parent_id_14,
  t0.product_id AS product_id_15
FROM
  attribute_options t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.title AS title_5, t0.long_title AS long_title_6, t0.private AS private_7, t0.in_short_desc AS in_short_desc_8, t0.archived AS archived_9, t0.sort_index AS sort_index_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.attribute_id AS attribute_id_13, t0.parent_id AS parent_id_14, t0.product_id AS product_id_15 FROM attribute_options t0 WHERE t0.id = 204;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.updated_by_time AS updated_by_time_4,
  t0.omega_plu AS omega_plu_5,
  t0.code AS code_6,
  t0.name AS name_7,
  t0.warranty AS warranty_8,
  t0.part_number AS part_number_9,
  t0.ean AS ean_10,
  t0.gtin AS gtin_11,
  t0.amazon_code AS amazon_code_12,
  t0.length AS length_13,
  t0.width AS width_14,
  t0.height AS height_15,
  t0.weight AS weight_16,
  t0.unit AS unit_17,
  t0.badges AS badges_18,
  t0.detail AS detail_19,
  t0.stock_position AS stock_position_20,
  t0.out_of_stock_status AS out_of_stock_status_21,
  t0.quality_status AS quality_status_22,
  t0.sold_out_date AS sold_out_date_23,
  t0.cache_description AS cache_description_24,
  t0.cache_item_last_updated AS cache_item_last_updated_25,
  t0.available AS available_26,
  t0.in_stock AS in_stock_27,
  t0.archived AS archived_28,
  t0.scannable AS scannable_29,
  t0.last_price AS last_price_30,
  t0.avg_price AS avg_price_31,
  t0.container AS container_32,
  t0.last_sale AS last_sale_33,
  t0.cpu_mark AS cpu_mark_34,
  t0.spare_part_card AS spare_part_card_35,
  t0.spare_part_price AS spare_part_price_36,
  t0.sold_during_time_frame AS sold_during_time_frame_37,
  t0.spare_part_created AS spare_part_created_38,
  t0.spare_part_updated AS spare_part_updated_39,
  t0.margin_level AS margin_level_40,
  t0.quantity_limit AS quantity_limit_41,
  t0.availability_paused_for_product_model AS availability_paused_for_product_model_42,
  t0.last_qty_calculated_for_marketplaces AS last_qty_calculated_for_marketplaces_43,
  t0.calculated_qty_grade_new AS calculated_qty_grade_new_44,
  t0.calculated_qty_grade_a AS calculated_qty_grade_a_45,
  t0.calculated_qty_grade_b AS calculated_qty_grade_b_46,
  t0.calculated_qty_grade_c AS calculated_qty_grade_c_47,
  t0.calculated_qty_grade_d AS calculated_qty_grade_d_48,
  t0.calculated_qty_date AS calculated_qty_date_49,
  t0.created_by AS created_by_50,
  t0.updated_by AS updated_by_51,
  t0.vendor_id AS vendor_id_52,
  t0.type_id AS type_id_53,
  t0.photo_album_id AS photo_album_id_54,
  t0.current_alternative_product_id AS current_alternative_product_id_55,
  t0.product_model_id AS product_model_id_56,
  t0.spare_part_created_by AS spare_part_created_by_57,
  t0.spare_part_updated_by AS spare_part_updated_by_58,
  t0.fixed_attribute_option_combination_id AS fixed_attribute_option_combination_id_59
FROM
  products t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.omega_plu AS omega_plu_5, t0.code AS code_6, t0.name AS name_7, t0.warranty AS warranty_8, t0.part_number AS part_number_9, t0.ean AS ean_10, t0.gtin AS gtin_11, t0.amazon_code AS amazon_code_12, t0.length AS length_13, t0.width AS width_14, t0.height AS height_15, t0.weight AS weight_16, t0.unit AS unit_17, t0.badges AS badges_18, t0.detail AS detail_19, t0.stock_position AS stock_position_20, t0.out_of_stock_status AS out_of_stock_status_21, t0.quality_status AS quality_status_22, t0.sold_out_date AS sold_out_date_23, t0.cache_description AS cache_description_24, t0.cache_item_last_updated AS cache_item_last_updated_25, t0.available AS available_26, t0.in_stock AS in_stock_27, t0.archived AS archived_28, t0.scannable AS scannable_29, t0.last_price AS last_price_30, t0.avg_price AS avg_price_31, t0.container AS container_32, t0.last_sale AS last_sale_33, t0.cpu_mark AS cpu_mark_34, t0.spare_part_card AS spare_part_card_35, t0.spare_part_price AS spare_part_price_36, t0.sold_during_time_frame AS sold_during_time_frame_37, t0.spare_part_created AS spare_part_created_38, t0.spare_part_updated AS spare_part_updated_39, t0.margin_level AS margin_level_40, t0.quantity_limit AS quantity_limit_41, t0.availability_paused_for_product_model AS availability_paused_for_product_model_42, t0.last_qty_calculated_for_marketplaces AS last_qty_calculated_for_marketplaces_43, t0.calculated_qty_grade_new AS calculated_qty_grade_new_44, t0.calculated_qty_grade_a AS calculated_qty_grade_a_45, t0.calculated_qty_grade_b AS calculated_qty_grade_b_46, t0.calculated_qty_grade_c AS calculated_qty_grade_c_47, t0.calculated_qty_grade_d AS calculated_qty_grade_d_48, t0.calculated_qty_date AS calculated_qty_date_49, t0.created_by AS created_by_50, t0.updated_by AS updated_by_51, t0.vendor_id AS vendor_id_52, t0.type_id AS type_id_53, t0.photo_album_id AS photo_album_id_54, t0.current_alternative_product_id AS current_alternative_product_id_55, t0.product_model_id AS product_model_id_56, t0.spare_part_created_by AS spare_part_created_by_57, t0.spare_part_updated_by AS spare_part_updated_by_58, t0.fixed_attribute_option_combination_id AS fixed_attribute_option_combination_id_59 FROM products t0 WHERE t0.id = 2932;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.price AS price_4,
  t0.suggested_price AS suggested_price_5,
  t0.current_vat_price AS current_vat_price_6,
  t0.discount AS discount_7,
  t0.discounted AS discounted_8,
  t0.active AS active_9,
  t0.listed AS listed_10,
  t0.orderable AS orderable_11,
  t0.vat AS vat_12,
  t0.warranty AS warranty_13,
  t0.bazaar AS bazaar_14,
  t0.best_seller AS best_seller_15,
  t0.re_lenovo AS re_lenovo_16,
  t0.hp_renew AS hp_renew_17,
  t0.special_promotion AS special_promotion_18,
  t0.detail AS detail_19,
  t0.sale_start AS sale_start_20,
  t0.sale_end AS sale_end_21,
  t0.activation_date AS activation_date_22,
  t0.discounted_date AS discounted_date_23,
  t0.flash_sale_date AS flash_sale_date_24,
  t0.domain_id AS domain_id_25,
  t0.product_id AS product_id_26
FROM
  products__metas t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.price AS price_4, t0.suggested_price AS suggested_price_5, t0.current_vat_price AS current_vat_price_6, t0.discount AS discount_7, t0.discounted AS discounted_8, t0.active AS active_9, t0.listed AS listed_10, t0.orderable AS orderable_11, t0.vat AS vat_12, t0.warranty AS warranty_13, t0.bazaar AS bazaar_14, t0.best_seller AS best_seller_15, t0.re_lenovo AS re_lenovo_16, t0.hp_renew AS hp_renew_17, t0.special_promotion AS special_promotion_18, t0.detail AS detail_19, t0.sale_start AS sale_start_20, t0.sale_end AS sale_end_21, t0.activation_date AS activation_date_22, t0.discounted_date AS discounted_date_23, t0.flash_sale_date AS flash_sale_date_24, t0.domain_id AS domain_id_25, t0.product_id AS product_id_26 FROM products__metas t0 WHERE t0.product_id = 2932;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.sort_index AS sort_index_4,
  t0.type AS type_5,
  t0.name AS name_6,
  t0.currency AS currency_7,
  t0.price_factor AS price_factor_8,
  t0.price_precision AS price_precision_9,
  t0.price_end AS price_end_10,
  t0.price_end2 AS price_end2_11,
  t0.price_end2_under AS price_end2_under_12,
  t0.vat AS vat_13,
  t0.warranty AS warranty_14,
  t0.url AS url_15,
  t0.title AS title_16,
  t0.short_title AS short_title_17,
  t0.ga_id AS ga_id_18,
  t0.blog_url AS blog_url_19,
  t0.facebook_url AS facebook_url_20,
  t0.twitter_url AS twitter_url_21,
  t0.youtube_url AS youtube_url_22,
  t0.gplus_url AS gplus_url_23,
  t0.livechat_username AS livechat_username_24,
  t0.javascripts AS javascripts_25,
  t0.language_id AS language_id_26,
  t0.company_id AS company_id_27,
  t0.default_sales_manager_id AS default_sales_manager_id_28
FROM
  domains t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.sort_index AS sort_index_4,
  t0.type AS type_5,
  t0.name AS name_6,
  t0.currency AS currency_7,
  t0.price_factor AS price_factor_8,
  t0.price_precision AS price_precision_9,
  t0.price_end AS price_end_10,
  t0.price_end2 AS price_end2_11,
  t0.price_end2_under AS price_end2_under_12,
  t0.vat AS vat_13,
  t0.warranty AS warranty_14,
  t0.url AS url_15,
  t0.title AS title_16,
  t0.short_title AS short_title_17,
  t0.ga_id AS ga_id_18,
  t0.blog_url AS blog_url_19,
  t0.facebook_url AS facebook_url_20,
  t0.twitter_url AS twitter_url_21,
  t0.youtube_url AS youtube_url_22,
  t0.gplus_url AS gplus_url_23,
  t0.livechat_username AS livechat_username_24,
  t0.javascripts AS javascripts_25,
  t0.language_id AS language_id_26,
  t0.company_id AS company_id_27,
  t0.default_sales_manager_id AS default_sales_manager_id_28
FROM
  domains t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.updated_by_time AS updated_by_time_4,
  t0.type AS type_5,
  t0.title AS title_6,
  t0.help_file AS help_file_7,
  t0.sort_index AS sort_index_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10
FROM
  attributes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.type AS type_5, t0.title AS title_6, t0.help_file AS help_file_7, t0.sort_index AS sort_index_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attributes t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.query AS query_4,
  t0.keyword AS keyword_5,
  t0.archived AS archived_6,
  t0.language_id AS language_id_7,
  t0.domain_id AS domain_id_8
FROM
  seo_url t0
WHERE
  t0.query = ?
  AND t0.language_id = ?
  AND t0.domain_id = ?
  AND t0.archived = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = 'static_id=50' AND t0.language_id = 1 AND t0.domain_id = 1 AND t0.archived = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.updated_by_time AS updated_by_time_4,
  t0.text AS text_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.product_model_id AS product_model_id_8,
  t0.language_id AS language_id_9
FROM
  product_model_metas t0
WHERE
  t0.product_model_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.text AS text_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.product_model_id AS product_model_id_8, t0.language_id AS language_id_9 FROM product_model_metas t0 WHERE t0.product_model_id = 11211;

SELECT
  c0_.id AS id_0,
  c0_.created AS created_1,
  c0_.updated AS updated_2,
  c0_.updated_by_time AS updated_by_time_3,
  c0_.code AS code_4,
  c0_.enabled AS enabled_5,
  c0_.description AS description_6,
  c0_.valid_form AS valid_form_7,
  c0_.valid_to AS valid_to_8,
  c0_.discount_type AS discount_type_9,
  c0_.discount AS discount_10,
  c0_.total AS total_11,
  c0_.available_for_discounted_products AS available_for_discounted_products_12,
  c0_.only_once_use AS only_once_use_13,
  c0_.only_once_customer_use AS only_once_customer_use_14,
  c0_.free_shipping AS free_shipping_15,
  c0_.product_tags AS product_tags_16,
  c0_.show_badge_on_website AS show_badge_on_website_17,
  c0_.created_by AS created_by_18,
  c0_.updated_by AS updated_by_19,
  c0_.domain_id AS domain_id_20
FROM
  coupons c0_
  INNER JOIN coupons__product_types c2_ ON c0_.id = c2_.coupon_id
  INNER JOIN product_types p1_ ON p1_.id = c2_.product_type_id
WHERE
  c0_.show_badge_on_website = 1
  AND c0_.domain_id = ?
  AND (
    (
      c0_.valid_form IS NULL
      OR c0_.valid_form < ?
    )
  )
  AND (
    (
      c0_.valid_to IS NULL
      OR c0_.valid_to > ?
    )
  )
  AND p1_.id IN (?)

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.updated AS updated_2, c0_.updated_by_time AS updated_by_time_3, c0_.code AS code_4, c0_.enabled AS enabled_5, c0_.description AS description_6, c0_.valid_form AS valid_form_7, c0_.valid_to AS valid_to_8, c0_.discount_type AS discount_type_9, c0_.discount AS discount_10, c0_.total AS total_11, c0_.available_for_discounted_products AS available_for_discounted_products_12, c0_.only_once_use AS only_once_use_13, c0_.only_once_customer_use AS only_once_customer_use_14, c0_.free_shipping AS free_shipping_15, c0_.product_tags AS product_tags_16, c0_.show_badge_on_website AS show_badge_on_website_17, c0_.created_by AS created_by_18, c0_.updated_by AS updated_by_19, c0_.domain_id AS domain_id_20 FROM coupons c0_ INNER JOIN coupons__product_types c2_ ON c0_.id = c2_.coupon_id INNER JOIN product_types p1_ ON p1_.id = c2_.product_type_id WHERE c0_.show_badge_on_website = 1 AND c0_.domain_id = 1 AND ((c0_.valid_form IS NULL OR c0_.valid_form < '2026-10-11 01:54:41')) AND ((c0_.valid_to IS NULL OR c0_.valid_to > '2026-10-11 01:54:41')) AND p1_.id IN (44);

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reviews r0_
WHERE
  r0_.language_id IN (?, ?)
  AND r0_.type = ?
  AND r0_.approved = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM reviews r0_ WHERE r0_.language_id IN (1, 3) AND r0_.type = 2 AND r0_.approved = 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.tr_key AS tr_key_4,
  t0.value AS value_5,
  t0.language_id AS language_id_6
FROM
  translations t0
WHERE
  t0.language_id = ?
  AND t0.tr_key = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.tr_key AS tr_key_4, t0.value AS value_5, t0.language_id AS language_id_6 FROM translations t0 WHERE t0.language_id = 1 AND t0.tr_key = '1920 x 1200';

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.created AS created_1,
  r0_.updated AS updated_2,
  r0_.updated_by_time AS updated_by_time_3,
  r0_.type AS type_4,
  r0_.name AS name_5,
  r0_.text AS text_6,
  r0_.stars AS stars_7,
  r0_.approved AS approved_8,
  r0_.show_at_homepage AS show_at_homepage_9,
  r0_.created_by AS created_by_10,
  r0_.updated_by AS updated_by_11,
  r0_.language_id AS language_id_12,
  r0_.product_id AS product_id_13,
  r0_.customer_id AS customer_id_14,
  r0_.order_id AS order_id_15
FROM
  reviews r0_
  LEFT JOIN review_survey_media r1_ ON r0_.id = r1_.review_id
WHERE
  r0_.language_id IN (?, ?)
  AND r0_.type = ?
  AND r0_.approved = ?
  AND r1_.id IS NOT NULL
  AND r1_.approved = 1
  AND r0_.show_at_homepage = 1
ORDER BY
  r0_.created DESC
LIMIT
  5

SELECT DISTINCT r0_.id AS id_0, r0_.created AS created_1, r0_.updated AS updated_2, r0_.updated_by_time AS updated_by_time_3, r0_.type AS type_4, r0_.name AS name_5, r0_.text AS text_6, r0_.stars AS stars_7, r0_.approved AS approved_8, r0_.show_at_homepage AS show_at_homepage_9, r0_.created_by AS created_by_10, r0_.updated_by AS updated_by_11, r0_.language_id AS language_id_12, r0_.product_id AS product_id_13, r0_.customer_id AS customer_id_14, r0_.order_id AS order_id_15 FROM reviews r0_ LEFT JOIN review_survey_media r1_ ON r0_.id = r1_.review_id WHERE r0_.language_id IN (1, 3) AND r0_.type = 2 AND r0_.approved = 1 AND r1_.id IS NOT NULL AND r1_.approved = 1 AND r0_.show_at_homepage = 1 ORDER BY r0_.created DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.used AS used_4,
  t0.multiplier AS multiplier_5,
  t0.always AS always_6,
  t0.product_id AS product_id_7,
  t0.option_id AS option_id_8
FROM
  products__attributes t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.used AS used_4, t0.multiplier AS multiplier_5, t0.always AS always_6, t0.product_id AS product_id_7, t0.option_id AS option_id_8 FROM products__attributes t0 WHERE t0.product_id = 2932;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.updated_by_time AS updated_by_time_4,
  t0.status AS status_5,
  t0.payment_status AS payment_status_6,
  t0.invoice_code AS invoice_code_7,
  t0.payment_type AS payment_type_8,
  t0.payment_price AS payment_price_9,
  t0.shipping_type AS shipping_type_10,
  t0.shipping_price AS shipping_price_11,
  t0.billing_first_name AS billing_first_name_12,
  t0.billing_last_name AS billing_last_name_13,
  t0.billing_business_name AS billing_business_name_14,
  t0.billing_street AS billing_street_15,
  t0.billing_city AS billing_city_16,
  t0.billing_zip AS billing_zip_17,
  t0.billing_country AS billing_country_18,
  t0.billing_business_id AS billing_business_id_19,
  t0.billing_tax_id AS billing_tax_id_20,
  t0.billing_vat_id AS billing_vat_id_21,
  t0.billing_email AS billing_email_22,
  t0.billing_phone_number AS billing_phone_number_23,
  t0.shipping_first_name AS shipping_first_name_24,
  t0.shipping_last_name AS shipping_last_name_25,
  t0.shipping_business_name AS shipping_business_name_26,
  t0.shipping_street AS shipping_street_27,
  t0.shipping_city AS shipping_city_28,
  t0.shipping_zip AS shipping_zip_29,
  t0.shipping_country AS shipping_country_30,
  t0.shipping_email AS shipping_email_31,
  t0.shipping_phone_number AS shipping_phone_number_32,
  t0.message AS message_33,
  t0.coupon_code AS coupon_code_34,
  t0.ship_date AS ship_date_35,
  t0.planned_ship_date AS planned_ship_date_36,
  t0.delivery_date AS delivery_date_37,
  t0.box_count AS box_count_38,
  t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_39,
  t0.full_price AS full_price_40,
  t0.presta_order_code AS presta_order_code_41,
  t0.external_order_source AS external_order_source_42,
  t0.external_order_code AS external_order_code_43,
  t0.message_done AS message_done_44,
  t0.message_done_time AS message_done_time_45,
  t0.force_free_shipping AS force_free_shipping_46,
  t0.warranty AS warranty_47,
  t0.created_by_type AS created_by_type_48,
  t0.archived AS archived_49,
  t0.discount AS discount_50,
  t0.tracking_url AS tracking_url_51,
  t0.parcelNumber AS parcelNumber_52,
  t0.dhlShipmentNumber AS dhlShipmentNumber_53,
  t0.parcelStatus AS parcelStatus_54,
  t0.priority AS priority_55,
  t0.base_order_id AS base_order_id_56,
  t0.vat AS vat_57,
  t0.created_by AS created_by_58,
  t0.updated_by AS updated_by_59,
  t0.domain_id AS domain_id_60,
  t0.customer_id AS customer_id_61,
  t0.message_done_by AS message_done_by_62
FROM
  orders t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.status AS status_5, t0.payment_status AS payment_status_6, t0.invoice_code AS invoice_code_7, t0.payment_type AS payment_type_8, t0.payment_price AS payment_price_9, t0.shipping_type AS shipping_type_10, t0.shipping_price AS shipping_price_11, t0.billing_first_name AS billing_first_name_12, t0.billing_last_name AS billing_last_name_13, t0.billing_business_name AS billing_business_name_14, t0.billing_street AS billing_street_15, t0.billing_city AS billing_city_16, t0.billing_zip AS billing_zip_17, t0.billing_country AS billing_country_18, t0.billing_business_id AS billing_business_id_19, t0.billing_tax_id AS billing_tax_id_20, t0.billing_vat_id AS billing_vat_id_21, t0.billing_email AS billing_email_22, t0.billing_phone_number AS billing_phone_number_23, t0.shipping_first_name AS shipping_first_name_24, t0.shipping_last_name AS shipping_last_name_25, t0.shipping_business_name AS shipping_business_name_26, t0.shipping_street AS shipping_street_27, t0.shipping_city AS shipping_city_28, t0.shipping_zip AS shipping_zip_29, t0.shipping_country AS shipping_country_30, t0.shipping_email AS shipping_email_31, t0.shipping_phone_number AS shipping_phone_number_32, t0.message AS message_33, t0.coupon_code AS coupon_code_34, t0.ship_date AS ship_date_35, t0.planned_ship_date AS planned_ship_date_36, t0.delivery_date AS delivery_date_37, t0.box_count AS box_count_38, t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_39, t0.full_price AS full_price_40, t0.presta_order_code AS presta_order_code_41, t0.external_order_source AS external_order_source_42, t0.external_order_code AS external_order_code_43, t0.message_done AS message_done_44, t0.message_done_time AS message_done_time_45, t0.force_free_shipping AS force_free_shipping_46, t0.warranty AS warranty_47, t0.created_by_type AS created_by_type_48, t0.archived AS archived_49, t0.discount AS discount_50, t0.tracking_url AS tracking_url_51, t0.parcelNumber AS parcelNumber_52, t0.dhlShipmentNumber AS dhlShipmentNumber_53, t0.parcelStatus AS parcelStatus_54, t0.priority AS priority_55, t0.base_order_id AS base_order_id_56, t0.vat AS vat_57, t0.created_by AS created_by_58, t0.updated_by AS updated_by_59, t0.domain_id AS domain_id_60, t0.customer_id AS customer_id_61, t0.message_done_by AS message_done_by_62 FROM orders t0 WHERE t0.id = 202464144;