Symfony Profiler

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_declination_value_file ON t0.id = produit_declination_value_file.file_id
WHERE
  produit_declination_value_file.produit_declination_value_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_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = 18125;

SELECT
  t0.id AS id_1,
  t0.qt_stock AS qt_stock_2,
  t0.qt_reserved AS qt_reserved_3,
  t0.incoming_quantity AS incoming_quantity_4,
  t0.incoming_date_estimated AS incoming_date_estimated_5,
  t0.exchange_incoming_quantity AS exchange_incoming_quantity_6,
  t0.average_unit_cost AS average_unit_cost_7,
  t0.last_purchase_price AS last_purchase_price_8,
  t0.valuation_updated_at AS valuation_updated_at_9,
  t0.produit_id AS produit_id_10,
  t0.declination_produit_id AS declination_produit_id_11,
  t0.warehouse_id AS warehouse_id_12
FROM
  stock t0
WHERE
  t0.declination_produit_id = ?

SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.incoming_quantity AS incoming_quantity_4, t0.incoming_date_estimated AS incoming_date_estimated_5, t0.exchange_incoming_quantity AS exchange_incoming_quantity_6, t0.average_unit_cost AS average_unit_cost_7, t0.last_purchase_price AS last_purchase_price_8, t0.valuation_updated_at AS valuation_updated_at_9, t0.produit_id AS produit_id_10, t0.declination_produit_id AS declination_produit_id_11, t0.warehouse_id AS warehouse_id_12 FROM stock t0 WHERE t0.declination_produit_id = 18125;

SELECT
  t0.id AS id_1,
  t0.produit_declination_id AS produit_declination_id_2,
  t0.declination_id AS declination_id_3,
  t0.value_id AS value_id_4
FROM
  group_declination_value t0
WHERE
  t0.produit_declination_id = ?

SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = 18125;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.barcode AS barcode_2,
  p0_.name AS name_3,
  p0_.description AS description_4,
  p0_.usual_quantity AS usual_quantity_5,
  p0_.buying_price_ht AS buying_price_ht_6,
  p0_.buying_price_ttc AS buying_price_ttc_7,
  p0_.real_unit_value AS real_unit_value_8,
  p0_.price_ht AS price_ht_9,
  p0_.price_ttc AS price_ttc_10,
  p0_.reseller_price_ttc AS reseller_price_ttc_11,
  p0_.unit AS unit_12,
  p0_.is_stock AS is_stock_13,
  p0_.is_declination AS is_declination_14,
  p0_.created_at AS created_at_15,
  p0_.uuid AS uuid_16,
  p0_.information AS information_17,
  p0_.is_archived AS is_archived_18,
  p0_.deleted_at AS deleted_at_19,
  p0_.reason_of_delete AS reason_of_delete_20,
  p0_.best_selection AS best_selection_21,
  p0_.rating_score AS rating_score_22,
  p0_.rating_count AS rating_count_23,
  p0_.material AS material_24,
  p0_.supplier_reference AS supplier_reference_25,
  p0_.meta_description AS meta_description_26,
  p0_.video_url AS video_url_27,
  p0_.show_in_web_site AS show_in_web_site_28,
  p0_.show_in_pos_default AS show_in_pos_default_29,
  p0_.can_be_restocked AS can_be_restocked_30,
  p0_.categories_id AS categories_id_31,
  p0_.tva_id AS tva_id_32,
  p0_.buy_tva_id AS buy_tva_id_33,
  p0_.promotion_id AS promotion_id_34,
  p0_.supplier_id AS supplier_id_35
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_.barcode AS barcode_2, p0_.name AS name_3, p0_.description AS description_4, p0_.usual_quantity AS usual_quantity_5, p0_.buying_price_ht AS buying_price_ht_6, p0_.buying_price_ttc AS buying_price_ttc_7, p0_.real_unit_value AS real_unit_value_8, p0_.price_ht AS price_ht_9, p0_.price_ttc AS price_ttc_10, p0_.reseller_price_ttc AS reseller_price_ttc_11, p0_.unit AS unit_12, p0_.is_stock AS is_stock_13, p0_.is_declination AS is_declination_14, p0_.created_at AS created_at_15, p0_.uuid AS uuid_16, p0_.information AS information_17, p0_.is_archived AS is_archived_18, p0_.deleted_at AS deleted_at_19, p0_.reason_of_delete AS reason_of_delete_20, p0_.best_selection AS best_selection_21, p0_.rating_score AS rating_score_22, p0_.rating_count AS rating_count_23, p0_.material AS material_24, p0_.supplier_reference AS supplier_reference_25, p0_.meta_description AS meta_description_26, p0_.video_url AS video_url_27, p0_.show_in_web_site AS show_in_web_site_28, p0_.show_in_pos_default AS show_in_pos_default_29, p0_.can_be_restocked AS can_be_restocked_30, p0_.categories_id AS categories_id_31, p0_.tva_id AS tva_id_32, p0_.buy_tva_id AS buy_tva_id_33, p0_.promotion_id AS promotion_id_34, p0_.supplier_id AS supplier_id_35 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 >= '2026-02-28 11:45:56' 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.name AS name_2,
  t0.code AS code_3,
  t0.declination_id AS declination_id_4,
  t0.parent_id AS parent_id_5
FROM
  value_declination t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = 23;

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

SELECT
  t0.id AS id_1,
  t0.qt_stock AS qt_stock_2,
  t0.qt_reserved AS qt_reserved_3,
  t0.incoming_quantity AS incoming_quantity_4,
  t0.incoming_date_estimated AS incoming_date_estimated_5,
  t0.exchange_incoming_quantity AS exchange_incoming_quantity_6,
  t0.average_unit_cost AS average_unit_cost_7,
  t0.last_purchase_price AS last_purchase_price_8,
  t0.valuation_updated_at AS valuation_updated_at_9,
  t0.produit_id AS produit_id_10,
  t0.declination_produit_id AS declination_produit_id_11,
  t0.warehouse_id AS warehouse_id_12
FROM
  stock t0
WHERE
  t0.produit_id = ?

SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.incoming_quantity AS incoming_quantity_4, t0.incoming_date_estimated AS incoming_date_estimated_5, t0.exchange_incoming_quantity AS exchange_incoming_quantity_6, t0.average_unit_cost AS average_unit_cost_7, t0.last_purchase_price AS last_purchase_price_8, t0.valuation_updated_at AS valuation_updated_at_9, t0.produit_id AS produit_id_10, t0.declination_produit_id AS declination_produit_id_11, t0.warehouse_id AS warehouse_id_12 FROM stock t0 WHERE t0.produit_id = 1362;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.barcode AS barcode_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.buying_price_ht AS buying_price_ht_6,
  t0.buying_price_ttc AS buying_price_ttc_7,
  t0.price_ht AS price_ht_8,
  t0.created_at AS created_at_9,
  t0.alert_stock_min AS alert_stock_min_10,
  t0.uuid AS uuid_11,
  t0.produit_id AS produit_id_12
FROM
  produit_declination_value t0
WHERE
  t0.produit_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.barcode AS barcode_3, t0.name AS name_4, t0.description AS description_5, t0.buying_price_ht AS buying_price_ht_6, t0.buying_price_ttc AS buying_price_ttc_7, t0.price_ht AS price_ht_8, t0.created_at AS created_at_9, t0.alert_stock_min AS alert_stock_min_10, t0.uuid AS uuid_11, t0.produit_id AS produit_id_12 FROM produit_declination_value t0 WHERE t0.produit_id = 1362;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.barcode AS barcode_2,
  p0_.name AS name_3,
  p0_.description AS description_4,
  p0_.usual_quantity AS usual_quantity_5,
  p0_.buying_price_ht AS buying_price_ht_6,
  p0_.buying_price_ttc AS buying_price_ttc_7,
  p0_.real_unit_value AS real_unit_value_8,
  p0_.price_ht AS price_ht_9,
  p0_.price_ttc AS price_ttc_10,
  p0_.reseller_price_ttc AS reseller_price_ttc_11,
  p0_.unit AS unit_12,
  p0_.is_stock AS is_stock_13,
  p0_.is_declination AS is_declination_14,
  p0_.created_at AS created_at_15,
  p0_.uuid AS uuid_16,
  p0_.information AS information_17,
  p0_.is_archived AS is_archived_18,
  p0_.deleted_at AS deleted_at_19,
  p0_.reason_of_delete AS reason_of_delete_20,
  p0_.best_selection AS best_selection_21,
  p0_.rating_score AS rating_score_22,
  p0_.rating_count AS rating_count_23,
  p0_.material AS material_24,
  p0_.supplier_reference AS supplier_reference_25,
  p0_.meta_description AS meta_description_26,
  p0_.video_url AS video_url_27,
  p0_.show_in_web_site AS show_in_web_site_28,
  p0_.show_in_pos_default AS show_in_pos_default_29,
  p0_.can_be_restocked AS can_be_restocked_30,
  p0_.categories_id AS categories_id_31,
  p0_.tva_id AS tva_id_32,
  p0_.buy_tva_id AS buy_tva_id_33,
  p0_.promotion_id AS promotion_id_34,
  p0_.supplier_id AS supplier_id_35
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_.barcode AS barcode_2, p0_.name AS name_3, p0_.description AS description_4, p0_.usual_quantity AS usual_quantity_5, p0_.buying_price_ht AS buying_price_ht_6, p0_.buying_price_ttc AS buying_price_ttc_7, p0_.real_unit_value AS real_unit_value_8, p0_.price_ht AS price_ht_9, p0_.price_ttc AS price_ttc_10, p0_.reseller_price_ttc AS reseller_price_ttc_11, p0_.unit AS unit_12, p0_.is_stock AS is_stock_13, p0_.is_declination AS is_declination_14, p0_.created_at AS created_at_15, p0_.uuid AS uuid_16, p0_.information AS information_17, p0_.is_archived AS is_archived_18, p0_.deleted_at AS deleted_at_19, p0_.reason_of_delete AS reason_of_delete_20, p0_.best_selection AS best_selection_21, p0_.rating_score AS rating_score_22, p0_.rating_count AS rating_count_23, p0_.material AS material_24, p0_.supplier_reference AS supplier_reference_25, p0_.meta_description AS meta_description_26, p0_.video_url AS video_url_27, p0_.show_in_web_site AS show_in_web_site_28, p0_.show_in_pos_default AS show_in_pos_default_29, p0_.can_be_restocked AS can_be_restocked_30, p0_.categories_id AS categories_id_31, p0_.tva_id AS tva_id_32, p0_.buy_tva_id AS buy_tva_id_33, p0_.promotion_id AS promotion_id_34, p0_.supplier_id AS supplier_id_35 FROM produit p0_ WHERE p0_.created_at >= '2025-12-30 11:45:56' 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.position AS position_3,
  t0.display_in_filter AS display_in_filter_4
FROM
  declination t0
WHERE
  t0.id = ?

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.type AS type_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.is_active AS is_active_7,
  t0.is_default AS is_default_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  warehouse t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.is_default DESC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.type AS type_4, t0.address AS address_5, t0.city AS city_6, t0.is_active AS is_active_7, t0.is_default AS is_default_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM warehouse t0 WHERE t0.is_active = 1 ORDER BY t0.is_default DESC, t0.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.aspect_ratio AS aspect_ratio_9,
  t0.parent_id AS parent_id_10
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.aspect_ratio AS aspect_ratio_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.parent_id = 93 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.zip AS zip_7,
  t0.tva_code AS tva_code_8,
  t0.mail AS mail_9,
  t0.website AS website_10,
  t0.phone AS phone_11,
  t0.mobile AS mobile_12,
  t0.social_links AS social_links_13,
  t0.updated_at AS updated_at_14,
  t0.tva_rate_buy_id AS tva_rate_buy_id_15,
  t0.tva_rate_sale_id AS tva_rate_sale_id_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.zip AS zip_7, t0.tva_code AS tva_code_8, t0.mail AS mail_9, t0.website AS website_10, t0.phone AS phone_11, t0.mobile AS mobile_12, t0.social_links AS social_links_13, t0.updated_at AS updated_at_14, t0.tva_rate_buy_id AS tva_rate_buy_id_15, t0.tva_rate_sale_id AS tva_rate_sale_id_16 FROM company t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.start_at AS start_at_4,
  t0.end_at AS end_at_5,
  t0.created_at AS created_at_6,
  t0.discount_type AS discount_type_7,
  t0.discount_value AS discount_value_8,
  t0.code AS code_9,
  t0.total_quantity AS total_quantity_10,
  t0.quantity_user AS quantity_user_11,
  t0.is_enabled AS is_enabled_12,
  t0.type AS type_13
FROM
  promotion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5, t0.created_at AS created_at_6, t0.discount_type AS discount_type_7, t0.discount_value AS discount_value_8, t0.code AS code_9, t0.total_quantity AS total_quantity_10, t0.quantity_user AS quantity_user_11, t0.is_enabled AS is_enabled_12, t0.type AS type_13 FROM promotion t0 WHERE t0.id = 79;

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.cta_label AS cta_label_6,
  t0.is_active AS is_active_7,
  t0.`order` AS order_8,
  t0.display_mode AS display_mode_9
FROM
  slider t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.`order` ASC
LIMIT
  3

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.cta_label AS cta_label_6, t0.is_active AS is_active_7, t0.`order` AS order_8, t0.display_mode AS display_mode_9 FROM slider t0 WHERE t0.is_active = 1 ORDER BY t0.`order` ASC LIMIT 3;

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.aspect_ratio AS aspect_ratio_9,
  t0.parent_id AS parent_id_10
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.aspect_ratio AS aspect_ratio_9, t0.parent_id AS parent_id_10 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.setting_key AS setting_key_2,
  t0.type AS type_3,
  t0.value_string AS value_string_4,
  t0.value_int AS value_int_5,
  t0.value_float AS value_float_6,
  t0.value_bool AS value_bool_7,
  t0.value_json AS value_json_8,
  t0.value_text AS value_text_9,
  t0.description AS description_10,
  t0.updated_at AS updated_at_11,
  t0.section AS section_12
FROM
  website_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.type AS type_3, t0.value_string AS value_string_4, t0.value_int AS value_int_5, t0.value_float AS value_float_6, t0.value_bool AS value_bool_7, t0.value_json AS value_json_8, t0.value_text AS value_text_9, t0.description AS description_10, t0.updated_at AS updated_at_11, t0.section AS section_12 FROM website_setting t0 WHERE t0.setting_key = 'site_maintenance' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.type AS type_3,
  t0.value_string AS value_string_4,
  t0.value_int AS value_int_5,
  t0.value_float AS value_float_6,
  t0.value_bool AS value_bool_7,
  t0.value_json AS value_json_8,
  t0.value_text AS value_text_9,
  t0.description AS description_10,
  t0.updated_at AS updated_at_11,
  t0.section AS section_12
FROM
  website_setting t0

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.type AS type_3, t0.value_string AS value_string_4, t0.value_int AS value_int_5, t0.value_float AS value_float_6, t0.value_bool AS value_bool_7, t0.value_json AS value_json_8, t0.value_text AS value_text_9, t0.description AS description_10, t0.updated_at AS updated_at_11, t0.section AS section_12 FROM website_setting t0;

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.aspect_ratio AS aspect_ratio_9,
  t0.parent_id AS parent_id_10
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.aspect_ratio AS aspect_ratio_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.show_in_homepage = 1;