Symfony Profiler

SELECT
  t0.ip AS ip_1,
  t0.data AS data_2,
  t0.updated_at AS updated_at_3,
  t0.expires_at AS expires_at_4
FROM
  geo_ip_cache t0
WHERE
  t0.ip = ?

SELECT t0.ip AS ip_1, t0.data AS data_2, t0.updated_at AS updated_at_3, t0.expires_at AS expires_at_4 FROM geo_ip_cache t0 WHERE t0.ip = '66.249.79.237';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.active AS active_4,
  t0.sort_order AS sort_order_5,
  t0.is_default AS is_default_6
FROM
  delivery_type t0
WHERE
  t0.is_default = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6 FROM delivery_type t0 WHERE t0.is_default = 1 AND t0.active = 1 LIMIT 1;

SELECT
  t0.slug AS slug_1,
  t0.entity_type AS entity_type_2,
  t0.entity_id AS entity_id_3,
  t0.target_path AS target_path_4,
  t0.http_code AS http_code_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  url_rewrite t0
WHERE
  t0.slug = ?

SELECT t0.slug AS slug_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.target_path AS target_path_4, t0.http_code AS http_code_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM url_rewrite t0 WHERE t0.slug = 'valeri-5-shar';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.sort_order AS sort_order_3,
  p0_.effective_price AS effective_price_4,
  p0_.status AS status_5,
  p0_.type AS type_6,
  p0_.quantity AS quantity_7,
  p0_.options_json AS options_json_8,
  p0_.attribute_json AS attribute_json_9,
  p0_.code AS code_10,
  p0_.description AS description_11,
  p0_.similar_group_id AS similar_group_id_12,
  p0_.price AS price_13,
  p0_.sale_price AS sale_price_14,
  p0_.currency AS currency_15,
  p0_.date_added AS date_added_16,
  p0_.date_edited AS date_edited_17,
  p1_.meta_title AS meta_title_18,
  p1_.meta_description AS meta_description_19,
  p1_.meta_keywords AS meta_keywords_20,
  p1_.h1 AS h1_21,
  p0_.manufacturer_id AS manufacturer_id_22,
  p0_.series_id AS series_id_23,
  p1_.product_id AS product_id_24
FROM
  product p0_
  LEFT JOIN product_seo p1_ ON p0_.id = p1_.product_id
WHERE
  p0_.slug = ?
  AND p0_.status = 1
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sort_order AS sort_order_3, p0_.effective_price AS effective_price_4, p0_.status AS status_5, p0_.type AS type_6, p0_.quantity AS quantity_7, p0_.options_json AS options_json_8, p0_.attribute_json AS attribute_json_9, p0_.code AS code_10, p0_.description AS description_11, p0_.similar_group_id AS similar_group_id_12, p0_.price AS price_13, p0_.sale_price AS sale_price_14, p0_.currency AS currency_15, p0_.date_added AS date_added_16, p0_.date_edited AS date_edited_17, p1_.meta_title AS meta_title_18, p1_.meta_description AS meta_description_19, p1_.meta_keywords AS meta_keywords_20, p1_.h1 AS h1_21, p0_.manufacturer_id AS manufacturer_id_22, p0_.series_id AS series_id_23, p1_.product_id AS product_id_24 FROM product p0_ LEFT JOIN product_seo p1_ ON p0_.id = p1_.product_id WHERE p0_.slug = 'valeri-5-shar' AND p0_.status = 1 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.data_type AS data_type_1,
  p0_.string_value AS string_value_2,
  p0_.text_value AS text_value_3,
  p0_.int_value AS int_value_4,
  p0_.decimal_value AS decimal_value_5,
  p0_.bool_value AS bool_value_6,
  p0_.date_value AS date_value_7,
  p0_.json_value AS json_value_8,
  p0_.unit AS unit_9,
  p0_.position AS position_10,
  p0_.sort_order AS sort_order_11,
  a1_.id AS id_12,
  a1_.name AS name_13,
  a1_.sort_order AS sort_order_14,
  a1_.code AS code_15,
  a2_.id AS id_16,
  a2_.name AS name_17,
  a2_.sort_order AS sort_order_18,
  a2_.show_in_category AS show_in_category_19,
  a2_.short_name AS short_name_20,
  a2_.code AS code_21,
  p0_.product_id AS product_id_22,
  p0_.attribute_id AS attribute_id_23,
  p0_.attribute_group_id AS attribute_group_id_24,
  a2_.attribute_group_id AS attribute_group_id_25
FROM
  product_attribute_assignment p0_
  LEFT JOIN attribute_group a1_ ON p0_.attribute_group_id = a1_.id
  LEFT JOIN attribute a2_ ON p0_.attribute_id = a2_.id
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0, p0_.data_type AS data_type_1, p0_.string_value AS string_value_2, p0_.text_value AS text_value_3, p0_.int_value AS int_value_4, p0_.decimal_value AS decimal_value_5, p0_.bool_value AS bool_value_6, p0_.date_value AS date_value_7, p0_.json_value AS json_value_8, p0_.unit AS unit_9, p0_.position AS position_10, p0_.sort_order AS sort_order_11, a1_.id AS id_12, a1_.name AS name_13, a1_.sort_order AS sort_order_14, a1_.code AS code_15, a2_.id AS id_16, a2_.name AS name_17, a2_.sort_order AS sort_order_18, a2_.show_in_category AS show_in_category_19, a2_.short_name AS short_name_20, a2_.code AS code_21, p0_.product_id AS product_id_22, p0_.attribute_id AS attribute_id_23, p0_.attribute_group_id AS attribute_group_id_24, a2_.attribute_group_id AS attribute_group_id_25 FROM product_attribute_assignment p0_ LEFT JOIN attribute_group a1_ ON p0_.attribute_group_id = a1_.id LEFT JOIN attribute a2_ ON p0_.attribute_id = a2_.id WHERE p0_.product_id = 108;

SELECT
  t0.id AS id_1,
  t0.data_type AS data_type_2,
  t0.string_value AS string_value_3,
  t0.text_value AS text_value_4,
  t0.int_value AS int_value_5,
  t0.decimal_value AS decimal_value_6,
  t0.bool_value AS bool_value_7,
  t0.date_value AS date_value_8,
  t0.json_value AS json_value_9,
  t0.unit AS unit_10,
  t0.position AS position_11,
  t0.sort_order AS sort_order_12,
  t0.product_id AS product_id_13,
  t0.attribute_id AS attribute_id_14,
  t0.attribute_group_id AS attribute_group_id_15
FROM
  product_attribute_assignment t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.data_type AS data_type_2, t0.string_value AS string_value_3, t0.text_value AS text_value_4, t0.int_value AS int_value_5, t0.decimal_value AS decimal_value_6, t0.bool_value AS bool_value_7, t0.date_value AS date_value_8, t0.json_value AS json_value_9, t0.unit AS unit_10, t0.position AS position_11, t0.sort_order AS sort_order_12, t0.product_id AS product_id_13, t0.attribute_id AS attribute_id_14, t0.attribute_group_id AS attribute_group_id_15 FROM product_attribute_assignment t0 WHERE t0.product_id = 108;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sort_order_3,
      sort_order_20
    FROM
      (
        SELECT
          DISTINCT p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.slug AS slug_2,
          p0_.sort_order AS sort_order_3,
          p0_.effective_price AS effective_price_4,
          p0_.status AS status_5,
          p0_.type AS type_6,
          p0_.quantity AS quantity_7,
          p0_.options_json AS options_json_8,
          p0_.attribute_json AS attribute_json_9,
          p0_.code AS code_10,
          p0_.description AS description_11,
          p0_.similar_group_id AS similar_group_id_12,
          p0_.price AS price_13,
          p0_.sale_price AS sale_price_14,
          p0_.currency AS currency_15,
          p0_.date_added AS date_added_16,
          p0_.date_edited AS date_edited_17,
          p1_.id AS id_18,
          p1_.image_url AS image_url_19,
          p1_.sort_order AS sort_order_20,
          p2_.id AS id_21,
          p2_.height AS height_22,
          p2_.price AS price_23,
          p2_.set_price AS set_price_24,
          p2_.bulbs_count AS bulbs_count_25,
          p2_.lighting_area AS lighting_area_26,
          p2_.sku AS sku_27,
          p2_.attributes AS attributes_28,
          p2_.original_sku AS original_sku_29,
          p2_.sale_price AS sale_price_30,
          p2_.sort_order AS sort_order_31,
          p2_.quantity AS quantity_32,
          p3_.id AS id_33,
          p3_.is_parent AS is_parent_34,
          p3_.position AS position_35,
          p3_.visibility AS visibility_36
        FROM
          product p0_
          INNER JOIN product_to_category p3_ ON p0_.id = p3_.product_id
          LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id
          LEFT JOIN product_option_value_assignment p2_ ON p0_.id = p2_.product_id
          AND (p2_.quantity > 0)
        WHERE
          p3_.category_id = ?
          AND p3_.visibility = 1
          AND p0_.status = 1
          AND (
            (
              p0_.type <> ?
              OR p2_.id IS NOT NULL
            )
          )
        ORDER BY
          p1_.sort_order ASC,
          p2_.sort_order ASC,
          p2_.id ASC
      ) dctrn_result_inner
    ORDER BY
      sort_order_3 ASC,
      sort_order_20 ASC
  ) dctrn_result
LIMIT
  11

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sort_order_3, sort_order_20 FROM (SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sort_order AS sort_order_3, p0_.effective_price AS effective_price_4, p0_.status AS status_5, p0_.type AS type_6, p0_.quantity AS quantity_7, p0_.options_json AS options_json_8, p0_.attribute_json AS attribute_json_9, p0_.code AS code_10, p0_.description AS description_11, p0_.similar_group_id AS similar_group_id_12, p0_.price AS price_13, p0_.sale_price AS sale_price_14, p0_.currency AS currency_15, p0_.date_added AS date_added_16, p0_.date_edited AS date_edited_17, p1_.id AS id_18, p1_.image_url AS image_url_19, p1_.sort_order AS sort_order_20, p2_.id AS id_21, p2_.height AS height_22, p2_.price AS price_23, p2_.set_price AS set_price_24, p2_.bulbs_count AS bulbs_count_25, p2_.lighting_area AS lighting_area_26, p2_.sku AS sku_27, p2_.attributes AS attributes_28, p2_.original_sku AS original_sku_29, p2_.sale_price AS sale_price_30, p2_.sort_order AS sort_order_31, p2_.quantity AS quantity_32, p3_.id AS id_33, p3_.is_parent AS is_parent_34, p3_.position AS position_35, p3_.visibility AS visibility_36 FROM product p0_ INNER JOIN product_to_category p3_ ON p0_.id = p3_.product_id LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id LEFT JOIN product_option_value_assignment p2_ ON p0_.id = p2_.product_id AND (p2_.quantity > 0) WHERE p3_.category_id = 10 AND p3_.visibility = 1 AND p0_.status = 1 AND ((p0_.type <> 'variable' OR p2_.id IS NOT NULL)) ORDER BY p1_.sort_order ASC, p2_.sort_order ASC, p2_.id ASC) dctrn_result_inner ORDER BY sort_order_3 ASC, sort_order_20 ASC) dctrn_result LIMIT 11;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.sort_order AS sort_order_3,
  p0_.effective_price AS effective_price_4,
  p0_.status AS status_5,
  p0_.type AS type_6,
  p0_.quantity AS quantity_7,
  p0_.options_json AS options_json_8,
  p0_.attribute_json AS attribute_json_9,
  p0_.code AS code_10,
  p0_.description AS description_11,
  p0_.similar_group_id AS similar_group_id_12,
  p0_.price AS price_13,
  p0_.sale_price AS sale_price_14,
  p0_.currency AS currency_15,
  p0_.date_added AS date_added_16,
  p0_.date_edited AS date_edited_17,
  p1_.id AS id_18,
  p1_.image_url AS image_url_19,
  p1_.sort_order AS sort_order_20,
  p0_.manufacturer_id AS manufacturer_id_21,
  p0_.series_id AS series_id_22,
  p1_.product_id AS product_id_23
FROM
  product p0_
  INNER JOIN product_to_category p2_ ON p0_.id = p2_.product_id
  LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id
  LEFT JOIN product_option_value_assignment p3_ ON p0_.id = p3_.product_id
  AND (p3_.quantity > 0)
WHERE
  p2_.category_id = ?
  AND p2_.visibility = 1
  AND p0_.status = 1
  AND (
    (
      p0_.type <> ?
      OR p3_.id IS NOT NULL
    )
  )
  AND p0_.id IN (?, ?, ?, ?)
ORDER BY
  p0_.sort_order ASC,
  p1_.sort_order ASC

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sort_order AS sort_order_3, p0_.effective_price AS effective_price_4, p0_.status AS status_5, p0_.type AS type_6, p0_.quantity AS quantity_7, p0_.options_json AS options_json_8, p0_.attribute_json AS attribute_json_9, p0_.code AS code_10, p0_.description AS description_11, p0_.similar_group_id AS similar_group_id_12, p0_.price AS price_13, p0_.sale_price AS sale_price_14, p0_.currency AS currency_15, p0_.date_added AS date_added_16, p0_.date_edited AS date_edited_17, p1_.id AS id_18, p1_.image_url AS image_url_19, p1_.sort_order AS sort_order_20, p0_.manufacturer_id AS manufacturer_id_21, p0_.series_id AS series_id_22, p1_.product_id AS product_id_23 FROM product p0_ INNER JOIN product_to_category p2_ ON p0_.id = p2_.product_id LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id LEFT JOIN product_option_value_assignment p3_ ON p0_.id = p3_.product_id AND (p3_.quantity > 0) WHERE p2_.category_id = 10 AND p2_.visibility = 1 AND p0_.status = 1 AND ((p0_.type <> 'variable' OR p3_.id IS NOT NULL)) AND p0_.id IN (108, 109, 110, 111) ORDER BY p0_.sort_order ASC, p1_.sort_order ASC;

SELECT
  t0.meta_title AS meta_title_1,
  t0.meta_description AS meta_description_2,
  t0.meta_keywords AS meta_keywords_3,
  t0.h1 AS h1_4,
  t0.product_id AS product_id_5
FROM
  product_seo t0
WHERE
  t0.product_id = ?

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 109;

SELECT
  t0.meta_title AS meta_title_1,
  t0.meta_description AS meta_description_2,
  t0.meta_keywords AS meta_keywords_3,
  t0.h1 AS h1_4,
  t0.product_id AS product_id_5
FROM
  product_seo t0
WHERE
  t0.product_id = ?

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 111;

SELECT
  t0.meta_title AS meta_title_1,
  t0.meta_description AS meta_description_2,
  t0.meta_keywords AS meta_keywords_3,
  t0.h1 AS h1_4,
  t0.product_id AS product_id_5
FROM
  product_seo t0
WHERE
  t0.product_id = ?

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 110;

SELECT
  COUNT(*)
FROM
  product_to_category t0
WHERE
  t0.product_id = ?

SELECT COUNT(*) FROM product_to_category t0 WHERE t0.product_id = 108;

SELECT
  t0.id AS id_1,
  t0.is_parent AS is_parent_2,
  t0.position AS position_3,
  t0.visibility AS visibility_4,
  t0.product_id AS product_id_5,
  t0.category_id AS category_id_6
FROM
  product_to_category t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 108;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.visibility AS visibility_4,
  t0.parent_category_id AS parent_category_id_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.meta_keywords AS meta_keywords_8,
  t0.sort_order AS sort_order_9,
  t0.meta_h1 AS meta_h1_10,
  t0.description AS description_11,
  t0.navbar_visibility AS navbar_visibility_12,
  t0.footer_visibility AS footer_visibility_13
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.visibility AS visibility_4, t0.parent_category_id AS parent_category_id_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.meta_keywords AS meta_keywords_8, t0.sort_order AS sort_order_9, t0.meta_h1 AS meta_h1_10, t0.description AS description_11, t0.navbar_visibility AS navbar_visibility_12, t0.footer_visibility AS footer_visibility_13 FROM category t0 WHERE t0.id = 4;

SELECT
  r0_.id AS id_0,
  r0_.author_name AS author_name_1,
  r0_.rating AS rating_2,
  r0_.comment AS comment_3,
  r0_.pros AS pros_4,
  r0_.cons AS cons_5,
  r0_.status AS status_6,
  r0_.ip_address AS ip_address_7,
  r0_.created_at AS created_at_8,
  r0_.updated_at AS updated_at_9,
  r0_.product_id AS product_id_10,
  r0_.author_id AS author_id_11
FROM
  reviews r0_
WHERE
  r0_.product_id = ?
  AND r0_.status = ?
ORDER BY
  r0_.created_at DESC

SELECT r0_.id AS id_0, r0_.author_name AS author_name_1, r0_.rating AS rating_2, r0_.comment AS comment_3, r0_.pros AS pros_4, r0_.cons AS cons_5, r0_.status AS status_6, r0_.ip_address AS ip_address_7, r0_.created_at AS created_at_8, r0_.updated_at AS updated_at_9, r0_.product_id AS product_id_10, r0_.author_id AS author_id_11 FROM reviews r0_ WHERE r0_.product_id = 108 AND r0_.status = 1 ORDER BY r0_.created_at DESC;

SELECT
  m0_.id AS id_0,
  m0_.entity_type AS entity_type_1,
  m0_.template_type AS template_type_2,
  m0_.template AS template_3,
  m0_.priority AS priority_4,
  m0_.conditions AS conditions_5,
  m0_.is_active AS is_active_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8
FROM
  meta_template m0_
WHERE
  m0_.entity_type = ?
  AND m0_.template_type = ?
  AND m0_.is_active = ?
ORDER BY
  m0_.priority DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.entity_type AS entity_type_1, m0_.template_type AS template_type_2, m0_.template AS template_3, m0_.priority AS priority_4, m0_.conditions AS conditions_5, m0_.is_active AS is_active_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8 FROM meta_template m0_ WHERE m0_.entity_type = 'product' AND m0_.template_type = 'description' AND m0_.is_active = 1 ORDER BY m0_.priority DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.visibility AS visibility_3,
  c0_.parent_category_id AS parent_category_id_4,
  c0_.meta_title AS meta_title_5,
  c0_.meta_description AS meta_description_6,
  c0_.meta_keywords AS meta_keywords_7,
  c0_.sort_order AS sort_order_8,
  c0_.meta_h1 AS meta_h1_9,
  c0_.description AS description_10,
  c0_.navbar_visibility AS navbar_visibility_11,
  c0_.footer_visibility AS footer_visibility_12
FROM
  category c0_
WHERE
  c0_.navbar_visibility = ?
  AND c0_.visibility = ?
  AND c0_.name IS NOT NULL
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.visibility AS visibility_3, c0_.parent_category_id AS parent_category_id_4, c0_.meta_title AS meta_title_5, c0_.meta_description AS meta_description_6, c0_.meta_keywords AS meta_keywords_7, c0_.sort_order AS sort_order_8, c0_.meta_h1 AS meta_h1_9, c0_.description AS description_10, c0_.navbar_visibility AS navbar_visibility_11, c0_.footer_visibility AS footer_visibility_12 FROM category c0_ WHERE c0_.navbar_visibility = 1 AND c0_.visibility = 1 AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC;