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 = 'philippe-cote-antiquites-15358';

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

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

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

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 = 15358 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 = 15358 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
  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,
  t2_.id AS id_29,
  t2_.slug AS slug_30,
  t2_.created_at AS created_at_31,
  p3_.id AS id_32,
  p3_.locale AS locale_33,
  p3_.title AS title_34,
  p3_.description AS description_35,
  p3_.auto_translated AS auto_translated_36,
  p3_.translated_at AS translated_at_37,
  s4_.id AS id_38,
  s4_.slug AS slug_39,
  s4_.status AS status_40,
  s4_.stripe_account_id AS stripe_account_id_41,
  s4_.stripe_customer_id AS stripe_customer_id_42,
  s4_.stripe_kyc_complete AS stripe_kyc_complete_43,
  s4_.paypal_email AS paypal_email_44,
  s4_.paypal_merchant_id AS paypal_merchant_id_45,
  s4_.paypal_account_status AS paypal_account_status_46,
  s4_.paypal_permissions_granted AS paypal_permissions_granted_47,
  s4_.created_at AS created_at_48,
  s4_.activated_at AS activated_at_49,
  s4_.suspended_at AS suspended_at_50,
  s4_.commercial_status AS commercial_status_51,
  s4_.subscribed_since AS subscribed_since_52,
  s4_.subscription_ends_at AS subscription_ends_at_53,
  s4_.crm_priority AS crm_priority_54,
  s4_.next_reminder_at AS next_reminder_at_55,
  s4_.next_reminder_note AS next_reminder_note_56,
  s4_.prospect_source AS prospect_source_57,
  s4_.prospect_collected_at AS prospect_collected_at_58,
  s4_.crm_flag_for_human AS crm_flag_for_human_59,
  s5_.id AS id_60,
  s5_.business_name AS business_name_61,
  s5_.description AS description_62,
  s5_.siret AS siret_63,
  s5_.vat_number AS vat_number_64,
  s5_.phone AS phone_65,
  s5_.website AS website_66,
  s5_.logo_path AS logo_path_67,
  s5_.banner_path AS banner_path_68,
  s5_.opening_hours AS opening_hours_69,
  s5_.filter_tag_category_keys AS filter_tag_category_keys_70,
  s5_.updated_at AS updated_at_71,
  s6_.id AS id_72,
  s6_.street AS street_73,
  s6_.zip AS zip_74,
  s6_.country_code AS country_code_75,
  s6_.lat AS lat_76,
  s6_.lng AS lng_77,
  s6_.street_view_heading AS street_view_heading_78,
  s6_.street_view_pitch AS street_view_pitch_79,
  s6_.street_view_zoom AS street_view_zoom_80,
  p0_.seller_id AS seller_id_81,
  p1_.product_id AS product_id_82,
  t2_.tag_category_id AS tag_category_id_83,
  t2_.parent_id AS parent_id_84,
  p3_.product_id AS product_id_85,
  s4_.user_id AS user_id_86,
  s5_.seller_id AS seller_id_87,
  s6_.seller_id AS seller_id_88,
  s6_.geo_city_id AS geo_city_id_89
FROM
  product p0_
  LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id
  LEFT JOIN product_tag p7_ ON p0_.id = p7_.product_id
  LEFT JOIN tag t2_ ON t2_.id = p7_.tag_id
  LEFT JOIN product_translation p3_ ON p0_.id = p3_.product_id
  LEFT JOIN seller s4_ ON p0_.seller_id = s4_.id
  LEFT JOIN seller_profile s5_ ON s4_.id = s5_.seller_id
  LEFT JOIN seller_address s6_ ON s4_.id = s6_.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, t2_.id AS id_29, t2_.slug AS slug_30, t2_.created_at AS created_at_31, p3_.id AS id_32, p3_.locale AS locale_33, p3_.title AS title_34, p3_.description AS description_35, p3_.auto_translated AS auto_translated_36, p3_.translated_at AS translated_at_37, s4_.id AS id_38, s4_.slug AS slug_39, s4_.status AS status_40, s4_.stripe_account_id AS stripe_account_id_41, s4_.stripe_customer_id AS stripe_customer_id_42, s4_.stripe_kyc_complete AS stripe_kyc_complete_43, s4_.paypal_email AS paypal_email_44, s4_.paypal_merchant_id AS paypal_merchant_id_45, s4_.paypal_account_status AS paypal_account_status_46, s4_.paypal_permissions_granted AS paypal_permissions_granted_47, s4_.created_at AS created_at_48, s4_.activated_at AS activated_at_49, s4_.suspended_at AS suspended_at_50, s4_.commercial_status AS commercial_status_51, s4_.subscribed_since AS subscribed_since_52, s4_.subscription_ends_at AS subscription_ends_at_53, s4_.crm_priority AS crm_priority_54, s4_.next_reminder_at AS next_reminder_at_55, s4_.next_reminder_note AS next_reminder_note_56, s4_.prospect_source AS prospect_source_57, s4_.prospect_collected_at AS prospect_collected_at_58, s4_.crm_flag_for_human AS crm_flag_for_human_59, s5_.id AS id_60, s5_.business_name AS business_name_61, s5_.description AS description_62, s5_.siret AS siret_63, s5_.vat_number AS vat_number_64, s5_.phone AS phone_65, s5_.website AS website_66, s5_.logo_path AS logo_path_67, s5_.banner_path AS banner_path_68, s5_.opening_hours AS opening_hours_69, s5_.filter_tag_category_keys AS filter_tag_category_keys_70, s5_.updated_at AS updated_at_71, s6_.id AS id_72, s6_.street AS street_73, s6_.zip AS zip_74, s6_.country_code AS country_code_75, s6_.lat AS lat_76, s6_.lng AS lng_77, s6_.street_view_heading AS street_view_heading_78, s6_.street_view_pitch AS street_view_pitch_79, s6_.street_view_zoom AS street_view_zoom_80, p0_.seller_id AS seller_id_81, p1_.product_id AS product_id_82, t2_.tag_category_id AS tag_category_id_83, t2_.parent_id AS parent_id_84, p3_.product_id AS product_id_85, s4_.user_id AS user_id_86, s5_.seller_id AS seller_id_87, s6_.seller_id AS seller_id_88, s6_.geo_city_id AS geo_city_id_89 FROM product p0_ LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id LEFT JOIN product_tag p7_ ON p0_.id = p7_.product_id LEFT JOIN tag t2_ ON t2_.id = p7_.tag_id LEFT JOIN product_translation p3_ ON p0_.id = p3_.product_id LEFT JOIN seller s4_ ON p0_.seller_id = s4_.id LEFT JOIN seller_profile s5_ ON s4_.id = s5_.seller_id LEFT JOIN seller_address s6_ ON s4_.id = s6_.seller_id WHERE p0_.id IN (177742, 177739, 177678, 177673, 177672, 177626, 177625, 177619, 177604, 177597, 177586, 177576, 177575, 177573, 177572, 177570, 177502, 177492, 177491, 177411, 177410, 177408, 177392, 177391);

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 = 15358 AND p1_.status IN ('active', 'sold') AND p1_.display = 1 GROUP BY t0_.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.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

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.id IN (14, 15, 16, 17, 18, 21, 23, 26, 48, 93, 94, 96, 101, 102, 103, 106, 107, 108, 109, 110, 111, 113, 114, 115, 118, 123, 125, 136, 140, 141, 142, 143, 144, 148, 149, 150, 151, 153, 154, 155, 159, 164, 165, 167, 168, 171, 172, 173, 174, 175, 176, 177, 178, 179, 181, 182, 183, 184, 185, 187, 188, 189, 192, 196, 197, 198, 200, 201, 202, 203, 204, 206, 207, 208, 209, 210, 211, 212, 213, 215, 219, 225, 226, 227, 233, 235, 236, 238, 240, 242, 244, 245, 250, 251, 252, 254, 256, 260, 261, 262, 264, 268, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 289, 290, 291, 292);

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

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