GET http://dev.bussiness-car.profsoft.online/api/cars/newArrivals?cityId=1

Query Metrics

29 Database Queries
10 Different statements
103.81 ms Query time
1 Invalid entities
216 Managed entities

Grouped Statements

Show all queries

Time Count Info
93.10 ms
(89.68%)
7
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 = ?
Parameters:
[
  3
]
3.18 ms
(3.06%)
12
SELECT t0.id AS id_1, t0.path AS path_2, t0.url AS url_3, t0.feedback_id AS feedback_id_4, t0.car_id AS car_id_5, t0.story_id AS story_id_6 FROM file t0 WHERE t0.car_id = ?
Parameters:
[
  22504
]
2.49 ms
(2.40%)
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, c0_.brand_id AS brand_id_39, c0_.city_id AS city_id_40, c0_.dealer_id AS dealer_id_41 FROM car c0_ WHERE c0_.city_id = ? AND c0_.new_in_stock = true AND c0_.is_bought = false LIMIT 12
Parameters:
[
  1
]
1.09 ms
(1.05%)
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 = ?
Parameters:
[
  1272
]
0.97 ms
(0.94%)
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 = ? AND t0.status = ? LIMIT 1
Parameters:
[
  "5eb5f44b9ec3259c776c697be3a9acc9"
  10
]
0.87 ms
(0.83%)
3
SELECT t0.id AS id_1, t0.poi_id AS poi_id_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.phone AS phone_6, t0.address AS address_7, t0.salon_time AS salon_time_8, t0.service_time AS service_time_9, t0.rating AS rating_10, t0.min_image AS min_image_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.timeslots AS timeslots_14, t0.external_id AS external_id_15, t0.city_id AS city_id_16, t0.brand_id AS brand_id_17 FROM dealer t0 WHERE t0.id = ?
Parameters:
[
  3607
]
0.66 ms
(0.63%)
1
SELECT t0.id AS id_1, t0.map AS map_2, t0.phone_number AS phone_number_3, t0.name AS name_4, t0.external_id AS external_id_5, t0.timezone AS timezone_6 FROM city t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.58 ms
(0.55%)
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 INNER JOIN brand_city ON t0.id = brand_city.brand_id WHERE brand_city.city_id = ?
Parameters:
[
  1
]
0.57 ms
(0.54%)
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 = ? 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
Parameters:
[
  1272
  10
  20
  30
  "2026-05-26 17:04:27"
]
0.31 ms
(0.30%)
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 = ? LIMIT 1
Parameters:
[
  "79992950995"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\File 184
App\Entity\Brand 14
App\Entity\Car 12
App\Entity\Dealer 3
App\Entity\Device 1
App\Entity\User 1
App\Entity\City 1

Entities Mapping

Class Mapping errors
App\Entity\Device No errors.
App\Entity\User No errors.
App\Entity\Dealer No errors.
App\Entity\City
  • The mappings App\Entity\City#notifications and App\Entity\Story#cities are inconsistent with each other.
App\Entity\Invoice No errors.
App\Entity\Order No errors.
App\Entity\UserWatchedFavourite No errors.
App\Entity\Notification No errors.
App\Entity\FeedbackSession No errors.
App\Entity\CarEvaluationRequest No errors.
App\Entity\Car No errors.
App\Entity\Brand No errors.
App\Entity\File No errors.
App\Entity\SpecialOffer No errors.
App\Entity\Disc No errors.
App\Entity\Tire No errors.
App\Entity\WheelSet No errors.
App\Entity\Story No errors.
App\Entity\Assistance No errors.