Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.name AS name_2,
  p0_.description AS description_3,
  p0_.usual_quantity AS usual_quantity_4,
  p0_.buying_price AS buying_price_5,
  p0_.price_ht AS price_ht_6,
  p0_.price_ttc AS price_ttc_7,
  p0_.unit AS unit_8,
  p0_.is_stock AS is_stock_9,
  p0_.is_declination AS is_declination_10,
  p0_.created_at AS created_at_11,
  p0_.uuid AS uuid_12,
  p0_.information AS information_13,
  p0_.is_archived AS is_archived_14,
  p0_.deleted_at AS deleted_at_15,
  p0_.reason_of_delete AS reason_of_delete_16,
  p0_.best_selection AS best_selection_17,
  p0_.show_in_web_site AS show_in_web_site_18,
  p0_.categories_id AS categories_id_19,
  p0_.tva_id AS tva_id_20,
  p0_.promotion_id AS promotion_id_21
FROM
  produit p0_
  INNER JOIN produit_declination_value p1_ ON (p1_.produit_id = p0_.id)
  INNER JOIN document_declination_produit d2_ ON (
    d2_.produit_declination_value_id = p1_.id
  )
WHERE
  p0_.deleted_at IS NULL
  AND d2_.created_at >= ?
  AND p0_.show_in_web_site = 1
GROUP BY
  p0_.id
ORDER BY
  count(p0_.id) DESC
LIMIT
  50

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.name AS name_2, p0_.description AS description_3, p0_.usual_quantity AS usual_quantity_4, p0_.buying_price AS buying_price_5, p0_.price_ht AS price_ht_6, p0_.price_ttc AS price_ttc_7, p0_.unit AS unit_8, p0_.is_stock AS is_stock_9, p0_.is_declination AS is_declination_10, p0_.created_at AS created_at_11, p0_.uuid AS uuid_12, p0_.information AS information_13, p0_.is_archived AS is_archived_14, p0_.deleted_at AS deleted_at_15, p0_.reason_of_delete AS reason_of_delete_16, p0_.best_selection AS best_selection_17, p0_.show_in_web_site AS show_in_web_site_18, p0_.categories_id AS categories_id_19, p0_.tva_id AS tva_id_20, p0_.promotion_id AS promotion_id_21 FROM produit p0_ INNER JOIN produit_declination_value p1_ ON (p1_.produit_id = p0_.id) INNER JOIN document_declination_produit d2_ ON (d2_.produit_declination_value_id = p1_.id) WHERE p0_.deleted_at IS NULL AND d2_.created_at >= '2025-11-09 23:39:12' AND p0_.show_in_web_site = 1 GROUP BY p0_.id ORDER BY count(p0_.id) DESC LIMIT 50;

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 = 93 ORDER BY t0.`order` ASC;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_file ON t0.id = produit_file.file_id
WHERE
  produit_file.produit_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_file ON t0.id = produit_file.file_id WHERE produit_file.produit_id = 1348;

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
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.name AS name_2,
  p0_.description AS description_3,
  p0_.usual_quantity AS usual_quantity_4,
  p0_.buying_price AS buying_price_5,
  p0_.price_ht AS price_ht_6,
  p0_.price_ttc AS price_ttc_7,
  p0_.unit AS unit_8,
  p0_.is_stock AS is_stock_9,
  p0_.is_declination AS is_declination_10,
  p0_.created_at AS created_at_11,
  p0_.uuid AS uuid_12,
  p0_.information AS information_13,
  p0_.is_archived AS is_archived_14,
  p0_.deleted_at AS deleted_at_15,
  p0_.reason_of_delete AS reason_of_delete_16,
  p0_.best_selection AS best_selection_17,
  p0_.show_in_web_site AS show_in_web_site_18,
  p0_.categories_id AS categories_id_19,
  p0_.tva_id AS tva_id_20,
  p0_.promotion_id AS promotion_id_21
FROM
  produit p0_
WHERE
  p0_.created_at >= ?
  AND p0_.deleted_at IS NULL
  AND p0_.show_in_web_site = 1
ORDER BY
  p0_.created_at DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.name AS name_2, p0_.description AS description_3, p0_.usual_quantity AS usual_quantity_4, p0_.buying_price AS buying_price_5, p0_.price_ht AS price_ht_6, p0_.price_ttc AS price_ttc_7, p0_.unit AS unit_8, p0_.is_stock AS is_stock_9, p0_.is_declination AS is_declination_10, p0_.created_at AS created_at_11, p0_.uuid AS uuid_12, p0_.information AS information_13, p0_.is_archived AS is_archived_14, p0_.deleted_at AS deleted_at_15, p0_.reason_of_delete AS reason_of_delete_16, p0_.best_selection AS best_selection_17, p0_.show_in_web_site AS show_in_web_site_18, p0_.categories_id AS categories_id_19, p0_.tva_id AS tva_id_20, p0_.promotion_id AS promotion_id_21 FROM produit p0_ WHERE p0_.created_at >= '2025-09-10 23:39:12' AND p0_.deleted_at IS NULL AND p0_.show_in_web_site = 1 ORDER BY p0_.created_at DESC LIMIT 10;

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.show_in_homepage = ?

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.show_in_homepage = 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
  t0.id AS id_1,
  t0.image AS image_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.url AS url_5,
  t0.is_active AS is_active_6,
  t0.`order` AS order_7
FROM
  slider t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.`order` ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.description AS description_4, t0.url AS url_5, t0.is_active AS is_active_6, t0.`order` AS order_7 FROM slider t0 WHERE t0.is_active = 1 ORDER BY t0.`order` ASC;