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
  s0_.id AS id_0,
  s0_.slug AS slug_1,
  s0_.status AS status_2,
  s0_.stripe_account_id AS stripe_account_id_3,
  s0_.stripe_customer_id AS stripe_customer_id_4,
  s0_.stripe_kyc_complete AS stripe_kyc_complete_5,
  s0_.paypal_email AS paypal_email_6,
  s0_.paypal_merchant_id AS paypal_merchant_id_7,
  s0_.paypal_account_status AS paypal_account_status_8,
  s0_.paypal_permissions_granted AS paypal_permissions_granted_9,
  s0_.created_at AS created_at_10,
  s0_.activated_at AS activated_at_11,
  s0_.suspended_at AS suspended_at_12,
  s0_.commercial_status AS commercial_status_13,
  s0_.subscribed_since AS subscribed_since_14,
  s0_.subscription_ends_at AS subscription_ends_at_15,
  s0_.crm_priority AS crm_priority_16,
  s0_.next_reminder_at AS next_reminder_at_17,
  s0_.next_reminder_note AS next_reminder_note_18,
  s0_.prospect_source AS prospect_source_19,
  s0_.prospect_collected_at AS prospect_collected_at_20,
  s0_.crm_flag_for_human AS crm_flag_for_human_21,
  u1_.id AS id_22,
  u1_.email AS email_23,
  u1_.roles AS roles_24,
  u1_.password AS password_25,
  u1_.locale AS locale_26,
  u1_.email_verified_at AS email_verified_at_27,
  u1_.email_verification_token AS email_verification_token_28,
  u1_.email_verification_token_expires_at AS email_verification_token_expires_at_29,
  u1_.password_reset_token AS password_reset_token_30,
  u1_.password_reset_token_expires_at AS password_reset_token_expires_at_31,
  u1_.created_at AS created_at_32,
  u1_.last_login_at AS last_login_at_33,
  u1_.active AS active_34,
  u1_.email_bounced AS email_bounced_35,
  u1_.email_bounce_count AS email_bounce_count_36,
  u1_.email_bounce_type AS email_bounce_type_37,
  u1_.email_bounce_last_at AS email_bounce_last_at_38,
  u1_.email_bounce_reason AS email_bounce_reason_39,
  u1_.api_token_hash AS api_token_hash_40,
  u1_.stripe_customer_id AS stripe_customer_id_41,
  s0_.user_id AS user_id_42
FROM
  seller s0_
  LEFT JOIN user u1_ ON s0_.user_id = u1_.id
WHERE
  s0_.slug = ?

SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.status AS status_2, s0_.stripe_account_id AS stripe_account_id_3, s0_.stripe_customer_id AS stripe_customer_id_4, s0_.stripe_kyc_complete AS stripe_kyc_complete_5, s0_.paypal_email AS paypal_email_6, s0_.paypal_merchant_id AS paypal_merchant_id_7, s0_.paypal_account_status AS paypal_account_status_8, s0_.paypal_permissions_granted AS paypal_permissions_granted_9, s0_.created_at AS created_at_10, s0_.activated_at AS activated_at_11, s0_.suspended_at AS suspended_at_12, s0_.commercial_status AS commercial_status_13, s0_.subscribed_since AS subscribed_since_14, s0_.subscription_ends_at AS subscription_ends_at_15, s0_.crm_priority AS crm_priority_16, s0_.next_reminder_at AS next_reminder_at_17, s0_.next_reminder_note AS next_reminder_note_18, s0_.prospect_source AS prospect_source_19, s0_.prospect_collected_at AS prospect_collected_at_20, s0_.crm_flag_for_human AS crm_flag_for_human_21, u1_.id AS id_22, u1_.email AS email_23, u1_.roles AS roles_24, u1_.password AS password_25, u1_.locale AS locale_26, u1_.email_verified_at AS email_verified_at_27, u1_.email_verification_token AS email_verification_token_28, u1_.email_verification_token_expires_at AS email_verification_token_expires_at_29, u1_.password_reset_token AS password_reset_token_30, u1_.password_reset_token_expires_at AS password_reset_token_expires_at_31, u1_.created_at AS created_at_32, u1_.last_login_at AS last_login_at_33, u1_.active AS active_34, u1_.email_bounced AS email_bounced_35, u1_.email_bounce_count AS email_bounce_count_36, u1_.email_bounce_type AS email_bounce_type_37, u1_.email_bounce_last_at AS email_bounce_last_at_38, u1_.email_bounce_reason AS email_bounce_reason_39, u1_.api_token_hash AS api_token_hash_40, u1_.stripe_customer_id AS stripe_customer_id_41, s0_.user_id AS user_id_42 FROM seller s0_ LEFT JOIN user u1_ ON s0_.user_id = u1_.id WHERE s0_.slug = 'carre-rive-gauche-17146';

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.description AS description_3,
  t0.siret AS siret_4,
  t0.vat_number AS vat_number_5,
  t0.phone AS phone_6,
  t0.website AS website_7,
  t0.logo_path AS logo_path_8,
  t0.banner_path AS banner_path_9,
  t0.opening_hours AS opening_hours_10,
  t0.filter_tag_category_keys AS filter_tag_category_keys_11,
  t0.updated_at AS updated_at_12,
  t0.seller_id AS seller_id_13
FROM
  seller_profile t0
WHERE
  t0.seller_id = ?

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.description AS description_3, t0.siret AS siret_4, t0.vat_number AS vat_number_5, t0.phone AS phone_6, t0.website AS website_7, t0.logo_path AS logo_path_8, t0.banner_path AS banner_path_9, t0.opening_hours AS opening_hours_10, t0.filter_tag_category_keys AS filter_tag_category_keys_11, t0.updated_at AS updated_at_12, t0.seller_id AS seller_id_13 FROM seller_profile t0 WHERE t0.seller_id = 17146;

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

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.phone AS phone_4,
  t0.newsletter_opt_in AS newsletter_opt_in_5,
  t0.alert_preferences AS alert_preferences_6,
  t0.updated_at AS updated_at_7,
  t0.user_id AS user_id_8
FROM
  user_profile t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.newsletter_opt_in AS newsletter_opt_in_5, t0.alert_preferences AS alert_preferences_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM user_profile t0 WHERE t0.user_id = 17146;

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

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = 17146 AND p0_.status IN ('active', 'sold') AND p0_.display = 1;

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.seller_id = ?
  AND p0_.status IN (?, ?)
  AND p0_.display = 1
ORDER BY
  CASE WHEN p0_.status = ? THEN
    1
  ELSE
    0
  END ASC,
  p0_.created_at DESC
LIMIT
  24

SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.seller_id = 17146 AND p0_.status IN ('active', 'sold') AND p0_.display = 1 ORDER BY CASE WHEN p0_.status = 'sold' THEN 1 ELSE 0 END ASC, p0_.created_at DESC LIMIT 24;

SELECT
  t0_.id AS id_0,
  COUNT(DISTINCT p1_.id) AS sclr_1
FROM
  product p1_
  INNER JOIN product_tag p2_ ON p1_.id = p2_.product_id
  INNER JOIN tag t0_ ON t0_.id = p2_.tag_id
WHERE
  p1_.seller_id = ?
  AND p1_.status IN (?, ?)
  AND p1_.display = 1
GROUP BY
  t0_.id

SELECT t0_.id AS id_0, COUNT(DISTINCT p1_.id) AS sclr_1 FROM product p1_ INNER JOIN product_tag p2_ ON p1_.id = p2_.product_id INNER JOIN tag t0_ ON t0_.id = p2_.tag_id WHERE p1_.seller_id = 17146 AND p1_.status IN ('active', 'sold') AND p1_.display = 1 GROUP BY t0_.id;

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 = 'maps.google_api_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 = ?
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 = 'recaptcha.site_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 = ?
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 = 'recaptcha.secret_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 = ?
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 = 'recaptcha.site_key' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.description_translated AS description_translated_3,
  t0.auto_translated AS auto_translated_4,
  t0.translated_at AS translated_at_5,
  t0.seller_profile_id AS seller_profile_id_6
FROM
  seller_profile_translation t0
WHERE
  t0.seller_profile_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description_translated AS description_translated_3, t0.auto_translated AS auto_translated_4, t0.translated_at AS translated_at_5, t0.seller_profile_id AS seller_profile_id_6 FROM seller_profile_translation t0 WHERE t0.seller_profile_id = 341;

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

SELECT
  t0.id AS id_1,
  t0.insee_code AS insee_code_2,
  t0.name AS name_3,
  t0.region_id AS region_id_4
FROM
  geo_department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.insee_code AS insee_code_2, t0.name AS name_3, t0.region_id AS region_id_4 FROM geo_department t0 WHERE t0.id = 76;

SELECT
  t0.id AS id_1,
  t0.insee_code AS insee_code_2,
  t0.name AS name_3,
  t0.country_id AS country_id_4
FROM
  geo_region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.insee_code AS insee_code_2, t0.name AS name_3, t0.country_id AS country_id_4 FROM geo_region t0 WHERE t0.id = 13;