GET https://app-test.fr/tickets/moyenne

Query Metrics

35 Database Queries
3 Different statements
25.87 ms Query time
0 Invalid entities
49 Managed entities

Queries

Group similar statements

# Time Info
1 2.04 ms
SELECT t0_.id AS id_0, t0_.ticket_number AS ticket_number_1, t0_.jira_link AS jira_link_2, t0_.last_updated AS last_updated_3, t0_.subject AS subject_4, t0_.short_description AS short_description_5, t0_.long_description AS long_description_6, t0_.owner AS owner_7, t0_.after_sales_service_volumetry AS after_sales_service_volumetry_8, t0_.ticket_title AS ticket_title_9, t0_.assign_jira AS assign_jira_10, t0_.ticket_creator AS ticket_creator_11, t0_.os AS os_12, t0_.priority AS priority_13, t0_.status AS status_14, t0_.ticket_type AS ticket_type_15, t0_.last_automation_pass AS last_automation_pass_16, t0_.show_preparation AS show_preparation_17 FROM tickets t0_ WHERE t0_.priority = ? AND t0_.status NOT IN (?, ?, ?) ORDER BY t0_.last_updated DESC
Parameters:
[
  "Moyenne"
  "Fermé"
  "Résolu"
  "Closed"
]
2 0.93 ms
SELECT t0_.id AS id_0, t0_.ticket_number AS ticket_number_1, t0_.jira_link AS jira_link_2, t0_.last_updated AS last_updated_3, t0_.subject AS subject_4, t0_.short_description AS short_description_5, t0_.long_description AS long_description_6, t0_.owner AS owner_7, t0_.after_sales_service_volumetry AS after_sales_service_volumetry_8, t0_.ticket_title AS ticket_title_9, t0_.assign_jira AS assign_jira_10, t0_.ticket_creator AS ticket_creator_11, t0_.os AS os_12, t0_.priority AS priority_13, t0_.status AS status_14, t0_.ticket_type AS ticket_type_15, t0_.last_automation_pass AS last_automation_pass_16, t0_.show_preparation AS show_preparation_17 FROM tickets t0_ WHERE t0_.priority IN (?, ?, ?) AND t0_.status NOT IN (?, ?, ?) ORDER BY t0_.last_updated DESC LIMIT 10
Parameters:
[
  "Haute"
  "Critical"
  "Urgente"
  "Fermé"
  "Résolu"
  "Closed"
]
3 0.78 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  600
]
4 0.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  839
]
5 0.66 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  755
]
6 0.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  844
]
7 0.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  699
]
8 0.66 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  848
]
9 0.64 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  609
]
10 0.68 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  594
]
11 0.60 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  788
]
12 0.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  774
]
13 0.69 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  715
]
14 0.69 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  760
]
15 0.67 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  789
]
16 0.77 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  728
]
17 0.71 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  781
]
18 0.69 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  730
]
19 0.69 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  655
]
20 0.76 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  761
]
21 0.72 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  673
]
22 0.74 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  757
]
23 0.81 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  847
]
24 0.75 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  751
]
25 0.71 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  585
]
26 0.79 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  736
]
27 0.74 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  810
]
28 0.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  587
]
29 0.64 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  630
]
30 0.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  621
]
31 0.62 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  782
]
32 0.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  639
]
33 0.69 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  617
]
34 0.63 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  664
]
35 0.64 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC
Parameters:
[
  683
]

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\Entity\Tickets 40
App\Entity\TicketTask 9

Entities Mapping

Class Mapping errors
App\Entity\Tickets No errors.
App\Entity\Chapeau No errors.
App\Entity\User No errors.
App\Entity\TicketComment No errors.
App\Entity\TicketTask No errors.