Symfony Profiler

SELECT
  p0_.id AS id_0,
  p1_.name AS name_1,
  v2_.id AS id_2,
  v3_.name AS name_3
FROM
  product p4_
  LEFT JOIN product_category p6_ ON p4_.id = p6_.product_id
  LEFT JOIN category c5_ ON c5_.id = p6_.category_id
  LEFT JOIN category c7_ ON c5_.parent_id = c7_.id
  LEFT JOIN category c8_ ON c7_.parent_id = c8_.id
  INNER JOIN product_variant p9_ ON p4_.id = p9_.product_id
  INNER JOIN variant_properties v10_ ON p9_.id = v10_.variant_id
  INNER JOIN value v2_ ON v2_.id = v10_.value_id
  INNER JOIN property p0_ ON v2_.property_id = p0_.id
  LEFT JOIN property_translations p1_ ON p0_.id = p1_.translatable_id
  LEFT JOIN value_translations v3_ ON v2_.id = v3_.translatable_id
WHERE
  c5_.id = ?
  OR c5_.parent_id = ?
  OR c7_.parent_id = ?
ORDER BY
  p1_.name ASC,
  v3_.name ASC

SELECT p0_.id AS id_0, p1_.name AS name_1, v2_.id AS id_2, v3_.name AS name_3 FROM product p4_ LEFT JOIN product_category p6_ ON p4_.id = p6_.product_id LEFT JOIN category c5_ ON c5_.id = p6_.category_id LEFT JOIN category c7_ ON c5_.parent_id = c7_.id LEFT JOIN category c8_ ON c7_.parent_id = c8_.id INNER JOIN product_variant p9_ ON p4_.id = p9_.product_id INNER JOIN variant_properties v10_ ON p9_.id = v10_.variant_id INNER JOIN value v2_ ON v2_.id = v10_.value_id INNER JOIN property p0_ ON v2_.property_id = p0_.id LEFT JOIN property_translations p1_ ON p0_.id = p1_.translatable_id LEFT JOIN value_translations v3_ ON v2_.id = v3_.translatable_id WHERE c5_.id = 312 OR c5_.parent_id = 312 OR c7_.parent_id = 312 ORDER BY p1_.name ASC, v3_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.is_new AS is_new_3,
  p0_.is_popular AS is_popular_4,
  p0_.width AS width_5,
  p0_.length AS length_6,
  p0_.business_id AS business_id_7,
  p0_.is_active AS is_active_8,
  p0_.is_sold AS is_sold_9,
  p0_.sold_date AS sold_date_10,
  p0_.is_enabled AS is_enabled_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.brand_id AS brand_id_14
FROM
  product p0_
  LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id
  LEFT JOIN category c1_ ON c1_.id = p2_.category_id
  LEFT JOIN category c3_ ON c1_.parent_id = c3_.id
  LEFT JOIN product_variant p4_ ON p0_.id = p4_.product_id
  LEFT JOIN product_translations p5_ ON p0_.id = p5_.translatable_id
  LEFT JOIN variant_properties v7_ ON p4_.id = v7_.variant_id
  LEFT JOIN value v6_ ON v6_.id = v7_.value_id
  LEFT JOIN property p8_ ON v6_.property_id = p8_.id
WHERE
  (
    (
      p0_.is_active = 1
      AND c1_.id = ?
    )
    OR c1_.parent_id = ?
    OR c3_.parent_id = ?
  )
  AND p0_.is_enabled = 1

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.is_new AS is_new_3, p0_.is_popular AS is_popular_4, p0_.width AS width_5, p0_.length AS length_6, p0_.business_id AS business_id_7, p0_.is_active AS is_active_8, p0_.is_sold AS is_sold_9, p0_.sold_date AS sold_date_10, p0_.is_enabled AS is_enabled_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.brand_id AS brand_id_14 FROM product p0_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id LEFT JOIN category c3_ ON c1_.parent_id = c3_.id LEFT JOIN product_variant p4_ ON p0_.id = p4_.product_id LEFT JOIN product_translations p5_ ON p0_.id = p5_.translatable_id LEFT JOIN variant_properties v7_ ON p4_.id = v7_.variant_id LEFT JOIN value v6_ ON v6_.id = v7_.value_id LEFT JOIN property p8_ ON v6_.property_id = p8_.id WHERE ((p0_.is_active = 1 AND c1_.id = 312) OR c1_.parent_id = 312 OR c3_.parent_id = 312) AND p0_.is_enabled = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.left_id AS left_id_4,
  t0.right_id AS right_id_5,
  t0.level AS level_6,
  t0.business_key AS business_key_7,
  t0.show_in_main_page AS show_in_main_page_8,
  t0.is_enabled AS is_enabled_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.parent_id AS parent_id_12,
  t0.media_id AS media_id_13
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.left_id ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.left_id AS left_id_4, t0.right_id AS right_id_5, t0.level AS level_6, t0.business_key AS business_key_7, t0.show_in_main_page AS show_in_main_page_8, t0.is_enabled AS is_enabled_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.media_id AS media_id_13 FROM category t0 WHERE t0.parent_id = 120 ORDER BY t0.left_id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.description AS description_5,
  t0.seo_text AS seo_text_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  category_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.description AS description_5, t0.seo_text AS seo_text_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM category_translations t0 WHERE t0.translatable_id = 120;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.left_id AS left_id_4,
  t0.right_id AS right_id_5,
  t0.level AS level_6,
  t0.business_key AS business_key_7,
  t0.show_in_main_page AS show_in_main_page_8,
  t0.is_enabled AS is_enabled_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.parent_id AS parent_id_12,
  t0.media_id AS media_id_13
FROM
  category t0
  INNER JOIN product_category ON t0.id = product_category.category_id
WHERE
  product_category.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.left_id AS left_id_4, t0.right_id AS right_id_5, t0.level AS level_6, t0.business_key AS business_key_7, t0.show_in_main_page AS show_in_main_page_8, t0.is_enabled AS is_enabled_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.media_id AS media_id_13 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 552742;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552742;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.description AS description_5,
  t0.short_description AS short_description_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  product_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_translations t0 WHERE t0.translatable_id = 552742;

SELECT
  t0.id AS id_1,
  t0.media_id AS media_id_2,
  t0.product_id AS product_id_3
FROM
  product_gallery t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.product_id AS product_id_3 FROM product_gallery t0 WHERE t0.product_id = 552742;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 12365345;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.left_id AS left_id_3,
  c0_.right_id AS right_id_4,
  c0_.level AS level_5,
  c0_.business_key AS business_key_6,
  c0_.show_in_main_page AS show_in_main_page_7,
  c0_.is_enabled AS is_enabled_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.parent_id AS parent_id_11,
  c0_.media_id AS media_id_12
FROM
  category c0_
WHERE
  c0_.is_enabled = ?
ORDER BY
  c0_.left_id ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.left_id AS left_id_3, c0_.right_id AS right_id_4, c0_.level AS level_5, c0_.business_key AS business_key_6, c0_.show_in_main_page AS show_in_main_page_7, c0_.is_enabled AS is_enabled_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.parent_id AS parent_id_11, c0_.media_id AS media_id_12 FROM category c0_ WHERE c0_.is_enabled = 1 ORDER BY c0_.left_id ASC;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.left_id AS left_id_3,
  c0_.right_id AS right_id_4,
  c0_.level AS level_5,
  c0_.business_key AS business_key_6,
  c0_.show_in_main_page AS show_in_main_page_7,
  c0_.is_enabled AS is_enabled_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.parent_id AS parent_id_11,
  c0_.media_id AS media_id_12
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.slug = ?
  AND c0_.is_enabled = 1

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.left_id AS left_id_3, c0_.right_id AS right_id_4, c0_.level AS level_5, c0_.business_key AS business_key_6, c0_.show_in_main_page AS show_in_main_page_7, c0_.is_enabled AS is_enabled_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.parent_id AS parent_id_11, c0_.media_id AS media_id_12 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.slug = 'ghom' AND c0_.is_enabled = 1;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.left_id AS left_id_3,
  c0_.right_id AS right_id_4,
  c0_.level AS level_5,
  c0_.business_key AS business_key_6,
  c0_.show_in_main_page AS show_in_main_page_7,
  c0_.is_enabled AS is_enabled_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.parent_id AS parent_id_11,
  c0_.media_id AS media_id_12
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.is_enabled = ?
ORDER BY
  c0_.left_id ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.left_id AS left_id_3, c0_.right_id AS right_id_4, c0_.level AS level_5, c0_.business_key AS business_key_6, c0_.show_in_main_page AS show_in_main_page_7, c0_.is_enabled AS is_enabled_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.parent_id AS parent_id_11, c0_.media_id AS media_id_12 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.is_enabled = 1 ORDER BY c0_.left_id ASC;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2
FROM
  static_page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2 FROM static_page t0 WHERE t0.slug = 'ghom' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.invoice_amount AS invoice_amount_2,
  t0.invoice_amount_net AS invoice_amount_net_3,
  t0.order_time AS order_time_4,
  t0.transaction_id AS transaction_id_5,
  t0.comment AS comment_6,
  t0.is_quick_buy AS is_quick_buy_7,
  t0.user_id AS user_id_8,
  t0.order_billing_address_id AS order_billing_address_id_9,
  t0.coupon_id AS coupon_id_10
FROM
  `order` t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.invoice_amount AS invoice_amount_2, t0.invoice_amount_net AS invoice_amount_net_3, t0.order_time AS order_time_4, t0.transaction_id AS transaction_id_5, t0.comment AS comment_6, t0.is_quick_buy AS is_quick_buy_7, t0.user_id AS user_id_8, t0.order_billing_address_id AS order_billing_address_id_9, t0.coupon_id AS coupon_id_10 FROM `order` t0 WHERE t0.id IS NULL LIMIT 1;