Query Metrics
4
Database Queries
4
Different statements
71.72 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
69.64 ms (97.10%) |
1 |
SELECT t0.user_id AS user_id_1, t0.user_outside_id AS user_outside_id_2, t0.user_type AS user_type_3, t0.user_api_type AS user_api_type_4, t0.user_login AS user_login_5, t0.user_password AS user_password_6, t0.user_checksum AS user_checksum_7, t0.user_status AS user_status_8, t0.user_token AS user_token_9, t0.user_token_exp AS user_token_exp_10, t0.user_last_login AS user_last_login_11, t0.user_created_at AS user_created_at_12, t0.user_updated_at AS user_updated_at_13, t0.user_deleted_at AS user_deleted_at_14, t0.user_public_approved AS user_public_approved_15, t0.user_public_blocked AS user_public_blocked_16, t0.user_public_app_code AS user_public_app_code_17, t0.user_public_app_code_sended_at AS user_public_app_code_sended_at_18, t0.user_public_app_code_registered_at AS user_public_app_code_registered_at_19, t0.user_option AS user_option_20, t0.user_public_app_code_hash AS user_public_app_code_hash_21, t0.user_api_setting_sms AS user_api_setting_sms_22, t0.user_api_setting_email AS user_api_setting_email_23, t0.user_api_setting_mobile AS user_api_setting_mobile_24, t0.user_special AS user_special_25, t0.google_authenticator_secret AS google_authenticator_secret_26, t27.user_detail_id AS user_detail_id_28, t27.user_detail_name AS user_detail_name_29, t27.user_detail_surname AS user_detail_surname_30, t27.user_detail_sex AS user_detail_sex_31, t27.user_detail_personal_id_type AS user_detail_personal_id_type_32, t27.user_detail_personal_id AS user_detail_personal_id_33, t27.user_detail_birthday AS user_detail_birthday_34, t27.user_detail_email AS user_detail_email_35, t27.user_detail_phone AS user_detail_phone_36, t27.user_detail_street AS user_detail_street_37, t27.user_detail_street_no AS user_detail_street_no_38, t27.user_detail_post_code AS user_detail_post_code_39, t27.user_detail_state AS user_detail_state_40, t27.user_detail_province AS user_detail_province_41, t27.user_detail_comunity AS user_detail_comunity_42, t27.user_detail_city AS user_detail_city_43, t27.user_detail_personal_id_hash AS user_detail_personal_id_hash_44, t27.user_detail_surname_hash AS user_detail_surname_hash_45, t27.user_id AS user_id_46 FROM user t0 LEFT JOIN user_detail t27 ON t27.user_id = t0.user_id WHERE t0.user_login = ? LIMIT 1
Parameters:
[
"contento"
]
|
||||||||||||||||||||||||||||||||||
1.02 ms (1.43%) |
1 |
SELECT t0.user_mob_device_id AS user_mob_device_id_1, t0.user_mob_device_uuid AS user_mob_device_uuid_2, t0.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_3, t0.user_mob_device_created_at AS user_mob_device_created_at_4, t0.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_5, t0.user_mob_device_default_lang AS user_mob_device_default_lang_6, t0.user_mob_device_sec_token AS user_mob_device_sec_token_7, t0.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_8, t0.user_mob_device_app_version AS user_mob_device_app_version_9, t0.user_mob_device_model AS user_mob_device_model_10, t0.user_mob_device_os AS user_mob_device_os_11, t0.user_mob_device_user_id AS user_mob_device_user_id_12 FROM user_mob_device t0 WHERE t0.user_mob_device_uuid = ? AND t0.user_mob_device_sec_token = ? LIMIT 1
Parameters:
[ "B77DFBB6-91D0-4279-A743-758702F67B63" "ddfbcc6f-c8ae-42fb-b8db-5be8e298ec9d-34132613dad844f7e85745aa74744ebb530d762c-916edb70-209b-4b73-ac29-8d3d383de348" ]
|
||||||||||||||||||||||||||||||||||
0.67 ms (0.94%) |
1 |
SELECT s0_.id AS id_0, s0_.sticky_title AS sticky_title_1, s0_.sticky_message AS sticky_message_2, s0_.sticky_availability AS sticky_availability_3, s0_.sticky_type AS sticky_type_4, s0_.sticky_can_close AS sticky_can_close_5, s0_.sticky_can_permanently_close AS sticky_can_permanently_close_6, s0_.sticky_show_once AS sticky_show_once_7, s0_.sticky_link AS sticky_link_8, s0_.sticky_close_on_link AS sticky_close_on_link_9, s0_.sticky_created_by AS sticky_created_by_10, s0_.sticky_created_at AS sticky_created_at_11, s0_.sticky_updated_by AS sticky_updated_by_12, s0_.sticky_updated_at AS sticky_updated_at_13 FROM sticky s0_ WHERE s0_.sticky_availability >= ? ORDER BY s0_.id DESC, s0_.sticky_availability DESC
Parameters:
[
1752960104
]
|
||||||||||||||||||||||||||||||||||
0.38 ms (0.53%) |
1 |
SELECT t0.user_to_role_id AS user_to_role_id_1, t0.read_perm AS read_perm_2, t0.write_perm AS write_perm_3, t0.user_to_role_created_at AS user_to_role_created_at_4, t0.user_to_role_updated_at AS user_to_role_updated_at_5, t0.user_id AS user_id_6, t0.user_role_id AS user_role_id_7 FROM user_to_role t0 WHERE t0.user_id = ?
Parameters:
[
2
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\UserDetail | No errors. |
App\Entity\UserToRole | No errors. |
App\Entity\SendMethod | No errors. |
App\Entity\Category | No errors. |
App\Entity\Fault | No errors. |
App\Entity\UserGroup | No errors. |
App\Entity\UserMobDevice |
|
App\Entity\SendQueue | No errors. |
App\Entity\Notice | No errors. |
App\Entity\TerytHistory | No errors. |
App\Entity\Unit | No errors. |
App\Entity\UserToPartner | No errors. |
App\Entity\UserToCityCard | No errors. |
App\Entity\FormData | No errors. |
App\Entity\UserToStatute | No errors. |
App\Entity\UserToOutsideSystem | No errors. |
App\Entity\UserRole | No errors. |
App\Entity\UserMobDeviceToCategory | No errors. |
App\Entity\UserMobDeviceToGarbage | No errors. |
App\Entity\CityCardCode | No errors. |
App\Entity\UserMobDeviceToken | No errors. |
App\Entity\UserMobDeviceConfig |
|
App\Entity\ContentLikesToUserMobDevice | No errors. |
App\Entity\Sticky | No errors. |