Query Metrics
29
Database Queries
10
Different statements
103.81 ms
Query time
1
Invalid entities
216
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.97 ms |
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 ] |
| 2 | 1.09 ms |
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
]
|
| 3 | 0.31 ms |
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"
]
|
| 4 | 2.49 ms |
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
]
|
| 5 | 0.57 ms |
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" ] |
| 6 | 0.37 ms |
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
]
|
| 7 | 91.68 ms |
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
]
|
| 8 | 0.66 ms |
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
]
|
| 9 | 0.58 ms |
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
]
|
| 10 | 0.23 ms |
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:
[
24
]
|
| 11 | 0.40 ms |
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
]
|
| 12 | 0.22 ms |
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:
[
44
]
|
| 13 | 0.24 ms |
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:
[
22505
]
|
| 14 | 0.25 ms |
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:
[
21
]
|
| 15 | 0.27 ms |
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:
[
22506
]
|
| 16 | 0.23 ms |
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:
[
3649
]
|
| 17 | 0.21 ms |
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:
[
64
]
|
| 18 | 0.23 ms |
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:
[
22510
]
|
| 19 | 0.29 ms |
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:
[
43
]
|
| 20 | 0.26 ms |
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:
[
22512
]
|
| 21 | 0.27 ms |
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:
[
3650
]
|
| 22 | 0.38 ms |
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:
[
22513
]
|
| 23 | 0.21 ms |
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:
[
22514
]
|
| 24 | 0.21 ms |
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:
[
25
]
|
| 25 | 0.25 ms |
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:
[
22517
]
|
| 26 | 0.21 ms |
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:
[
22509
]
|
| 27 | 0.25 ms |
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:
[
22515
]
|
| 28 | 0.24 ms |
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:
[
22525
]
|
| 29 | 0.24 ms |
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:
[
22524
]
|
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 |
|
| 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. |