You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2019-09-18 11:40:50

quidet
Member
Registered: 2009-03-30
Posts: 33

Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#2 2019-09-18 14:35:35

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#3 2019-09-18 14:43:27

mab3
Member
Registered: 2014-09-22
Posts: 193

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#4 2019-09-18 15:55:22

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

Salut,

J'ai aussi upgradé la distri de debian 7 Wheezy à debian 8 jessie et migré mysql qui était en 5.5.38

Offline

#5 2019-09-18 16:18:35

mab3
Member
Registered: 2014-09-22
Posts: 193

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#6 2019-09-18 16:28:14

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#7 2019-09-18 16:37:31

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

Je parle bien sur de la mémoire du cache d'OPcode de PHP

Offline

#8 2019-09-18 16:42:19

mab3
Member
Registered: 2014-09-22
Posts: 193

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#9 2019-09-18 17:08:49

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#10 2019-09-18 17:09:53

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

j'ai lu également qu'on pouvait vider la table glpi_logs. Ca a du sens?

Offline

#11 2019-09-18 17:12:11

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

En même temps, j'ai activé la purge de l'historique que je n'avais pas dans mes versions précédentes.

Offline

#12 2019-09-18 17:13:11

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

je vais ajouter l'indexe et je regarde ce que ça donne

Offline

#13 2019-09-18 17:18:06

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

L'ajout de l'indexe ne change rien au problème

Offline

#14 2019-09-18 17:20:47

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 6,145

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#15 2019-09-18 17:26:18

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

j'ai bien migré les tables en innoDB via la console

php bin/console glpi:migration:myisam_to_innodb

Offline

#16 2019-09-18 17:35:38

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

C'est vrai que j'ai pas mal d'entités mais je n'avais pas ce problème avant de migrer ?

Offline

#17 2019-09-18 17:45:27

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 6,145

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#18 2019-09-18 17:47:13

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

Je suis sur la page d'accueil

Offline

#19 2019-09-18 17:52:35

mab3
Member
Registered: 2014-09-22
Posts: 193

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#20 2019-09-18 17:56:28

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

J'arrive sur le parc des ordinateurs (Parc/ordinateurs)

Offline

#21 2019-09-18 17:57:15

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

et affichage quasi instant avec 809 machines enregistrées.

Offline

#22 2019-09-19 09:53:08

mab3
Member
Registered: 2014-09-22
Posts: 193

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#23 2019-09-19 11:42:41

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

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

#24 2019-09-19 11:46:24

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

En fait, je connais la commande pour ajouter l'index mais je ne sais pas sur quel champ

Offline

#25 2019-09-19 11:53:01

quidet
Member
Registered: 2009-03-30
Posts: 33

Re: Grosses lenteurs affichage page d'accueil suite mise à jour en 9.4.3

De plus, dans la table dlpi_itilsolutions, j'ai l'impression que tous les champs nécessitant un index l'ont déjà

Offline

Board footer

Powered by FluxBB