Symfony Profiler

SELECT
  p0_.id AS id_0,
  COUNT(DISTINCT t1_.id) AS sclr_1
FROM
  product p0_
  LEFT JOIN product_tag p2_ ON p0_.id = p2_.product_id
  LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id
  AND (
    t1_.id IN (?, ?, ?, ?, ?)
  )
WHERE
  p0_.seller_id = ?
  AND p0_.id <> ?
  AND p0_.status = ?
  AND p0_.display = 1
GROUP BY
  p0_.id
ORDER BY
  sclr_1 DESC,
  CASE WHEN p0_.is_week_featured = 1 THEN
    1
  ELSE
    0
  END DESC,
  p0_.published_at DESC
LIMIT
  4

SELECT p0_.id AS id_0, COUNT(DISTINCT t1_.id) AS sclr_1 FROM product p0_ LEFT JOIN product_tag p2_ ON p0_.id = p2_.product_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id AND (t1_.id IN (106, 151, 173, 281, 291)) WHERE p0_.seller_id = 6240 AND p0_.id <> 93720 AND p0_.status = 'active' AND p0_.display = 1 GROUP BY p0_.id ORDER BY sclr_1 DESC, CASE WHEN p0_.is_week_featured = 1 THEN 1 ELSE 0 END DESC, p0_.published_at DESC LIMIT 4;

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

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,
  t5_.id AS id_72,
  t5_.slug AS slug_73,
  t5_.created_at AS created_at_74,
  t6_.id AS id_75,
  t6_.key_name AS key_name_76,
  t6_.position AS position_77,
  t6_.filterable AS filterable_78,
  t6_.icon AS icon_79,
  p0_.seller_id AS seller_id_80,
  p1_.product_id AS product_id_81,
  s2_.user_id AS user_id_82,
  s3_.seller_id AS seller_id_83,
  s4_.seller_id AS seller_id_84,
  s4_.geo_city_id AS geo_city_id_85,
  t5_.tag_category_id AS tag_category_id_86,
  t5_.parent_id AS parent_id_87
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 product_tag p7_ ON p0_.id = p7_.product_id
  LEFT JOIN tag t5_ ON t5_.id = p7_.tag_id
  LEFT JOIN tag_category t6_ ON t5_.tag_category_id = t6_.id
WHERE
  p0_.slug = ?

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, t5_.id AS id_72, t5_.slug AS slug_73, t5_.created_at AS created_at_74, t6_.id AS id_75, t6_.key_name AS key_name_76, t6_.position AS position_77, t6_.filterable AS filterable_78, t6_.icon AS icon_79, p0_.seller_id AS seller_id_80, p1_.product_id AS product_id_81, s2_.user_id AS user_id_82, s3_.seller_id AS seller_id_83, s4_.seller_id AS seller_id_84, s4_.geo_city_id AS geo_city_id_85, t5_.tag_category_id AS tag_category_id_86, t5_.parent_id AS parent_id_87 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 product_tag p7_ ON p0_.id = p7_.product_id LEFT JOIN tag t5_ ON t5_.id = p7_.tag_id LEFT JOIN tag_category t6_ ON t5_.tag_category_id = t6_.id WHERE p0_.slug = '478-m-93720';

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
  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,
  p0_.seller_id AS seller_id_29,
  p1_.product_id AS product_id_30
FROM
  product p0_
  LEFT JOIN product_image p1_ ON p0_.id = p1_.product_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, p0_.seller_id AS seller_id_29, p1_.product_id AS product_id_30 FROM product p0_ LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id WHERE p0_.id IN (170624, 154298, 110900, 76248);

SELECT
  t0.id AS id_1,
  t0.mode AS mode_2,
  t0.price AS price_3,
  t0.currency AS currency_4,
  t0.estimated_delay AS estimated_delay_5,
  t0.carrier_info AS carrier_info_6,
  t0.product_id AS product_id_7,
  t0.shipping_zone_id AS shipping_zone_id_8
FROM
  product_shipping_rule t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.mode AS mode_2, t0.price AS price_3, t0.currency AS currency_4, t0.estimated_delay AS estimated_delay_5, t0.carrier_info AS carrier_info_6, t0.product_id AS product_id_7, t0.shipping_zone_id AS shipping_zone_id_8 FROM product_shipping_rule t0 WHERE t0.product_id = 93720;

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