| 1 |
1.69 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_ INNER JOIN tickets_user t2_ ON t0_.id = t2_.tickets_id INNER JOIN user u1_ ON u1_.id = t2_.user_id WHERE u1_.id = ? ORDER BY t0_.last_updated DESC
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_ INNER JOIN tickets_user t2_ ON t0_.id = t2_.tickets_id INNER JOIN user u1_ ON u1_.id = t2_.user_id WHERE u1_.id = 4 ORDER BY t0_.last_updated DESC;
|
| 2 |
0.92 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_ INNER JOIN tickets_user t2_ ON t0_.id = t2_.tickets_id INNER JOIN user u1_ ON u1_.id = t2_.user_id WHERE u1_.id = ? ORDER BY t0_.last_updated DESC
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_ INNER JOIN tickets_user t2_ ON t0_.id = t2_.tickets_id INNER JOIN user u1_ ON u1_.id = t2_.user_id WHERE u1_.id = 4 ORDER BY t0_.last_updated DESC;
|
| 3 |
0.99 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"
]
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 ('Haute', 'Critical', 'Urgente') AND t0_.status NOT IN ('Fermé', 'Résolu', 'Closed') ORDER BY t0_.last_updated DESC LIMIT 10;
|
| 4 |
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
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 = 755 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 5 |
0.56 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
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 = 616 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 6 |
0.54 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
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 = 788 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 7 |
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
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 = 659 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 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
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 = 829 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 9 |
0.58 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
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 = 761 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 10 |
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
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 = 632 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 11 |
0.51 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
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 = 757 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 12 |
0.53 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
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 = 751 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 13 |
0.73 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
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 = 783 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 14 |
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
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 = 657 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 15 |
0.59 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
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 = 763 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 16 |
0.58 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
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 = 845 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 17 |
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
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 = 810 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 18 |
0.55 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
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 = 797 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 19 |
0.45 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
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 = 587 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 20 |
0.53 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
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 = 630 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 21 |
0.56 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
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 = 843 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 22 |
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
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 = 621 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 23 |
0.56 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
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 = 664 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 24 |
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
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 = 725 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 25 |
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
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 = 696 ORDER BY t0.position ASC, t0.created_at ASC;
|
| 26 |
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
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 = 618 ORDER BY t0.position ASC, t0.created_at ASC;
|