******************** Script profiler ******************** Total time: 0.671295 Total SQL time: 0.299763 SQL count: 34 (selects: 22 | executes: 12) Peak memory usage: 40.75M Memory limit: 1024M 1. map.get [sysmaps.php:407] Parameters: Array ( [output] => Array ( [0] => sysmapid [1] => name [2] => width [3] => height ) [sortfield] => name [limit] => 1001 [search] => Array ( [name] => ) [preservekeys] => 1 ) Result: Array ( [25] => Array ( [sysmapid] => 25 [name] => 9jan [width] => 3000 [height] => 2000 ) [21] => Array ( [sysmapid] => 21 [name] => A23 [width] => 1800 [height] => 1400 ) [20] => Array ( [sysmapid] => 20 [name] => A26 [width] => 1700 [height] => 1400 ) [24] => Array ( [sysmapid] => 24 [name] => A31 [width] => 2100 [height] => 1200 ) [23] => Array ( [sysmapid] => 23 [name] => A33 [width] => 1600 [height] => 800 ) [7] => Array ( [sysmapid] => 7 [name] => A36 [width] => 2000 [height] => 1000 ) [9] => Array ( [sysmapid] => 9 [name] => A45 [width] => 2000 [height] => 1500 ) [19] => Array ( [sysmapid] => 19 [name] => A49 [width] => 3000 [height] => 2200 ) [28] => Array ( [sysmapid] => 28 [name] => A52 [width] => 2600 [height] => 2000 ) [22] => Array ( [sysmapid] => 22 [name] => A53 [width] => 2400 [height] => 1700 ) [26] => Array ( [sysmapid] => 26 [name] => A66 [width] => 2000 [height] => 1200 ) [27] => Array ( [sysmapid] => 27 [name] => A73 [width] => 2000 [height] => 1200 ) [8] => Array ( [sysmapid] => 8 [name] => A77 [width] => 1600 [height] => 900 ) [45] => Array ( [sysmapid] => 45 [name] => Anna [width] => 2000 [height] => 1000 ) [16] => Array ( [sysmapid] => 16 [name] => BGLBSK [width] => 2700 [height] => 2000 ) [14] => Array ( [sysmapid] => 14 [name] => Bobrov [width] => 2500 [height] => 1500 ) [15] => Array ( [sysmapid] => 15 [name] => Boguch [width] => 1600 [height] => 1600 ) [17] => Array ( [sysmapid] => 17 [name] => Buturl [width] => 1800 [height] => 1000 ) [3] => Array ( [sysmapid] => 3 [name] => CORE [width] => 2560 [height] => 1440 ) [44] => Array ( [sysmapid] => 44 [name] => Ertil [width] => 1600 [height] => 800 ) [18] => Array ( [sysmapid] => 18 [name] => Grib [width] => 1600 [height] => 800 ) [31] => Array ( [sysmapid] => 31 [name] => Hohol [width] => 1500 [height] => 1050 ) [11] => Array ( [sysmapid] => 11 [name] => kalach [width] => 1800 [height] => 1000 ) [34] => Array ( [sysmapid] => 34 [name] => Kamen [width] => 1600 [height] => 800 ) [38] => Array ( [sysmapid] => 38 [name] => Kantem [width] => 1600 [height] => 800 ) [50] => Array ( [sysmapid] => 50 [name] => Kash [width] => 1600 [height] => 800 ) [4] => Array ( [sysmapid] => 4 [name] => Liski [width] => 3300 [height] => 2300 ) [53] => Array ( [sysmapid] => 53 [name] => Lomon [width] => 2000 [height] => 1200 ) [52] => Array ( [sysmapid] => 52 [name] => NCC [width] => 1920 [height] => 1080 ) [32] => Array ( [sysmapid] => 32 [name] => Ndevick [width] => 1600 [height] => 800 ) [42] => Array ( [sysmapid] => 42 [name] => NHopr [width] => 2000 [height] => 1500 ) [6] => Array ( [sysmapid] => 6 [name] => Nusm [width] => 2200 [height] => 1500 ) [49] => Array ( [sysmapid] => 49 [name] => NVor [width] => 1600 [height] => 1000 ) [35] => Array ( [sysmapid] => 35 [name] => Olh [width] => 1600 [height] => 800 ) [13] => Array ( [sysmapid] => 13 [name] => OSTR [width] => 1800 [height] => 1200 ) [46] => Array ( [sysmapid] => 46 [name] => Panino [width] => 1600 [height] => 800 ) [39] => Array ( [sysmapid] => 39 [name] => Petrop [width] => 1600 [height] => 800 ) [36] => Array ( [sysmapid] => 36 [name] => Podgor [width] => 1600 [height] => 800 ) [29] => Array ( [sysmapid] => 29 [name] => Pov [width] => 2100 [height] => 1200 ) [10] => Array ( [sysmapid] => 10 [name] => PVL [width] => 2500 [height] => 1200 ) [48] => Array ( [sysmapid] => 48 [name] => Ramon [width] => 2000 [height] => 1400 ) [33] => Array ( [sysmapid] => 33 [name] => Repev [width] => 1600 [height] => 800 ) [12] => Array ( [sysmapid] => 12 [name] => ROSS [width] => 2500 [height] => 1700 ) [30] => Array ( [sysmapid] => 30 [name] => Seml [width] => 2500 [height] => 2500 ) [41] => Array ( [sysmapid] => 41 [name] => Tal [width] => 2300 [height] => 1200 ) [43] => Array ( [sysmapid] => 43 [name] => Tern [width] => 1600 [height] => 800 ) [47] => Array ( [sysmapid] => 47 [name] => VHava [width] => 1600 [height] => 800 ) [37] => Array ( [sysmapid] => 37 [name] => VMamon [width] => 1600 [height] => 1000 ) [40] => Array ( [sysmapid] => 40 [name] => Vorob [width] => 1600 [height] => 800 ) ) SQL (0.000383): SET search_path = 'public' sysmaps.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:84 SQL (0.000462): SET bytea_output = escape sysmaps.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:95 SQL (0.004185): SELECT 1 FROM information_schema.tables WHERE table_catalog='zabbix' AND table_schema='public' AND table_name='dbversion' sysmaps.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → PostgresqlDbBackend->checkDbVersionTable() → DBselect() in include/classes/db/PostgresqlDbBackend.php:41 SQL (0.000831): SELECT dv.mandatory,dv.optional FROM dbversion dv sysmaps.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → DBselect() in include/classes/db/DbBackend.php:46 SQL (0.000757): SELECT NULL FROM config c sysmaps.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkConfig() → DBselect() in include/classes/db/DbBackend.php:62 SQL (0.000521): BEGIN sysmaps.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:253 SQL (0.002229): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='885ab4604f266ad3b3746a2b40d2498d' AND s.status=0 AND s.userid=u.userid AND (s.lastaccess+u.autologout>1507726022 OR u.autologout=0) sysmaps.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBselect() in include/classes/api/services/CUser.php:1205 SQL (0.001282): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid='108' AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0 sysmaps.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → check_perm2system() → DBselect() in include/perm.inc.php:75 SQL (0.000723): UPDATE sessions SET lastaccess=1507726022 WHERE userid='108' AND sessionid='885ab4604f266ad3b3746a2b40d2498d' sysmaps.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBexecute() in include/classes/api/services/CUser.php:1230 SQL (0.000789): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='108' AND g.usrgrpid=ug.usrgrpid sysmaps.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBselect() in include/classes/api/services/CUser.php:1238 SQL (0.000758): SELECT u.userid,u.alias,u.name,u.surname,u.url,u.autologin,u.autologout,u.lang,u.refresh,u.type, u.theme,u.attempt_failed,u.attempt_ip,u.attempt_clock,u.rows_per_page FROM users u WHERE u.userid='108' sysmaps.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → CUser->_getUserData() → DBselect() in include/classes/api/services/CUser.php:1262 SQL (0.000615): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid='108' AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1 sysmaps.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → CUser->_getUserData() → DBselect() in include/classes/api/services/CUser.php:1270 SQL (0.000419): COMMIT sysmaps.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:314 SQL (0.00102): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=108 AND idx='web.menu.view.last' sysmaps.php:42 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107 SQL (0.000934): SELECT c.* FROM config c sysmaps.php:42 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33 SQL (0.000542): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=108 AND idx='web.login.attempt.failed' sysmaps.php:42 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107 SQL (0.000636): DELETE FROM profiles WHERE idx='web.maps.sysmapid' AND idx2='0' AND userid='108' sysmaps.php:371 → CProfile::delete() → CProfile::deleteValues() → DB::delete() → DBexecute() in include/classes/db/DB.php:829 SQL (0.000539): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=108 AND idx='web.sysmaps.php.sort' sysmaps.php:373 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107 SQL (0.000518): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=108 AND idx='web.sysmaps.php.sortorder' sysmaps.php:374 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107 SQL (0.000584): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=108 AND idx='web.sysmapconf.filter_name' sysmaps.php:392 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107 SQL (0.000321): BEGIN sysmaps.php:407 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:253 SQL (0.001312): SELECT s.sysmapid,s.name,s.width,s.height FROM sysmaps s ORDER BY s.name LIMIT 1001 OFFSET 0 sysmaps.php:407 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CMap->get() → DBselect() in include/classes/api/services/CMap.php:175 SQL (0.012329): SELECT slt.triggerid,sl.sysmapid FROM sysmaps_link_triggers slt,sysmaps_links sl WHERE (sl.sysmapid BETWEEN '6' AND '50' OR sl.sysmapid IN ('1','3','4','52','53')) AND sl.linkid=slt.linkid sysmaps.php:407 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CMap->get() → DBselect() in include/classes/api/services/CMap.php:197 SQL (0.000588): SELECT usrgrpid FROM users_groups WHERE userid='108' sysmaps.php:407 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CMap->get() → CTrigger->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:304 SQL (0.007242): SELECT t.triggerid FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid='19' WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND t.triggerid IN ('14189','55305242','55327864','60814048','64972581','74594512','74641632','74646088','74646870','74647416','74648152','74648277','74721047','74745681','74746230','74753426','74753613','74758333','74765181','74766433','74772917','74773592','74792431','74792556','74793653','74793890','74796131','74797873','74797961','74808335','74808446','74808620','74808662','74810687','74810769','74810965','74813753','74813992','74814081','74814359','74814386','74814446','74814561','74815015','74815099','74815238','74815400','74816397','74816723','74817425') AND t.flags IN ('0','4') sysmaps.php:407 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CMap->get() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1043 SQL (0.021922): SELECT se.* FROM sysmaps_elements se WHERE (se.sysmapid BETWEEN '6' AND '50' OR se.sysmapid IN ('3','4','52','53')) sysmaps.php:407 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CMap->get() → DBselect() in include/classes/api/services/CMap.php:226 SQL (0.232988): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='19' WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND (h.hostid BETWEEN '10131' AND '10143' OR h.hostid BETWEEN '10601' AND '10610' OR h.hostid BETWEEN '10618' AND '10622' OR h.hostid BETWEEN '10625' AND '10641' OR h.hostid BETWEEN '10678' AND '10689' OR h.hostid BETWEEN '10694' AND '10706' OR h.hostid BETWEEN '10711' AND '10728' OR h.hostid BETWEEN '10730' AND '10744' OR h.hostid BETWEEN '10746' AND '10757' OR h.hostid BETWEEN '10764' AND '10776' OR h.hostid BETWEEN '10784' AND '10806' OR h.hostid BETWEEN '10809' AND '10816' OR h.hostid BETWEEN '10828' AND '10835' OR h.hostid BETWEEN '10837' AND '10841' OR h.hostid BETWEEN '10920' AND '10927' OR h.hostid BETWEEN '11054' AND '11058' OR h.hostid BETWEEN '11192' AND '11205' OR h.hostid BETWEEN '11207' AND '11218' OR h.hostid BETWEEN '11298' AND '11302' OR h.hostid BETWEEN '11321' AND '11336' OR h.hostid BETWEEN '11338' AND '11357' OR h.hostid BETWEEN '11359' AND '11368' OR h.hostid BETWEEN '11371' AND '11376' OR h.hostid BETWEEN '11410' AND '11414' OR h.hostid BETWEEN '11431' AND '11436' OR h.hostid BETWEEN '11459' AND '11473' OR h.hostid BETWEEN '11475' AND '11483' OR h.hostid BETWEEN '11504' AND '11512' OR h.hostid BETWEEN '11614' AND '11645' OR h.hostid BETWEEN '11647' AND '11693' OR h.hostid BETWEEN '11695' AND '11700' OR h.hostid BETWEEN '11707' AND '11744' OR h.hostid BETWEEN '11746' AND '11751' OR h.hostid BETWEEN '11756' AND '11783' OR h.hostid BETWEEN '11797' AND '11803' OR h.hostid BETWEEN '11817' AND '11827' OR h.hostid BETWEEN '11829' AND '11834' OR h.hostid BETWEEN '11836' AND '11853' OR h.hostid BETWEEN '11855' AND '11868' OR h.hostid BETWEEN '11888' AND '11897' OR h.hostid BETWEEN '11899' AND '11910' OR h.hostid BETWEEN '11912' AND '11969' OR h.hostid BETWEEN '11974' AND '11997' OR h.hostid BETWEEN '12007' AND '12013' OR h.hostid BETWEEN '12015' AND '12025' OR h.hostid BETWEEN '12043' AND '12048' OR h.hostid BETWEEN '12053' AND '12073' OR h.hostid BETWEEN '12089' AND '12097' OR h.hostid BETWEEN '12099' AND '12105' OR h.hostid BETWEEN '12162' AND '12186' OR h.hostid BETWEEN '12194' AND '12221' OR h.hostid BETWEEN '12226' AND '12249' OR h.hostid BETWEEN '12256' AND '12361' OR h.hostid BETWEEN '12369' AND '12379' OR h.hostid BETWEEN '12381' AND '12386' OR h.hostid BETWEEN '12388' AND '12402' OR h.hostid BETWEEN '12405' AND '12430' OR h.hostid BETWEEN '12498' AND '12503' OR h.hostid BETWEEN '12759' AND '12763' OR h.hostid BETWEEN '12811' AND '12839' OR h.hostid BETWEEN '12841' AND '12846' OR h.hostid BETWEEN '12849' AND '12880' OR h.hostid BETWEEN '12882' AND '12903' OR h.hostid BETWEEN '12906' AND '12944' OR h.hostid BETWEEN '12946' AND '12950' OR h.hostid BETWEEN '12952' AND '13013' OR h.hostid BETWEEN '13015' AND '13019' OR h.hostid BETWEEN '13090' AND '13102' OR h.hostid BETWEEN '13104' AND '13115' OR h.hostid BETWEEN '13120' AND '13125' OR h.hostid BETWEEN '13127' AND '13134' OR h.hostid BETWEEN '13144' AND '13151' OR h.hostid BETWEEN '13157' AND '13165' OR h.hostid BETWEEN '13168' AND '13512' OR h.hostid BETWEEN '13528' AND '13666' OR h.hostid BETWEEN '13668' AND '13691' OR h.hostid BETWEEN '13693' AND '13723' OR h.hostid BETWEEN '13725' AND '13741' OR h.hostid BETWEEN '13743' AND '13778' OR h.hostid BETWEEN '13780' AND '13816' OR h.hostid BETWEEN '13818' AND '13822' OR h.hostid BETWEEN '13824' AND '13834' OR h.hostid BETWEEN '13836' AND '13928' OR h.hostid BETWEEN '13933' AND '13945' OR h.hostid BETWEEN '13948' AND '13962' OR h.hostid BETWEEN '13966' AND '13974' OR h.hostid BETWEEN '13976' AND '14024' OR h.hostid BETWEEN '14026' AND '14094' OR h.hostid BETWEEN '14096' AND '14118' OR h.hostid BETWEEN '14120' AND '14136' OR h.hostid BETWEEN '14138' AND '14146' OR h.hostid BETWEEN '14148' AND '14155' OR h.hostid BETWEEN '14157' AND '14177' OR h.hostid BETWEEN '14179' AND '14184' OR h.hostid BETWEEN '14186' AND '14212' OR h.hostid BETWEEN '14214' AND '14222' OR h.hostid BETWEEN '14227' AND '14365' OR h.hostid BETWEEN '14372' AND '14382' OR h.hostid BETWEEN '14384' AND '14400' OR h.hostid BETWEEN '14413' AND '14439' OR h.hostid BETWEEN '14441' AND '14470' OR h.hostid BETWEEN '14472' AND '14490' OR h.hostid BETWEEN '14500' AND '14548' OR h.hostid BETWEEN '14554' AND '14581' OR h.hostid BETWEEN '14583' AND '14597' OR h.hostid BETWEEN '14614' AND '14624' OR h.hostid BETWEEN '14626' AND '14670' OR h.hostid BETWEEN '14672' AND '14700' OR h.hostid BETWEEN '14702' AND '14758' OR h.hostid BETWEEN '14760' AND '14765' OR h.hostid BETWEEN '14767' AND '14818' OR h.hostid BETWEEN '14827' AND '14842' OR h.hostid BETWEEN '14847' AND '14857' OR h.hostid BETWEEN '14866' AND '14884' OR h.hostid BETWEEN '14886' AND '14903' OR h.hostid BETWEEN '14907' AND '14931' OR h.hostid BETWEEN '14938' AND '14943' OR h.hostid BETWEEN '14953' AND '14968' OR h.hostid BETWEEN '14972' AND '15052' OR h.hostid BETWEEN '15063' AND '15132' OR h.hostid BETWEEN '15144' AND '15236' OR h.hostid BETWEEN '15238' AND '15243' OR h.hostid BETWEEN '15245' AND '15261' OR h.hostid BETWEEN '15311' AND '15320' OR h.hostid BETWEEN '15335' AND '15339' OR h.hostid BETWEEN '15341' AND '15346' OR h.hostid BETWEEN '15352' AND '15361' OR h.hostid BETWEEN '15366' AND '15376' OR h.hostid BETWEEN '15381' AND '15402' OR h.hostid BETWEEN '15404' AND '15413' OR h.hostid BETWEEN '15488' AND '15527' OR h.hostid BETWEEN '15529' AND '15539' OR h.hostid BETWEEN '15547' AND '15608' OR h.hostid BETWEEN '15614' AND '15620' OR h.hostid BETWEEN '15665' AND '15695' OR h.hostid BETWEEN '15697' AND '15707' OR h.hostid BETWEEN '15709' AND '15715' OR h.hostid BETWEEN '15718' AND '15729' OR h.hostid BETWEEN '15734' AND '15738' OR h.hostid BETWEEN '15740' AND '15756' OR h.hostid BETWEEN '15776' AND '15782' OR h.hostid BETWEEN '15784' AND '15790' OR h.hostid BETWEEN '15797' AND '15811' OR h.hostid BETWEEN '15920' AND '15930' OR h.hostid BETWEEN '15937' AND '15945' OR h.hostid BETWEEN '15948' AND '15954' OR h.hostid BETWEEN '15958' AND '15979' OR h.hostid BETWEEN '15996' AND '16003' OR h.hostid BETWEEN '16027' AND '16052' OR h.hostid BETWEEN '16054' AND '16069' OR h.hostid BETWEEN '16071' AND '16086' OR h.hostid BETWEEN '16088' AND '16097' OR h.hostid BETWEEN '16106' AND '16150' OR h.hostid BETWEEN '16157' AND '16173' OR h.hostid BETWEEN '16199' AND '16210' OR h.hostid BETWEEN '16212' AND '16220' OR h.hostid BETWEEN '16255' AND '16259' OR h.hostid BETWEEN '16262' AND '16270' OR h.hostid BETWEEN '16274' AND '16279' OR h.hostid BETWEEN '16284' AND '16294' OR h.hostid BETWEEN '16305' AND '16310' OR h.hostid BETWEEN '16312' AND '16317' OR h.hostid BETWEEN '16320' AND '16324' OR h.hostid BETWEEN '16328' AND '16371' OR h.hostid BETWEEN '16373' AND '16380' OR h.hostid BETWEEN '16391' AND '16403' OR h.hostid BETWEEN '16434' AND '16439' OR h.hostid BETWEEN '16512' AND '16517' OR h.hostid BETWEEN '16595' AND '16602' OR h.hostid BETWEEN '16604' AND '16608' OR h.hostid BETWEEN '16628' AND '16675' OR h.hostid BETWEEN '16678' AND '16686' OR h.hostid BETWEEN '16739' AND '16746' OR h.hostid BETWEEN '16764' AND '16825' OR h.hostid BETWEEN '16827' AND '16850' OR h.hostid BETWEEN '16857' AND '16883' OR h.hostid BETWEEN '16885' AND '16929' OR h.hostid BETWEEN '16931' AND '16943' OR h.hostid BETWEEN '17026' AND '17046' OR h.hostid BETWEEN '17048' AND '17054' OR h.hostid BETWEEN '17104' AND '17111' OR h.hostid BETWEEN '17113' AND '17117' OR h.hostid BETWEEN '17119' AND '17127' OR h.hostid BETWEEN '17145' AND '17156' OR h.hostid BETWEEN '17159' AND '17244' OR h.hostid BETWEEN '17252' AND '17290' OR h.hostid BETWEEN '17348' AND '17366' OR h.hostid BETWEEN '17373' AND '17400' OR h.hostid BETWEEN '17402' AND '17408' OR h.hostid BETWEEN '17414' AND '17486' OR h.hostid BETWEEN '17494' AND '17546' OR h.hostid BETWEEN '17549' AND '17554' OR h.hostid BETWEEN '17557' AND '17563' OR h.hostid BETWEEN '17574' AND '17627' OR h.hostid BETWEEN '17629' AND '17638' OR h.hostid BETWEEN '17645' AND '17744' OR h.hostid BETWEEN '17748' AND '17793' OR h.hostid BETWEEN '17821' AND '17851' OR h.hostid BETWEEN '17853' AND '17885' OR h.hostid BETWEEN '17887' AND '17906' OR h.hostid BETWEEN '17920' AND '17943' OR h.hostid BETWEEN '17955' AND '17972' OR h.hostid BETWEEN '17978' AND '17984' OR h.hostid BETWEEN '17986' AND '17990' OR h.hostid BETWEEN '18012' AND '18024' OR h.hostid BETWEEN '18026' AND '18036' OR h.hostid BETWEEN '18038' AND '18054' OR h.hostid BETWEEN '18067' AND '18077' OR h.hostid BETWEEN '18079' AND '18119' OR h.hostid BETWEEN '18121' AND '18129' OR h.hostid BETWEEN '18134' AND '18141' OR h.hostid BETWEEN '18143' AND '18167' OR h.hostid BETWEEN '18169' AND '18190' OR h.hostid BETWEEN '18192' AND '18200' OR h.hostid BETWEEN '18202' AND '18216' OR h.hostid BETWEEN '18218' AND '18222' OR h.hostid BETWEEN '18225' AND '18243' OR h.hostid BETWEEN '18250' AND '18320' OR h.hostid BETWEEN '18333' AND '18379' OR h.hostid BETWEEN '18381' AND '18398' OR h.hostid BETWEEN '18403' AND '18421' OR h.hostid BETWEEN '18429' AND '18434' OR h.hostid BETWEEN '18436' AND '18441' OR h.hostid BETWEEN '18445' AND '18453' OR h.hostid BETWEEN '18458' AND '18462' OR h.hostid BETWEEN '18466' AND '18486' OR h.hostid BETWEEN '18488' AND '18504' OR h.hostid BETWEEN '18509' AND '18540' OR h.hostid BETWEEN '18542' AND '18564' OR h.hostid BETWEEN '18568' AND '18574' OR h.hostid BETWEEN '18592' AND '18621' OR h.hostid BETWEEN '18628' AND '18676' OR h.hostid BETWEEN '18681' AND '18694' OR h.hostid BETWEEN '18696' AND '18707' OR h.hostid BETWEEN '18710' AND '18727' OR h.hostid BETWEEN '18729' AND '18821' OR h.hostid BETWEEN '18824' AND '18841' OR h.hostid BETWEEN '18908' AND '18953' OR h.hostid BETWEEN '19220' AND '19232' OR h.hostid BETWEEN '19240' AND '19259' OR h.hostid BETWEEN '19265' AND '19271' OR h.hostid BETWEEN '19273' AND '19336' OR h.hostid BETWEEN '19346' AND '19428' OR h.hostid BETWEEN '19430' AND '19434' OR h.hostid BETWEEN '19439' AND '19446' OR h.hostid BETWEEN '19463' AND '19468' OR h.hostid BETWEEN '19470' AND '19474' OR h.hostid BETWEEN '19476' AND '19480' OR h.hostid BETWEEN '19603' AND '19608' OR h.hostid BETWEEN '19618' AND '19624' OR h.hostid BETWEEN '19627' AND '19634' OR h.hostid BETWEEN '19636' AND '19642' OR h.hostid BETWEEN '19652' AND '19662' OR h.hostid BETWEEN '19664' AND '19686' OR h.hostid BETWEEN '19688' AND '19693' OR h.hostid BETWEEN '19719' AND '19778' OR h.hostid BETWEEN '20211' AND '20220' OR h.hostid BETWEEN '20652' AND '20692' OR h.hostid BETWEEN '20694' AND '20709' OR h.hostid BETWEEN '20715' AND '20778' OR h.hostid BETWEEN '20780' AND '20795' OR h.hostid BETWEEN '20798' AND '20835' OR h.hostid BETWEEN '20837' AND '20846' OR h.hostid BETWEEN '20848' AND '20856' OR h.hostid BETWEEN '20858' AND '20897' OR h.hostid BETWEEN '20899' AND '20905' OR h.hostid BETWEEN '20907' AND '20930' OR h.hostid BETWEEN '20932' AND '20948' OR h.hostid BETWEEN '20950' AND '21002' OR h.hostid BETWEEN '21004' AND '21012' OR h.hostid BETWEEN '21075' AND '21080' OR h.hostid BETWEEN '21087' AND '21123' OR h.hostid BETWEEN '21202' AND '21214' OR h.hostid BETWEEN '21216' AND '21224' OR h.hostid BETWEEN '21228' AND '21236' OR h.hostid BETWEEN '21239' AND '21245' OR h.hostid BETWEEN '21247' AND '21252' OR h.hostid BETWEEN '21255' AND '21275' OR h.hostid BETWEEN '21397' AND '21411' OR h.hostid BETWEEN '21414' AND '21418' OR h.hostid BETWEEN '21421' AND '21430' OR h.hostid BETWEEN '21432' AND '21531' OR h.hostid BETWEEN '21533' AND '21541' OR h.hostid BETWEEN '21556' AND '21567' OR h.hostid BETWEEN '21569' AND '21574' OR h.hostid BETWEEN '21576' AND '21582' OR h.hostid BETWEEN '21584' AND '21625' OR h.hostid BETWEEN '21627' AND '21659' OR h.hostid BETWEEN '21929' AND '21974' OR h.hostid BETWEEN '21977' AND '22000' OR h.hostid BETWEEN '22002' AND '22018' OR h.hostid BETWEEN '22021' AND '22068' OR h.hostid BETWEEN '22080' AND '22173' OR h.hostid BETWEEN '22175' AND '22183' OR h.hostid BETWEEN '22189' AND '22227' OR h.hostid IN ('10122','10171','10241','10242','10243','10400','10413','10414','10538','10549','10550','10612','10614','10615','10616','10643','10644','10645','10646','10655','10675','10676','10691','10692','10708','10709','10760','10761','10762','10818','10819','10843','10844','10846','10850','10851','10876','10877','10944','10955','10999','11000','11001','11096','11097','11099','11100','11110','11112','11287','11288','11304','11305','11306','11307','11309','11310','11311','11312','11314','11319','11378','11404','11405','11406','11407','11416','11417','11418','11420','11422','11423','11425','11426','11427','11429','11502','11535','11536','11537','11538','11564','11565','11566','11607','11608','11609','11610','11702','11703','11704','11705','11753','11754','11785','11786','11788','11790','11791','11792','11794','11795','11805','11806','11807','11808','11810','11812','11813','11971','11972','12032','12033','12035','12036','12039','12040','12041','12050','12109','12111','12188','12189','12190','12251','12252','12254','12363','12364','12365','12432','12433','12439','12441','12604','12621','12628','12629','12676','12677','12748','12749','12785','12786','12787','13043','13065','13066','13083','13087','13117','13136','13137','13138','13139','13141','13153','13155','13524','13525','13526','14224','14225','14367','14368','14369','14370','14599','14600','14602','14935','15054','15055','15056','15058','15059','15060','15061','15322','15323','15324','15329','15332','15348','15379','15541','15542','15543','15544','15612','15732','15758','15759','15760','15761','15792','15794','15813','15814','15815','15915','15916','15917','15918','15932','15933','15934','15935','15956','16005','16006','16012','16013','16014','16015','16018','16019','16020','16022','16023','16024','16025','16152','16153','16154','16155','16175','16195','16196','16197','16222','16223','16224','16225','16227','16228','16230','16235','16236','16237','16238','16251','16252','16253','16272','16281','16282','16297','16299','16326','16383','16384','16385','16405','16407','16408','16409','16410','16412','16416','16442','16443','16446','16501','16503','16507','16557','16559','16560','16561','16562','16565','16566','16567','16574','16578','16580','16581','16582','16584','16585','16586','16589','16621','16688','16698','16701','16702','16703','16758','16759','16760','16852','16853','16855','17058','17059','17138','17410','17411','17412','17488','17490','17491','17565','17568','17569','17570','17571','17911','17912','17913','17915','17916','17917','17918','17946','17947','17974','17975','17976','18056','18057','18245','18246','18247','18248','18325','18326','18327','18328','18330','18331','18400','18401','18423','18424','18425','18426','18443','18507','18566','18623','18625','18678','18679','18843','18844','18845','18957','19209','19210','19213','19214','19215','19216','19218','19234','19235','19236','19261','19262','19263','19339','19343','19344','19448','19457','19461','19483','19484','19488','19508','19509','19510','19511','19526','19530','19562','19563','19564','19565','19567','19580','19581','19584','19585','19586','19587','19589','19611','19614','19644','19645','19646','19650','19715','19716','19717','20207','20222','20223','20224','20647','20648','20649','20650','20711','20712','20713','21082','21083','21084','21085','21226','21279','21280','21281','21282','22072','22074','22076','22077','22078','22185','22186')) AND h.status IN (0,1) sysmaps.php:407 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CMap->get() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434 SQL (0.000726): COMMIT sysmaps.php:407 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:314 SQL (0.000787): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=108 AND idx='web.paging.lastpage' sysmaps.php:427 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107 SQL (0.00052): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=108 AND idx='web.sysmapconf.filter.state' sysmaps.php:431 → CView->render() → include() → CFilter->__construct() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107 SQL (0.000406): BEGIN sysmaps.php:435 → require_once() → DBstart() → DBexecute() in include/db.inc.php:253 SQL (0.000929): UPDATE profiles SET value_str='zabbix.php', type=3 WHERE userid=108 AND idx='web.menu.view.last' sysmaps.php:435 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:285 SQL (0.00048): UPDATE profiles SET value_str='sysmaps.php', type=3 WHERE userid=108 AND idx='web.paging.lastpage' sysmaps.php:435 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:285 SQL (0.000486): COMMIT sysmaps.php:435 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:314