GET http://dev.bussiness-car.profsoft.online/api/userCars?limit=20&page=1

Response
200 OK
IP
10.244.0.176
Profiled on
Token
362352

Query Metrics

23 Database Queries
8 Different statements
11.43 ms Query time
1 Invalid entities
6 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.01 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: 
[
  "3829c8a8cc6f6a40c432b0f22b7b8c77"
  10
]
View formatted query    View runnable query    Explain query
2 0.61 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
]
View formatted query    View runnable query    Explain query
3 0.34 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"
]
View formatted query    View runnable query    Explain query
4 0.45 ms 
SELECT t0.id AS id_1, t0.video_player_title AS video_player_title_2, t0.is_video_player_have_tool_tip AS is_video_player_have_tool_tip_3, t0.tool_tip_description AS tool_tip_description_4, t0.no_video_description AS no_video_description_5, t0.deprecated_ios_version AS deprecated_ios_version_6, t0.hard_update_ios_version AS hard_update_ios_version_7, t0.deprecated_android_version AS deprecated_android_version_8, t0.hard_update_android_version AS hard_update_android_version_9, t0.deprecated_message AS deprecated_message_10, t0.hard_update_message AS hard_update_message_11, t0.default_tire_hotel_image_url AS default_tire_hotel_image_url_12, t0.default_tire_hotel_description AS default_tire_hotel_description_13, t0.evaluation_juridical_info AS evaluation_juridical_info_14, t0.popular_full_order AS popular_full_order_15, t0.used_cars_preview_image_url AS used_cars_preview_image_url_16 FROM settings t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 0.26 ms 
SELECT t0.id AS id_1, t0.video_player_title AS video_player_title_2, t0.is_video_player_have_tool_tip AS is_video_player_have_tool_tip_3, t0.tool_tip_description AS tool_tip_description_4, t0.no_video_description AS no_video_description_5, t0.deprecated_ios_version AS deprecated_ios_version_6, t0.hard_update_ios_version AS hard_update_ios_version_7, t0.deprecated_android_version AS deprecated_android_version_8, t0.hard_update_android_version AS hard_update_android_version_9, t0.deprecated_message AS deprecated_message_10, t0.hard_update_message AS hard_update_message_11, t0.default_tire_hotel_image_url AS default_tire_hotel_image_url_12, t0.default_tire_hotel_description AS default_tire_hotel_description_13, t0.evaluation_juridical_info AS evaluation_juridical_info_14, t0.popular_full_order AS popular_full_order_15, t0.used_cars_preview_image_url AS used_cars_preview_image_url_16 FROM settings t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 0.62 ms 
SELECT t0.id AS id_1, t0.video_player_title AS video_player_title_2, t0.is_video_player_have_tool_tip AS is_video_player_have_tool_tip_3, t0.tool_tip_description AS tool_tip_description_4, t0.no_video_description AS no_video_description_5, t0.deprecated_ios_version AS deprecated_ios_version_6, t0.hard_update_ios_version AS hard_update_ios_version_7, t0.deprecated_android_version AS deprecated_android_version_8, t0.hard_update_android_version AS hard_update_android_version_9, t0.deprecated_message AS deprecated_message_10, t0.hard_update_message AS hard_update_message_11, t0.default_tire_hotel_image_url AS default_tire_hotel_image_url_12, t0.default_tire_hotel_description AS default_tire_hotel_description_13, t0.evaluation_juridical_info AS evaluation_juridical_info_14, t0.popular_full_order AS popular_full_order_15, t0.used_cars_preview_image_url AS used_cars_preview_image_url_16 FROM settings t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.34 ms 
SELECT t0.id AS id_1, t0.video_player_title AS video_player_title_2, t0.is_video_player_have_tool_tip AS is_video_player_have_tool_tip_3, t0.tool_tip_description AS tool_tip_description_4, t0.no_video_description AS no_video_description_5, t0.deprecated_ios_version AS deprecated_ios_version_6, t0.hard_update_ios_version AS hard_update_ios_version_7, t0.deprecated_android_version AS deprecated_android_version_8, t0.hard_update_android_version AS hard_update_android_version_9, t0.deprecated_message AS deprecated_message_10, t0.hard_update_message AS hard_update_message_11, t0.default_tire_hotel_image_url AS default_tire_hotel_image_url_12, t0.default_tire_hotel_description AS default_tire_hotel_description_13, t0.evaluation_juridical_info AS evaluation_juridical_info_14, t0.popular_full_order AS popular_full_order_15, t0.used_cars_preview_image_url AS used_cars_preview_image_url_16 FROM settings t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 0.61 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "f40563eb-337e-43e6-9add-e74abe15391b"
]
View formatted query    View runnable query    Explain query
9 0.30 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "22f05880-fb52-4a4d-bb82-96e53da2aa5a"
]
View formatted query    View runnable query    Explain query
10 0.25 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "065b6d49-1dc8-4142-bb67-d9e119093d16"
]
View formatted query    View runnable query    Explain query
11 0.34 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
12 0.55 ms 
UPDATE car_evaluation_request SET evaluated_at = ? WHERE id = ?
Parameters: 
[
  "2026-06-09 16:13:46"
  426
]
View formatted query    View runnable query    Explain query
13 3.20 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
14 0.39 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "a3a38bc2-e0fc-482e-85bb-24a12d065b7a"
]
View formatted query    View runnable query    Explain query
15 0.30 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "f60eb8b4-5ef4-416e-8b3e-bf88decb0551"
]
View formatted query    View runnable query    Explain query
16 0.25 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "c77fc6d3-d269-4f33-b8de-e5b6ae565c24"
]
View formatted query    View runnable query    Explain query
17 0.24 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "838aadc3-a1fc-42de-a43b-22458914a4bc"
]
View formatted query    View runnable query    Explain query
18 0.23 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "c42350b7-a6e0-405a-923f-c03cf305c154"
]
View formatted query    View runnable query    Explain query
19 0.25 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "7f2eae03-5fcd-4a39-a52d-e83ebd11e17b"
]
View formatted query    View runnable query    Explain query
20 0.25 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "cccfc78b-a723-4e5d-a89a-2029ee383d6e"
]
View formatted query    View runnable query    Explain query
21 0.21 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "406e0e0b-fcc8-451b-8307-03d3d27c6544"
]
View formatted query    View runnable query    Explain query
22 0.22 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "0bfba291-56ea-420f-9567-aee9c25e3256"
]
View formatted query    View runnable query    Explain query
23 0.22 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_.car_id = ? ORDER BY c0_.issued_at DESC LIMIT 1
Parameters: 
[
  1272
  "21483ba2-01d5-4967-ba0f-5c29ead46187"
]
View formatted query    View runnable query    Explain query

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\CarEvaluationRequest 2
App\Entity\Device 1
App\Entity\User 1
App\Entity\City 1
App\Entity\Settings 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\Settings No errors.