POST http://dev.bussiness-car.profsoft.online/api/users/firebase

Query Metrics

12 Database Queries
12 Different statements
155.73 ms Query time
1 Invalid entities
36 Managed entities

Queries

Group similar statements

# 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:
[
  "3829c8a8cc6f6a40c432b0f22b7b8c77"
  10
]
2 0.55 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 54.27 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 0.39 ms
"START TRANSACTION"
Parameters:
[]
5 0.59 ms
UPDATE device SET updated_at = ?, last_activity_at = ? WHERE id = ?
Parameters:
[
  "2026-06-09 16:13:35"
  "2026-06-09 16:13:35"
  1764
]
6 0.46 ms
UPDATE "user" SET last_activity_at = ? WHERE id = ?
Parameters:
[
  "2026-06-09 16:13:35"
  1272
]
7 1.59 ms
"COMMIT"
Parameters:
[]
8 0.46 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.number AS number_3, t0.total_amount AS total_amount_4, t0.total_amount_discount AS total_amount_discount_5, t0.status AS status_6, t0.dealer_id AS dealer_id_7, t0.created_user_id AS created_user_id_8 FROM invoice t0 WHERE t0.created_user_id = ?
Parameters:
[
  1272
]
9 0.74 ms
SELECT t0.id AS id_1, t0.header AS header_2, t0.date AS date_3, t0.service_type AS service_type_4, t0.number AS number_5, t0.total_amount AS total_amount_6, t0.total_amount_discount AS total_amount_discount_7, t0.status AS status_8, t0.recommendation AS recommendation_9, t0.consultant_name AS consultant_name_10, t0.consultant_position AS consultant_position_11, t0.created_user_id AS created_user_id_12 FROM "order" t0 WHERE t0.created_user_id = ?
Parameters:
[
  1272
]
10 94.56 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
]
11 0.77 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
]
12 0.37 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.user_id = ?
Parameters:
[
  1272
]

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\Device 26
App\Entity\Brand 8
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\Brand No errors.
App\Entity\Story No errors.
App\Entity\Car No errors.
App\Entity\SpecialOffer No errors.
App\Entity\Disc No errors.
App\Entity\WheelSet No errors.
App\Entity\Tire No errors.
App\Entity\Assistance No errors.