Query Metrics
2
Database Queries
2
Different statements
2.18 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.24 ms (56.82%) |
1 |
SELECT j0_.id AS id_0, j0_.description AS description_1, j0_.date_job AS date_job_2, j0_.test_status AS test_status_3, j0_.test_date AS test_date_4, j1_.id AS id_5, j1_.name AS name_6, j1_.description AS description_7, j1_.code1c AS code1c_8, j1_.date_entered AS date_entered_9, j1_.date AS date_10, j1_.date_start AS date_start_11, j1_.date_end AS date_end_12, j1_.status AS status_13, j1_.comentar AS comentar_14, j1_.date_start_audit AS date_start_audit_15, j1_.date_audit AS date_audit_16, j1_.date_send_c1 AS date_send_c1_17, j1_.status_main_engineer_op AS status_main_engineer_op_18, j1_.date_main_engineer_op AS date_main_engineer_op_19, w2_.id AS id_20, w2_.full_name AS full_name_21, w2_.date_entered AS date_entered_22, w2_.description AS description_23, w2_.code1c AS code1c_24, w2_.code_ipn AS code_ipn_25, w2_.phone AS phone_26, w2_.email AS email_27, w2_.date_start AS date_start_28, w2_.date_end AS date_end_29, w2_.position AS position_30, w2_.date_of_birth AS date_of_birth_31, w2_.seria_pasport AS seria_pasport_32, w2_.number_pasport AS number_pasport_33, w2_.status AS status_34, j0_.job_id AS job_id_35, j0_.worker_id AS worker_id_36, j1_.account_id AS account_id_37, j1_.commandment_id AS commandment_id_38, j1_.graph_id AS graph_id_39, j1_.protocole_id AS protocole_id_40, j1_.engineer_id AS engineer_id_41, j1_.factory_id AS factory_id_42, j1_.assigned_user_id AS assigned_user_id_43, j1_.main_engineer_op_id AS main_engineer_op_id_44, w2_.photo_id AS photo_id_45, w2_.user_image_id AS user_image_id_46 FROM job_worker j0_ LEFT JOIN jobs j1_ ON j0_.job_id = j1_.id LEFT JOIN workers w2_ ON j0_.worker_id = w2_.id WHERE j0_.id = ?
Parameters:
[
3127
]
|
0.94 ms (43.18%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.code_user AS code_user_11, t0.code_manager AS code_manager_12, t0.work_schedule AS work_schedule_13, t0.telegram AS telegram_14, t0.viber AS viber_15, t0.is_main_engineer_op AS is_main_engineer_op_16, t0.manager_id AS manager_id_17, t0.location_id AS location_id_18 FROM users t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"bots"
]
|
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 |
|
App\Entity\Location | No errors. |
App\Entity\UserLikeList | No errors. |
App\Entity\Products |
|
App\Entity\Orders |
|
App\Entity\Accounts | No errors. |
App\Entity\LoadInvoice | No errors. |
App\Entity\Accepted |
|
App\Entity\AcceptedProduct | No errors. |
App\Entity\PreOrder | No errors. |
App\Entity\MediaObject | No errors. |
App\Entity\Coupons | No errors. |
App\Entity\UsersDocs | No errors. |
App\Entity\ProductBalanceInStorage | No errors. |
App\Entity\Jobs |
|
App\Entity\JobWorker | No errors. |
App\Entity\Workers | No errors. |
App\Entity\Engineer | No errors. |
App\Entity\Factory | No errors. |