Query Metrics
2
Database Queries
2
Different statements
29.85 ms
Query time
3
Invalid entities
2
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
21.15 ms (70.86%) |
1 |
SELECT t0.id AS id_1, t0.fias_id AS fias_id_2, t0.name AS name_3, t0.postal_code AS postal_code_4, t0.country_name AS country_name_5, t0.country_code AS country_code_6, t0.kladr AS kladr_7, t0.federal_district AS federal_district_8, t0.region_type AS region_type_9, t0.region AS region_10, t0.area_type AS area_type_11, t0.area AS area_12, t0.city_type AS city_type_13, t0.city AS city_14, t0.settlement_type AS settlement_type_15, t0.settlement AS settlement_16, t0.fias_level AS fias_level_17, t0.okato AS okato_18, t0.oktmo AS oktmo_19, t0.timezone AS timezone_20, t0.timezone_name AS timezone_name_21, t0.latitude AS latitude_22, t0.longitude AS longitude_23, t0.population AS population_24, t0.foundation_year AS foundation_year_25 FROM "cities_reference" t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
8.70 ms (29.14%) |
1 |
SELECT u0_.id AS id_0, u0_.public_number AS public_number_1, u0_.date AS date_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.phone_numeric AS phone_numeric_5, u0_.privacy_mask AS privacy_mask_6, u0_.push_settings_mask AS push_settings_mask_7, u0_.publish_daily_count AS publish_daily_count_8, u0_.publish_daily_at AS publish_daily_at_9, u0_.settings AS settings_10, u0_.password AS password_11, u0_.about AS about_12, u0_.stuff AS stuff_13, u0_.vk_code_verifier AS vk_code_verifier_14, u0_.vk_id AS vk_id_15, u0_.vk_avatar AS vk_avatar_16, u0_.vk_profile_imported AS vk_profile_imported_17, u0_.vk_confirmed AS vk_confirmed_18, u0_.first_jwt_at AS first_jwt_at_19, u0_.new_email AS new_email_20, u0_.new_email_token AS new_email_token_21, u0_.status AS status_22, u0_.block_reason AS block_reason_23, u0_.role AS role_24, u0_.last_visit_at AS last_visit_at_25, u0_.activity_status AS activity_status_26, u0_.confirm_token_token AS confirm_token_token_27, u0_.confirm_token_expires AS confirm_token_expires_28, u0_.name_first AS name_first_29, u0_.name_last AS name_last_30, u0_.name_middle AS name_middle_31, u0_.avatar_small_hash AS avatar_small_hash_32, u0_.avatar_original_hash AS avatar_original_hash_33, u0_.reset_token_token AS reset_token_token_34, u0_.reset_token_expires AS reset_token_expires_35, u0_.city_id AS city_id_36 FROM "user_users" u0_ WHERE u0_.email = ?
Parameters:
[
"1a8395f8-35f3-4830-a427-6eae60d2c576@1f226046-3b14-49b3-9753-2b4c6bd31aba.com"
]
|
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\Model\User\Entity\User | 1 |
| App\Model\City\Entity\CityReference | 1 |