******************* Статистика для script *************************
Загальний час: 0.382274
Ліміт пам'яті : 256M
Використано пам'яті : 512K - 3.25M (2.75M)
Memory peak : 3.25M
Кількість SQL selects: 32
Кількість SQL executes: 61
Кількість SQL requests: 93
Час:0.000183 SQL: SET NAMES utf8
Час:0.000136 SQL: SET CHARACTER SET utf8
Час:0.000337 SQL: SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid
Час:0.000318 SQL: SELECT u.*,s.* FROM sessions s,users u WHERE s.sessionid='7f40c0f102ebd7c0695f298730cae91d' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1289165750) OR (u.autologout=0)) AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))
Час:0.000285 SQL: SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=1 AND g.usrgrpid=ug.usrgrpid 
Час:0.000205 SQL: SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 1 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 LIMIT 1 OFFSET 0
Час:0.00126 SQL: UPDATE sessions SET lastaccess=1289165750 WHERE sessionid='7f40c0f102ebd7c0695f298730cae91d'
Час:0.000229 SQL: SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 1 AND g.usrgrpid = ug.usrgrpid AND g.debug_mode = 1 LIMIT 1 OFFSET 0
Час:0.001933 SQL: SELECT * FROM profiles WHERE userid=1 AND ((profileid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC, profileid ASC
Час:0.00205 SQL: SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))
Час:0.000287 SQL: SELECT title1, url1, title2, url2, title3, url3, title4, url4, title5, url5 FROM user_history WHERE userid=1
Час:0.001099 SQL: SELECT i.* FROM items i WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND i.type<>9 AND (i.itemid IN (24341)) 
Час:0.003036 SQL: SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=1 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid WHERE ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid 
Час:0.000286 SQL: SELECT h.host, i.itemid, i.description, i.key_, i.templateid, i.type FROM items i, hosts h WHERE (i.itemid IN (24342)) AND h.hostid=i.hostid AND (h.hostid IN (10052,10063,10020,10079,10054,10057,10058,10055,10056,10082,10008,10088,10066,10071,10049,10061,10060,10059,10083,10067,10072,10081,10070,10051,10045,10065,10062,10048,10050,10089,10064,10016,10078,10053,10004,10080,10025,10026,10012,10027,10003,10031,10030,10028,10029,10023,10032,10018,10022,10033,10034,10019,10024,10035,10013,10036,10021,10038,10042,10039,10001,10014,10040,10041,10044,10046,10011,10009,10007,10015,10043,10010,10076,10090,10091,10075,10002,10068,10085,10087,10077,10017)) 
Час:0.000186 SQL: SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid'
Час:0.001341 SQL: UPDATE ids SET nextid=nextid+1 WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid'
Час:0.000192 SQL: SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid'
Час:0.001206 SQL: INSERT INTO auditlog (auditid,userid,clock,action,resourcetype,details,ip) VALUES (207713,1,1289165750,2,15,'Елемент даних [vfs.fs.size[{#FSNAME},pfree]] [24342] Вузел мережі [it2]','10.20.0.16')
Час:7.9E-5 SQL: begin
Час:0.000272 SQL: SELECT i.* FROM items i WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND i.type<>9 AND (i.itemid IN (24342)) 
Час:0.000318 SQL: SELECT itemid FROM items WHERE (templateid IN (24342)) 
Час:0.000243 SQL: SELECT gi.graphid FROM graphs_items gi WHERE (gi.itemid IN (24342)) AND NOT EXISTS ( SELECT gii.gitemid FROM graphs_items gii WHERE gii.graphid=gi.graphid AND (gii.itemid NOT IN (24342)) )
Час:0.000162 SQL: SELECT itemid FROM item_discovery WHERE (parent_itemid IN (24342)) 
Час:0.000254 SQL: SELECT gi.graphid FROM graphs_items gi WHERE (gi.itemid IN (24342,24343,24344,24345,24346,24347,24348)) 
Час:0.000454 SQL: SELECT DISTINCT t.triggerid FROM triggers t,functions f WHERE ((t.triggerid BETWEEN 000000000000000 AND 099999999999999)) AND (f.itemid IN (24342,24343,24344,24345,24346,24347,24348)) AND f.triggerid=t.triggerid AND ( (t.flags IN (0,4)) )
Час:0.275085 LONG SQL: DELETE FROM triggers WHERE 13642 AND 13643 AND 13644 AND 13645 AND 13646 AND 13647
Час:0.000191 SQL: DELETE FROM screens_items WHERE (resourceid IN (24342,24343,24344,24345,24346,24347,24348)) AND (resourcetype IN (1,3)) 
Час:0.01446 LONG SQL: DELETE FROM items WHERE (itemid IN (24342,24343,24344,24345,24346,24347,24348)) 
Час:0.000119 SQL: DELETE FROM profiles WHERE idx='web.favorite.graphids' AND source='itemid' AND (value_id IN (24342,24343,24344,24345,24346,24347,24348)) 
Час:6.6E-5 SQL: SELECT nextid FROM ids WHERE nodeid=0 AND table_name='housekeeper' AND field_name='housekeeperid' FOR UPDATE
Час:3.0E-5 SQL: UPDATE ids SET nextid=nextid+49 WHERE nodeid=0 AND table_name='housekeeper' AND field_name='housekeeperid'
Час:0.000477 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid',24342,11874)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid',24342,11875)
Час:0.000284 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid',24342,11876)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid',24342,11877)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid',24342,11878)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid',24342,11879)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid',24342,11880)
Час:0.000936 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid',24343,11881)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid',24343,11882)
Час:3.1E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid',24343,11883)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid',24343,11884)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid',24343,11885)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid',24343,11886)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid',24343,11887)
Час:0.000102 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid',24344,11888)
Час:9.3E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid',24344,11889)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid',24344,11890)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid',24344,11891)
Час:0.000327 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid',24344,11892)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid',24344,11893)
Час:0.000193 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid',24344,11894)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid',24345,11895)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid',24345,11896)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid',24345,11897)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid',24345,11898)
Час:3.1E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid',24345,11899)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid',24345,11900)
Час:2.9E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid',24345,11901)
Час:2.9E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid',24346,11902)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid',24346,11903)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid',24346,11904)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid',24346,11905)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid',24346,11906)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid',24346,11907)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid',24346,11908)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid',24347,11909)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid',24347,11910)
Час:5.5E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid',24347,11911)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid',24347,11912)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid',24347,11913)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid',24347,11914)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid',24347,11915)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid',24348,11916)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid',24348,11917)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid',24348,11918)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid',24348,11919)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid',24348,11920)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid',24348,11921)
Час:3.0E-5 SQL: INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid',24348,11922)
Час:0.01059 LONG SQL: commit
Час:0.000327 SQL: SELECT h.* FROM hosts h WHERE (h.hostid IN (10049)) AND ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) AND h.status IN (0,1,3)
Час:0.000547 SQL: SELECT count(DISTINCT i.itemid) as rowscount,i.hostid FROM items i WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND i.type<>9 AND (i.hostid IN (10049)) AND ( (i.flags IN (0,4)) ) GROUP BY i.hostid
Час:0.000551 SQL: SELECT count(DISTINCT i.itemid) as rowscount,i.hostid FROM items i WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND i.type<>9 AND (i.hostid IN (10049)) AND ( (i.flags IN (1)) ) GROUP BY i.hostid
Час:4.2E-5 SQL: SELECT DISTINCT COUNT(DISTINCT t.triggerid) as rowscount,i.hostid FROM triggers t,functions f,items i WHERE ((t.triggerid BETWEEN 000000000000000 AND 099999999999999)) AND (i.hostid IN (10049)) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND ( (t.flags IN (0,4)) ) GROUP BY i.hostid
Час:0.001554 SQL: SELECT DISTINCT count(DISTINCT g.graphid) as rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE ((g.graphid BETWEEN 000000000000000 AND 099999999999999)) AND (i.hostid IN (10049)) AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND ( (g.flags IN (0,4)) ) GROUP BY i.hostid
Час:2.2E-5 SQL: SELECT count(a.applicationid) as rowscount,a.hostid FROM applications a WHERE ((a.applicationid BETWEEN 000000000000000 AND 099999999999999)) AND (a.hostid IN (10049)) GROUP BY a.hostid
Час:2.4E-5 SQL: SELECT ht.* FROM hosts_templates ht WHERE (hostid IN (10049)) 
Час:6.0E-5 SQL: SELECT ht.* FROM hosts_templates ht WHERE (hostid IN (10070)) 
Час:3.0E-5 SQL: SELECT count(DISTINCT s.screenid) as rowscount,s.templateid FROM screens s WHERE ((s.screenid BETWEEN 000000000000000 AND 099999999999999)) AND s.templateid IS NOT NULL AND (s.templateid IN (10049,10070)) GROUP BY s.templateid
Час:0.002725 SQL: SELECT DISTINCT i.*,id.parent_itemid FROM items i,item_discovery id WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND i.type<>9 AND (id.parent_itemid IN (24341)) AND i.itemid=id.itemid ORDER BY i.description ASC LIMIT 10001 OFFSET 0
Час:0.000598 SQL: SELECT DISTINCT a.*,ia.itemid FROM applications a,items_applications ia WHERE ((a.applicationid BETWEEN 000000000000000 AND 099999999999999)) AND (ia.itemid IN (24349)) AND a.applicationid=ia.applicationid
Час:9.0E-5 SQL: SELECT title5, url5 FROM user_history WHERE userid=1
Загальний час витрачений у SQL: 0.327159
******************** Кінець script ***************************