Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.refresh_token AS refresh_token_3,
  t0.token_expired_at AS token_expired_at_4,
  t0.status AS status_5,
  t0.firebase_token AS firebase_token_6,
  t0.ip AS ip_7,
  t0.device_model AS device_model_8,
  t0.os AS os_9,
  t0.os_version AS os_version_10,
  t0.app_version AS app_version_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.last_activity_at AS last_activity_at_14,
  t0.client_timezone AS client_timezone_15,
  t0.user_id AS user_id_16
FROM
  device t0
WHERE
  t0.token = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.refresh_token AS refresh_token_3, t0.token_expired_at AS token_expired_at_4, t0.status AS status_5, t0.firebase_token AS firebase_token_6, t0.ip AS ip_7, t0.device_model AS device_model_8, t0.os AS os_9, t0.os_version AS os_version_10, t0.app_version AS app_version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.last_activity_at AS last_activity_at_14, t0.client_timezone AS client_timezone_15, t0.user_id AS user_id_16 FROM device t0 WHERE t0.token = '5eb5f44b9ec3259c776c697be3a9acc9' AND t0.status = 10 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.surname AS surname_3,
  t0.patronymic AS patronymic_4,
  t0.date_birth AS date_birth_5,
  t0.email AS email_6,
  t0.phone AS phone_7,
  t0.status AS status_8,
  t0.verification_status AS verification_status_9,
  t0.bonus AS bonus_10,
  t0.notification_subscription_status AS notification_subscription_status_11,
  t0.created_at AS created_at_12,
  t0.last_activity_at AS last_activity_at_13,
  t0.is_guest AS is_guest_14,
  t0.external_uid AS external_uid_15,
  t0.roles AS roles_16,
  t0.vk_id AS vk_id_17,
  t0.is_pin_enabled AS is_pin_enabled_18,
  t0.is_biometry_enabled AS is_biometry_enabled_19,
  t0.email_updated_at AS email_updated_at_20,
  t0.email_requested_at AS email_requested_at_21,
  t0.gender AS gender_22,
  t0.is_evaluation_on_catalog AS is_evaluation_on_catalog_23,
  t0.last_dealer_id AS last_dealer_id_24,
  t0.city_id AS city_id_25,
  t0.registration_city_id AS registration_city_id_26
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.surname AS surname_3, t0.patronymic AS patronymic_4, t0.date_birth AS date_birth_5, t0.email AS email_6, t0.phone AS phone_7, t0.status AS status_8, t0.verification_status AS verification_status_9, t0.bonus AS bonus_10, t0.notification_subscription_status AS notification_subscription_status_11, t0.created_at AS created_at_12, t0.last_activity_at AS last_activity_at_13, t0.is_guest AS is_guest_14, t0.external_uid AS external_uid_15, t0.roles AS roles_16, t0.vk_id AS vk_id_17, t0.is_pin_enabled AS is_pin_enabled_18, t0.is_biometry_enabled AS is_biometry_enabled_19, t0.email_updated_at AS email_updated_at_20, t0.email_requested_at AS email_requested_at_21, t0.gender AS gender_22, t0.is_evaluation_on_catalog AS is_evaluation_on_catalog_23, t0.last_dealer_id AS last_dealer_id_24, t0.city_id AS city_id_25, t0.registration_city_id AS registration_city_id_26 FROM "user" t0 WHERE t0.id = 1272;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.surname AS surname_3,
  t0.patronymic AS patronymic_4,
  t0.date_birth AS date_birth_5,
  t0.email AS email_6,
  t0.phone AS phone_7,
  t0.status AS status_8,
  t0.verification_status AS verification_status_9,
  t0.bonus AS bonus_10,
  t0.notification_subscription_status AS notification_subscription_status_11,
  t0.created_at AS created_at_12,
  t0.last_activity_at AS last_activity_at_13,
  t0.is_guest AS is_guest_14,
  t0.external_uid AS external_uid_15,
  t0.roles AS roles_16,
  t0.vk_id AS vk_id_17,
  t0.is_pin_enabled AS is_pin_enabled_18,
  t0.is_biometry_enabled AS is_biometry_enabled_19,
  t0.email_updated_at AS email_updated_at_20,
  t0.email_requested_at AS email_requested_at_21,
  t0.gender AS gender_22,
  t0.is_evaluation_on_catalog AS is_evaluation_on_catalog_23,
  t0.last_dealer_id AS last_dealer_id_24,
  t0.city_id AS city_id_25,
  t0.registration_city_id AS registration_city_id_26
FROM
  "user" t0
WHERE
  t0.phone = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.surname AS surname_3, t0.patronymic AS patronymic_4, t0.date_birth AS date_birth_5, t0.email AS email_6, t0.phone AS phone_7, t0.status AS status_8, t0.verification_status AS verification_status_9, t0.bonus AS bonus_10, t0.notification_subscription_status AS notification_subscription_status_11, t0.created_at AS created_at_12, t0.last_activity_at AS last_activity_at_13, t0.is_guest AS is_guest_14, t0.external_uid AS external_uid_15, t0.roles AS roles_16, t0.vk_id AS vk_id_17, t0.is_pin_enabled AS is_pin_enabled_18, t0.is_biometry_enabled AS is_biometry_enabled_19, t0.email_updated_at AS email_updated_at_20, t0.email_requested_at AS email_requested_at_21, t0.gender AS gender_22, t0.is_evaluation_on_catalog AS is_evaluation_on_catalog_23, t0.last_dealer_id AS last_dealer_id_24, t0.city_id AS city_id_25, t0.registration_city_id AS registration_city_id_26 FROM "user" t0 WHERE t0.phone = '79992950995' LIMIT 1;

SELECT
  c0_.id AS id_0,
  (CASE WHEN c1_.id = ? THEN
    0
  ELSE
    1
  END) AS sclr_1
FROM
  car c0_
  INNER JOIN city c1_ ON c0_.city_id = c1_.id
WHERE
  c0_.is_bought = false
ORDER BY
  sclr_1 ASC,
  c0_.availability ASC,
  c0_.id ASC
LIMIT
  1

SELECT c0_.id AS id_0, (CASE WHEN c1_.id = '1' THEN 0 ELSE 1 END) AS sclr_1 FROM car c0_ INNER JOIN city c1_ ON c0_.city_id = c1_.id WHERE c0_.is_bought = false ORDER BY sclr_1 ASC, c0_.availability ASC, c0_.id ASC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.car_guid AS car_guid_1,
  c0_.complectation_name AS complectation_name_2,
  c0_.vin AS vin_3,
  c0_.volume AS volume_4,
  c0_.engine AS engine_5,
  c0_.power AS power_6,
  c0_.gearbox AS gearbox_7,
  c0_.body_type AS body_type_8,
  c0_.wd AS wd_9,
  c0_.color AS color_10,
  c0_.description AS description_11,
  c0_.is_full_nds AS is_full_nds_12,
  c0_.is_original_pts AS is_original_pts_13,
  c0_.price AS price_14,
  c0_.credit_discount AS credit_discount_15,
  c0_.tradein_discount AS tradein_discount_16,
  c0_.insurance_discount AS insurance_discount_17,
  c0_.discount_price AS discount_price_18,
  c0_.max_discount AS max_discount_19,
  c0_.is_lovi_moment AS is_lovi_moment_20,
  c0_.run AS run_21,
  c0_.year AS year_22,
  c0_.owners_number AS owners_number_23,
  c0_.certification AS certification_24,
  c0_.certification_name AS certification_name_25,
  c0_.is_new AS is_new_26,
  c0_.extras AS extras_27,
  c0_.folder_id AS folder_id_28,
  c0_.video AS video_29,
  c0_.availability AS availability_30,
  c0_.model AS model_31,
  c0_.date_created AS date_created_32,
  c0_.date_deleted AS date_deleted_33,
  c0_.new_in_stock AS new_in_stock_34,
  c0_.is_bought AS is_bought_35,
  c0_.images AS images_36,
  c0_.original_images AS original_images_37,
  c0_.catch_moment AS catch_moment_38,
  b1_.id AS id_39,
  b1_.mark_id AS mark_id_40,
  b1_.image AS image_41,
  b1_.type AS type_42,
  b1_.external_id AS external_id_43,
  b1_.map_images AS map_images_44,
  d2_.id AS id_45,
  d2_.poi_id AS poi_id_46,
  d2_.name AS name_47,
  d2_.description AS description_48,
  d2_.image AS image_49,
  d2_.phone AS phone_50,
  d2_.address AS address_51,
  d2_.salon_time AS salon_time_52,
  d2_.service_time AS service_time_53,
  d2_.rating AS rating_54,
  d2_.min_image AS min_image_55,
  d2_.latitude AS latitude_56,
  d2_.longitude AS longitude_57,
  d2_.timeslots AS timeslots_58,
  d2_.external_id AS external_id_59,
  c3_.id AS id_60,
  c3_.map AS map_61,
  c3_.phone_number AS phone_number_62,
  c3_.name AS name_63,
  c3_.external_id AS external_id_64,
  c3_.timezone AS timezone_65,
  f4_.id AS id_66,
  f4_.path AS path_67,
  f4_.url AS url_68,
  f4_.feedback_id AS feedback_id_69,
  c0_.brand_id AS brand_id_70,
  c0_.city_id AS city_id_71,
  c0_.dealer_id AS dealer_id_72,
  d2_.city_id AS city_id_73,
  d2_.brand_id AS brand_id_74,
  f4_.car_id AS car_id_75,
  f4_.story_id AS story_id_76
FROM
  car c0_
  LEFT JOIN brand b1_ ON c0_.brand_id = b1_.id
  LEFT JOIN dealer d2_ ON c0_.dealer_id = d2_.id
  LEFT JOIN city c3_ ON c0_.city_id = c3_.id
  LEFT JOIN file f4_ ON c0_.id = f4_.car_id
WHERE
  c0_.id IN (?)

SELECT c0_.id AS id_0, c0_.car_guid AS car_guid_1, c0_.complectation_name AS complectation_name_2, c0_.vin AS vin_3, c0_.volume AS volume_4, c0_.engine AS engine_5, c0_.power AS power_6, c0_.gearbox AS gearbox_7, c0_.body_type AS body_type_8, c0_.wd AS wd_9, c0_.color AS color_10, c0_.description AS description_11, c0_.is_full_nds AS is_full_nds_12, c0_.is_original_pts AS is_original_pts_13, c0_.price AS price_14, c0_.credit_discount AS credit_discount_15, c0_.tradein_discount AS tradein_discount_16, c0_.insurance_discount AS insurance_discount_17, c0_.discount_price AS discount_price_18, c0_.max_discount AS max_discount_19, c0_.is_lovi_moment AS is_lovi_moment_20, c0_.run AS run_21, c0_.year AS year_22, c0_.owners_number AS owners_number_23, c0_.certification AS certification_24, c0_.certification_name AS certification_name_25, c0_.is_new AS is_new_26, c0_.extras AS extras_27, c0_.folder_id AS folder_id_28, c0_.video AS video_29, c0_.availability AS availability_30, c0_.model AS model_31, c0_.date_created AS date_created_32, c0_.date_deleted AS date_deleted_33, c0_.new_in_stock AS new_in_stock_34, c0_.is_bought AS is_bought_35, c0_.images AS images_36, c0_.original_images AS original_images_37, c0_.catch_moment AS catch_moment_38, b1_.id AS id_39, b1_.mark_id AS mark_id_40, b1_.image AS image_41, b1_.type AS type_42, b1_.external_id AS external_id_43, b1_.map_images AS map_images_44, d2_.id AS id_45, d2_.poi_id AS poi_id_46, d2_.name AS name_47, d2_.description AS description_48, d2_.image AS image_49, d2_.phone AS phone_50, d2_.address AS address_51, d2_.salon_time AS salon_time_52, d2_.service_time AS service_time_53, d2_.rating AS rating_54, d2_.min_image AS min_image_55, d2_.latitude AS latitude_56, d2_.longitude AS longitude_57, d2_.timeslots AS timeslots_58, d2_.external_id AS external_id_59, c3_.id AS id_60, c3_.map AS map_61, c3_.phone_number AS phone_number_62, c3_.name AS name_63, c3_.external_id AS external_id_64, c3_.timezone AS timezone_65, f4_.id AS id_66, f4_.path AS path_67, f4_.url AS url_68, f4_.feedback_id AS feedback_id_69, c0_.brand_id AS brand_id_70, c0_.city_id AS city_id_71, c0_.dealer_id AS dealer_id_72, d2_.city_id AS city_id_73, d2_.brand_id AS brand_id_74, f4_.car_id AS car_id_75, f4_.story_id AS story_id_76 FROM car c0_ LEFT JOIN brand b1_ ON c0_.brand_id = b1_.id LEFT JOIN dealer d2_ ON c0_.dealer_id = d2_.id LEFT JOIN city c3_ ON c0_.city_id = c3_.id LEFT JOIN file f4_ ON c0_.id = f4_.car_id WHERE c0_.id IN (24);

SELECT
  DISTINCT c0_.engine AS engine_0,
  c0_.gearbox AS gearbox_1,
  c0_.wd AS wd_2,
  c0_.body_type AS body_type_3,
  c0_.color AS color_4
FROM
  car c0_
WHERE
  c0_.is_bought = false

SELECT DISTINCT c0_.engine AS engine_0, c0_.gearbox AS gearbox_1, c0_.wd AS wd_2, c0_.body_type AS body_type_3, c0_.color AS color_4 FROM car c0_ WHERE c0_.is_bought = false;

SELECT
  DISTINCT c0_.name AS name_0,
  d1_.name AS name_1
FROM
  car c2_
  LEFT JOIN city c0_ ON c2_.city_id = c0_.id
  LEFT JOIN dealer d1_ ON c2_.dealer_id = d1_.id
WHERE
  c2_.is_bought = false

SELECT DISTINCT c0_.name AS name_0, d1_.name AS name_1 FROM car c2_ LEFT JOIN city c0_ ON c2_.city_id = c0_.id LEFT JOIN dealer d1_ ON c2_.dealer_id = d1_.id WHERE c2_.is_bought = false;

SELECT
  MIN(c0_.brand_id) AS sclr_0,
  b1_.mark_id AS mark_id_1,
  c0_.model AS model_2,
  c0_.complectation_name AS complectation_name_3
FROM
  car c0_
  INNER JOIN brand b1_ ON c0_.brand_id = b1_.id
WHERE
  c0_.is_bought = false
  AND b1_.type <> ?
GROUP BY
  b1_.mark_id,
  c0_.model,
  c0_.complectation_name
ORDER BY
  b1_.mark_id ASC,
  c0_.model ASC,
  c0_.complectation_name ASC

SELECT MIN(c0_.brand_id) AS sclr_0, b1_.mark_id AS mark_id_1, c0_.model AS model_2, c0_.complectation_name AS complectation_name_3 FROM car c0_ INNER JOIN brand b1_ ON c0_.brand_id = b1_.id WHERE c0_.is_bought = false AND b1_.type <> 3 GROUP BY b1_.mark_id, c0_.model, c0_.complectation_name ORDER BY b1_.mark_id ASC, c0_.model ASC, c0_.complectation_name ASC;

SELECT
  DISTINCT c0_.is_new AS is_new_0,
  c0_.is_full_nds AS is_full_nds_1,
  c0_.certification AS certification_2
FROM
  car c0_
WHERE
  c0_.is_bought = false

SELECT DISTINCT c0_.is_new AS is_new_0, c0_.is_full_nds AS is_full_nds_1, c0_.certification AS certification_2 FROM car c0_ WHERE c0_.is_bought = false;

SELECT
  MIN(c0_.year) AS sclr_0,
  MAX(c0_.year) AS sclr_1
FROM
  car c0_
WHERE
  c0_.is_bought = false

SELECT MIN(c0_.year) AS sclr_0, MAX(c0_.year) AS sclr_1 FROM car c0_ WHERE c0_.is_bought = false;

SELECT
  DISTINCT c0_.is_new AS is_new_0,
  c0_.is_full_nds AS is_full_nds_1,
  c0_.certification AS certification_2
FROM
  car c0_
WHERE
  c0_.is_bought = false

SELECT DISTINCT c0_.is_new AS is_new_0, c0_.is_full_nds AS is_full_nds_1, c0_.certification AS certification_2 FROM car c0_ WHERE c0_.is_bought = false;

SELECT
  MIN(c0_.brand_id) AS sclr_0,
  b1_.mark_id AS mark_id_1,
  c0_.model AS model_2,
  c0_.complectation_name AS complectation_name_3
FROM
  car c0_
  INNER JOIN brand b1_ ON c0_.brand_id = b1_.id
WHERE
  c0_.is_bought = false
  AND b1_.type <> ?
GROUP BY
  b1_.mark_id,
  c0_.model,
  c0_.complectation_name
ORDER BY
  b1_.mark_id ASC,
  c0_.model ASC,
  c0_.complectation_name ASC

SELECT MIN(c0_.brand_id) AS sclr_0, b1_.mark_id AS mark_id_1, c0_.model AS model_2, c0_.complectation_name AS complectation_name_3 FROM car c0_ INNER JOIN brand b1_ ON c0_.brand_id = b1_.id WHERE c0_.is_bought = false AND b1_.type <> 3 GROUP BY b1_.mark_id, c0_.model, c0_.complectation_name ORDER BY b1_.mark_id ASC, c0_.model ASC, c0_.complectation_name ASC;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  car c0_
WHERE
  c0_.is_bought = false

SELECT COUNT(c0_.id) AS sclr_0 FROM car c0_ WHERE c0_.is_bought = false;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  car c0_
WHERE
  c0_.is_bought = false

SELECT COUNT(c0_.id) AS sclr_0 FROM car c0_ WHERE c0_.is_bought = false;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.external_id AS external_id_1,
  s0_.title AS title_2,
  s0_.description AS description_3,
  s0_.type AS type_4,
  s0_.min_image AS min_image_5,
  s0_.max_image AS max_image_6,
  s0_.feedback_id AS feedback_id_7,
  s0_.sort AS sort_8,
  s0_.disclaimer AS disclaimer_9,
  s0_.date_at AS date_at_10,
  s0_.date_to AS date_to_11,
  s0_.car_type AS car_type_12,
  s0_.marks_filter AS marks_filter_13
FROM
  special_offer s0_
ORDER BY
  s0_.sort DESC,
  s0_.id DESC
LIMIT
  100

SELECT DISTINCT s0_.id AS id_0, s0_.external_id AS external_id_1, s0_.title AS title_2, s0_.description AS description_3, s0_.type AS type_4, s0_.min_image AS min_image_5, s0_.max_image AS max_image_6, s0_.feedback_id AS feedback_id_7, s0_.sort AS sort_8, s0_.disclaimer AS disclaimer_9, s0_.date_at AS date_at_10, s0_.date_to AS date_to_11, s0_.car_type AS car_type_12, s0_.marks_filter AS marks_filter_13 FROM special_offer s0_ ORDER BY s0_.sort DESC, s0_.id DESC LIMIT 100;

SELECT
  c0_.id AS id_0,
  c0_.car_id AS car_id_1,
  c0_.is_verified AS is_verified_2,
  c0_.status AS status_3,
  c0_.mileage AS mileage_4,
  c0_.year AS year_5,
  c0_.vin AS vin_6,
  c0_.issued_at AS issued_at_7,
  c0_.evaluated_at AS evaluated_at_8,
  c0_.evaluated_price AS evaluated_price_9,
  c0_.external_id AS external_id_10,
  c0_.error_message AS error_message_11,
  c0_.owner_id AS owner_id_12
FROM
  car_evaluation_request c0_
WHERE
  c0_.owner_id = ?
  AND (
    c0_.status IN (?, ?)
    OR (
      c0_.status = ?
      AND c0_.evaluated_at IS NOT NULL
      AND c0_.evaluated_at >= ?
    )
  )
ORDER BY
  c0_.issued_at DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.car_id AS car_id_1, c0_.is_verified AS is_verified_2, c0_.status AS status_3, c0_.mileage AS mileage_4, c0_.year AS year_5, c0_.vin AS vin_6, c0_.issued_at AS issued_at_7, c0_.evaluated_at AS evaluated_at_8, c0_.evaluated_price AS evaluated_price_9, c0_.external_id AS external_id_10, c0_.error_message AS error_message_11, c0_.owner_id AS owner_id_12 FROM car_evaluation_request c0_ WHERE c0_.owner_id = 1272 AND (c0_.status IN (10, 20) OR (c0_.status = 30 AND c0_.evaluated_at IS NOT NULL AND c0_.evaluated_at >= '2026-05-26 17:04:27')) ORDER BY c0_.issued_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.mark_id AS mark_id_2,
  t0.image AS image_3,
  t0.type AS type_4,
  t0.external_id AS external_id_5,
  t0.map_images AS map_images_6
FROM
  brand t0
  INNER JOIN brand_city ON t0.id = brand_city.brand_id
WHERE
  brand_city.city_id = ?

SELECT t0.id AS id_1, t0.mark_id AS mark_id_2, t0.image AS image_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.map_images AS map_images_6 FROM brand t0 INNER JOIN brand_city ON t0.id = brand_city.brand_id WHERE brand_city.city_id = 1;