http://188.165.134.117:8081/jvn_notifications

Method
GET
HTTP Status
200
IP
95.60.153.157
Profiled on
Token
497e74

Query Metrics

3 Database Queries
3 Different statements
207.24 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
162.05 ms
(78.19%) 		1 
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
    __toString(): "6d86407d-a0da-507d-8623-71729ca95495"
  }
]
View formatted query    View runnable query
43.56 ms
(21.02%) 		1 
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
    __toString(): "6d86407d-a0da-507d-8623-71729ca95495"
  }
]
View formatted query    View runnable query
1.63 ms
(0.79%) 		1 
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"
]
View formatted query    View runnable query    Explain query

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.