Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.freebird_id AS freebird_id_1,
  c0_.position AS position_2,
  c0_.default_weight AS default_weight_3,
  c0_.menu AS menu_4,
  c0_.active AS active_5,
  c0_.image_name AS image_name_6,
  c0_.image_name_responsive AS image_name_responsive_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c1_.id AS id_10,
  c1_.title AS title_11,
  c1_.title_web AS title_web_12,
  c1_.path AS path_13,
  c1_.locale AS locale_14,
  c2_.id AS id_15,
  c2_.freebird_id AS freebird_id_16,
  c2_.position AS position_17,
  c2_.default_weight AS default_weight_18,
  c2_.menu AS menu_19,
  c2_.active AS active_20,
  c2_.image_name AS image_name_21,
  c2_.image_name_responsive AS image_name_responsive_22,
  c2_.created_at AS created_at_23,
  c2_.updated_at AS updated_at_24,
  c3_.id AS id_25,
  c3_.title AS title_26,
  c3_.title_web AS title_web_27,
  c3_.path AS path_28,
  c3_.locale AS locale_29,
  c4_.id AS id_30,
  c4_.freebird_id AS freebird_id_31,
  c4_.position AS position_32,
  c4_.default_weight AS default_weight_33,
  c4_.menu AS menu_34,
  c4_.active AS active_35,
  c4_.image_name AS image_name_36,
  c4_.image_name_responsive AS image_name_responsive_37,
  c4_.created_at AS created_at_38,
  c4_.updated_at AS updated_at_39,
  c5_.id AS id_40,
  c5_.title AS title_41,
  c5_.title_web AS title_web_42,
  c5_.path AS path_43,
  c5_.locale AS locale_44,
  c0_.parent_id AS parent_id_45,
  c1_.translatable_id AS translatable_id_46,
  c2_.parent_id AS parent_id_47,
  c3_.translatable_id AS translatable_id_48,
  c4_.parent_id AS parent_id_49,
  c5_.translatable_id AS translatable_id_50
FROM
  category c0_
  LEFT JOIN category_translation c1_ ON c0_.id = c1_.translatable_id
  LEFT JOIN category c2_ ON c0_.id = c2_.parent_id
  AND (c2_.active = 1)
  LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id
  LEFT JOIN category c4_ ON c2_.id = c4_.parent_id
  AND (c4_.active = 1)
  LEFT JOIN category_translation c5_ ON c4_.id = c5_.translatable_id
WHERE
  c0_.menu = 1
  AND c0_.active = 1
ORDER BY
  c0_.position ASC,
  c2_.position ASC,
  c4_.position ASC

SELECT c0_.id AS id_0, c0_.freebird_id AS freebird_id_1, c0_.position AS position_2, c0_.default_weight AS default_weight_3, c0_.menu AS menu_4, c0_.active AS active_5, c0_.image_name AS image_name_6, c0_.image_name_responsive AS image_name_responsive_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c1_.id AS id_10, c1_.title AS title_11, c1_.title_web AS title_web_12, c1_.path AS path_13, c1_.locale AS locale_14, c2_.id AS id_15, c2_.freebird_id AS freebird_id_16, c2_.position AS position_17, c2_.default_weight AS default_weight_18, c2_.menu AS menu_19, c2_.active AS active_20, c2_.image_name AS image_name_21, c2_.image_name_responsive AS image_name_responsive_22, c2_.created_at AS created_at_23, c2_.updated_at AS updated_at_24, c3_.id AS id_25, c3_.title AS title_26, c3_.title_web AS title_web_27, c3_.path AS path_28, c3_.locale AS locale_29, c4_.id AS id_30, c4_.freebird_id AS freebird_id_31, c4_.position AS position_32, c4_.default_weight AS default_weight_33, c4_.menu AS menu_34, c4_.active AS active_35, c4_.image_name AS image_name_36, c4_.image_name_responsive AS image_name_responsive_37, c4_.created_at AS created_at_38, c4_.updated_at AS updated_at_39, c5_.id AS id_40, c5_.title AS title_41, c5_.title_web AS title_web_42, c5_.path AS path_43, c5_.locale AS locale_44, c0_.parent_id AS parent_id_45, c1_.translatable_id AS translatable_id_46, c2_.parent_id AS parent_id_47, c3_.translatable_id AS translatable_id_48, c4_.parent_id AS parent_id_49, c5_.translatable_id AS translatable_id_50 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN category c2_ ON c0_.id = c2_.parent_id AND (c2_.active = 1) LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id LEFT JOIN category c4_ ON c2_.id = c4_.parent_id AND (c4_.active = 1) LEFT JOIN category_translation c5_ ON c4_.id = c5_.translatable_id WHERE c0_.menu = 1 AND c0_.active = 1 ORDER BY c0_.position ASC, c2_.position ASC, c4_.position ASC;

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.phone_contact AS phone_contact_3,
  t0.email_contact AS email_contact_4,
  t0.facebook AS facebook_5,
  t0.instagram AS instagram_6,
  t0.youtube AS youtube_7,
  t0.twitter AS twitter_8,
  t0.linkedin AS linkedin_9,
  t0.logo_name AS logo_name_10,
  t0.logo_footer_name AS logo_footer_name_11,
  t0.favicon_name AS favicon_name_12,
  t0.maintenance AS maintenance_13,
  t0.title AS title_14,
  t0.meta_title AS meta_title_15,
  t0.meta_description AS meta_description_16,
  t0.meta_image_name AS meta_image_name_17,
  t0.payment_cb AS payment_cb_18,
  t0.payment_transfer AS payment_transfer_19,
  t0.payment_bank_cheque AS payment_bank_cheque_20,
  t0.payment_on_delivery AS payment_on_delivery_21,
  t0.payment_cbmodel AS payment_cbmodel_22,
  t0.payment_cbendpoint AS payment_cbendpoint_23,
  t0.payment_cbusername AS payment_cbusername_24,
  t0.payment_cbpassword AS payment_cbpassword_25,
  t0.payment_cbmode AS payment_cbmode_26,
  t0.denomination_virement AS denomination_virement_27,
  t0.iban AS iban_28,
  t0.bic AS bic_29,
  t0.payment_transfer_block_delay AS payment_transfer_block_delay_30,
  t0.payment_bank_cheque_order AS payment_bank_cheque_order_31,
  t0.payment_bank_cheque_address AS payment_bank_cheque_address_32,
  t0.payment_bank_cheque_block_delay AS payment_bank_cheque_block_delay_33,
  t0.allow_pickup_in_store AS allow_pickup_in_store_34,
  t0.api_key_google_maps AS api_key_google_maps_35,
  t0.api_key_public_grecaptcha AS api_key_public_grecaptcha_36,
  t0.api_key_private_grecaptcha AS api_key_private_grecaptcha_37,
  t0.latitude AS latitude_38,
  t0.longitude AS longitude_39,
  t0.zoom AS zoom_40,
  t0.map_id AS map_id_41,
  t0.marker_image_name AS marker_image_name_42,
  t0.api_freebird_backend_endpoint AS api_freebird_backend_endpoint_43,
  t0.api_freebird_licence_endpoint AS api_freebird_licence_endpoint_44,
  t0.api_freebird_backend_username AS api_freebird_backend_username_45,
  t0.api_freebird_backend_password AS api_freebird_backend_password_46,
  t0.section_id AS section_id_47,
  t0.caisse_id AS caisse_id_48,
  t0.stock_restriction_section AS stock_restriction_section_49,
  t0.font_primary AS font_primary_50,
  t0.font_secondary AS font_secondary_51,
  t0.color_primary AS color_primary_52,
  t0.color_secondary AS color_secondary_53,
  t0.tax AS tax_54,
  t0.created_at AS created_at_55,
  t0.updated_at AS updated_at_56,
  t0.current_devise_id AS current_devise_id_57
FROM
  configuration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.address AS address_2, t0.phone_contact AS phone_contact_3, t0.email_contact AS email_contact_4, t0.facebook AS facebook_5, t0.instagram AS instagram_6, t0.youtube AS youtube_7, t0.twitter AS twitter_8, t0.linkedin AS linkedin_9, t0.logo_name AS logo_name_10, t0.logo_footer_name AS logo_footer_name_11, t0.favicon_name AS favicon_name_12, t0.maintenance AS maintenance_13, t0.title AS title_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.meta_image_name AS meta_image_name_17, t0.payment_cb AS payment_cb_18, t0.payment_transfer AS payment_transfer_19, t0.payment_bank_cheque AS payment_bank_cheque_20, t0.payment_on_delivery AS payment_on_delivery_21, t0.payment_cbmodel AS payment_cbmodel_22, t0.payment_cbendpoint AS payment_cbendpoint_23, t0.payment_cbusername AS payment_cbusername_24, t0.payment_cbpassword AS payment_cbpassword_25, t0.payment_cbmode AS payment_cbmode_26, t0.denomination_virement AS denomination_virement_27, t0.iban AS iban_28, t0.bic AS bic_29, t0.payment_transfer_block_delay AS payment_transfer_block_delay_30, t0.payment_bank_cheque_order AS payment_bank_cheque_order_31, t0.payment_bank_cheque_address AS payment_bank_cheque_address_32, t0.payment_bank_cheque_block_delay AS payment_bank_cheque_block_delay_33, t0.allow_pickup_in_store AS allow_pickup_in_store_34, t0.api_key_google_maps AS api_key_google_maps_35, t0.api_key_public_grecaptcha AS api_key_public_grecaptcha_36, t0.api_key_private_grecaptcha AS api_key_private_grecaptcha_37, t0.latitude AS latitude_38, t0.longitude AS longitude_39, t0.zoom AS zoom_40, t0.map_id AS map_id_41, t0.marker_image_name AS marker_image_name_42, t0.api_freebird_backend_endpoint AS api_freebird_backend_endpoint_43, t0.api_freebird_licence_endpoint AS api_freebird_licence_endpoint_44, t0.api_freebird_backend_username AS api_freebird_backend_username_45, t0.api_freebird_backend_password AS api_freebird_backend_password_46, t0.section_id AS section_id_47, t0.caisse_id AS caisse_id_48, t0.stock_restriction_section AS stock_restriction_section_49, t0.font_primary AS font_primary_50, t0.font_secondary AS font_secondary_51, t0.color_primary AS color_primary_52, t0.color_secondary AS color_secondary_53, t0.tax AS tax_54, t0.created_at AS created_at_55, t0.updated_at AS updated_at_56, t0.current_devise_id AS current_devise_id_57 FROM configuration t0 WHERE t0.id = 1;

SELECT
  DISTINCT c0_.id AS id_0
FROM
  category c0_
  INNER JOIN reference_category r2_ ON c0_.id = r2_.category_id
  INNER JOIN reference r1_ ON r1_.id = r2_.reference_id
  INNER JOIN product p3_ ON r1_.id = p3_.reference_id
WHERE
  r1_.active = 1
  AND p3_.active = 1
  AND p3_.stock > 0

SELECT DISTINCT c0_.id AS id_0 FROM category c0_ INNER JOIN reference_category r2_ ON c0_.id = r2_.category_id INNER JOIN reference r1_ ON r1_.id = r2_.reference_id INNER JOIN product p3_ ON r1_.id = p3_.reference_id WHERE r1_.active = 1 AND p3_.active = 1 AND p3_.stock > 0;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.symbol AS symbol_4,
  t0.symbol_before AS symbol_before_5,
  t0.decimals AS decimals_6,
  t0.thousands_sep AS thousands_sep_7,
  t0.decimal_sep AS decimal_sep_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  devise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.symbol_before AS symbol_before_5, t0.decimals AS decimals_6, t0.thousands_sep AS thousands_sep_7, t0.decimal_sep AS decimal_sep_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM devise t0 WHERE t0.id = 2;

SELECT
  COUNT(DISTINCT r0_.id) AS sclr_0
FROM
  reference r0_
  INNER JOIN product p1_ ON r0_.id = p1_.reference_id
WHERE
  r0_.active = 1
  AND p1_.active = 1
  AND p1_.stock > 0
  AND r0_.created_at >= ?

SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM reference r0_ INNER JOIN product p1_ ON r0_.id = p1_.reference_id WHERE r0_.active = 1 AND p1_.active = 1 AND p1_.stock > 0 AND r0_.created_at >= '2026-05-12 02:52:57';