Query Metrics
3
Database Queries
3
Different statements
207.24 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.63 ms |
SELECT t0.device_uuid AS device_uuid_1, t0.roles AS roles_2, t0.password AS password_3, t0.token AS token_4, t0.operario_id AS operario_id_5 FROM jvn_device t0 WHERE t0.device_uuid = ? LIMIT 1
Parameters:
[
"6e8ad82d-06fa-4d98-974e-16798e962542"
]
|
| 2 | 162.05 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.body AS body_2, j0_.created_at AS created_at_3, j0_.notification_type AS notification_type_4, j0_.read AS read_5, j0_.dispatch_status AS dispatch_status_6, j0_.dispatched_at AS dispatched_at_7, j0_.dispatch_error_message AS dispatch_error_message_8, j1_.id AS id_9, j1_.name AS name_10, j1_.description AS description_11, j1_.priority AS priority_12, j1_.status AS status_13, j1_.start_date AS start_date_14, j1_.end_date AS end_date_15, j1_.event_date AS event_date_16, j1_.due_date AS due_date_17, j1_.event_place AS event_place_18, j1_.estimated_minutes AS estimated_minutes_19, j1_.worked_minutes AS worked_minutes_20, j1_.remaining_minutes AS remaining_minutes_21, j1_.last_modified AS last_modified_22, j1_.created_at AS created_at_23, j1_.type AS type_24, j1_.position AS position_25, j2_.id AS id_26, j2_.name AS name_27, j2_.chapter_order AS chapter_order_28, j2_.estimated_minutes AS estimated_minutes_29, j2_.worked_minutes AS worked_minutes_30, j2_.remaining_minutes AS remaining_minutes_31, j2_.workers AS workers_32, j2_.external_id AS external_id_33, j2_.triton_last_modified AS triton_last_modified_34, j2_.last_modified AS last_modified_35, j3_.id AS id_36, j3_.estimated_minutes AS estimated_minutes_37, j3_.worked_minutes AS worked_minutes_38, j3_.remaining_minutes AS remaining_minutes_39, j3_.workers AS workers_40, j3_.start_date AS start_date_41, j3_.due_date AS due_date_42, j3_.name AS name_43, j3_.status AS status_44, j3_.type AS type_45, j3_.last_update AS last_update_46, j3_.external_id AS external_id_47, j3_.triton_last_modified AS triton_last_modified_48, j3_.last_modified AS last_modified_49, j4_.id AS id_50, j4_.name AS name_51, j4_.manufacturer AS manufacturer_52, j4_.model AS model_53, j4_.country_code AS country_code_54, j4_.license AS license_55, j4_.external_id AS external_id_56, j4_.triton_last_modified AS triton_last_modified_57, j4_.last_modified AS last_modified_58, j5_.id AS id_59, j5_.estimated_minutes AS estimated_minutes_60, j5_.worked_minutes AS worked_minutes_61, j5_.remaining_minutes AS remaining_minutes_62, j5_.workers AS workers_63, j5_.start_date AS start_date_64, j5_.due_date AS due_date_65, j5_.name AS name_66, j5_.status AS status_67, j5_.type AS type_68, j5_.last_update AS last_update_69, j5_.external_id AS external_id_70, j5_.triton_last_modified AS triton_last_modified_71, j5_.last_modified AS last_modified_72, j6_.id AS id_73, j6_.name AS name_74, j6_.manufacturer AS manufacturer_75, j6_.model AS model_76, j6_.country_code AS country_code_77, j6_.license AS license_78, j6_.external_id AS external_id_79, j6_.triton_last_modified AS triton_last_modified_80, j6_.last_modified AS last_modified_81, j0_.task_id AS task_id_82, j0_.notified_user_id AS notified_user_id_83, j0_.work_order_id AS work_order_id_84, j1_.chapter_id AS chapter_id_85, j2_.work_order_id AS work_order_id_86, j2_.chapter_type_id AS chapter_type_id_87, j3_.ship_id AS ship_id_88, j3_.customer_id AS customer_id_89, j3_.wintering_id AS wintering_id_90, j4_.cliente_id AS cliente_id_91, j5_.ship_id AS ship_id_92, j5_.customer_id AS customer_id_93, j5_.wintering_id AS wintering_id_94, j6_.cliente_id AS cliente_id_95 FROM jvn_notification j0_ LEFT JOIN jvn_task j1_ ON j0_.task_id = j1_.id LEFT JOIN jvn_chapter j2_ ON j1_.chapter_id = j2_.id LEFT JOIN jvn_work_order j3_ ON j2_.work_order_id = j3_.id LEFT JOIN jvn_ship j4_ ON j3_.ship_id = j4_.id LEFT JOIN jvn_work_order j5_ ON j0_.work_order_id = j5_.id LEFT JOIN jvn_ship j6_ ON j5_.ship_id = j6_.id WHERE j0_.id IN (SELECT j7_.id FROM jvn_notification j7_ LEFT JOIN jvn_task j8_ ON j7_.task_id = j8_.id LEFT JOIN jvn_chapter j9_ ON j8_.chapter_id = j9_.id LEFT JOIN jvn_work_order j10_ ON j9_.work_order_id = j10_.id LEFT JOIN jvn_ship j11_ ON j10_.ship_id = j11_.id LEFT JOIN jvn_work_order j12_ ON j7_.work_order_id = j12_.id LEFT JOIN jvn_ship j13_ ON j12_.ship_id = j13_.id WHERE j7_.notified_user_id = ?) ORDER BY j0_.created_at DESC, j0_.id ASC LIMIT 30
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#913 : "6d86407d-a0da-507d-8623-71729ca95495" } ] |
| 3 | 43.56 ms |
SELECT count(DISTINCT j0_.id) AS sclr_0 FROM jvn_notification j0_ LEFT JOIN jvn_task j1_ ON j0_.task_id = j1_.id LEFT JOIN jvn_chapter j2_ ON j1_.chapter_id = j2_.id LEFT JOIN jvn_work_order j3_ ON j2_.work_order_id = j3_.id LEFT JOIN jvn_ship j4_ ON j3_.ship_id = j4_.id LEFT JOIN jvn_work_order j5_ ON j0_.work_order_id = j5_.id LEFT JOIN jvn_ship j6_ ON j5_.ship_id = j6_.id WHERE j0_.id IN (SELECT j7_.id FROM jvn_notification j7_ LEFT JOIN jvn_task j8_ ON j7_.task_id = j8_.id LEFT JOIN jvn_chapter j9_ ON j8_.chapter_id = j9_.id LEFT JOIN jvn_work_order j10_ ON j9_.work_order_id = j10_.id LEFT JOIN jvn_ship j11_ ON j10_.ship_id = j11_.id LEFT JOIN jvn_work_order j12_ ON j7_.work_order_id = j12_.id LEFT JOIN jvn_ship j13_ ON j12_.ship_id = j13_.id WHERE j7_.notified_user_id = ?)
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#913 : "6d86407d-a0da-507d-8623-71729ca95495" } ] |
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\JvnDevice | No errors. |
| App\Entity\JvnBaseSyncedEntity | No errors. |
| App\Entity\JvnUser | No errors. |
| App\Entity\JvnNotification | No errors. |
| App\Entity\JvnTask | No errors. |
| App\Entity\JvnChapter | No errors. |
| App\Entity\JvnWorkOrder | No errors. |
| App\Entity\JvnShip | No errors. |
| App\Entity\JvnChapterType | No errors. |
| App\Entity\JvnCustomer | No errors. |
| App\Entity\JvnWintering | No errors. |
| App\Entity\JvnTaskComment | No errors. |
| App\Entity\JvnMedia | No errors. |
| App\Entity\JvnUserTasks | No errors. |
| App\Entity\JvnWorkedTimesheet | No errors. |
| App\Entity\JvnTaskCheckPoint | No errors. |
| App\Entity\JvnShipEngine | No errors. |