Symfony Profiler

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;

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 = 'kassandra-6-2-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 = 134;

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 = 'kassandra-6-2-shar';

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

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.color AS color_4,
  t0.sort_order AS sort_order_5
FROM
  badge t0
  INNER JOIN product_badge ON t0.id = product_badge.badge_id
WHERE
  product_badge.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.color AS color_4, t0.sort_order AS sort_order_5 FROM badge t0 INNER JOIN product_badge ON t0.id = product_badge.badge_id WHERE product_badge.product_id = 134;

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_.footer_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_.footer_visibility = 1 AND c0_.visibility = 1 AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.image_url AS image_url_2,
  t0.sort_order AS sort_order_3,
  t0.product_id AS product_id_4
FROM
  product_image t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 134 ORDER BY t0.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.height AS height_2,
  t0.price AS price_3,
  t0.set_price AS set_price_4,
  t0.bulbs_count AS bulbs_count_5,
  t0.lighting_area AS lighting_area_6,
  t0.sku AS sku_7,
  t0.attributes AS attributes_8,
  t0.original_sku AS original_sku_9,
  t0.sale_price AS sale_price_10,
  t0.sort_order AS sort_order_11,
  t0.quantity AS quantity_12,
  t0.product_id AS product_id_13,
  t0.option_id AS option_id_14,
  t0.value_id AS value_id_15
FROM
  product_option_value_assignment t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.sort_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.height AS height_2, t0.price AS price_3, t0.set_price AS set_price_4, t0.bulbs_count AS bulbs_count_5, t0.lighting_area AS lighting_area_6, t0.sku AS sku_7, t0.attributes AS attributes_8, t0.original_sku AS original_sku_9, t0.sale_price AS sale_price_10, t0.sort_order AS sort_order_11, t0.quantity AS quantity_12, t0.product_id AS product_id_13, t0.option_id AS option_id_14, t0.value_id AS value_id_15 FROM product_option_value_assignment t0 WHERE t0.product_id = 134 ORDER BY t0.sort_order ASC, t0.id ASC;

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 = 134 AND r0_.status = 1 ORDER BY r0_.created_at DESC;

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
  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 = 134;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort_order AS sort_order_3,
  t0.code AS code_4
FROM
  `option` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.code AS code_4 FROM `option` t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.sort_order AS sort_order_3,
  t0.code AS code_4,
  t0.option_id AS option_id_5
FROM
  option_value t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_order AS sort_order_3, t0.code AS code_4, t0.option_id AS option_id_5 FROM option_value t0 WHERE t0.id = 11;

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 = 134;

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

SELECT COUNT(*) FROM product_video t0 WHERE t0.product_id = 134;