You are not logged in.
Bonjour viens de migrer de la 9.1.2 à la 9.4.3 sur un serveur de preprod avant de le faire en prod.
J'ai un problème d'affichage de la page d'accueil qui prend 30 secondes ou plus à s'afficher après l'authentification. Pendant le temps de chargement, quand je fais un top, je vois que mysql consomme plus de 100% de charge cpu jusqu'à ce que l'affichage de la page se termine. J'ai désactivé tous mes plugins et le problème persiste. J'ai vérifié innodb buffer pool size qui est à 128M.
Pour info également, suite à la mise à jour, je n'ai pas activé l'extension CAS. J'ai également un soucis sur l'envoi des mails via SMTP et le plugin formcreator que je ne parviens pas à mettre à jour. Je suis en train de regarder ces 2 problèmes en parallèle mais je ne suis pas sur q'il y ait un lien avec mon problème précédant.
En mode debug, j'ai le résultat suivant:
--------------------------------------------------------------------------------------------
290 Queries took 29.279s
N° Queries Time Errors
1 SELECT *
FROM `glpi_plugins`
WHERE `state` = '1' 0.000
2 SELECT `id`
FROM `glpi_plugins`
WHERE `directory` = 'mreporting' 0.000
3 SELECT *
FROM `glpi_plugins`
WHERE `glpi_plugins`.`id` = '24' LIMIT 1 0.000
4 SELECT *
FROM `glpi_plugins`
WHERE `state` = '1' 0.000
5 SELECT *
FROM `glpi_plugin_mreporting_profiles`
WHERE `profiles_id` = '6' AND `right` = '1' 0.000
6 SELECT `name`, `password`
FROM `glpi_users`
WHERE `is_active` = '1' AND `is_deleted` = '0' AND `name` IN ('glpi', 'tech', 'normal', 'post-only') 0.000
7 SELECT `TABLE_NAME`
FROM `information_schema`.`TABLES`
WHERE `TABLE_SCHEMA` = 'glpi' AND `TABLE_TYPE` = 'BASE TABLE' AND `TABLE_NAME` LIKE 'glpi_%' AND `engine` = 'MyIsam' 0.015
8 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
LEFT JOIN `glpi_ticketvalidations` ON (`glpi_tickets`.`id` = `glpi_ticketvalidations`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND `users_id_validate` = '1894' AND `glpi_ticketvalidations`.`status` = '2' AND `glpi_tickets`.`global_validation` = '2' AND (`glpi_tickets`.`status` NOT IN ('6', '5')) AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC 0.002
9 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
LEFT JOIN `glpi_ticketvalidations` ON (`glpi_tickets`.`id` = `glpi_ticketvalidations`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND `users_id_validate` = '1894' AND `glpi_ticketvalidations`.`status` = '2' AND `glpi_tickets`.`global_validation` = '2' AND (`glpi_tickets`.`status` NOT IN ('6', '5')) AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC LIMIT 0,10 0.001
10 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND (`glpi_tickets`.`status` = '5') AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '1') OR `glpi_tickets`.users_id_recipient = '1894' )AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC 0.001
11 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND (`glpi_tickets`.`status` = '5') AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '1') OR `glpi_tickets`.users_id_recipient = '1894' )AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC LIMIT 0,10 0.001
12 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
INNER JOIN `glpi_ticketsatisfactions` ON (`glpi_tickets`.`id` = `glpi_ticketsatisfactions`.`tickets_id`)
INNER JOIN `glpi_entities` ON (`glpi_entities`.`id` = `glpi_tickets`.`entities_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '1') OR `glpi_tickets`.`users_id_recipient` = '1894') AND `glpi_tickets`.`status` = '6' AND (`glpi_entities`.`inquest_duration` = 0 OR DATEDIFF(ADDDATE(`glpi_ticketsatisfactions`.`date_begin`, INTERVAL `glpi_entities`.`inquest_duration` DAY), CURDATE()) > 0) AND `glpi_ticketsatisfactions`.`date_answered` IS NULL AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC 0.002
13 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
INNER JOIN `glpi_ticketsatisfactions` ON (`glpi_tickets`.`id` = `glpi_ticketsatisfactions`.`tickets_id`)
INNER JOIN `glpi_entities` ON (`glpi_entities`.`id` = `glpi_tickets`.`entities_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '1') OR `glpi_tickets`.`users_id_recipient` = '1894') AND `glpi_tickets`.`status` = '6' AND (`glpi_entities`.`inquest_duration` = 0 OR DATEDIFF(ADDDATE(`glpi_ticketsatisfactions`.`date_begin`, INTERVAL `glpi_entities`.`inquest_duration` DAY), CURDATE()) > 0) AND `glpi_ticketsatisfactions`.`date_answered` IS NULL AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC LIMIT 0,10 0.001
14 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2')) AND `status` <> '6' AND `global_validation` = '4' AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC 0.001
15 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2')) AND `status` <> '6' AND `global_validation` = '4' AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC LIMIT 0,10 0.001
16 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
LEFT JOIN `glpi_itilsolutions` ON (`glpi_itilsolutions`.`id` = (SELECT `last_solution`.`id`
FROM `glpi_itilsolutions` as `last_solution`
WHERE `last_solution`.`items_id` = `glpi_tickets`.`id` AND `last_solution`.`itemtype` = 'Ticket'
ORDER BY `last_solution`.`id` DESC LIMIT 1))
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2')) AND `glpi_tickets`.`status` <> '6' AND `glpi_itilsolutions`.`status` = '4' AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC 13.853
17 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
LEFT JOIN `glpi_itilsolutions` ON (`glpi_itilsolutions`.`id` = (SELECT `last_solution`.`id`
FROM `glpi_itilsolutions` as `last_solution`
WHERE `last_solution`.`items_id` = `glpi_tickets`.`id` AND `last_solution`.`itemtype` = 'Ticket'
ORDER BY `last_solution`.`id` DESC LIMIT 1))
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2')) AND `glpi_tickets`.`status` <> '6' AND `glpi_itilsolutions`.`status` = '4' AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC LIMIT 0,10 15.289
18 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '35318' LIMIT 1 0.000
19 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '35318'
ORDER BY `id` ASC 0.000
20 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '35318'
ORDER BY `id` ASC 0.000
21 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '35318'
ORDER BY `id` ASC 0.000
22 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '35318' 0.000
23 SELECT *
FROM `glpi_users`
WHERE `id` = '2937' 0.000
24 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '2937'
ORDER BY `is_default` DESC LIMIT 1 0.000
25 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '6' 0.000
26 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '35318' 0.000
27 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '35318' 0.000
28 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '35433' LIMIT 1 0.000
29 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '35433'
ORDER BY `id` ASC 0.000
30 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '35433'
ORDER BY `id` ASC 0.000
31 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '35433'
ORDER BY `id` ASC 0.000
32 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '35433' 0.000
33 SELECT *
FROM `glpi_users`
WHERE `id` = '1829' 0.000
34 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1829'
ORDER BY `is_default` DESC LIMIT 1 0.000
35 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '131' 0.000
36 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '35433' 0.000
37 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '35433' 0.000
38 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '1') ) AND (`glpi_tickets`.`status` IN ('1', '3', '2', '4')) AND NOT ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2') ) AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC 0.003
39 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '1') ) AND (`glpi_tickets`.`status` IN ('1', '3', '2', '4')) AND NOT ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2') ) AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC LIMIT 0,10 0.002
40 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '31537' LIMIT 1 0.000
41 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '31537'
ORDER BY `id` ASC 0.000
42 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '31537'
ORDER BY `id` ASC 0.000
43 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '31537'
ORDER BY `id` ASC 0.000
44 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '31537' 0.000
45 SELECT *
FROM `glpi_users`
WHERE `id` = '1894' 0.000
46 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1894'
ORDER BY `is_default` DESC LIMIT 1 0.000
47 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '71' 0.000
48 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '31537' 0.001
49 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '31537' 0.000
50 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '35454' LIMIT 1 0.000
51 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '35454'
ORDER BY `id` ASC 0.000
52 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '35454'
ORDER BY `id` ASC 0.000
53 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '35454'
ORDER BY `id` ASC 0.000
54 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '35454' 0.000
55 SELECT *
FROM `glpi_printers`
WHERE `glpi_printers`.`id` = '257' LIMIT 1 0.000
56 SELECT *
FROM `glpi_printers`
WHERE `glpi_printers`.`id` = '6' LIMIT 1 0.000
57 SELECT *
FROM `glpi_users`
WHERE `id` = '1894' 0.000
58 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1894'
ORDER BY `is_default` DESC LIMIT 1 0.000
59 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '71' 0.000
60 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '35454' 0.000
61 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '35454' 0.000
62 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '35461' LIMIT 1 0.000
63 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '35461'
ORDER BY `id` ASC 0.000
64 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '35461'
ORDER BY `id` ASC 0.000
65 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '35461'
ORDER BY `id` ASC 0.000
66 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '35461' 0.000
67 SELECT *
FROM `glpi_users`
WHERE `id` = '1894' 0.000
68 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1894'
ORDER BY `is_default` DESC LIMIT 1 0.000
69 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '71' 0.000
70 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '35461' 0.000
71 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '35461' 0.000
72 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '35851' LIMIT 1 0.000
73 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '35851'
ORDER BY `id` ASC 0.000
74 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '35851'
ORDER BY `id` ASC 0.000
75 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '35851'
ORDER BY `id` ASC 0.000
76 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '35851' 0.000
77 SELECT *
FROM `glpi_users`
WHERE `id` = '1894' 0.000
78 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1894'
ORDER BY `is_default` DESC LIMIT 1 0.000
79 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '71' 0.000
80 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '35851' 0.000
81 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '35851' 0.000
82 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '3')) AND (`glpi_tickets`.`status` IN ('1', '3', '2', '4')) AND NOT ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2') ) AND NOT ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '1') ) AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC 0.004
83 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '3')) AND (`glpi_tickets`.`status` IN ('1', '3', '2', '4')) AND NOT ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2') ) AND NOT ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '1') ) AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC LIMIT 0,10 0.002
84 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '34732' LIMIT 1 0.000
85 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '34732'
ORDER BY `id` ASC 0.000
86 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '34732'
ORDER BY `id` ASC 0.000
87 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '34732'
ORDER BY `id` ASC 0.000
88 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '34732' 0.000
89 SELECT *
FROM `glpi_users`
WHERE `id` = '744' 0.000
90 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '744'
ORDER BY `is_default` DESC LIMIT 1 0.000
91 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '35' 0.000
92 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '34732' 0.000
93 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '34732' 0.000
94 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '35100' LIMIT 1 0.000
95 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '35100'
ORDER BY `id` ASC 0.000
96 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '35100'
ORDER BY `id` ASC 0.000
97 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '35100'
ORDER BY `id` ASC 0.000
98 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '35100' 0.000
99 SELECT *
FROM `glpi_users`
WHERE `id` = '1106' 0.000
100 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1106'
ORDER BY `is_default` DESC LIMIT 1 0.000
101 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '7' 0.000
102 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '35100' 0.000
103 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '35100' 0.000
104 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '35499' LIMIT 1 0.000
105 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '35499'
ORDER BY `id` ASC 0.000
106 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '35499'
ORDER BY `id` ASC 0.000
107 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '35499'
ORDER BY `id` ASC 0.000
108 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '35499' 0.000
109 SELECT *
FROM `glpi_users`
WHERE `id` = '3245' 0.000
110 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '3245'
ORDER BY `is_default` DESC LIMIT 1 0.000
111 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '13' 0.000
112 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '35499' 0.000
113 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '35499' 0.000
114 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '35956' LIMIT 1 0.000
115 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '35956'
ORDER BY `id` ASC 0.000
116 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '35956'
ORDER BY `id` ASC 0.000
117 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '35956'
ORDER BY `id` ASC 0.000
118 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '35956' 0.000
119 SELECT *
FROM `glpi_users`
WHERE `id` = '1106' 0.000
120 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1106'
ORDER BY `is_default` DESC LIMIT 1 0.000
121 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '7' 0.000
122 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '35956' 0.000
123 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '35956' 0.000
124 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '22841' LIMIT 1 0.000
125 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '22841'
ORDER BY `id` ASC 0.000
126 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '22841'
ORDER BY `id` ASC 0.000
127 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '22841'
ORDER BY `id` ASC 0.000
128 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '22841' 0.000
129 SELECT *
FROM `glpi_users`
WHERE `id` = '1741' 0.000
130 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1741'
ORDER BY `is_default` DESC LIMIT 1 0.000
131 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '22841' 0.000
132 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '22841' 0.000
133 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '33515' LIMIT 1 0.000
134 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '33515'
ORDER BY `id` ASC 0.000
135 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '33515'
ORDER BY `id` ASC 0.000
136 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '33515'
ORDER BY `id` ASC 0.000
137 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '33515' 0.000
138 SELECT *
FROM `glpi_users`
WHERE `id` = '1352' 0.000
139 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1352'
ORDER BY `is_default` DESC LIMIT 1 0.000
140 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '6' 0.000
141 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '33515' 0.000
142 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '33515' 0.000
143 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2') ) AND (`glpi_tickets`.`status` IN ('2','3')) AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC 0.005
144 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2') ) AND (`glpi_tickets`.`status` IN ('2','3')) AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC LIMIT 0,10 0.076
145 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '36251' LIMIT 1 0.000
146 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '36251'
ORDER BY `id` ASC 0.000
147 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '36251'
ORDER BY `id` ASC 0.000
148 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '36251'
ORDER BY `id` ASC 0.000
149 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '36251' 0.000
150 SELECT *
FROM `glpi_users`
WHERE `id` = '787' 0.000
151 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '787'
ORDER BY `is_default` DESC LIMIT 1 0.000
152 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '73' 0.000
153 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '36251' 0.000
154 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '36251' 0.000
155 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '36100' LIMIT 1 0.000
156 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '36100'
ORDER BY `id` ASC 0.000
157 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '36100'
ORDER BY `id` ASC 0.000
158 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '36100'
ORDER BY `id` ASC 0.000
159 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '36100' 0.000
160 SELECT *
FROM `glpi_users`
WHERE `id` = '3114' 0.000
161 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '3114'
ORDER BY `is_default` DESC LIMIT 1 0.000
162 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '22' 0.000
163 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '36100' 0.000
164 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '36100' 0.000
165 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '36093' LIMIT 1 0.000
166 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '36093'
ORDER BY `id` ASC 0.000
167 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '36093'
ORDER BY `id` ASC 0.000
168 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '36093'
ORDER BY `id` ASC 0.000
169 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '36093' 0.000
170 SELECT *
FROM `glpi_users`
WHERE `id` = '1732' 0.000
171 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1732'
ORDER BY `is_default` DESC LIMIT 1 0.000
172 SELECT *
FROM `glpi_users`
WHERE `id` = '1052' 0.000
173 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1052'
ORDER BY `is_default` DESC LIMIT 1 0.000
174 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '6' 0.000
175 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '36093' 0.000
176 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '36093' 0.000
177 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '36089' LIMIT 1 0.000
178 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '36089'
ORDER BY `id` ASC 0.000
179 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '36089'
ORDER BY `id` ASC 0.000
180 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '36089'
ORDER BY `id` ASC 0.000
181 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '36089' 0.000
182 SELECT *
FROM `glpi_users`
WHERE `id` = '3081' 0.000
183 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '3081'
ORDER BY `is_default` DESC LIMIT 1 0.000
184 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '36089' 0.000
185 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '36089' 0.000
186 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '36088' LIMIT 1 0.000
187 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '36088'
ORDER BY `id` ASC 0.000
188 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '36088'
ORDER BY `id` ASC 0.000
189 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '36088'
ORDER BY `id` ASC 0.000
190 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '36088' 0.000
191 SELECT *
FROM `glpi_users`
WHERE `id` = '3069' 0.000
192 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '3069'
ORDER BY `is_default` DESC LIMIT 1 0.000
193 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '7' 0.000
194 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '36088' 0.000
195 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '36088' 0.000
196 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '36068' LIMIT 1 0.000
197 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '36068'
ORDER BY `id` ASC 0.000
198 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '36068'
ORDER BY `id` ASC 0.000
199 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '36068'
ORDER BY `id` ASC 0.000
200 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '36068' 0.000
201 SELECT *
FROM `glpi_users`
WHERE `id` = '1331' 0.000
202 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1331'
ORDER BY `is_default` DESC LIMIT 1 0.000
203 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '6' 0.000
204 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '36068' 0.000
205 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '36068' 0.000
206 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '36056' LIMIT 1 0.000
207 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '36056'
ORDER BY `id` ASC 0.000
208 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '36056'
ORDER BY `id` ASC 0.000
209 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '36056'
ORDER BY `id` ASC 0.000
210 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '36056' 0.000
211 SELECT *
FROM `glpi_users`
WHERE `id` = '2970' 0.000
212 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '2970'
ORDER BY `is_default` DESC LIMIT 1 0.000
213 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '207' 0.000
214 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '36056' 0.000
215 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '36056' 0.000
216 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '36045' LIMIT 1 0.000
217 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '36045'
ORDER BY `id` ASC 0.000
218 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '36045'
ORDER BY `id` ASC 0.000
219 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '36045'
ORDER BY `id` ASC 0.000
220 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '36045' 0.000
221 SELECT *
FROM `glpi_users`
WHERE `id` = '3087' 0.000
222 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '3087'
ORDER BY `is_default` DESC LIMIT 1 0.000
223 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '19' 0.000
224 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '36045' 0.000
225 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '36045' 0.000
226 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '36020' LIMIT 1 0.000
227 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '36020'
ORDER BY `id` ASC 0.000
228 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '36020'
ORDER BY `id` ASC 0.000
229 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '36020'
ORDER BY `id` ASC 0.000
230 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '36020' 0.000
231 SELECT *
FROM `glpi_users`
WHERE `id` = '1749' 0.000
232 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1749'
ORDER BY `is_default` DESC LIMIT 1 0.000
233 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '36020' 0.000
234 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '36020' 0.000
235 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '36015' LIMIT 1 0.000
236 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '36015'
ORDER BY `id` ASC 0.000
237 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '36015'
ORDER BY `id` ASC 0.000
238 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '36015'
ORDER BY `id` ASC 0.000
239 SELECT *
FROM `glpi_items_tickets`
WHERE `tickets_id` = '36015' 0.000
240 SELECT *
FROM `glpi_users`
WHERE `id` = '3200' 0.000
241 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '3200'
ORDER BY `is_default` DESC LIMIT 1 0.000
242 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '13' 0.000
243 SELECT COUNT(*) AS cpt
FROM `glpi_itilfollowups`
WHERE `itemtype` = 'Ticket' AND `items_id` = '36015' 0.000
244 SELECT COUNT(*) AS cpt
FROM `glpi_tickettasks`
WHERE `tickets_id` = '36015' 0.000
245 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2')) AND `glpi_tickets`.`status` = '4' AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC 0.001
246 SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets` ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0 AND ( (`glpi_tickets_users`.`users_id` = '1894' AND `glpi_tickets_users`.`type` = '2')) AND `glpi_tickets`.`status` = '4' AND ( `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY `glpi_tickets`.`date_mod` DESC LIMIT 0,10 0.001
247 SELECT `glpi_tickettasks`.`id`
FROM `glpi_tickettasks`
INNER JOIN `glpi_tickets` ON (`glpi_tickettasks`.`tickets_id` = `glpi_tickets`.`id`)
WHERE `glpi_tickets`.`status` IN ('1', '2', '3', '4') AND `glpi_tickettasks`.`state` = '1' AND `glpi_tickettasks`.`users_id_tech` = '1894' AND `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124')
ORDER BY `glpi_tickettasks`.`date_mod` DESC 0.002
248 SELECT `glpi_tickettasks`.`id`
FROM `glpi_tickettasks`
INNER JOIN `glpi_tickets` ON (`glpi_tickettasks`.`tickets_id` = `glpi_tickets`.`id`)
WHERE `glpi_tickets`.`status` IN ('1', '2', '3', '4') AND `glpi_tickettasks`.`state` = '1' AND `glpi_tickettasks`.`users_id_tech` = '1894' AND `glpi_tickets`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124')
ORDER BY `glpi_tickettasks`.`date_mod` DESC LIMIT 10 0.001
249 SELECT *
FROM `glpi_tickettasks`
WHERE `glpi_tickettasks`.`id` = '5436' LIMIT 1 0.000
250 SELECT `TABLE_NAME`
FROM `information_schema`.`TABLES`
WHERE `TABLE_SCHEMA` = 'glpi' AND `TABLE_TYPE` = 'BASE TABLE' AND `TABLE_NAME` LIKE '%glpi_tickettasks%' 0.003
251 SHOW COLUMNS
FROM `glpi_tickettasks` 0.000
252 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '22841' LIMIT 1 0.000
253 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '22841'
ORDER BY `id` ASC 0.000
254 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '22841'
ORDER BY `id` ASC 0.000
255 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '22841'
ORDER BY `id` ASC 0.000
256 SELECT *
FROM `glpi_tickettasks`
WHERE `glpi_tickettasks`.`id` = '5437' LIMIT 1 0.000
257 SELECT `TABLE_NAME`
FROM `information_schema`.`TABLES`
WHERE `TABLE_SCHEMA` = 'glpi' AND `TABLE_TYPE` = 'BASE TABLE' AND `TABLE_NAME` LIKE '%glpi_tickettasks%' 0.003
258 SELECT *
FROM `glpi_tickets`
WHERE `glpi_tickets`.`id` = '27453' LIMIT 1 0.000
259 SELECT *
FROM `glpi_groups_tickets`
WHERE `tickets_id` = '27453'
ORDER BY `id` ASC 0.000
260 SELECT *
FROM `glpi_tickets_users`
WHERE `tickets_id` = '27453'
ORDER BY `id` ASC 0.000
261 SELECT *
FROM `glpi_suppliers_tickets`
WHERE `tickets_id` = '27453'
ORDER BY `id` ASC 0.000
262 SELECT DISTINCT `glpi_problems`.`id`
FROM `glpi_problems`
LEFT JOIN `glpi_problems_users` ON (`glpi_problems`.`id` = `glpi_problems_users`.`problems_id`)
LEFT JOIN `glpi_groups_problems` ON (`glpi_problems`.`id` = `glpi_groups_problems`.`problems_id`)
WHERE `glpi_problems`.`is_deleted` = 0 AND ( (`glpi_problems_users`.`users_id` = '1894' AND `glpi_problems_users`.`type` = '2')) AND (`status` IN ('3','2')) AND ( `glpi_problems`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY date_mod DESC 0.001
263 SELECT DISTINCT `glpi_problems`.`id`
FROM `glpi_problems`
LEFT JOIN `glpi_problems_users` ON (`glpi_problems`.`id` = `glpi_problems_users`.`problems_id`)
LEFT JOIN `glpi_groups_problems` ON (`glpi_problems`.`id` = `glpi_groups_problems`.`problems_id`)
WHERE `glpi_problems`.`is_deleted` = 0 AND ( (`glpi_problems_users`.`users_id` = '1894' AND `glpi_problems_users`.`type` = '2')) AND (`status` IN ('3','2')) AND ( `glpi_problems`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') )
ORDER BY date_mod DESC LIMIT 0,10 0.001
264 SELECT *
FROM `glpi_problems`
WHERE `glpi_problems`.`id` = '44' LIMIT 1 0.000
265 SELECT *
FROM `glpi_groups_problems`
WHERE `problems_id` = '44'
ORDER BY `id` ASC 0.000
266 SELECT *
FROM `glpi_problems_users`
WHERE `problems_id` = '44'
ORDER BY `id` ASC 0.000
267 SELECT *
FROM `glpi_problems_suppliers`
WHERE `problems_id` = '44'
ORDER BY `id` ASC 0.000
268 SELECT *
FROM `glpi_users`
WHERE `id` = '1894' 0.000
269 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1894'
ORDER BY `is_default` DESC LIMIT 1 0.000
270 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '71' 0.000
271 SELECT *
FROM `glpi_problems`
WHERE `glpi_problems`.`id` = '42' LIMIT 1 0.000
272 SELECT *
FROM `glpi_groups_problems`
WHERE `problems_id` = '42'
ORDER BY `id` ASC 0.000
273 SELECT *
FROM `glpi_problems_users`
WHERE `problems_id` = '42'
ORDER BY `id` ASC 0.000
274 SELECT *
FROM `glpi_problems_suppliers`
WHERE `problems_id` = '42'
ORDER BY `id` ASC 0.000
275 SELECT *
FROM `glpi_users`
WHERE `id` = '1894' 0.000
276 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1894'
ORDER BY `is_default` DESC LIMIT 1 0.000
277 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '71' 0.000
278 SELECT *
FROM `glpi_problems`
WHERE `glpi_problems`.`id` = '41' LIMIT 1 0.000
279 SELECT *
FROM `glpi_groups_problems`
WHERE `problems_id` = '41'
ORDER BY `id` ASC 0.000
280 SELECT *
FROM `glpi_problems_users`
WHERE `problems_id` = '41'
ORDER BY `id` ASC 0.000
281 SELECT *
FROM `glpi_problems_suppliers`
WHERE `problems_id` = '41'
ORDER BY `id` ASC 0.000
282 SELECT *
FROM `glpi_users`
WHERE `id` = '1894' 0.000
283 SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '1894'
ORDER BY `is_default` DESC LIMIT 1 0.000
284 SELECT `glpi_usertitles`.*, '' AS `transname`, '' AS `transcomment`
FROM `glpi_usertitles`
WHERE `glpi_usertitles`.`id` = '71' 0.000
285 SELECT `glpi_problemtasks`.`id`
FROM `glpi_problemtasks`
INNER JOIN `glpi_problems` ON (`glpi_problemtasks`.`problems_id` = `glpi_problems`.`id`)
WHERE `glpi_problems`.`status` IN ('1', '7', '2', '3', '4') AND `glpi_problemtasks`.`state` = '1' AND `glpi_problemtasks`.`users_id_tech` = '1894' AND `glpi_problems`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124')
ORDER BY `glpi_problemtasks`.`date_mod` DESC 0.001
286 SELECT `glpi_problemtasks`.`id`
FROM `glpi_problemtasks`
INNER JOIN `glpi_problems` ON (`glpi_problemtasks`.`problems_id` = `glpi_problems`.`id`)
WHERE `glpi_problems`.`status` IN ('1', '7', '2', '3', '4') AND `glpi_problemtasks`.`state` = '1' AND `glpi_problemtasks`.`users_id_tech` = '1894' AND `glpi_problems`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124')
ORDER BY `glpi_problemtasks`.`date_mod` DESC LIMIT 10 0.001
287 SELECT *
FROM `glpi_reminders`
WHERE `users_id` = '1894' AND ((`end` >= '2019-09-18' OR `is_planned` = '0')) AND (((`glpi_reminders`.`begin_view_date` IS NULL) OR (`glpi_reminders`.`begin_view_date` < '2019-09-18 10:45:51'))) AND (((`glpi_reminders`.`end_view_date` IS NULL) OR (`glpi_reminders`.`end_view_date` > '2019-09-18 10:45:51')))
ORDER BY `name` 0.000
288 SELECT DISTINCT `glpi_reminders`.*
FROM `glpi_reminders`
LEFT JOIN `glpi_reminders_users` ON (`glpi_reminders_users`.`reminders_id` = `glpi_reminders`.`id`)
LEFT JOIN `glpi_groups_reminders` ON (`glpi_groups_reminders`.`reminders_id` = `glpi_reminders`.`id`)
LEFT JOIN `glpi_profiles_reminders` ON (`glpi_profiles_reminders`.`reminders_id` = `glpi_reminders`.`id`)
LEFT JOIN `glpi_entities_reminders` ON (`glpi_entities_reminders`.`reminders_id` = `glpi_reminders`.`id`)
WHERE (((`glpi_reminders`.`begin_view_date` IS NULL) OR (`glpi_reminders`.`begin_view_date` < '2019-09-18 10:45:51'))) AND (((`glpi_reminders`.`end_view_date` IS NULL) OR (`glpi_reminders`.`end_view_date` > '2019-09-18 10:45:51'))) AND (`glpi_reminders`.`users_id` = '1894' OR `glpi_reminders_users`.`users_id` = '1894' OR (`glpi_groups_reminders`.`groups_id` IN ('114') AND (`glpi_groups_reminders`.`entities_id` < '0' OR (`glpi_groups_reminders`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') OR (`glpi_groups_reminders`.`is_recursive` = '1' AND `glpi_groups_reminders`.`entities_id` IN ('0'))))) OR (`glpi_profiles_reminders`.`profiles_id` = '6' AND (`glpi_profiles_reminders`.`entities_id` < '0' OR (`glpi_profiles_reminders`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') OR (`glpi_profiles_reminders`.`is_recursive` = '1' AND `glpi_profiles_reminders`.`entities_id` IN ('0'))))) OR (`glpi_entities_reminders`.`entities_id` IN ('2', '125', '123', '99', '114', '116', '100', '109', '121', '112', '24', '110', '3', '4', '11', '20', '29', '44', '47', '57', '67', '73', '101', '25', '63', '80', '103', '122', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '22', '23', '26', '27', '28', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '45', '46', '48', '49', '50', '51', '52', '53', '54', '55', '56', '58', '59', '60', '61', '62', '64', '65', '66', '68', '69', '70', '71', '72', '74', '75', '76', '77', '78', '79', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '102', '104', '105', '106', '107', '108', '111', '113', '115', '117', '118', '119', '120', '124') OR (`glpi_entities_reminders`.`is_recursive` = '1' AND `glpi_entities_reminders`.`entities_id` IN ('0')))) AND `glpi_reminders`.`users_id` <> '1894'
ORDER BY `name` 0.001
289 SELECT `TABLE_NAME`
FROM `information_schema`.`TABLES`
WHERE `TABLE_SCHEMA` = 'glpi' AND `TABLE_TYPE` = 'BASE TABLE' AND `TABLE_NAME` LIKE '%glpi_configs%' 0.003
290 SELECT *
FROM `glpi_configs`
WHERE `context` = 'core' AND `name` IN ('cache_db') 0.000
--------------------------------------------------------------------------------------------
Voici ma config:
Informations sur le système, l'installation et la configuration
GLPI 9.4.3 (/glpi => /var/www/glpi)
Installation mode: TARBALL
Server
Operating system: Linux glpi-test 3.16.0-10-amd64 #1 SMP Debian 3.16.72-1 (2019-08-13) x86_64
PHP 5.6.40-0+deb8u5 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc, apcu,
bcmath, bz2, calendar, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, json,
ldap, libxml, mbstring, mcrypt, mhash, mysql, mysqli, openssl, pcre, pdo_mysql, pdo_sqlite, posix, readline, session, shmop,
soap, sockets, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, zip, zlib)
Setup: max_execution_time="600" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files"
upload_max_filesize="5M"
Software: Apache/2.4.10 (Debian) (Apache/2.4.10 (Debian) Server at glpi-test.domaine.fr Port 80)
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36
Server Software: MySQL Cluster Community Server (GPL)
Server Version: 5.7.27-ndb-7.5.15
Server SQL Mode:
Parameters: root@localhost/glpi
Host info: Localhost via UNIX socket
mysqli extension is installed
ctype extension is installed
fileinfo extension is installed
json extension is installed
mbstring extension is installed
iconv extension is installed
zlib extension is installed
curl extension is installed
gd extension is installed
simplexml extension is installed
xml extension is installed
ldap extension is installed
imap extension is installed
Zend OPcache extension is installed
APCu extension is installed
xmlrpc extension is installed
exif extension is installed
CAS extension is not present
Database version seems correct (5.7.27) - Perfect!Database version seems correct (5.7.27) - Perfect!
OK/var/www/glpi/files/_log : OK
OK/var/www/glpi/config : OK
OK/var/www/glpi/files : OK
OK/var/www/glpi/files/_dumps : OK
OK/var/www/glpi/files/_sessions : OK
OK/var/www/glpi/files/_cron : OK
OK/var/www/glpi/files/_graphs : OK
OK/var/www/glpi/files/_lock : OK
OK/var/www/glpi/files/_plugins : OK
OK/var/www/glpi/files/_tmp : OK
OK/var/www/glpi/files/_cache : OK
OK/var/www/glpi/files/_rss : OK
OK/var/www/glpi/files/_uploads : OK
OK/var/www/glpi/files/_pictures : OK
Web access to the files directory should not be allowed
Check the .htaccess file and the web server configuration.
Libraries
htmLawed version 1.2.4 in (/var/www/glpi/lib/htmlawed)
phpmailer/phpmailer version 6.0.7 in (/var/www/glpi/vendor/phpmailer/phpmailer/src)
simplepie/simplepie version 1.5.2 in (/var/www/glpi/vendor/simplepie/simplepie/library)
tecnickcom/tcpdf version 6.2.26 in (/var/www/glpi/vendor/tecnickcom/tcpdf)
michelf/php-markdown in (/var/www/glpi/vendor/michelf/php-markdown/Michelf)
true/punycode in (/var/www/glpi/vendor/true/punycode/src)
iamcal/lib_autolink in (/var/www/glpi/vendor/iamcal/lib_autolink)
sabre/vobject in (/var/www/glpi/vendor/sabre/vobject/lib)
zendframework/zend-cache in (/var/www/glpi/vendor/zendframework/zend-cache/src)
zendframework/zend-i18n in (/var/www/glpi/vendor/zendframework/zend-i18n/src)
zendframework/zend-serializer in (/var/www/glpi/vendor/zendframework/zend-serializer/src)
monolog/monolog in (/var/www/glpi/vendor/monolog/monolog/src/Monolog)
sebastian/diff in (/var/www/glpi/vendor/sebastian/diff/src)
elvanto/litemoji in (/var/www/glpi/vendor/elvanto/litemoji/src)
symfony/console in (/var/www/glpi/vendor/symfony/console)
leafo/scssphp in (/var/www/glpi/vendor/leafo/scssphp/src)
paragonie/random_compat in (/var/www/glpi/vendor/paragonie/random_compat/lib)
LDAP directories
Server: 'ipadress', Port: '389', BaseDN: 'DC=domaine,DC=fr', Connection filter:
'(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN: 'nom@domaine.fr', Use
TLS: none
SQL replicas
Not active
Notifications
Way of sending emails: SMTP+SSL (nom@domaine.fr@ipadress)
Mails receivers
Name: 'collecteur1' Active: No
Server: '{hostname.domaine.fr/imap/novalidate-cert/tls}' Login: 'nom@domaine.fr' Password: Yes
Name: 'collecteur2' Active: No
Server: '{hostname.domaine.fr/imap/novalidate-cert/tls}INBOX/collecteur' Login: 'nom@domaine.fr' Password: Yes
Name: 'collecteur3' Active: No
Server: '{hostname.domaine.fr/imap/novalidate-cert/tls}INBOX/collecteur' Login: 'nom@domaine.fr' Password: Yes
Name: 'collecteur4' Active: No
Server: '{hostname.domaine.fr/imap/novalidate-cert/tls}INBOX/collecteur' Login: 'nom@domaine.fr' Password: Yes
Name: 'collecteur5' Active: No
Server: '{hostname.domaine.fr/imap/novalidate-cert/tls}INBOX/collecteur' Login: 'nom@domaine.fr' Password: Yes
Name: 'collecteur6' Active: No
Server: '{hostname.domaine.fr/imap/novalidate-cert/tls}INBOX/GLPI/COLLECTEUR' Login: 'nom@domaine.fr' Password: Yes
Name: 'collecteur7' Active: No
Server: '{hostname.domaine.fr/imap/novalidate-cert/tls}INBOX/collecteur' Login: 'nom@domaine.fr' Password: Yes
Name: 'collecteur8' Active: No
Server: '{hostname.domaine.fr/imap/novalidate-cert/tls}' Login: 'nom@domaine.fr' Password: Yes
Name: 'collecteur9' Active: No
Server: '{hostname.domaine.fr/imap/novalidate-cert/tls}INBOX/collecteur' Login: 'nom@domaine.fr' Password: Yes
Name: 'collecteur10' Active: No
Server: '{hostname.domaine.fr/imap/novalidate-cert/tls}INBOX/collecteur' Login: 'nom@domaine.fr' Password: Yes
Plugins list
fields Name: Champs supplémentaires Version: 1.10.1 State: Not activated
formcreator Name: Form Creator Version: 2.8.5 State: To be cleaned
genericobject Name: Gestion d'objets Version: 2.7.0 State: Not activated
order Name: Gestion des commandes Version: 2.5.2 State: Not activated
datainjection Name: Injection de fichiers Version: 2.7.0 State: Not activated
mreporting Name: Plus de rapports Version: 1.6.1 State: Not activated
reports Name: Rapports Version: 1.13.1 State: Not activated
Merci d'avance pour votre aide.
Offline
Encore moi.
En continuant mes tests, j'ai constaté que la durée d'affichage est proportionnelle au nombre de tickets ouverts:
0 tickets ouverts ==> affichage quasi immédiat
500 tickets ouverts ==> 30 secondes
1000 tickets ouverts ==> 37 secondes
1500 tickets ouverts ==> 50 secondes
2000 tickets ouverts ==> 57 secondes
J'ai réglé mon pb de smtp pour l'envoi des mails et j'ai désinstallé le plugin formcreator. Aucun impact sur les perfs.
Offline
Bonjour,
As-tu migré aussi le contexte technique de fonctionnement ou juste glpi ?
Contexte : GLPI 9.4.3/FusionInventory 9.4+1.1 / Agent FI 2.5.1
Offline
Salut,
J'ai aussi upgradé la distri de debian 7 Wheezy à debian 8 jessie et migré mysql qui était en 5.5.38
Offline
Dans configuration/generale/systeme, Zend OPcache extension est-il installé et activé ?
Contexte : GLPI 9.4.3/FusionInventory 9.4+1.1 / Agent FI 2.5.1
Offline
Oui (tu peux le voir dans le compte rendu de ma conf également) ==> Zend OPcache extension is installed
Par contre, dans performance, la mémoire est quasi au taquet 63Mio/64Mio. Mais mon pb est lié au cpu et pas à la mémoire...
Offline
Je parle bien sur de la mémoire du cache d'OPcode de PHP
Offline
N'y aurait-il pas eu un problème lors de la migration ?
cf /var/www/html/glpi/files/_log/migration_to***
Contexte : GLPI 9.4.3/FusionInventory 9.4+1.1 / Agent FI 2.5.1
Offline
j'ai eu un fichier log: warning_during_migration_to_9.2.log qui contient:
An index must be added in the 'id_search_option' field of the 'glpi_logs table'; but your glpi_logs table is too huge. You'll have to add it on your database with the following query:
'ALTER TABLE glpi_logs ADD INDEX id_search_option(id_search_option);' @ 2019-09-17 14:38:54 [@glpi-test]
Api users tokens has been reset, if you use REST/XMLRPC api with personal token for authentication, please reset your user's token. @
Offline
j'ai lu également qu'on pouvait vider la table glpi_logs. Ca a du sens?
Offline
En même temps, j'ai activé la purge de l'historique que je n'avais pas dans mes versions précédentes.
Offline
je vais ajouter l'indexe et je regarde ce que ça donne
Offline
L'ajout de l'indexe ne change rien au problème
Offline
vous n'etes pas passé en innodb ?
vous avez 2 requêtes qui prennent chacune 15 secondes environ, je pense en raison du grand nombre d'entités. (ça ne donne pas la solution malheureusement)
a mon avis vider la table de log n'aurait pas d'incidence sur la requête (mêem si ça peut allerger les sauvegardes, accélerer les migrations, et la bascule vers innodb)
Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6
Offline
j'ai bien migré les tables en innoDB via la console
php bin/console glpi:migration:myisam_to_innodb
Offline
C'est vrai que j'ai pas mal d'entités mais je n'avais pas ce problème avant de migrer ?
Offline
les 2 requêtes longues (#16 et #17) ont pour point commun une jointure sur la table des solutions qui est nouvelle par rapport à votre version 9.1
à l'ouverture êtes vous sur la page d'accueil ou directement sur la liste des tickets ?
affichez vous
Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6
Offline
Je suis sur la page d'accueil
Offline
si tu fais un http://ip_de_ta_machine/glpi/front/computer.php directement, ça t'amène à quoi?
Contexte : GLPI 9.4.3/FusionInventory 9.4+1.1 / Agent FI 2.5.1
Offline
J'arrive sur le parc des ordinateurs (Parc/ordinateurs)
Offline
et affichage quasi instant avec 809 machines enregistrées.
Offline
Bonjour,
A priori, le problème est donc concentré sur la table des solutions où il doit manquer un index de performance...
Contexte : GLPI 9.4.3/FusionInventory 9.4+1.1 / Agent FI 2.5.1
Offline
Merci pour le retour. N'étant pas un as de Mysql. Peux-tu m'aider sur la manip à effectuer ou bien tu penses qu'il faut ouvrir un ticket sur github?
Offline
En fait, je connais la commande pour ajouter l'index mais je ne sais pas sur quel champ
Offline
De plus, dans la table dlpi_itilsolutions, j'ai l'impression que tous les champs nécessitant un index l'ont déjà
Offline