API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 17th, 2018
83
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.43 KB | None | 0 0
raw download clone embed print report
  1. MonitoringInventoryReports
  2.  
  3.  
  4. Share
  5.  
  6.  
  7.  
  8. DashboardOverviewWebLatest dataTriggersEventsGraphsScreensMapsIT servicesZBX
  9. Screens
  10. Create screenImport
  11. Filter
  12. Name like
  13.  
  14. FilterReset
  15.  
  16. Name
  17. Dimension (cols x rows) Actions
  18. I41-RTP Balashiha 4 x 6
  19. i41_КДУ2.0 8800 2 x 3
  20. I412-VATC.EKB 4 x 3
  21. I413-VATC.NNOV 3 x 3
  22. I414-VATC.NVS 3 x 2
  23. i415-VATC.RSV 3 x 3
  24. i416-VATC.SPB 3 x 2
  25. RTPsess 2 x 16
  26. UD_tst_ 1 x 1
  27. Алле Базы данных 4 x 4
  28. Displaying 10 of 10 found
  29. 0 selectedExportDelete
  30. Zabbix 3.0.22. © 2001–2018, Zabbix SIA
  31. ******************** Script profiler ********************
  32. Total time: 0.081753
  33. Total SQL time: 0.056683
  34. SQL count: 34 (selects: 24 | executes: 10)
  35. Peak memory usage: 8.25M
  36. Memory limit: 512M
  37.  
  38. 1. screen.get [screenconf.php:418]
  39.  
  40. Parameters:
  41. Array
  42. (
  43. [output] => Array
  44. (
  45. [0] => screenid
  46. [1] => name
  47. [2] => hsize
  48. [3] => vsize
  49. )
  50.  
  51. [sortfield] => name
  52. [limit] => 5001
  53. [search] => Array
  54. (
  55. [name] =>
  56. )
  57.  
  58. [preservekeys] => 1
  59. )
  60. Result:
  61. Array
  62. (
  63. [143] => Array
  64. (
  65. [screenid] => 143
  66. [name] => I412-VATC.EKB
  67. [hsize] => 4
  68. [vsize] => 3
  69. )
  70.  
  71. [162] => Array
  72. (
  73. [screenid] => 162
  74. [name] => I413-VATC.NNOV
  75. [hsize] => 3
  76. [vsize] => 3
  77. )
  78.  
  79. [164] => Array
  80. (
  81. [screenid] => 164
  82. [name] => I414-VATC.NVS
  83. [hsize] => 3
  84. [vsize] => 2
  85. )
  86.  
  87. [158] => Array
  88. (
  89. [screenid] => 158
  90. [name] => i415-VATC.RSV
  91. [hsize] => 3
  92. [vsize] => 3
  93. )
  94.  
  95. [161] => Array
  96. (
  97. [screenid] => 161
  98. [name] => i416-VATC.SPB
  99. [hsize] => 3
  100. [vsize] => 2
  101. )
  102.  
  103. [166] => Array
  104. (
  105. [screenid] => 166
  106. [name] => I41-RTP Balashiha
  107. [hsize] => 4
  108. [vsize] => 6
  109. )
  110.  
  111. [142] => Array
  112. (
  113. [screenid] => 142
  114. [name] => i41_КДУ2.0 8800
  115. [hsize] => 2
  116. [vsize] => 3
  117. )
  118.  
  119. [123] => Array
  120. (
  121. [screenid] => 123
  122. [name] => RTPsess
  123. [hsize] => 2
  124. [vsize] => 16
  125. )
  126.  
  127. [146] => Array
  128. (
  129. [screenid] => 146
  130. [name] => UD_tst_
  131. [hsize] => 1
  132. [vsize] => 1
  133. )
  134.  
  135. [54] => Array
  136. (
  137. [screenid] => 54
  138. [name] => Алле Базы данных
  139. [hsize] => 4
  140. [vsize] => 4
  141. )
  142.  
  143. )
  144.  
  145. 2. screen.get [screenconf.php:428]
  146.  
  147. Parameters:
  148. Array
  149. (
  150. [output] => Array
  151. (
  152. )
  153.  
  154. [screenids] => Array
  155. (
  156. [0] => 143
  157. [1] => 162
  158. [2] => 164
  159. [3] => 158
  160. [4] => 161
  161. [5] => 166
  162. [6] => 142
  163. [7] => 123
  164. [8] => 146
  165. [9] => 54
  166. )
  167.  
  168. [editable] => 1
  169. [preservekeys] => 1
  170. )
  171. Result:
  172. Array
  173. (
  174. )
  175.  
  176.  
  177. SQL (0.000282): SET search_path = 'public'
  178. screenconf.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:84
  179.  
  180. SQL (0.000192): SET bytea_output = escape
  181. screenconf.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:95
  182.  
  183. SQL (0.004258): SELECT 1 FROM information_schema.tables WHERE table_catalog='zabbixdb' AND table_schema='public' AND table_name='dbversion'
  184. screenconf.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → PostgresqlDbBackend->checkDbVersionTable() → DBselect() in include/classes/db/PostgresqlDbBackend.php:41
  185.  
  186. SQL (0.000475): SELECT dv.mandatory,dv.optional FROM dbversion dv
  187. screenconf.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → DBselect() in include/classes/db/DbBackend.php:46
  188.  
  189. SQL (0.000673): SELECT NULL FROM config c
  190. screenconf.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkConfig() → DBselect() in include/classes/db/DbBackend.php:62
  191.  
  192. SQL (0.000204): BEGIN
  193. screenconf.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
  194.  
  195. SQL (0.00154): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='1d9e253dd39c9c9375d8424d26b2fa57' AND s.status=0 AND s.userid=u.userid AND (s.lastaccess+u.autologout>1539796808 OR u.autologout=0)
  196. screenconf.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
  197.  
  198. SQL (0.000917): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid='101' AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0
  199. screenconf.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
  200.  
  201. SQL (0.000422): UPDATE sessions SET lastaccess=1539796808 WHERE userid='101' AND sessionid='1d9e253dd39c9c9375d8424d26b2fa57'
  202. screenconf.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
  203.  
  204. SQL (0.00072): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='101' AND g.usrgrpid=ug.usrgrpid
  205. screenconf.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
  206.  
  207. SQL (0.00054): 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='101'
  208. screenconf.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
  209.  
  210. SQL (0.0005): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid='101' AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1
  211. screenconf.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
  212.  
  213. SQL (0.000708): COMMIT
  214. screenconf.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
  215.  
  216. SQL (0.000843): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=101 AND idx='web.menu.view.last'
  217. screenconf.php:43 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107
  218.  
  219. SQL (0.00086): SELECT c.* FROM config c
  220. screenconf.php:43 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33
  221.  
  222. SQL (0.000446): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=101 AND idx='web.login.attempt.failed'
  223. screenconf.php:43 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107
  224.  
  225. SQL (0.000365): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=101 AND idx='web.screenconf.config'
  226. screenconf.php:79 → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107
  227.  
  228. SQL (0.002751): DELETE FROM profiles WHERE idx='web.screens.elementid' AND idx2='0' AND userid='101'
  229. screenconf.php:370 → CProfile::delete() → CProfile::deleteValues() → DB::delete() → DBexecute() in include/classes/db/DB.php:829
  230.  
  231. SQL (0.00035): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=101 AND idx='web.screenconf.php.sort'
  232. screenconf.php:372 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107
  233.  
  234. SQL (0.000337): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=101 AND idx='web.screenconf.php.sortorder'
  235. screenconf.php:373 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107
  236.  
  237. SQL (0.000302): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=101 AND idx='web.screenconf.filter_name'
  238. screenconf.php:407 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107
  239.  
  240. SQL (0.000188): BEGIN
  241. screenconf.php:418 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:253
  242.  
  243. SQL (0.000317): SELECT usrgrpid FROM users_groups WHERE userid='101'
  244. screenconf.php:418 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CScreen->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:304
  245.  
  246. SQL (0.002189): SELECT s.screenid,s.name,s.hsize,s.vsize FROM screens s WHERE s.templateid IS NULL AND (EXISTS (SELECT NULL FROM screen_user su WHERE s.screenid=su.screenid AND su.userid=101 AND su.permission>=2) OR EXISTS (SELECT NULL FROM screen_usrgrp sg WHERE s.screenid=sg.screenid AND sg.usrgrpid IN ('11','29','44','45','54','55') AND sg.permission>=2) OR s.userid=101 OR s.private=0) ORDER BY s.name LIMIT 5001 OFFSET 0
  247. screenconf.php:418 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CScreen->get() → DBselect() in include/classes/api/services/CScreen.php:167
  248.  
  249. SQL (0.001319): SELECT si.screenid,si.resourcetype,si.resourceid,si.style FROM screens_items si WHERE si.screenid IN ('16','54','55','104','123','142','143','146','158','159','161','162','164','166','167','186','201') AND (si.resourcetype BETWEEN '0' AND '5' OR si.resourcetype IN ('7','8','9','10','14','16')) AND si.resourceid<>0
  250. screenconf.php:418 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CScreen->get() → DBselect() in include/classes/api/services/CScreen.php:186
  251.  
  252. SQL (0.030207): SELECT g.graphid FROM graphs g WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('11','29','44','45','54','55') WHERE g.graphid=gi.graphid AND gi.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 NOT EXISTS (SELECT NULL FROM items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('11','29','44','45','54','55') WHERE g.ymin_type=2 AND g.ymin_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 NOT EXISTS (SELECT NULL FROM items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('11','29','44','45','54','55') WHERE g.ymax_type=2 AND g.ymax_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 (g.graphid BETWEEN '84825' AND '84834' OR g.graphid BETWEEN '149190' AND '149194' OR g.graphid BETWEEN '220908' AND '220913' OR g.graphid IN ('524','525','14327','14353','14379','14392','44560','44573','44586','44683','44690','44703','44740','44771','44822','44864','44878','44921','44960','44965','44972','44981','44994','45052','48296','48415','51716','51729','51739','51757','51758','51778','52555','55767','62742','62743','62749','62750','62756','62757','62765','62767','62774','62776','62783','62785','62792','62794','62828','62830','88525','88528','92881','92882','92883','92884','92886','92895','92896','92897','92898','92900','92909','92910','92911','92912','92914','92923','92924','92925','92926','92928','93705','93710','93711','93716','96346','96352','96377','96712','96718','96728','96731','101885','103722','103728','103749','104096','104108','104123','105954','105960','106040','112321','112322','117115','117121','117143','117424','117425','117426','117427','117869','117875','117890','118623','149196','149210','220928','222870','222884','222914')) AND g.flags IN ('0','4')
  253. screenconf.php:418 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CScreen->get() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:293
  254.  
  255. SQL (0.001535): SELECT i.itemid FROM items i WHERE i.flags IN (0,4) AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('11','29','44','45','54','55') WHERE i.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND i.itemid IN ('576972','576982','576996','898368','898378','898392')
  256. screenconf.php:418 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CScreen->get() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:352
  257.  
  258. SQL (0.000827): COMMIT
  259. screenconf.php:418 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:314
  260.  
  261. SQL (0.000188): BEGIN
  262. screenconf.php:428 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:253
  263.  
  264. SQL (0.000987): SELECT s.screenid FROM screens s WHERE s.templateid IS NULL AND (EXISTS (SELECT NULL FROM screen_user su WHERE s.screenid=su.screenid AND su.userid=101 AND su.permission>=3) OR EXISTS (SELECT NULL FROM screen_usrgrp sg WHERE s.screenid=sg.screenid AND sg.usrgrpid IN ('11','29','44','45','54','55') AND sg.permission>=3) OR s.userid=101) AND s.screenid IN ('54','123','142','143','146','158','161','162','164','166')
  265. screenconf.php:428 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CScreen->get() → DBselect() in include/classes/api/services/CScreen.php:167
  266.  
  267. SQL (0.000192): COMMIT
  268. screenconf.php:428 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:314
  269.  
  270. SQL (0.000349): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=101 AND idx='web.paging.lastpage'
  271. screenconf.php:439 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107
  272.  
  273. SQL (0.000364): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=101 AND idx='web.paging.page'
  274. screenconf.php:439 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107
  275.  
  276. SQL (0.000336): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=101 AND idx='web.screenconf.filter.state'
  277. screenconf.php:443 → CView->render() → include() → CFilter->__construct() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:107
  278.  
  279. Hide debug
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!