Symfony Profiler

SELECT
  p0_.id AS id_0
FROM
  product p0_
  LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id
  LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id
  LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id
  LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id
  INNER JOIN product_tag p6_ ON p0_.id = p6_.product_id
  INNER JOIN tag t5_ ON t5_.id = p6_.tag_id
WHERE
  p0_.status IN (?, ?)
  AND p0_.display = 1
  AND t5_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  p0_.id
ORDER BY
  CASE WHEN p0_.status = ? THEN
    1
  ELSE
    0
  END ASC,
  p0_.published_at DESC
LIMIT
  24

SELECT p0_.id AS id_0 FROM product p0_ LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id INNER JOIN product_tag p6_ ON p0_.id = p6_.product_id INNER JOIN tag t5_ ON t5_.id = p6_.tag_id WHERE p0_.status IN ('active', 'sold') AND p0_.display = 1 AND t5_.id IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23) GROUP BY p0_.id ORDER BY CASE WHEN p0_.status = 'sold' THEN 1 ELSE 0 END ASC, p0_.published_at DESC LIMIT 24;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id
  LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id
  LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id
  LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id
  INNER JOIN product_tag p6_ ON p0_.id = p6_.product_id
  INNER JOIN tag t5_ ON t5_.id = p6_.tag_id
WHERE
  p0_.status IN (?, ?)
  AND p0_.display = 1
  AND t5_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id INNER JOIN product_tag p6_ ON p0_.id = p6_.product_id INNER JOIN tag t5_ ON t5_.id = p6_.tag_id WHERE p0_.status IN ('active', 'sold') AND p0_.display = 1 AND t5_.id IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23);

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_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
  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,
  s4_.id AS id_63,
  s4_.street AS street_64,
  s4_.zip AS zip_65,
  s4_.country_code AS country_code_66,
  s4_.lat AS lat_67,
  s4_.lng AS lng_68,
  s4_.street_view_heading AS street_view_heading_69,
  s4_.street_view_pitch AS street_view_pitch_70,
  s4_.street_view_zoom AS street_view_zoom_71,
  g5_.id AS id_72,
  g5_.insee_code AS insee_code_73,
  g5_.name AS name_74,
  g5_.zip_codes AS zip_codes_75,
  g5_.lat AS lat_76,
  g5_.lng AS lng_77,
  p0_.seller_id AS seller_id_78,
  p1_.product_id AS product_id_79,
  s2_.user_id AS user_id_80,
  s3_.seller_id AS seller_id_81,
  s4_.seller_id AS seller_id_82,
  s4_.geo_city_id AS geo_city_id_83,
  g5_.department_id AS department_id_84
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
  LEFT JOIN seller_address s4_ ON s2_.id = s4_.seller_id
  LEFT JOIN geo_city g5_ ON s4_.geo_city_id = g5_.id
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND p0_.display = 1

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, s4_.id AS id_63, s4_.street AS street_64, s4_.zip AS zip_65, s4_.country_code AS country_code_66, s4_.lat AS lat_67, s4_.lng AS lng_68, s4_.street_view_heading AS street_view_heading_69, s4_.street_view_pitch AS street_view_pitch_70, s4_.street_view_zoom AS street_view_zoom_71, g5_.id AS id_72, g5_.insee_code AS insee_code_73, g5_.name AS name_74, g5_.zip_codes AS zip_codes_75, g5_.lat AS lat_76, g5_.lng AS lng_77, p0_.seller_id AS seller_id_78, p1_.product_id AS product_id_79, s2_.user_id AS user_id_80, s3_.seller_id AS seller_id_81, s4_.seller_id AS seller_id_82, s4_.geo_city_id AS geo_city_id_83, g5_.department_id AS department_id_84 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 LEFT JOIN seller_address s4_ ON s2_.id = s4_.seller_id LEFT JOIN geo_city g5_ ON s4_.geo_city_id = g5_.id WHERE p0_.id IN (177783, 177782, 177781, 177780, 177778, 177776, 177775, 177774, 177771, 177770, 177769, 177768, 177761, 177760, 177755, 177754, 177752, 177748, 177747, 177745, 177744, 177743, 177742, 177739) AND p0_.display = 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.tag_category_id AS tag_category_id_4,
  t0.parent_id AS parent_id_5
FROM
  tag t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.tag_category_id AS tag_category_id_4, t0.parent_id AS parent_id_5 FROM tag t0 WHERE t0.parent_id = 13;

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
  s0_.id AS id_0,
  s0_.tag_slug AS tag_slug_1,
  s0_.locale AS locale_2,
  s0_.meta_title AS meta_title_3,
  s0_.meta_description AS meta_description_4,
  s0_.intro_html AS intro_html_5,
  s0_.outro_html AS outro_html_6,
  s0_.faq_items AS faq_items_7,
  s0_.is_published AS is_published_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10
FROM
  seo_page_content s0_
WHERE
  s0_.tag_slug = ?
  AND s0_.locale = ?
  AND s0_.is_published = 1

SELECT s0_.id AS id_0, s0_.tag_slug AS tag_slug_1, s0_.locale AS locale_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.intro_html AS intro_html_5, s0_.outro_html AS outro_html_6, s0_.faq_items AS faq_items_7, s0_.is_published AS is_published_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM seo_page_content s0_ WHERE s0_.tag_slug = 'styles-francais' AND s0_.locale = 'es' AND s0_.is_published = 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.tag_category_id AS tag_category_id_4,
  t0.parent_id AS parent_id_5
FROM
  tag t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.tag_category_id AS tag_category_id_4, t0.parent_id AS parent_id_5 FROM tag t0 WHERE t0.slug = 'styles-francais' LIMIT 1;