Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.value AS value_3,
  t0.updated_at AS updated_at_4
FROM
  marketplace_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = 'public.locale_definitions' LIMIT 1;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  product p0_
WHERE
  p0_.status = ?
  AND p0_.display = 1

SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.status = 'active' AND p0_.display = 1;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  seller s0_
WHERE
  s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM seller s0_ WHERE s0_.status = 'active';

SELECT
  COUNT(DISTINCT s0_.geo_city_id) AS sclr_0
FROM
  seller s1_
  LEFT JOIN seller_address s0_ ON s1_.id = s0_.seller_id
WHERE
  s1_.status = ?
  AND s0_.geo_city_id IS NOT NULL

SELECT COUNT(DISTINCT s0_.geo_city_id) AS sclr_0 FROM seller s1_ LEFT JOIN seller_address s0_ ON s1_.id = s0_.seller_id WHERE s1_.status = 'active' AND s0_.geo_city_id IS NOT NULL;

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.status = ?
  AND p0_.display = 1
ORDER BY
  p0_.published_at DESC
LIMIT
  12

SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = 'active' AND p0_.display = 1 ORDER BY p0_.published_at DESC LIMIT 12;

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.status AS status_2,
  p0_.display AS display_3,
  p0_.price AS price_4,
  p0_.currency AS currency_5,
  p0_.condition AS condition_6,
  p0_.stock_qty AS stock_qty_7,
  p0_.weight_kg AS weight_kg_8,
  p0_.length_cm AS length_cm_9,
  p0_.width_cm AS width_cm_10,
  p0_.height_cm AS height_cm_11,
  p0_.depth_cm AS depth_cm_12,
  p0_.diameter_cm AS diameter_cm_13,
  p0_.is_week_featured AS is_week_featured_14,
  p0_.created_at AS created_at_15,
  p0_.updated_at AS updated_at_16,
  p0_.published_at AS published_at_17,
  p0_.sold_at AS sold_at_18,
  p1_.id AS id_19,
  p1_.file_path AS file_path_20,
  p1_.thumb_path AS thumb_path_21,
  p1_.detail_path AS detail_path_22,
  p1_.alt_text AS alt_text_23,
  p1_.position AS position_24,
  p1_.is_primary AS is_primary_25,
  p1_.width AS width_26,
  p1_.height AS height_27,
  p1_.created_at AS created_at_28,
  s2_.id AS id_29,
  s2_.slug AS slug_30,
  s2_.status AS status_31,
  s2_.stripe_account_id AS stripe_account_id_32,
  s2_.stripe_customer_id AS stripe_customer_id_33,
  s2_.stripe_kyc_complete AS stripe_kyc_complete_34,
  s2_.paypal_email AS paypal_email_35,
  s2_.paypal_merchant_id AS paypal_merchant_id_36,
  s2_.paypal_account_status AS paypal_account_status_37,
  s2_.paypal_permissions_granted AS paypal_permissions_granted_38,
  s2_.created_at AS created_at_39,
  s2_.activated_at AS activated_at_40,
  s2_.suspended_at AS suspended_at_41,
  s2_.commercial_status AS commercial_status_42,
  s2_.subscribed_since AS subscribed_since_43,
  s2_.subscription_ends_at AS subscription_ends_at_44,
  s2_.crm_priority AS crm_priority_45,
  s2_.next_reminder_at AS next_reminder_at_46,
  s2_.next_reminder_note AS next_reminder_note_47,
  s2_.prospect_source AS prospect_source_48,
  s2_.prospect_collected_at AS prospect_collected_at_49,
  s2_.crm_flag_for_human AS crm_flag_for_human_50,
  s3_.id AS id_51,
  s3_.business_name AS business_name_52,
  s3_.description AS description_53,
  s3_.siret AS siret_54,
  s3_.vat_number AS vat_number_55,
  s3_.phone AS phone_56,
  s3_.website AS website_57,
  s3_.logo_path AS logo_path_58,
  s3_.banner_path AS banner_path_59,
  s3_.opening_hours AS opening_hours_60,
  s3_.filter_tag_category_keys AS filter_tag_category_keys_61,
  s3_.updated_at AS updated_at_62,
  p0_.seller_id AS seller_id_63,
  p1_.product_id AS product_id_64,
  s2_.user_id AS user_id_65,
  s3_.seller_id AS seller_id_66
FROM
  product p0_
  LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id
  LEFT JOIN seller s2_ ON p0_.seller_id = s2_.id
  LEFT JOIN seller_profile s3_ ON s2_.id = s3_.seller_id
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.status AS status_2, p0_.display AS display_3, p0_.price AS price_4, p0_.currency AS currency_5, p0_.condition AS condition_6, p0_.stock_qty AS stock_qty_7, p0_.weight_kg AS weight_kg_8, p0_.length_cm AS length_cm_9, p0_.width_cm AS width_cm_10, p0_.height_cm AS height_cm_11, p0_.depth_cm AS depth_cm_12, p0_.diameter_cm AS diameter_cm_13, p0_.is_week_featured AS is_week_featured_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.published_at AS published_at_17, p0_.sold_at AS sold_at_18, p1_.id AS id_19, p1_.file_path AS file_path_20, p1_.thumb_path AS thumb_path_21, p1_.detail_path AS detail_path_22, p1_.alt_text AS alt_text_23, p1_.position AS position_24, p1_.is_primary AS is_primary_25, p1_.width AS width_26, p1_.height AS height_27, p1_.created_at AS created_at_28, s2_.id AS id_29, s2_.slug AS slug_30, s2_.status AS status_31, s2_.stripe_account_id AS stripe_account_id_32, s2_.stripe_customer_id AS stripe_customer_id_33, s2_.stripe_kyc_complete AS stripe_kyc_complete_34, s2_.paypal_email AS paypal_email_35, s2_.paypal_merchant_id AS paypal_merchant_id_36, s2_.paypal_account_status AS paypal_account_status_37, s2_.paypal_permissions_granted AS paypal_permissions_granted_38, s2_.created_at AS created_at_39, s2_.activated_at AS activated_at_40, s2_.suspended_at AS suspended_at_41, s2_.commercial_status AS commercial_status_42, s2_.subscribed_since AS subscribed_since_43, s2_.subscription_ends_at AS subscription_ends_at_44, s2_.crm_priority AS crm_priority_45, s2_.next_reminder_at AS next_reminder_at_46, s2_.next_reminder_note AS next_reminder_note_47, s2_.prospect_source AS prospect_source_48, s2_.prospect_collected_at AS prospect_collected_at_49, s2_.crm_flag_for_human AS crm_flag_for_human_50, s3_.id AS id_51, s3_.business_name AS business_name_52, s3_.description AS description_53, s3_.siret AS siret_54, s3_.vat_number AS vat_number_55, s3_.phone AS phone_56, s3_.website AS website_57, s3_.logo_path AS logo_path_58, s3_.banner_path AS banner_path_59, s3_.opening_hours AS opening_hours_60, s3_.filter_tag_category_keys AS filter_tag_category_keys_61, s3_.updated_at AS updated_at_62, p0_.seller_id AS seller_id_63, p1_.product_id AS product_id_64, s2_.user_id AS user_id_65, s3_.seller_id AS seller_id_66 FROM product p0_ LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id LEFT JOIN seller s2_ ON p0_.seller_id = s2_.id LEFT JOIN seller_profile s3_ ON s2_.id = s3_.seller_id WHERE p0_.id IN (177783, 177782, 177781, 177780, 177779, 177778, 177777, 177776, 177775, 177774, 177773, 177772);

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.zip AS zip_3,
  t0.country_code AS country_code_4,
  t0.lat AS lat_5,
  t0.lng AS lng_6,
  t0.street_view_heading AS street_view_heading_7,
  t0.street_view_pitch AS street_view_pitch_8,
  t0.street_view_zoom AS street_view_zoom_9,
  t0.seller_id AS seller_id_10,
  t0.geo_city_id AS geo_city_id_11
FROM
  seller_address t0
WHERE
  t0.seller_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.zip AS zip_3, t0.country_code AS country_code_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.street_view_heading AS street_view_heading_7, t0.street_view_pitch AS street_view_pitch_8, t0.street_view_zoom AS street_view_zoom_9, t0.seller_id AS seller_id_10, t0.geo_city_id AS geo_city_id_11 FROM seller_address t0 WHERE t0.seller_id = 19295;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.zip AS zip_3,
  t0.country_code AS country_code_4,
  t0.lat AS lat_5,
  t0.lng AS lng_6,
  t0.street_view_heading AS street_view_heading_7,
  t0.street_view_pitch AS street_view_pitch_8,
  t0.street_view_zoom AS street_view_zoom_9,
  t0.seller_id AS seller_id_10,
  t0.geo_city_id AS geo_city_id_11
FROM
  seller_address t0
WHERE
  t0.seller_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.zip AS zip_3, t0.country_code AS country_code_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.street_view_heading AS street_view_heading_7, t0.street_view_pitch AS street_view_pitch_8, t0.street_view_zoom AS street_view_zoom_9, t0.seller_id AS seller_id_10, t0.geo_city_id AS geo_city_id_11 FROM seller_address t0 WHERE t0.seller_id = 19106;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.zip AS zip_3,
  t0.country_code AS country_code_4,
  t0.lat AS lat_5,
  t0.lng AS lng_6,
  t0.street_view_heading AS street_view_heading_7,
  t0.street_view_pitch AS street_view_pitch_8,
  t0.street_view_zoom AS street_view_zoom_9,
  t0.seller_id AS seller_id_10,
  t0.geo_city_id AS geo_city_id_11
FROM
  seller_address t0
WHERE
  t0.seller_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.zip AS zip_3, t0.country_code AS country_code_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.street_view_heading AS street_view_heading_7, t0.street_view_pitch AS street_view_pitch_8, t0.street_view_zoom AS street_view_zoom_9, t0.seller_id AS seller_id_10, t0.geo_city_id AS geo_city_id_11 FROM seller_address t0 WHERE t0.seller_id = 19007;

SELECT
  t0_.id AS id_0,
  t0_.key_name AS key_name_1,
  t0_.position AS position_2,
  t0_.filterable AS filterable_3,
  t0_.icon AS icon_4,
  t1_.id AS id_5,
  t1_.locale AS locale_6,
  t1_.label AS label_7,
  t2_.id AS id_8,
  t2_.slug AS slug_9,
  t2_.created_at AS created_at_10,
  t3_.id AS id_11,
  t3_.locale AS locale_12,
  t3_.label AS label_13,
  t3_.auto_translated AS auto_translated_14,
  t4_.id AS id_15,
  t4_.slug AS slug_16,
  t4_.created_at AS created_at_17,
  t5_.id AS id_18,
  t5_.locale AS locale_19,
  t5_.label AS label_20,
  t5_.auto_translated AS auto_translated_21,
  t1_.tag_category_id AS tag_category_id_22,
  t2_.tag_category_id AS tag_category_id_23,
  t2_.parent_id AS parent_id_24,
  t3_.tag_id AS tag_id_25,
  t4_.tag_category_id AS tag_category_id_26,
  t4_.parent_id AS parent_id_27,
  t5_.tag_id AS tag_id_28
FROM
  tag_category t0_
  LEFT JOIN tag_category_translation t1_ ON t0_.id = t1_.tag_category_id
  LEFT JOIN tag t2_ ON t0_.id = t2_.tag_category_id
  LEFT JOIN tag_translation t3_ ON t2_.id = t3_.tag_id
  LEFT JOIN tag t4_ ON t2_.id = t4_.parent_id
  LEFT JOIN tag_translation t5_ ON t4_.id = t5_.tag_id
WHERE
  t0_.filterable = 1
ORDER BY
  t0_.position ASC,
  t2_.slug ASC

SELECT t0_.id AS id_0, t0_.key_name AS key_name_1, t0_.position AS position_2, t0_.filterable AS filterable_3, t0_.icon AS icon_4, t1_.id AS id_5, t1_.locale AS locale_6, t1_.label AS label_7, t2_.id AS id_8, t2_.slug AS slug_9, t2_.created_at AS created_at_10, t3_.id AS id_11, t3_.locale AS locale_12, t3_.label AS label_13, t3_.auto_translated AS auto_translated_14, t4_.id AS id_15, t4_.slug AS slug_16, t4_.created_at AS created_at_17, t5_.id AS id_18, t5_.locale AS locale_19, t5_.label AS label_20, t5_.auto_translated AS auto_translated_21, t1_.tag_category_id AS tag_category_id_22, t2_.tag_category_id AS tag_category_id_23, t2_.parent_id AS parent_id_24, t3_.tag_id AS tag_id_25, t4_.tag_category_id AS tag_category_id_26, t4_.parent_id AS parent_id_27, t5_.tag_id AS tag_id_28 FROM tag_category t0_ LEFT JOIN tag_category_translation t1_ ON t0_.id = t1_.tag_category_id LEFT JOIN tag t2_ ON t0_.id = t2_.tag_category_id LEFT JOIN tag_translation t3_ ON t2_.id = t3_.tag_id LEFT JOIN tag t4_ ON t2_.id = t4_.parent_id LEFT JOIN tag_translation t5_ ON t4_.id = t5_.tag_id WHERE t0_.filterable = 1 ORDER BY t0_.position ASC, t2_.slug ASC;

SELECT
  f0_.id AS id_0,
  f0_.week_start AS week_start_1,
  f0_.status AS status_2,
  f0_.source AS source_3,
  f0_.stripe_checkout_session_id AS stripe_checkout_session_id_4,
  f0_.amount_paid AS amount_paid_5,
  f0_.admin_notes AS admin_notes_6,
  f0_.created_at AS created_at_7,
  f0_.cancelled_at AS cancelled_at_8,
  f0_.seller_id AS seller_id_9,
  f0_.cancelled_by_id AS cancelled_by_id_10
FROM
  featured_seller_week f0_
WHERE
  f0_.week_start >= ?
  AND f0_.week_start <= ?
  AND f0_.status IN (?, ?)
LIMIT
  1

SELECT f0_.id AS id_0, f0_.week_start AS week_start_1, f0_.status AS status_2, f0_.source AS source_3, f0_.stripe_checkout_session_id AS stripe_checkout_session_id_4, f0_.amount_paid AS amount_paid_5, f0_.admin_notes AS admin_notes_6, f0_.created_at AS created_at_7, f0_.cancelled_at AS cancelled_at_8, f0_.seller_id AS seller_id_9, f0_.cancelled_by_id AS cancelled_by_id_10 FROM featured_seller_week f0_ WHERE f0_.week_start >= '2026-04-20' AND f0_.week_start <= '2026-04-26' AND f0_.status IN ('active', 'booked') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.auto_translated AS auto_translated_5,
  t0.translated_at AS translated_at_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 177783;

SELECT
  t0.id AS id_1,
  t0.insee_code AS insee_code_2,
  t0.name AS name_3,
  t0.zip_codes AS zip_codes_4,
  t0.lat AS lat_5,
  t0.lng AS lng_6,
  t0.department_id AS department_id_7
FROM
  geo_city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.insee_code AS insee_code_2, t0.name AS name_3, t0.zip_codes AS zip_codes_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.department_id AS department_id_7 FROM geo_city t0 WHERE t0.id = 44;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.auto_translated AS auto_translated_5,
  t0.translated_at AS translated_at_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 177782;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.auto_translated AS auto_translated_5,
  t0.translated_at AS translated_at_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 177781;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.auto_translated AS auto_translated_5,
  t0.translated_at AS translated_at_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 177780;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.auto_translated AS auto_translated_5,
  t0.translated_at AS translated_at_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 177779;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.auto_translated AS auto_translated_5,
  t0.translated_at AS translated_at_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 177778;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.auto_translated AS auto_translated_5,
  t0.translated_at AS translated_at_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?