Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.usual_quantity AS usual_quantity_5,
  t0.buying_price AS buying_price_6,
  t0.price_ht AS price_ht_7,
  t0.price_ttc AS price_ttc_8,
  t0.unit AS unit_9,
  t0.is_stock AS is_stock_10,
  t0.is_declination AS is_declination_11,
  t0.created_at AS created_at_12,
  t0.uuid AS uuid_13,
  t0.information AS information_14,
  t0.is_archived AS is_archived_15,
  t0.deleted_at AS deleted_at_16,
  t0.reason_of_delete AS reason_of_delete_17,
  t0.best_selection AS best_selection_18,
  t0.show_in_web_site AS show_in_web_site_19,
  t0.categories_id AS categories_id_20,
  t0.tva_id AS tva_id_21,
  t0.promotion_id AS promotion_id_22
FROM
  produit t0
WHERE
  t0.categories_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.description AS description_4, t0.usual_quantity AS usual_quantity_5, t0.buying_price AS buying_price_6, t0.price_ht AS price_ht_7, t0.price_ttc AS price_ttc_8, t0.unit AS unit_9, t0.is_stock AS is_stock_10, t0.is_declination AS is_declination_11, t0.created_at AS created_at_12, t0.uuid AS uuid_13, t0.information AS information_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.reason_of_delete AS reason_of_delete_17, t0.best_selection AS best_selection_18, t0.show_in_web_site AS show_in_web_site_19, t0.categories_id AS categories_id_20, t0.tva_id AS tva_id_21, t0.promotion_id AS promotion_id_22 FROM produit t0 WHERE t0.categories_id = 93;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.`order` AS order_4,
  t0.`homepage_order` AS homepage_order_5,
  t0.show_in_homepage AS show_in_homepage_6,
  t0.show_in_menu AS show_in_menu_7,
  t0.is_active AS is_active_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.`order` ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = 2 ORDER BY t0.`order` ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.footer_logo AS footer_logo_4,
  t0.address AS address_5,
  t0.region AS region_6,
  t0.tva AS tva_7,
  t0.mail AS mail_8,
  t0.website AS website_9,
  t0.phone AS phone_10,
  t0.mobile AS mobile_11,
  t0.title AS title_12,
  t0.description AS description_13,
  t0.keywords AS keywords_14,
  t0.social_links AS social_links_15,
  t0.updated_at AS updated_at_16
FROM
  company t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.footer_logo AS footer_logo_4, t0.address AS address_5, t0.region AS region_6, t0.tva AS tva_7, t0.mail AS mail_8, t0.website AS website_9, t0.phone AS phone_10, t0.mobile AS mobile_11, t0.title AS title_12, t0.description AS description_13, t0.keywords AS keywords_14, t0.social_links AS social_links_15, t0.updated_at AS updated_at_16 FROM company t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.`order` AS order_4,
  t0.`homepage_order` AS homepage_order_5,
  t0.show_in_homepage AS show_in_homepage_6,
  t0.show_in_menu AS show_in_menu_7,
  t0.is_active AS is_active_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.parent_id IS NULL
  AND t0.is_active = ?
ORDER BY
  t0.`order` ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id IS NULL AND t0.is_active = '1' ORDER BY t0.`order` ASC;

SELECT
  DISTINCT v0_.id AS id_0,
  v0_.name AS name_1
FROM
  value_declination v0_
  INNER JOIN group_declination_value g1_ ON (v0_.id = g1_.value_id)
  INNER JOIN produit_declination_value p2_ ON (
    g1_.produit_declination_id = p2_.id
  )
  INNER JOIN produit p3_ ON (p2_.produit_id = p3_.id)
WHERE
  g1_.declination_id = ?
  AND p3_.deleted_at IS NULL
  AND p3_.show_in_web_site = 1
  AND p3_.categories_id IN (?)
ORDER BY
  v0_.name ASC

SELECT DISTINCT v0_.id AS id_0, v0_.name AS name_1 FROM value_declination v0_ INNER JOIN group_declination_value g1_ ON (v0_.id = g1_.value_id) INNER JOIN produit_declination_value p2_ ON (g1_.produit_declination_id = p2_.id) INNER JOIN produit p3_ ON (p2_.produit_id = p3_.id) WHERE g1_.declination_id = 1 AND p3_.deleted_at IS NULL AND p3_.show_in_web_site = 1 AND p3_.categories_id IN (2) ORDER BY v0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.`order` AS order_4,
  t0.`homepage_order` AS homepage_order_5,
  t0.show_in_homepage AS show_in_homepage_6,
  t0.show_in_menu AS show_in_menu_7,
  t0.is_active AS is_active_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = '2';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3
FROM
  declination t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM declination t0 WHERE t0.id = 1;

SELECT
  DISTINCT CASE WHEN v0_.parent_id IS NULL THEN v0_.id ELSE v0_.parent_id END AS sclr_0,
  CASE WHEN v0_.parent_id IS NULL THEN v0_.name ELSE v1_.name END AS sclr_1,
  CASE WHEN v0_.parent_id IS NULL THEN v0_.code ELSE v1_.code END AS sclr_2
FROM
  value_declination v0_
  LEFT JOIN value_declination v1_ ON v0_.parent_id = v1_.id
  AND (v0_.parent_id = v1_.id)
  INNER JOIN group_declination_value g2_ ON (v0_.id = g2_.value_id)
  INNER JOIN produit_declination_value p3_ ON (
    g2_.produit_declination_id = p3_.id
  )
  INNER JOIN produit p4_ ON (p3_.produit_id = p4_.id)
WHERE
  g2_.declination_id = ?
  AND p4_.deleted_at IS NULL
  AND p4_.show_in_web_site = 1
  AND p4_.categories_id IN (?)
GROUP BY
  v0_.id
ORDER BY
  v0_.name ASC

SELECT DISTINCT CASE WHEN v0_.parent_id IS NULL THEN v0_.id ELSE v0_.parent_id END AS sclr_0, CASE WHEN v0_.parent_id IS NULL THEN v0_.name ELSE v1_.name END AS sclr_1, CASE WHEN v0_.parent_id IS NULL THEN v0_.code ELSE v1_.code END AS sclr_2 FROM value_declination v0_ LEFT JOIN value_declination v1_ ON v0_.parent_id = v1_.id AND (v0_.parent_id = v1_.id) INNER JOIN group_declination_value g2_ ON (v0_.id = g2_.value_id) INNER JOIN produit_declination_value p3_ ON (g2_.produit_declination_id = p3_.id) INNER JOIN produit p4_ ON (p3_.produit_id = p4_.id) WHERE g2_.declination_id = 2 AND p4_.deleted_at IS NULL AND p4_.show_in_web_site = 1 AND p4_.categories_id IN (2) GROUP BY v0_.id ORDER BY v0_.name ASC;