API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 28th, 2014
286
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 102.35 KB | None | 0 0
raw download clone embed print report
  1. Database Queries
  2. 42 Queries Logged 10.5 ms
  3.  
  4. 6 duplicate found!
  5. 2 duplicates: #15 #16
  6. 2 duplicates: #21 #22
  7. 2 duplicates: #31 #33
  8.  
  9. Query Time: 0.16 ms Query memory: 0.013 MB Memory before query: 2.316 MB Rows returned: 1
  10.  
  11. SELECT `data`
  12.  
  13. FROM `an1sp0t_session`
  14.  
  15. WHERE `session_id` = '94ede3bdf9b6946f4c5a6bc3f10bb5e2'
  16.  
  17. Explain
  18. id select_type table type possible_keys key key_len ref rows Extra
  19. 1 SIMPLE an1sp0t_session const PRIMARY PRIMARY 602 const 1
  20. Profile
  21. Status Duration
  22. starting 0.0 ms
  23. Waiting for query cache lock 0.0 ms
  24. checking query cache for query 0.0 ms
  25. checking permissions 0.0 ms
  26. Opening tables 0.0 ms
  27. System lock 0.0 ms
  28. Waiting for query cache lock 0.0 ms
  29. init 0.0 ms
  30. optimizing 0.0 ms
  31. statistics 0.0 ms
  32. preparing 0.0 ms
  33. executing 0.0 ms
  34. Sending data 0.0 ms
  35. end 0.0 ms
  36. query end 0.0 ms
  37. closing tables 0.0 ms
  38. freeing items 0.0 ms
  39. Waiting for query cache lock 0.0 ms
  40. freeing items 0.0 ms
  41. Waiting for query cache lock 0.0 ms
  42. freeing items 0.0 ms
  43. storing result in query cache 0.0 ms
  44. logging slow query 0.0 ms
  45. cleaning up 0.0 ms
  46. Call Stack
  47. JROOT/libraries/joomla/session/storage/database.php:46
  48. JROOT/libraries/joomla/session/session.php:658
  49. JROOT/libraries/joomla/session/session.php:596
  50. JROOT/libraries/cms/application/cms.php:672
  51. JROOT/libraries/cms/application/cms.php:131
  52. JROOT/libraries/cms/application/administrator.php:45
  53. JROOT/libraries/cms/application/cms.php:332
  54. JROOT/libraries/joomla/factory.php:124
  55. JROOT/administrator/index.php:39
  56. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  57. Query Time: 0.10 ms After last query: 0.74 ms Query memory: 0.008 MB Memory before query: 2.425 MB
  58.  
  59. DELETE
  60.  
  61. FROM `an1sp0t_session`
  62.  
  63. WHERE `time` < '1401265045'
  64.  
  65. Explain
  66. EXPLAIN not possible on query: DELETE FROM `an1sp0t_session` WHERE `time` < '1401265045'
  67. Profile
  68. Status Duration
  69. starting 0.0 ms
  70. checking permissions 0.0 ms
  71. Opening tables 0.0 ms
  72. System lock 0.0 ms
  73. init 0.0 ms
  74. updating 0.0 ms
  75. end 0.0 ms
  76. query end 0.0 ms
  77. closing tables 0.0 ms
  78. freeing items 0.0 ms
  79. logging slow query 0.0 ms
  80. cleaning up 0.0 ms
  81. Call Stack
  82. JROOT/libraries/cms/application/cms.php:689
  83. JROOT/libraries/cms/application/cms.php:131
  84. JROOT/libraries/cms/application/administrator.php:45
  85. JROOT/libraries/cms/application/cms.php:332
  86. JROOT/libraries/joomla/factory.php:124
  87. JROOT/administrator/index.php:39
  88. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  89. Query Time: 0.16 ms After last query: 6.77 ms Query memory: 0.021 MB Memory before query: 3.204 MB Rows returned: 1
  90.  
  91. SELECT extension_id AS id, element AS "option", params, enabled
  92.  
  93. FROM an1sp0t_extensions
  94.  
  95. WHERE `type` = 'component'
  96. AND `element` = 'com_users'
  97.  
  98. Explain
  99. id select_type table type possible_keys key key_len ref rows Extra
  100. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
  101. Profile
  102. Status Duration
  103. starting 0.0 ms
  104. Waiting for query cache lock 0.0 ms
  105. checking query cache for query 0.0 ms
  106. checking permissions 0.0 ms
  107. Opening tables 0.0 ms
  108. System lock 0.0 ms
  109. Waiting for query cache lock 0.0 ms
  110. init 0.0 ms
  111. optimizing 0.0 ms
  112. statistics 0.0 ms
  113. preparing 0.0 ms
  114. executing 0.0 ms
  115. Sending data 0.0 ms
  116. end 0.0 ms
  117. query end 0.0 ms
  118. closing tables 0.0 ms
  119. freeing items 0.0 ms
  120. Waiting for query cache lock 0.0 ms
  121. freeing items 0.0 ms
  122. Waiting for query cache lock 0.0 ms
  123. freeing items 0.0 ms
  124. storing result in query cache 0.0 ms
  125. logging slow query 0.0 ms
  126. cleaning up 0.0 ms
  127. Call Stack
  128. JROOT/libraries/joomla/cache/controller/callback.php:158
  129. JROOT/libraries/cms/component/helper.php:396
  130. JROOT/libraries/cms/component/helper.php:43
  131. JROOT/libraries/cms/component/helper.php:91
  132. JROOT/libraries/joomla/access/access.php:295
  133. JROOT/libraries/joomla/access/access.php:405
  134. JROOT/libraries/joomla/user/user.php:428
  135. JROOT/libraries/cms/plugin/helper.php:298
  136. JROOT/libraries/cms/plugin/helper.php:88
  137. JROOT/libraries/cms/plugin/helper.php:130
  138. JROOT/libraries/cms/application/cms.php:573
  139. JROOT/libraries/cms/application/administrator.php:301
  140. JROOT/libraries/cms/application/administrator.php:116
  141. JROOT/libraries/cms/application/cms.php:255
  142. JROOT/administrator/index.php:42
  143. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  144. Query Time: 0.04 ms After last query: 0.44 ms Query memory: 0.015 MB Memory before query: 3.231 MB Rows returned: 2
  145.  
  146. SELECT b.id
  147.  
  148. FROM an1sp0t_user_usergroup_map AS map
  149.  
  150. LEFT JOIN an1sp0t_usergroups AS a
  151. ON a.id = map.group_id
  152.  
  153. LEFT JOIN an1sp0t_usergroups AS b
  154. ON b.lft <= a.lft
  155. AND b.rgt >= a.rgt
  156.  
  157. WHERE map.user_id = 105
  158.  
  159. Explain
  160. id select_type table type possible_keys key key_len ref rows Extra
  161. 1 SIMPLE map ref PRIMARY PRIMARY 4 const 1 Using index
  162. 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 anispotc_bd.map.group_id 1
  163. 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using index
  164. Profile
  165. Status Duration
  166. starting 0.0 ms
  167. Waiting for query cache lock 0.0 ms
  168. checking query cache for query 0.0 ms
  169. checking privileges on cached 0.0 ms
  170. checking permissions 0.0 ms
  171. checking permissions 0.0 ms
  172. checking permissions 0.0 ms
  173. sending cached result to clien 0.0 ms
  174. logging slow query 0.0 ms
  175. cleaning up 0.0 ms
  176. Call Stack
  177. JROOT/libraries/joomla/access/access.php:336
  178. JROOT/libraries/joomla/access/access.php:405
  179. JROOT/libraries/joomla/user/user.php:428
  180. JROOT/libraries/cms/plugin/helper.php:298
  181. JROOT/libraries/cms/plugin/helper.php:88
  182. JROOT/libraries/cms/plugin/helper.php:130
  183. JROOT/libraries/cms/application/cms.php:573
  184. JROOT/libraries/cms/application/administrator.php:301
  185. JROOT/libraries/cms/application/administrator.php:116
  186. JROOT/libraries/cms/application/cms.php:255
  187. JROOT/administrator/index.php:42
  188. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  189. Query Time: 0.04 ms After last query: 0.48 ms Query memory: 0.014 MB Memory before query: 3.296 MB Rows returned: 5
  190.  
  191. SELECT id, rules
  192.  
  193. FROM `an1sp0t_viewlevels`
  194.  
  195. Explain
  196. id select_type table type possible_keys key key_len ref rows Extra
  197. 1 SIMPLE an1sp0t_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5
  198. Profile
  199. Status Duration
  200. starting 0.0 ms
  201. Waiting for query cache lock 0.0 ms
  202. checking query cache for query 0.0 ms
  203. checking privileges on cached 0.0 ms
  204. checking permissions 0.0 ms
  205. sending cached result to clien 0.0 ms
  206. logging slow query 0.0 ms
  207. cleaning up 0.0 ms
  208. Call Stack
  209. JROOT/libraries/joomla/access/access.php:422
  210. JROOT/libraries/joomla/user/user.php:428
  211. JROOT/libraries/cms/plugin/helper.php:298
  212. JROOT/libraries/cms/plugin/helper.php:88
  213. JROOT/libraries/cms/plugin/helper.php:130
  214. JROOT/libraries/cms/application/cms.php:573
  215. JROOT/libraries/cms/application/administrator.php:301
  216. JROOT/libraries/cms/application/administrator.php:116
  217. JROOT/libraries/cms/application/cms.php:255
  218. JROOT/administrator/index.php:42
  219. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  220. Query Time: 0.38 ms After last query: 0.15 ms Query memory: 0.011 MB Memory before query: 3.318 MB Rows returned: 49
  221.  
  222. SELECT folder AS type, element AS name, params
  223.  
  224. FROM an1sp0t_extensions
  225.  
  226. WHERE enabled >= 1
  227. AND type ='plugin'
  228. AND state >= 0
  229. AND access IN (1,1,2,3,6)
  230.  
  231. ORDER BY ordering
  232.  
  233. Explain
  234. id select_type table type possible_keys key key_len ref rows Extra
  235. 1 SIMPLE an1sp0t_extensions ref extension extension 62 const 63 Using where; Using filesort
  236. Profile
  237. Status Duration
  238. starting 0.0 ms
  239. Waiting for query cache lock 0.0 ms
  240. checking query cache for query 0.0 ms
  241. checking permissions 0.0 ms
  242. Opening tables 0.0 ms
  243. System lock 0.0 ms
  244. Waiting for query cache lock 0.0 ms
  245. init 0.0 ms
  246. optimizing 0.0 ms
  247. statistics 0.0 ms
  248. preparing 0.0 ms
  249. executing 0.0 ms
  250. Sorting result 0.1 ms
  251. Sending data 0.1 ms
  252. end 0.0 ms
  253. query end 0.0 ms
  254. closing tables 0.0 ms
  255. freeing items 0.0 ms
  256. Waiting for query cache lock 0.0 ms
  257. freeing items 0.0 ms
  258. Waiting for query cache lock 0.0 ms
  259. freeing items 0.0 ms
  260. storing result in query cache 0.0 ms
  261. logging slow query 0.0 ms
  262. cleaning up 0.0 ms
  263. Call Stack
  264. JROOT/libraries/cms/plugin/helper.php:312
  265. JROOT/libraries/cms/plugin/helper.php:88
  266. JROOT/libraries/cms/plugin/helper.php:130
  267. JROOT/libraries/cms/application/cms.php:573
  268. JROOT/libraries/cms/application/administrator.php:301
  269. JROOT/libraries/cms/application/administrator.php:116
  270. JROOT/libraries/cms/application/cms.php:255
  271. JROOT/administrator/index.php:42
  272. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  273. Query Time: 0.13 ms After last query: 5.91 ms Query memory: 0.011 MB Memory before query: 4.210 MB Rows returned: 1
  274.  
  275. SELECT `enabled`
  276.  
  277. FROM `an1sp0t_extensions`
  278.  
  279. WHERE `element` = 'com_akeeba'
  280. AND `type` = 'component'
  281.  
  282. Explain
  283. id select_type table type possible_keys key key_len ref rows Extra
  284. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
  285. Profile
  286. Status Duration
  287. starting 0.0 ms
  288. Waiting for query cache lock 0.0 ms
  289. checking query cache for query 0.0 ms
  290. checking permissions 0.0 ms
  291. Opening tables 0.0 ms
  292. System lock 0.0 ms
  293. Waiting for query cache lock 0.0 ms
  294. init 0.0 ms
  295. optimizing 0.0 ms
  296. statistics 0.0 ms
  297. preparing 0.0 ms
  298. executing 0.0 ms
  299. Sending data 0.0 ms
  300. end 0.0 ms
  301. query end 0.0 ms
  302. closing tables 0.0 ms
  303. freeing items 0.0 ms
  304. Waiting for query cache lock 0.0 ms
  305. freeing items 0.0 ms
  306. Waiting for query cache lock 0.0 ms
  307. freeing items 0.0 ms
  308. storing result in query cache 0.1 ms
  309. logging slow query 0.0 ms
  310. cleaning up 0.0 ms
  311. Call Stack
  312. JROOT/plugins/system/srp/srp.php:47
  313. JROOT/libraries/cms/plugin/helper.php:232
  314. JROOT/libraries/cms/plugin/helper.php:172
  315. JROOT/libraries/cms/application/cms.php:586
  316. JROOT/libraries/cms/application/administrator.php:301
  317. JROOT/libraries/cms/application/administrator.php:116
  318. JROOT/libraries/cms/application/cms.php:255
  319. JROOT/administrator/index.php:42
  320. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  321. Query Time: 0.14 ms After last query: 7.29 ms Query memory: 0.017 MB Memory before query: 4.812 MB Rows returned: 1
  322.  
  323. SELECT extension_id AS id, element AS "option", params, enabled
  324.  
  325. FROM an1sp0t_extensions
  326.  
  327. WHERE `type` = 'component'
  328. AND `element` = 'com_widgetkit'
  329.  
  330. Explain
  331. id select_type table type possible_keys key key_len ref rows Extra
  332. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
  333. Profile
  334. Status Duration
  335. starting 0.0 ms
  336. Waiting for query cache lock 0.0 ms
  337. checking query cache for query 0.0 ms
  338. checking permissions 0.0 ms
  339. Opening tables 0.0 ms
  340. System lock 0.0 ms
  341. Waiting for query cache lock 0.0 ms
  342. init 0.0 ms
  343. optimizing 0.0 ms
  344. statistics 0.0 ms
  345. preparing 0.0 ms
  346. executing 0.0 ms
  347. Sending data 0.0 ms
  348. end 0.0 ms
  349. query end 0.0 ms
  350. closing tables 0.0 ms
  351. freeing items 0.0 ms
  352. Waiting for query cache lock 0.0 ms
  353. freeing items 0.0 ms
  354. Waiting for query cache lock 0.0 ms
  355. freeing items 0.0 ms
  356. storing result in query cache 0.1 ms
  357. logging slow query 0.0 ms
  358. cleaning up 0.0 ms
  359. Call Stack
  360. JROOT/libraries/joomla/cache/controller/callback.php:158
  361. JROOT/libraries/cms/component/helper.php:396
  362. JROOT/libraries/cms/component/helper.php:43
  363. JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:32
  364. JROOT/libraries/joomla/event/event.php:71
  365. JROOT/libraries/joomla/event/dispatcher.php:162
  366. JROOT/libraries/joomla/application/base.php:106
  367. JROOT/libraries/cms/application/cms.php:587
  368. JROOT/libraries/cms/application/administrator.php:301
  369. JROOT/libraries/cms/application/administrator.php:116
  370. JROOT/libraries/cms/application/cms.php:255
  371. JROOT/administrator/index.php:42
  372. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  373. Query Time: 0.14 ms After last query: 3.38 ms Query memory: 0.021 MB Memory before query: 5.135 MB Rows returned: 1
  374.  
  375. SELECT extension_id AS id, element AS "option", params, enabled
  376.  
  377. FROM an1sp0t_extensions
  378.  
  379. WHERE `type` = 'library'
  380. AND `element` = 'joomla'
  381.  
  382. Explain
  383. id select_type table type possible_keys key key_len ref rows Extra
  384. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where
  385. Profile
  386. Status Duration
  387. starting 0.0 ms
  388. Waiting for query cache lock 0.0 ms
  389. checking query cache for query 0.0 ms
  390. checking permissions 0.0 ms
  391. Opening tables 0.0 ms
  392. System lock 0.0 ms
  393. Waiting for query cache lock 0.0 ms
  394. init 0.0 ms
  395. optimizing 0.0 ms
  396. statistics 0.0 ms
  397. preparing 0.0 ms
  398. executing 0.0 ms
  399. Sending data 0.0 ms
  400. end 0.0 ms
  401. query end 0.0 ms
  402. closing tables 0.0 ms
  403. freeing items 0.0 ms
  404. Waiting for query cache lock 0.0 ms
  405. freeing items 0.0 ms
  406. Waiting for query cache lock 0.0 ms
  407. freeing items 0.0 ms
  408. storing result in query cache 0.0 ms
  409. logging slow query 0.0 ms
  410. cleaning up 0.0 ms
  411. Call Stack
  412. JROOT/libraries/joomla/cache/controller/callback.php:158
  413. JROOT/libraries/cms/library/helper.php:156
  414. JROOT/libraries/cms/library/helper.php:47
  415. JROOT/libraries/cms/library/helper.php:90
  416. JROOT/libraries/cms/version/version.php:179
  417. JROOT/libraries/joomla/factory.php:734
  418. JROOT/libraries/joomla/factory.php:215
  419. JROOT/plugins/system/sef/sef.php:30
  420. JROOT/libraries/joomla/event/event.php:71
  421. JROOT/libraries/joomla/event/dispatcher.php:162
  422. JROOT/libraries/joomla/application/base.php:106
  423. JROOT/libraries/cms/application/administrator.php:464
  424. JROOT/libraries/cms/application/administrator.php:153
  425. JROOT/libraries/cms/application/cms.php:255
  426. JROOT/administrator/index.php:42
  427. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  428. Query Time: 0.50 ms After last query: 0.20 ms Query memory: 0.017 MB Memory before query: 5.142 MB
  429.  
  430. UPDATE `an1sp0t_extensions`
  431.  
  432. SET `params` = '{\"mediaversion\":\"e0a839f0307cf6c2971a305551fd5a5a\"}'
  433.  
  434. WHERE `type` = 'library'
  435. AND `element` = 'joomla'
  436.  
  437. Explain
  438. EXPLAIN not possible on query: UPDATE `an1sp0t_extensions` SET `params` = '{\"mediaversion\":\"e0a839f0307cf6c2971a305551fd5a5a\"}' WHERE `type` = 'library' AND `element` = 'joomla'
  439. Profile
  440. Status Duration
  441. starting 0.0 ms
  442. checking permissions 0.0 ms
  443. Opening tables 0.0 ms
  444. System lock 0.0 ms
  445. init 0.0 ms
  446. Updating 0.0 ms
  447. end 0.0 ms
  448. Waiting for query cache lock 0.0 ms
  449. end 0.1 ms
  450. query end 0.3 ms
  451. closing tables 0.0 ms
  452. freeing items 0.0 ms
  453. logging slow query 0.0 ms
  454. cleaning up 0.0 ms
  455. Call Stack
  456. JROOT/libraries/cms/library/helper.php:119
  457. JROOT/libraries/cms/version/version.php:230
  458. JROOT/libraries/cms/version/version.php:189
  459. JROOT/libraries/joomla/factory.php:734
  460. JROOT/libraries/joomla/factory.php:215
  461. JROOT/plugins/system/sef/sef.php:30
  462. JROOT/libraries/joomla/event/event.php:71
  463. JROOT/libraries/joomla/event/dispatcher.php:162
  464. JROOT/libraries/joomla/application/base.php:106
  465. JROOT/libraries/cms/application/administrator.php:464
  466. JROOT/libraries/cms/application/administrator.php:153
  467. JROOT/libraries/cms/application/cms.php:255
  468. JROOT/administrator/index.php:42
  469. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  470. Query Time: 0.19 ms After last query: 1.51 ms Query memory: 0.008 MB Memory before query: 5.359 MB Rows returned: 1
  471.  
  472. SELECT template, s.params
  473.  
  474. FROM an1sp0t_template_styles as s
  475.  
  476. LEFT JOIN an1sp0t_extensions as e
  477. ON e.type='template'
  478. AND e.element=s.template
  479. AND e.client_id=s.client_id
  480.  
  481. WHERE s.client_id = 1
  482. AND home = '1'
  483.  
  484. ORDER BY home
  485.  
  486. Explain
  487. id select_type table type possible_keys key key_len ref rows Extra
  488. 1 SIMPLE s ref idx_home idx_home 21 const 2 Using where
  489. 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 anispotc_bd.s.template,const 1
  490. Profile
  491. Status Duration
  492. starting 0.0 ms
  493. Waiting for query cache lock 0.0 ms
  494. checking query cache for query 0.0 ms
  495. checking permissions 0.0 ms
  496. checking permissions 0.0 ms
  497. Opening tables 0.0 ms
  498. System lock 0.0 ms
  499. Waiting for query cache lock 0.0 ms
  500. init 0.0 ms
  501. optimizing 0.0 ms
  502. statistics 0.0 ms
  503. preparing 0.0 ms
  504. executing 0.0 ms
  505. Sending data 0.0 ms
  506. end 0.0 ms
  507. query end 0.0 ms
  508. closing tables 0.0 ms
  509. freeing items 0.0 ms
  510. Waiting for query cache lock 0.0 ms
  511. freeing items 0.0 ms
  512. Waiting for query cache lock 0.0 ms
  513. freeing items 0.0 ms
  514. storing result in query cache 0.1 ms
  515. logging slow query 0.0 ms
  516. cleaning up 0.0 ms
  517. Call Stack
  518. JROOT/libraries/cms/application/administrator.php:219
  519. JROOT/libraries/cms/application/administrator.php:82
  520. JROOT/libraries/cms/application/administrator.php:159
  521. JROOT/libraries/cms/application/cms.php:255
  522. JROOT/administrator/index.php:42
  523. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  524. Query Time: 0.14 ms After last query: 1.29 ms Query memory: 0.013 MB Memory before query: 5.433 MB Rows returned: 1
  525.  
  526. SELECT extension_id AS id, element AS "option", params, enabled
  527.  
  528. FROM an1sp0t_extensions
  529.  
  530. WHERE `type` = 'component'
  531. AND `element` = 'com_cpanel'
  532.  
  533. Explain
  534. id select_type table type possible_keys key key_len ref rows Extra
  535. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
  536. Profile
  537. Status Duration
  538. starting 0.0 ms
  539. Waiting for query cache lock 0.0 ms
  540. checking query cache for query 0.0 ms
  541. checking permissions 0.0 ms
  542. Opening tables 0.0 ms
  543. System lock 0.0 ms
  544. Waiting for query cache lock 0.0 ms
  545. init 0.0 ms
  546. optimizing 0.0 ms
  547. statistics 0.0 ms
  548. preparing 0.0 ms
  549. executing 0.0 ms
  550. Sending data 0.0 ms
  551. end 0.0 ms
  552. query end 0.0 ms
  553. closing tables 0.0 ms
  554. freeing items 0.0 ms
  555. Waiting for query cache lock 0.0 ms
  556. freeing items 0.0 ms
  557. Waiting for query cache lock 0.0 ms
  558. freeing items 0.0 ms
  559. storing result in query cache 0.1 ms
  560. logging slow query 0.0 ms
  561. cleaning up 0.0 ms
  562. Call Stack
  563. JROOT/libraries/joomla/cache/controller/callback.php:158
  564. JROOT/libraries/cms/component/helper.php:396
  565. JROOT/libraries/cms/component/helper.php:43
  566. JROOT/libraries/cms/component/helper.php:73
  567. JROOT/libraries/cms/component/helper.php:320
  568. JROOT/libraries/cms/application/administrator.php:98
  569. JROOT/libraries/cms/application/administrator.php:159
  570. JROOT/libraries/cms/application/cms.php:255
  571. JROOT/administrator/index.php:42
  572. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  573. Query Time: 0.38 ms After last query: 5.23 ms Query memory: 0.016 MB Memory before query: 5.937 MB Rows returned: 11
  574.  
  575. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  576.  
  577. FROM an1sp0t_modules AS m
  578.  
  579. LEFT JOIN an1sp0t_modules_menu AS mm
  580. ON mm.moduleid = m.id
  581.  
  582. LEFT JOIN an1sp0t_extensions AS e
  583. ON e.element = m.module
  584. AND e.client_id = m.client_id
  585.  
  586. WHERE m.published = 1
  587. AND e.enabled = 1
  588. AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-05-28 08:32:25')
  589. AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-05-28 08:32:25')
  590. AND m.access IN (1,1,2,3,6)
  591. AND m.client_id = 1
  592. AND (mm.menuid = 0 OR mm.menuid <= 0)
  593.  
  594. ORDER BY m.position, m.ordering
  595.  
  596. Explain
  597. id select_type table type possible_keys key key_len ref rows Extra
  598. 1 SIMPLE m ALL PRIMARY,published,newsfeeds NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort
  599. 1 SIMPLE mm ref PRIMARY PRIMARY 4 anispotc_bd.m.id 1 Using where; Using index
  600. 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 anispotc_bd.m.module,const 1 Using where
  601. Profile
  602. Status Duration
  603. starting 0.0 ms
  604. Waiting for query cache lock 0.0 ms
  605. checking query cache for query 0.0 ms
  606. checking permissions 0.0 ms
  607. checking permissions 0.0 ms
  608. checking permissions 0.0 ms
  609. Opening tables 0.0 ms
  610. System lock 0.0 ms
  611. Waiting for query cache lock 0.0 ms
  612. init 0.0 ms
  613. optimizing 0.0 ms
  614. statistics 0.0 ms
  615. preparing 0.0 ms
  616. executing 0.0 ms
  617. Sorting result 0.0 ms
  618. Sending data 0.1 ms
  619. end 0.0 ms
  620. query end 0.0 ms
  621. closing tables 0.0 ms
  622. freeing items 0.0 ms
  623. Waiting for query cache lock 0.0 ms
  624. freeing items 0.0 ms
  625. Waiting for query cache lock 0.0 ms
  626. freeing items 0.0 ms
  627. storing result in query cache 0.1 ms
  628. logging slow query 0.0 ms
  629. cleaning up 0.0 ms
  630. Call Stack
  631. JROOT/libraries/cms/module/helper.php:376
  632. JROOT/libraries/cms/module/helper.php:84
  633. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:50
  634. JROOT/libraries/legacy/controller/legacy.php:685
  635. JROOT/libraries/legacy/controller/legacy.php:722
  636. JROOT/administrator/components/com_cpanel/cpanel.php:15
  637. JROOT/libraries/cms/component/helper.php:352
  638. JROOT/libraries/cms/component/helper.php:332
  639. JROOT/libraries/cms/application/administrator.php:98
  640. JROOT/libraries/cms/application/administrator.php:159
  641. JROOT/libraries/cms/application/cms.php:255
  642. JROOT/administrator/index.php:42
  643. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  644. Query Time: 0.36 ms After last query: 14.03 ms Query memory: 0.024 MB Memory before query: 7.547 MB Rows returned: 75
  645.  
  646. SHOW TABLES
  647.  
  648. Explain
  649. EXPLAIN not possible on query: SHOW TABLES
  650. Profile
  651. Status Duration
  652. starting 0.0 ms
  653. checking permissions 0.0 ms
  654. Opening tables 0.0 ms
  655. System lock 0.0 ms
  656. init 0.0 ms
  657. optimizing 0.0 ms
  658. statistics 0.0 ms
  659. preparing 0.0 ms
  660. executing 0.0 ms
  661. checking permissions 0.2 ms
  662. Sending data 0.0 ms
  663. end 0.0 ms
  664. query end 0.0 ms
  665. closing tables 0.0 ms
  666. removing tmp table 0.0 ms
  667. closing tables 0.0 ms
  668. freeing items 0.0 ms
  669. logging slow query 0.0 ms
  670. cleaning up 0.0 ms
  671. Call Stack
  672. JROOT/libraries/fof/table/table.php:2041
  673. JROOT/libraries/fof/table/table.php:529
  674. JROOT/libraries/fof/table/table.php:426
  675. JROOT/libraries/fof/model/model.php:1963
  676. JROOT/libraries/fof/model/model.php:1920
  677. JROOT/libraries/fof/model/model.php:1987
  678. JROOT/administrator/components/com_postinstall/models/messages.php:32
  679. JROOT/libraries/fof/model/model.php:1152
  680. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:59
  681. JROOT/libraries/legacy/controller/legacy.php:685
  682. JROOT/libraries/legacy/controller/legacy.php:722
  683. JROOT/administrator/components/com_cpanel/cpanel.php:15
  684. JROOT/libraries/cms/component/helper.php:352
  685. JROOT/libraries/cms/component/helper.php:332
  686. JROOT/libraries/cms/application/administrator.php:98
  687. JROOT/libraries/cms/application/administrator.php:159
  688. JROOT/libraries/cms/application/cms.php:255
  689. JROOT/administrator/index.php:42
  690. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  691. Query Time: 0.65 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 7.586 MB Rows returned: 14
  692. Duplicate queries: #16
  693.  
  694. SHOW FULL COLUMNS
  695. FROM `an1sp0t_postinstall_messages`
  696.  
  697. Explain
  698. EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `an1sp0t_postinstall_messages`
  699. Profile
  700. Status Duration
  701. starting 0.0 ms
  702. checking permissions 0.0 ms
  703. Opening tables 0.3 ms
  704. System lock 0.0 ms
  705. init 0.0 ms
  706. optimizing 0.0 ms
  707. statistics 0.0 ms
  708. preparing 0.0 ms
  709. executing 0.0 ms
  710. Opening tables 0.0 ms
  711. checking permissions 0.0 ms
  712. checking permissions 0.0 ms
  713. checking permissions 0.0 ms
  714. checking permissions 0.0 ms
  715. checking permissions 0.0 ms
  716. checking permissions 0.0 ms
  717. checking permissions 0.0 ms
  718. checking permissions 0.0 ms
  719. checking permissions 0.0 ms
  720. checking permissions 0.0 ms
  721. checking permissions 0.0 ms
  722. checking permissions 0.0 ms
  723. checking permissions 0.0 ms
  724. checking permissions 0.0 ms
  725. Sending data 0.0 ms
  726. end 0.0 ms
  727. query end 0.0 ms
  728. closing tables 0.0 ms
  729. removing tmp table 0.1 ms
  730. closing tables 0.0 ms
  731. freeing items 0.0 ms
  732. logging slow query 0.0 ms
  733. cleaning up 0.0 ms
  734. Call Stack
  735. JROOT/libraries/fof/table/table.php:2126
  736. JROOT/libraries/fof/table/table.php:529
  737. JROOT/libraries/fof/table/table.php:426
  738. JROOT/libraries/fof/model/model.php:1963
  739. JROOT/libraries/fof/model/model.php:1920
  740. JROOT/libraries/fof/model/model.php:1987
  741. JROOT/administrator/components/com_postinstall/models/messages.php:32
  742. JROOT/libraries/fof/model/model.php:1152
  743. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:59
  744. JROOT/libraries/legacy/controller/legacy.php:685
  745. JROOT/libraries/legacy/controller/legacy.php:722
  746. JROOT/administrator/components/com_cpanel/cpanel.php:15
  747. JROOT/libraries/cms/component/helper.php:352
  748. JROOT/libraries/cms/component/helper.php:332
  749. JROOT/libraries/cms/application/administrator.php:98
  750. JROOT/libraries/cms/application/administrator.php:159
  751. JROOT/libraries/cms/application/cms.php:255
  752. JROOT/administrator/index.php:42
  753. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  754. Query Time: 0.43 ms After last query: 3.95 ms Query memory: 0.024 MB Memory before query: 7.841 MB Rows returned: 14
  755. Duplicate queries: #15
  756.  
  757. SHOW FULL COLUMNS
  758. FROM `an1sp0t_postinstall_messages`
  759.  
  760. Explain
  761. EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `an1sp0t_postinstall_messages`
  762. Profile
  763. Status Duration
  764. starting 0.0 ms
  765. checking permissions 0.0 ms
  766. Opening tables 0.1 ms
  767. System lock 0.0 ms
  768. init 0.0 ms
  769. optimizing 0.0 ms
  770. statistics 0.0 ms
  771. preparing 0.0 ms
  772. executing 0.0 ms
  773. Opening tables 0.0 ms
  774. checking permissions 0.0 ms
  775. checking permissions 0.0 ms
  776. checking permissions 0.0 ms
  777. checking permissions 0.0 ms
  778. checking permissions 0.0 ms
  779. checking permissions 0.0 ms
  780. checking permissions 0.0 ms
  781. checking permissions 0.0 ms
  782. checking permissions 0.0 ms
  783. checking permissions 0.0 ms
  784. checking permissions 0.0 ms
  785. checking permissions 0.0 ms
  786. checking permissions 0.0 ms
  787. checking permissions 0.0 ms
  788. Sending data 0.0 ms
  789. end 0.0 ms
  790. query end 0.0 ms
  791. closing tables 0.0 ms
  792. removing tmp table 0.0 ms
  793. closing tables 0.0 ms
  794. freeing items 0.0 ms
  795. logging slow query 0.0 ms
  796. cleaning up 0.0 ms
  797. Call Stack
  798. JROOT/libraries/fof/model/model.php:2049
  799. JROOT/libraries/fof/model/behavior/filters.php:35
  800. JROOT/libraries/fof/utils/observable/event.php:63
  801. JROOT/libraries/fof/utils/observable/dispatcher.php:146
  802. JROOT/libraries/fof/model/model.php:2033
  803. JROOT/administrator/components/com_postinstall/models/messages.php:32
  804. JROOT/libraries/fof/model/model.php:1152
  805. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:59
  806. JROOT/libraries/legacy/controller/legacy.php:685
  807. JROOT/libraries/legacy/controller/legacy.php:722
  808. JROOT/administrator/components/com_cpanel/cpanel.php:15
  809. JROOT/libraries/cms/component/helper.php:352
  810. JROOT/libraries/cms/component/helper.php:332
  811. JROOT/libraries/cms/application/administrator.php:98
  812. JROOT/libraries/cms/application/administrator.php:159
  813. JROOT/libraries/cms/application/cms.php:255
  814. JROOT/administrator/index.php:42
  815. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  816. Query Time: 0.21 ms After last query: 10.78 ms Query memory: 0.016 MB Memory before query: 8.127 MB Rows returned: 2
  817.  
  818. SELECT `an1sp0t_postinstall_messages`.*
  819.  
  820. FROM `an1sp0t_postinstall_messages`
  821.  
  822. WHERE `extension_id` = '700'
  823. AND `enabled` = '1'
  824.  
  825. ORDER BY `postinstall_message_id` ASC
  826.  
  827. Explain
  828. id select_type table type possible_keys key key_len ref rows Extra
  829. 1 SIMPLE an1sp0t_postinstall_messages index NULL PRIMARY 8 NULL 4 Using where
  830. Profile
  831. Status Duration
  832. starting 0.0 ms
  833. Waiting for query cache lock 0.0 ms
  834. checking query cache for query 0.0 ms
  835. checking permissions 0.0 ms
  836. Opening tables 0.0 ms
  837. System lock 0.0 ms
  838. Waiting for query cache lock 0.0 ms
  839. init 0.0 ms
  840. optimizing 0.0 ms
  841. statistics 0.0 ms
  842. preparing 0.0 ms
  843. executing 0.0 ms
  844. Sorting result 0.0 ms
  845. Sending data 0.0 ms
  846. end 0.0 ms
  847. query end 0.0 ms
  848. closing tables 0.0 ms
  849. freeing items 0.0 ms
  850. Waiting for query cache lock 0.0 ms
  851. freeing items 0.0 ms
  852. Waiting for query cache lock 0.0 ms
  853. freeing items 0.0 ms
  854. storing result in query cache 0.0 ms
  855. logging slow query 0.0 ms
  856. cleaning up 0.0 ms
  857. Call Stack
  858. JROOT/libraries/fof/model/model.php:1879
  859. JROOT/libraries/fof/model/model.php:1158
  860. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:59
  861. JROOT/libraries/legacy/controller/legacy.php:685
  862. JROOT/libraries/legacy/controller/legacy.php:722
  863. JROOT/administrator/components/com_cpanel/cpanel.php:15
  864. JROOT/libraries/cms/component/helper.php:352
  865. JROOT/libraries/cms/component/helper.php:332
  866. JROOT/libraries/cms/application/administrator.php:98
  867. JROOT/libraries/cms/application/administrator.php:159
  868. JROOT/libraries/cms/application/cms.php:255
  869. JROOT/administrator/index.php:42
  870. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  871. Query Time: 0.15 ms After last query: 3.95 ms Query memory: 0.029 MB Memory before query: 8.454 MB Rows returned: 1
  872.  
  873. SELECT extension_id AS id, element AS "option", params, enabled
  874.  
  875. FROM an1sp0t_extensions
  876.  
  877. WHERE `type` = 'component'
  878. AND `element` = 'com_jce'
  879.  
  880. Explain
  881. id select_type table type possible_keys key key_len ref rows Extra
  882. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
  883. Profile
  884. Status Duration
  885. starting 0.0 ms
  886. Waiting for query cache lock 0.0 ms
  887. checking query cache for query 0.0 ms
  888. checking permissions 0.0 ms
  889. Opening tables 0.0 ms
  890. System lock 0.0 ms
  891. Waiting for query cache lock 0.0 ms
  892. init 0.0 ms
  893. optimizing 0.0 ms
  894. statistics 0.0 ms
  895. preparing 0.0 ms
  896. executing 0.0 ms
  897. Sending data 0.0 ms
  898. end 0.0 ms
  899. query end 0.0 ms
  900. closing tables 0.0 ms
  901. freeing items 0.0 ms
  902. Waiting for query cache lock 0.0 ms
  903. freeing items 0.0 ms
  904. Waiting for query cache lock 0.0 ms
  905. freeing items 0.0 ms
  906. storing result in query cache 0.1 ms
  907. logging slow query 0.0 ms
  908. cleaning up 0.0 ms
  909. Call Stack
  910. JROOT/libraries/joomla/cache/controller/callback.php:158
  911. JROOT/libraries/cms/component/helper.php:396
  912. JROOT/libraries/cms/component/helper.php:43
  913. JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:33
  914. JROOT/libraries/cms/plugin/helper.php:257
  915. JROOT/libraries/cms/plugin/helper.php:172
  916. JROOT/administrator/modules/mod_quickicon/helper.php:150
  917. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  918. JROOT/libraries/cms/module/helper.php:190
  919. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  920. JROOT/libraries/legacy/view/legacy.php:663
  921. JROOT/libraries/legacy/view/legacy.php:211
  922. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  923. JROOT/libraries/legacy/controller/legacy.php:685
  924. JROOT/libraries/legacy/controller/legacy.php:722
  925. JROOT/administrator/components/com_cpanel/cpanel.php:15
  926. JROOT/libraries/cms/component/helper.php:352
  927. JROOT/libraries/cms/component/helper.php:332
  928. JROOT/libraries/cms/application/administrator.php:98
  929. JROOT/libraries/cms/application/administrator.php:159
  930. JROOT/libraries/cms/application/cms.php:255
  931. JROOT/administrator/index.php:42
  932. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  933. Query Time: 0.48 ms After last query: 1.28 ms Query memory: 0.024 MB Memory before query: 8.517 MB
  934.  
  935. UPDATE `an1sp0t_extensions`
  936.  
  937. SET `enabled` = '0'
  938.  
  939. WHERE `element` = 'akeebabackup'
  940. AND `folder` = 'quickicon'
  941.  
  942. Explain
  943. EXPLAIN not possible on query: UPDATE `an1sp0t_extensions` SET `enabled` = '0' WHERE `element` = 'akeebabackup' AND `folder` = 'quickicon'
  944. Profile
  945. Status Duration
  946. starting 0.0 ms
  947. checking permissions 0.0 ms
  948. Opening tables 0.0 ms
  949. System lock 0.0 ms
  950. init 0.0 ms
  951. Updating 0.0 ms
  952. end 0.0 ms
  953. Waiting for query cache lock 0.0 ms
  954. end 0.1 ms
  955. query end 0.3 ms
  956. closing tables 0.0 ms
  957. freeing items 0.0 ms
  958. logging slow query 0.0 ms
  959. cleaning up 0.0 ms
  960. Call Stack
  961. JROOT/plugins/quickicon/akeebabackup/akeebabackup.php:42
  962. JROOT/libraries/cms/plugin/helper.php:232
  963. JROOT/libraries/cms/plugin/helper.php:172
  964. JROOT/administrator/modules/mod_quickicon/helper.php:150
  965. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  966. JROOT/libraries/cms/module/helper.php:190
  967. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  968. JROOT/libraries/legacy/view/legacy.php:663
  969. JROOT/libraries/legacy/view/legacy.php:211
  970. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  971. JROOT/libraries/legacy/controller/legacy.php:685
  972. JROOT/libraries/legacy/controller/legacy.php:722
  973. JROOT/administrator/components/com_cpanel/cpanel.php:15
  974. JROOT/libraries/cms/component/helper.php:352
  975. JROOT/libraries/cms/component/helper.php:332
  976. JROOT/libraries/cms/application/administrator.php:98
  977. JROOT/libraries/cms/application/administrator.php:159
  978. JROOT/libraries/cms/application/cms.php:255
  979. JROOT/administrator/index.php:42
  980. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  981. Query Time: 0.14 ms After last query: 0.21 ms Query memory: 0.030 MB Memory before query: 8.563 MB Rows returned: 1
  982.  
  983. SELECT extension_id AS id, element AS "option", params, enabled
  984.  
  985. FROM an1sp0t_extensions
  986.  
  987. WHERE `type` = 'component'
  988. AND `element` = 'com_akeeba'
  989.  
  990. Explain
  991. id select_type table type possible_keys key key_len ref rows Extra
  992. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
  993. Profile
  994. Status Duration
  995. starting 0.0 ms
  996. Waiting for query cache lock 0.0 ms
  997. checking query cache for query 0.0 ms
  998. checking permissions 0.0 ms
  999. Opening tables 0.0 ms
  1000. System lock 0.0 ms
  1001. Waiting for query cache lock 0.0 ms
  1002. init 0.0 ms
  1003. optimizing 0.0 ms
  1004. statistics 0.0 ms
  1005. preparing 0.0 ms
  1006. executing 0.0 ms
  1007. Sending data 0.0 ms
  1008. end 0.0 ms
  1009. query end 0.0 ms
  1010. closing tables 0.0 ms
  1011. freeing items 0.0 ms
  1012. Waiting for query cache lock 0.0 ms
  1013. freeing items 0.0 ms
  1014. Waiting for query cache lock 0.0 ms
  1015. freeing items 0.0 ms
  1016. storing result in query cache 0.0 ms
  1017. logging slow query 0.0 ms
  1018. cleaning up 0.0 ms
  1019. Call Stack
  1020. JROOT/libraries/joomla/cache/controller/callback.php:158
  1021. JROOT/libraries/cms/component/helper.php:396
  1022. JROOT/libraries/cms/component/helper.php:43
  1023. JROOT/libraries/cms/component/helper.php:73
  1024. JROOT/plugins/quickicon/akeebabackup/akeebabackup.php:77
  1025. JROOT/libraries/cms/plugin/helper.php:232
  1026. JROOT/libraries/cms/plugin/helper.php:172
  1027. JROOT/administrator/modules/mod_quickicon/helper.php:150
  1028. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  1029. JROOT/libraries/cms/module/helper.php:190
  1030. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  1031. JROOT/libraries/legacy/view/legacy.php:663
  1032. JROOT/libraries/legacy/view/legacy.php:211
  1033. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1034. JROOT/libraries/legacy/controller/legacy.php:685
  1035. JROOT/libraries/legacy/controller/legacy.php:722
  1036. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1037. JROOT/libraries/cms/component/helper.php:352
  1038. JROOT/libraries/cms/component/helper.php:332
  1039. JROOT/libraries/cms/application/administrator.php:98
  1040. JROOT/libraries/cms/application/administrator.php:159
  1041. JROOT/libraries/cms/application/cms.php:255
  1042. JROOT/administrator/index.php:42
  1043. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1044. Query Time: 0.20 ms After last query: 18.03 ms Query memory: 0.031 MB Memory before query: 10.048 MB Rows returned: 1
  1045. Duplicate queries: #22
  1046.  
  1047. SELECT *
  1048.  
  1049. FROM an1sp0t_wf_profiles
  1050.  
  1051. WHERE published = 1
  1052.  
  1053. ORDER BY ordering ASC
  1054.  
  1055. Explain
  1056. id select_type table type possible_keys key key_len ref rows Extra
  1057. 1 SIMPLE an1sp0t_wf_profiles ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Using where; Using filesort
  1058. Profile
  1059. Status Duration
  1060. starting 0.0 ms
  1061. Waiting for query cache lock 0.0 ms
  1062. checking query cache for query 0.0 ms
  1063. checking permissions 0.0 ms
  1064. Opening tables 0.0 ms
  1065. System lock 0.0 ms
  1066. Waiting for query cache lock 0.0 ms
  1067. init 0.0 ms
  1068. optimizing 0.0 ms
  1069. statistics 0.0 ms
  1070. preparing 0.0 ms
  1071. executing 0.0 ms
  1072. Sorting result 0.0 ms
  1073. Sending data 0.0 ms
  1074. end 0.0 ms
  1075. query end 0.0 ms
  1076. closing tables 0.0 ms
  1077. freeing items 0.0 ms
  1078. Waiting for query cache lock 0.0 ms
  1079. freeing items 0.0 ms
  1080. Waiting for query cache lock 0.0 ms
  1081. freeing items 0.0 ms
  1082. storing result in query cache 0.1 ms
  1083. logging slow query 0.0 ms
  1084. cleaning up 0.0 ms
  1085. Call Stack
  1086. JROOT/components/com_jce/editor/libraries/classes/editor.php:93
  1087. JROOT/administrator/components/com_jce/models/model.php:115
  1088. JROOT/administrator/components/com_jce/helpers/browser.php:20
  1089. JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
  1090. JROOT/libraries/joomla/event/event.php:71
  1091. JROOT/libraries/joomla/event/dispatcher.php:162
  1092. JROOT/libraries/joomla/application/base.php:106
  1093. JROOT/administrator/modules/mod_quickicon/helper.php:152
  1094. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  1095. JROOT/libraries/cms/module/helper.php:190
  1096. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  1097. JROOT/libraries/legacy/view/legacy.php:663
  1098. JROOT/libraries/legacy/view/legacy.php:211
  1099. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1100. JROOT/libraries/legacy/controller/legacy.php:685
  1101. JROOT/libraries/legacy/controller/legacy.php:722
  1102. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1103. JROOT/libraries/cms/component/helper.php:352
  1104. JROOT/libraries/cms/component/helper.php:332
  1105. JROOT/libraries/cms/application/administrator.php:98
  1106. JROOT/libraries/cms/application/administrator.php:159
  1107. JROOT/libraries/cms/application/cms.php:255
  1108. JROOT/administrator/index.php:42
  1109. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1110. Query Time: 0.05 ms After last query: 3.72 ms Query memory: 0.032 MB Memory before query: 10.397 MB Rows returned: 1
  1111. Duplicate queries: #21
  1112.  
  1113. SELECT *
  1114.  
  1115. FROM an1sp0t_wf_profiles
  1116.  
  1117. WHERE published = 1
  1118.  
  1119. ORDER BY ordering ASC
  1120.  
  1121. Explain
  1122. id select_type table type possible_keys key key_len ref rows Extra
  1123. 1 SIMPLE an1sp0t_wf_profiles ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Using where; Using filesort
  1124. Profile
  1125. Status Duration
  1126. starting 0.0 ms
  1127. Waiting for query cache lock 0.0 ms
  1128. checking query cache for query 0.0 ms
  1129. checking privileges on cached 0.0 ms
  1130. checking permissions 0.0 ms
  1131. sending cached result to clien 0.0 ms
  1132. logging slow query 0.0 ms
  1133. cleaning up 0.0 ms
  1134. Call Stack
  1135. JROOT/components/com_jce/editor/libraries/classes/editor.php:93
  1136. JROOT/administrator/components/com_jce/models/editor.php:89
  1137. JROOT/components/com_jce/editor/libraries/classes/editor.php:169
  1138. JROOT/administrator/components/com_jce/models/model.php:115
  1139. JROOT/administrator/components/com_jce/helpers/browser.php:20
  1140. JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
  1141. JROOT/libraries/joomla/event/event.php:71
  1142. JROOT/libraries/joomla/event/dispatcher.php:162
  1143. JROOT/libraries/joomla/application/base.php:106
  1144. JROOT/administrator/modules/mod_quickicon/helper.php:152
  1145. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  1146. JROOT/libraries/cms/module/helper.php:190
  1147. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  1148. JROOT/libraries/legacy/view/legacy.php:663
  1149. JROOT/libraries/legacy/view/legacy.php:211
  1150. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1151. JROOT/libraries/legacy/controller/legacy.php:685
  1152. JROOT/libraries/legacy/controller/legacy.php:722
  1153. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1154. JROOT/libraries/cms/component/helper.php:352
  1155. JROOT/libraries/cms/component/helper.php:332
  1156. JROOT/libraries/cms/application/administrator.php:98
  1157. JROOT/libraries/cms/application/administrator.php:159
  1158. JROOT/libraries/cms/application/cms.php:255
  1159. JROOT/administrator/index.php:42
  1160. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1161. Query Time: 0.54 ms After last query: 1.45 ms Query memory: 0.041 MB Memory before query: 10.482 MB Rows returned: 17
  1162.  
  1163. SHOW FULL COLUMNS
  1164. FROM `an1sp0t_extensions`
  1165.  
  1166. Explain
  1167. EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `an1sp0t_extensions`
  1168. Profile
  1169. Status Duration
  1170. starting 0.0 ms
  1171. checking permissions 0.0 ms
  1172. Opening tables 0.2 ms
  1173. System lock 0.0 ms
  1174. init 0.0 ms
  1175. optimizing 0.0 ms
  1176. statistics 0.0 ms
  1177. preparing 0.0 ms
  1178. executing 0.0 ms
  1179. Opening tables 0.0 ms
  1180. checking permissions 0.0 ms
  1181. checking permissions 0.0 ms
  1182. checking permissions 0.0 ms
  1183. checking permissions 0.0 ms
  1184. checking permissions 0.0 ms
  1185. checking permissions 0.0 ms
  1186. checking permissions 0.0 ms
  1187. checking permissions 0.0 ms
  1188. checking permissions 0.0 ms
  1189. checking permissions 0.0 ms
  1190. checking permissions 0.0 ms
  1191. checking permissions 0.0 ms
  1192. checking permissions 0.0 ms
  1193. checking permissions 0.0 ms
  1194. checking permissions 0.0 ms
  1195. checking permissions 0.0 ms
  1196. checking permissions 0.0 ms
  1197. Sending data 0.0 ms
  1198. end 0.0 ms
  1199. query end 0.0 ms
  1200. closing tables 0.0 ms
  1201. removing tmp table 0.1 ms
  1202. closing tables 0.0 ms
  1203. freeing items 0.0 ms
  1204. logging slow query 0.0 ms
  1205. cleaning up 0.0 ms
  1206. Call Stack
  1207. JROOT/libraries/joomla/table/table.php:229
  1208. JROOT/libraries/joomla/table/table.php:150
  1209. JROOT/libraries/joomla/table/extension.php:31
  1210. JROOT/libraries/joomla/table/table.php:294
  1211. JROOT/administrator/components/com_jce/helpers/extension.php:76
  1212. JROOT/components/com_jce/editor/libraries/classes/editor.php:246
  1213. JROOT/components/com_jce/editor/libraries/classes/editor.php:308
  1214. JROOT/administrator/components/com_jce/models/editor.php:559
  1215. JROOT/components/com_jce/editor/libraries/classes/editor.php:170
  1216. JROOT/administrator/components/com_jce/models/model.php:115
  1217. JROOT/administrator/components/com_jce/helpers/browser.php:20
  1218. JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
  1219. JROOT/libraries/joomla/event/event.php:71
  1220. JROOT/libraries/joomla/event/dispatcher.php:162
  1221. JROOT/libraries/joomla/application/base.php:106
  1222. JROOT/administrator/modules/mod_quickicon/helper.php:152
  1223. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  1224. JROOT/libraries/cms/module/helper.php:190
  1225. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  1226. JROOT/libraries/legacy/view/legacy.php:663
  1227. JROOT/libraries/legacy/view/legacy.php:211
  1228. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1229. JROOT/libraries/legacy/controller/legacy.php:685
  1230. JROOT/libraries/legacy/controller/legacy.php:722
  1231. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1232. JROOT/libraries/cms/component/helper.php:352
  1233. JROOT/libraries/cms/component/helper.php:332
  1234. JROOT/libraries/cms/application/administrator.php:98
  1235. JROOT/libraries/cms/application/administrator.php:159
  1236. JROOT/libraries/cms/application/cms.php:255
  1237. JROOT/administrator/index.php:42
  1238. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1239. Query Time: 0.14 ms After last query: 0.54 ms Query memory: 0.036 MB Memory before query: 10.576 MB Rows returned: 1
  1240.  
  1241. SELECT `extension_id`
  1242.  
  1243. FROM `an1sp0t_extensions`
  1244.  
  1245. WHERE type = 'plugin'
  1246. AND folder = 'editors'
  1247. AND element = 'jce'
  1248.  
  1249. Explain
  1250. id select_type table type possible_keys key key_len ref rows Extra
  1251. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
  1252. Profile
  1253. Status Duration
  1254. starting 0.0 ms
  1255. Waiting for query cache lock 0.0 ms
  1256. checking query cache for query 0.0 ms
  1257. checking permissions 0.0 ms
  1258. Opening tables 0.0 ms
  1259. System lock 0.0 ms
  1260. Waiting for query cache lock 0.0 ms
  1261. init 0.0 ms
  1262. optimizing 0.0 ms
  1263. statistics 0.0 ms
  1264. preparing 0.0 ms
  1265. executing 0.0 ms
  1266. Sending data 0.0 ms
  1267. end 0.0 ms
  1268. query end 0.0 ms
  1269. closing tables 0.0 ms
  1270. freeing items 0.0 ms
  1271. Waiting for query cache lock 0.0 ms
  1272. freeing items 0.0 ms
  1273. Waiting for query cache lock 0.0 ms
  1274. freeing items 0.0 ms
  1275. storing result in query cache 0.4 ms
  1276. logging slow query 0.0 ms
  1277. cleaning up 0.0 ms
  1278. Call Stack
  1279. JROOT/libraries/joomla/table/extension.php:108
  1280. JROOT/administrator/components/com_jce/helpers/extension.php:79
  1281. JROOT/components/com_jce/editor/libraries/classes/editor.php:246
  1282. JROOT/components/com_jce/editor/libraries/classes/editor.php:308
  1283. JROOT/administrator/components/com_jce/models/editor.php:559
  1284. JROOT/components/com_jce/editor/libraries/classes/editor.php:170
  1285. JROOT/administrator/components/com_jce/models/model.php:115
  1286. JROOT/administrator/components/com_jce/helpers/browser.php:20
  1287. JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
  1288. JROOT/libraries/joomla/event/event.php:71
  1289. JROOT/libraries/joomla/event/dispatcher.php:162
  1290. JROOT/libraries/joomla/application/base.php:106
  1291. JROOT/administrator/modules/mod_quickicon/helper.php:152
  1292. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  1293. JROOT/libraries/cms/module/helper.php:190
  1294. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  1295. JROOT/libraries/legacy/view/legacy.php:663
  1296. JROOT/libraries/legacy/view/legacy.php:211
  1297. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1298. JROOT/libraries/legacy/controller/legacy.php:685
  1299. JROOT/libraries/legacy/controller/legacy.php:722
  1300. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1301. JROOT/libraries/cms/component/helper.php:352
  1302. JROOT/libraries/cms/component/helper.php:332
  1303. JROOT/libraries/cms/application/administrator.php:98
  1304. JROOT/libraries/cms/application/administrator.php:159
  1305. JROOT/libraries/cms/application/cms.php:255
  1306. JROOT/administrator/index.php:42
  1307. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1308. Query Time: 0.35 ms After last query: 0.15 ms Query memory: 0.036 MB Memory before query: 10.616 MB Rows returned: 1
  1309.  
  1310. SELECT *
  1311.  
  1312. FROM an1sp0t_extensions
  1313.  
  1314. WHERE `extension_id` = '10001'
  1315.  
  1316. Explain
  1317. id select_type table type possible_keys key key_len ref rows Extra
  1318. 1 SIMPLE an1sp0t_extensions const PRIMARY PRIMARY 4 const 1
  1319. Profile
  1320. Status Duration
  1321. starting 0.0 ms
  1322. Waiting for query cache lock 0.0 ms
  1323. checking query cache for query 0.0 ms
  1324. checking permissions 0.0 ms
  1325. Opening tables 0.0 ms
  1326. System lock 0.0 ms
  1327. Waiting for query cache lock 0.0 ms
  1328. init 0.0 ms
  1329. optimizing 0.0 ms
  1330. statistics 0.0 ms
  1331. preparing 0.0 ms
  1332. executing 0.0 ms
  1333. Sending data 0.0 ms
  1334. end 0.0 ms
  1335. query end 0.0 ms
  1336. closing tables 0.0 ms
  1337. freeing items 0.0 ms
  1338. Waiting for query cache lock 0.0 ms
  1339. freeing items 0.0 ms
  1340. Waiting for query cache lock 0.0 ms
  1341. freeing items 0.0 ms
  1342. storing result in query cache 0.0 ms
  1343. logging slow query 0.0 ms
  1344. cleaning up 0.0 ms
  1345. Call Stack
  1346. JROOT/libraries/joomla/table/table.php:705
  1347. JROOT/administrator/components/com_jce/helpers/extension.php:82
  1348. JROOT/components/com_jce/editor/libraries/classes/editor.php:246
  1349. JROOT/components/com_jce/editor/libraries/classes/editor.php:308
  1350. JROOT/administrator/components/com_jce/models/editor.php:559
  1351. JROOT/components/com_jce/editor/libraries/classes/editor.php:170
  1352. JROOT/administrator/components/com_jce/models/model.php:115
  1353. JROOT/administrator/components/com_jce/helpers/browser.php:20
  1354. JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
  1355. JROOT/libraries/joomla/event/event.php:71
  1356. JROOT/libraries/joomla/event/dispatcher.php:162
  1357. JROOT/libraries/joomla/application/base.php:106
  1358. JROOT/administrator/modules/mod_quickicon/helper.php:152
  1359. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  1360. JROOT/libraries/cms/module/helper.php:190
  1361. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  1362. JROOT/libraries/legacy/view/legacy.php:663
  1363. JROOT/libraries/legacy/view/legacy.php:211
  1364. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1365. JROOT/libraries/legacy/controller/legacy.php:685
  1366. JROOT/libraries/legacy/controller/legacy.php:722
  1367. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1368. JROOT/libraries/cms/component/helper.php:352
  1369. JROOT/libraries/cms/component/helper.php:332
  1370. JROOT/libraries/cms/application/administrator.php:98
  1371. JROOT/libraries/cms/application/administrator.php:159
  1372. JROOT/libraries/cms/application/cms.php:255
  1373. JROOT/administrator/index.php:42
  1374. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1375. Query Time: 0.12 ms After last query: 0.19 ms Query memory: 0.036 MB Memory before query: 10.656 MB Rows returned: 1
  1376.  
  1377. SELECT `extension_id`
  1378.  
  1379. FROM `an1sp0t_extensions`
  1380.  
  1381. WHERE type = 'component'
  1382. AND element = 'com_jce'
  1383.  
  1384. Explain
  1385. id select_type table type possible_keys key key_len ref rows Extra
  1386. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
  1387. Profile
  1388. Status Duration
  1389. starting 0.0 ms
  1390. Waiting for query cache lock 0.0 ms
  1391. checking query cache for query 0.0 ms
  1392. checking permissions 0.0 ms
  1393. Opening tables 0.0 ms
  1394. System lock 0.0 ms
  1395. Waiting for query cache lock 0.0 ms
  1396. init 0.0 ms
  1397. optimizing 0.0 ms
  1398. statistics 0.0 ms
  1399. preparing 0.0 ms
  1400. executing 0.0 ms
  1401. Sending data 0.0 ms
  1402. end 0.0 ms
  1403. query end 0.0 ms
  1404. closing tables 0.0 ms
  1405. freeing items 0.0 ms
  1406. Waiting for query cache lock 0.0 ms
  1407. freeing items 0.0 ms
  1408. Waiting for query cache lock 0.0 ms
  1409. freeing items 0.0 ms
  1410. storing result in query cache 0.0 ms
  1411. logging slow query 0.0 ms
  1412. cleaning up 0.0 ms
  1413. Call Stack
  1414. JROOT/libraries/joomla/table/extension.php:108
  1415. JROOT/administrator/components/com_jce/helpers/extension.php:37
  1416. JROOT/components/com_jce/editor/libraries/classes/editor.php:259
  1417. JROOT/components/com_jce/editor/libraries/classes/editor.php:308
  1418. JROOT/administrator/components/com_jce/models/editor.php:559
  1419. JROOT/components/com_jce/editor/libraries/classes/editor.php:170
  1420. JROOT/administrator/components/com_jce/models/model.php:115
  1421. JROOT/administrator/components/com_jce/helpers/browser.php:20
  1422. JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
  1423. JROOT/libraries/joomla/event/event.php:71
  1424. JROOT/libraries/joomla/event/dispatcher.php:162
  1425. JROOT/libraries/joomla/application/base.php:106
  1426. JROOT/administrator/modules/mod_quickicon/helper.php:152
  1427. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  1428. JROOT/libraries/cms/module/helper.php:190
  1429. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  1430. JROOT/libraries/legacy/view/legacy.php:663
  1431. JROOT/libraries/legacy/view/legacy.php:211
  1432. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1433. JROOT/libraries/legacy/controller/legacy.php:685
  1434. JROOT/libraries/legacy/controller/legacy.php:722
  1435. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1436. JROOT/libraries/cms/component/helper.php:352
  1437. JROOT/libraries/cms/component/helper.php:332
  1438. JROOT/libraries/cms/application/administrator.php:98
  1439. JROOT/libraries/cms/application/administrator.php:159
  1440. JROOT/libraries/cms/application/cms.php:255
  1441. JROOT/administrator/index.php:42
  1442. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1443. Query Time: 0.11 ms After last query: 0.15 ms Query memory: 0.036 MB Memory before query: 10.695 MB Rows returned: 1
  1444.  
  1445. SELECT *
  1446.  
  1447. FROM an1sp0t_extensions
  1448.  
  1449. WHERE `extension_id` = '10003'
  1450.  
  1451. Explain
  1452. id select_type table type possible_keys key key_len ref rows Extra
  1453. 1 SIMPLE an1sp0t_extensions const PRIMARY PRIMARY 4 const 1
  1454. Profile
  1455. Status Duration
  1456. starting 0.0 ms
  1457. Waiting for query cache lock 0.0 ms
  1458. checking query cache for query 0.0 ms
  1459. checking permissions 0.0 ms
  1460. Opening tables 0.0 ms
  1461. System lock 0.0 ms
  1462. Waiting for query cache lock 0.0 ms
  1463. init 0.0 ms
  1464. optimizing 0.0 ms
  1465. statistics 0.0 ms
  1466. preparing 0.0 ms
  1467. executing 0.0 ms
  1468. Sending data 0.0 ms
  1469. end 0.0 ms
  1470. query end 0.0 ms
  1471. closing tables 0.0 ms
  1472. freeing items 0.0 ms
  1473. Waiting for query cache lock 0.0 ms
  1474. freeing items 0.0 ms
  1475. Waiting for query cache lock 0.0 ms
  1476. freeing items 0.0 ms
  1477. storing result in query cache 0.1 ms
  1478. logging slow query 0.0 ms
  1479. cleaning up 0.0 ms
  1480. Call Stack
  1481. JROOT/libraries/joomla/table/table.php:705
  1482. JROOT/administrator/components/com_jce/helpers/extension.php:40
  1483. JROOT/components/com_jce/editor/libraries/classes/editor.php:259
  1484. JROOT/components/com_jce/editor/libraries/classes/editor.php:308
  1485. JROOT/administrator/components/com_jce/models/editor.php:559
  1486. JROOT/components/com_jce/editor/libraries/classes/editor.php:170
  1487. JROOT/administrator/components/com_jce/models/model.php:115
  1488. JROOT/administrator/components/com_jce/helpers/browser.php:20
  1489. JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
  1490. JROOT/libraries/joomla/event/event.php:71
  1491. JROOT/libraries/joomla/event/dispatcher.php:162
  1492. JROOT/libraries/joomla/application/base.php:106
  1493. JROOT/administrator/modules/mod_quickicon/helper.php:152
  1494. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  1495. JROOT/libraries/cms/module/helper.php:190
  1496. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  1497. JROOT/libraries/legacy/view/legacy.php:663
  1498. JROOT/libraries/legacy/view/legacy.php:211
  1499. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1500. JROOT/libraries/legacy/controller/legacy.php:685
  1501. JROOT/libraries/legacy/controller/legacy.php:722
  1502. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1503. JROOT/libraries/cms/component/helper.php:352
  1504. JROOT/libraries/cms/component/helper.php:332
  1505. JROOT/libraries/cms/application/administrator.php:98
  1506. JROOT/libraries/cms/application/administrator.php:159
  1507. JROOT/libraries/cms/application/cms.php:255
  1508. JROOT/administrator/index.php:42
  1509. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1510. Query Time: 0.44 ms After last query: 2.12 ms Query memory: 0.025 MB Memory before query: 10.708 MB
  1511.  
  1512. UPDATE `an1sp0t_extensions`
  1513.  
  1514. SET `enabled` = '1'
  1515.  
  1516. WHERE `element` = 'akeebabackup'
  1517. AND `folder` = 'quickicon'
  1518.  
  1519. Explain
  1520. EXPLAIN not possible on query: UPDATE `an1sp0t_extensions` SET `enabled` = '1' WHERE `element` = 'akeebabackup' AND `folder` = 'quickicon'
  1521. Profile
  1522. Status Duration
  1523. starting 0.0 ms
  1524. checking permissions 0.0 ms
  1525. Opening tables 0.0 ms
  1526. System lock 0.0 ms
  1527. init 0.0 ms
  1528. Updating 0.0 ms
  1529. end 0.0 ms
  1530. Waiting for query cache lock 0.0 ms
  1531. end 0.1 ms
  1532. query end 0.2 ms
  1533. closing tables 0.0 ms
  1534. freeing items 0.0 ms
  1535. logging slow query 0.0 ms
  1536. cleaning up 0.0 ms
  1537. Call Stack
  1538. JROOT/plugins/quickicon/akeebabackup/akeebabackup.php:253
  1539. JROOT/libraries/joomla/event/event.php:71
  1540. JROOT/libraries/joomla/event/dispatcher.php:162
  1541. JROOT/libraries/joomla/application/base.php:106
  1542. JROOT/administrator/modules/mod_quickicon/helper.php:152
  1543. JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
  1544. JROOT/libraries/cms/module/helper.php:190
  1545. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
  1546. JROOT/libraries/legacy/view/legacy.php:663
  1547. JROOT/libraries/legacy/view/legacy.php:211
  1548. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1549. JROOT/libraries/legacy/controller/legacy.php:685
  1550. JROOT/libraries/legacy/controller/legacy.php:722
  1551. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1552. JROOT/libraries/cms/component/helper.php:352
  1553. JROOT/libraries/cms/component/helper.php:332
  1554. JROOT/libraries/cms/application/administrator.php:98
  1555. JROOT/libraries/cms/application/administrator.php:159
  1556. JROOT/libraries/cms/application/cms.php:255
  1557. JROOT/administrator/index.php:42
  1558. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1559. Query Time: 0.18 ms After last query: 12.25 ms Query memory: 0.022 MB Memory before query: 10.831 MB Rows returned: 1
  1560.  
  1561. SELECT s.time, s.client_id, u.id, u.name, u.username
  1562.  
  1563. FROM an1sp0t_session AS s
  1564.  
  1565. LEFT JOIN an1sp0t_users AS u
  1566. ON s.userid = u.id
  1567.  
  1568. WHERE s.guest = 0
  1569. LIMIT 0, 5
  1570.  
  1571. Explain
  1572. id select_type table type possible_keys key key_len ref rows Extra
  1573. 1 SIMPLE s ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where
  1574. 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 anispotc_bd.s.userid 1
  1575. Profile
  1576. Status Duration
  1577. starting 0.0 ms
  1578. Waiting for query cache lock 0.0 ms
  1579. checking query cache for query 0.0 ms
  1580. checking permissions 0.0 ms
  1581. checking permissions 0.0 ms
  1582. Opening tables 0.0 ms
  1583. System lock 0.0 ms
  1584. Waiting for query cache lock 0.0 ms
  1585. init 0.0 ms
  1586. optimizing 0.0 ms
  1587. statistics 0.0 ms
  1588. preparing 0.0 ms
  1589. executing 0.0 ms
  1590. Sending data 0.0 ms
  1591. end 0.0 ms
  1592. query end 0.0 ms
  1593. closing tables 0.0 ms
  1594. freeing items 0.0 ms
  1595. Waiting for query cache lock 0.0 ms
  1596. freeing items 0.0 ms
  1597. Waiting for query cache lock 0.0 ms
  1598. freeing items 0.0 ms
  1599. storing result in query cache 0.1 ms
  1600. logging slow query 0.0 ms
  1601. cleaning up 0.0 ms
  1602. Call Stack
  1603. JROOT/administrator/modules/mod_logged/helper.php:43
  1604. JROOT/administrator/modules/mod_logged/mod_logged.php:15
  1605. JROOT/libraries/cms/module/helper.php:190
  1606. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
  1607. JROOT/libraries/legacy/view/legacy.php:663
  1608. JROOT/libraries/legacy/view/legacy.php:211
  1609. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1610. JROOT/libraries/legacy/controller/legacy.php:685
  1611. JROOT/libraries/legacy/controller/legacy.php:722
  1612. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1613. JROOT/libraries/cms/component/helper.php:352
  1614. JROOT/libraries/cms/component/helper.php:332
  1615. JROOT/libraries/cms/application/administrator.php:98
  1616. JROOT/libraries/cms/application/administrator.php:159
  1617. JROOT/libraries/cms/application/cms.php:255
  1618. JROOT/administrator/index.php:42
  1619. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1620. Query Time: 0.17 ms After last query: 4.74 ms Query memory: 0.026 MB Memory before query: 11.197 MB Rows returned: 1
  1621.  
  1622. SELECT enabled
  1623.  
  1624. FROM `an1sp0t_extensions`
  1625.  
  1626. WHERE `type` = 'plugin'
  1627. AND `folder` = 'system'
  1628. AND `element` = 'languagefilter'
  1629.  
  1630. Explain
  1631. id select_type table type possible_keys key key_len ref rows Extra
  1632. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
  1633. Profile
  1634. Status Duration
  1635. starting 0.0 ms
  1636. Waiting for query cache lock 0.0 ms
  1637. checking query cache for query 0.0 ms
  1638. checking permissions 0.0 ms
  1639. Opening tables 0.0 ms
  1640. System lock 0.0 ms
  1641. Waiting for query cache lock 0.0 ms
  1642. init 0.0 ms
  1643. optimizing 0.0 ms
  1644. statistics 0.0 ms
  1645. preparing 0.0 ms
  1646. executing 0.0 ms
  1647. Sending data 0.0 ms
  1648. end 0.0 ms
  1649. query end 0.0 ms
  1650. closing tables 0.0 ms
  1651. freeing items 0.0 ms
  1652. Waiting for query cache lock 0.0 ms
  1653. freeing items 0.0 ms
  1654. Waiting for query cache lock 0.0 ms
  1655. freeing items 0.0 ms
  1656. storing result in query cache 0.2 ms
  1657. logging slow query 0.0 ms
  1658. cleaning up 0.0 ms
  1659. Call Stack
  1660. JROOT/libraries/cms/language/multilang.php:61
  1661. JROOT/libraries/cms/language/associations.php:121
  1662. JROOT/administrator/components/com_content/models/articles.php:59
  1663. JROOT/libraries/legacy/model/legacy.php:198
  1664. JROOT/administrator/modules/mod_popular/helper.php:35
  1665. JROOT/administrator/modules/mod_popular/mod_popular.php:16
  1666. JROOT/libraries/cms/module/helper.php:190
  1667. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
  1668. JROOT/libraries/legacy/view/legacy.php:663
  1669. JROOT/libraries/legacy/view/legacy.php:211
  1670. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1671. JROOT/libraries/legacy/controller/legacy.php:685
  1672. JROOT/libraries/legacy/controller/legacy.php:722
  1673. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1674. JROOT/libraries/cms/component/helper.php:352
  1675. JROOT/libraries/cms/component/helper.php:332
  1676. JROOT/libraries/cms/application/administrator.php:98
  1677. JROOT/libraries/cms/application/administrator.php:159
  1678. JROOT/libraries/cms/application/cms.php:255
  1679. JROOT/administrator/index.php:42
  1680. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1681. Query Time: 0.38 ms After last query: 0.37 ms Query memory: 0.027 MB Memory before query: 11.246 MB Rows returned: 1
  1682. Duplicate queries: #33
  1683.  
  1684. SELECT COUNT(*)
  1685.  
  1686. FROM an1sp0t_content AS a
  1687.  
  1688. LEFT JOIN `an1sp0t_languages` AS l
  1689. ON l.lang_code = a.language
  1690.  
  1691. LEFT JOIN an1sp0t_users AS uc
  1692. ON uc.id=a.checked_out
  1693.  
  1694. LEFT JOIN an1sp0t_viewlevels AS ag
  1695. ON ag.id = a.access
  1696.  
  1697. LEFT JOIN an1sp0t_categories AS c
  1698. ON c.id = a.catid
  1699.  
  1700. LEFT JOIN an1sp0t_users AS ua
  1701. ON ua.id = a.created_by
  1702.  
  1703. Explain
  1704. id select_type table type possible_keys key key_len ref rows Extra
  1705. 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5
  1706. 1 SIMPLE l eq_ref idx_langcode idx_langcode 21 anispotc_bd.a.language 1 Using index
  1707. 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.checked_out 1 Using index
  1708. 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.access 1 Using index
  1709. 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.catid 1 Using index
  1710. 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.created_by 1 Using index
  1711. Profile
  1712. Status Duration
  1713. starting 0.0 ms
  1714. Waiting for query cache lock 0.0 ms
  1715. checking query cache for query 0.0 ms
  1716. checking permissions 0.0 ms
  1717. checking permissions 0.0 ms
  1718. checking permissions 0.0 ms
  1719. checking permissions 0.0 ms
  1720. checking permissions 0.0 ms
  1721. checking permissions 0.0 ms
  1722. Opening tables 0.2 ms
  1723. System lock 0.0 ms
  1724. Waiting for query cache lock 0.0 ms
  1725. init 0.0 ms
  1726. optimizing 0.0 ms
  1727. statistics 0.0 ms
  1728. preparing 0.0 ms
  1729. executing 0.0 ms
  1730. Sending data 0.1 ms
  1731. end 0.0 ms
  1732. query end 0.0 ms
  1733. closing tables 0.0 ms
  1734. freeing items 0.0 ms
  1735. Waiting for query cache lock 0.0 ms
  1736. freeing items 0.0 ms
  1737. Waiting for query cache lock 0.0 ms
  1738. freeing items 0.0 ms
  1739. storing result in query cache 0.0 ms
  1740. logging slow query 0.0 ms
  1741. cleaning up 0.0 ms
  1742. Call Stack
  1743. JROOT/libraries/legacy/model/legacy.php:327
  1744. JROOT/libraries/legacy/model/list.php:276
  1745. JROOT/libraries/legacy/model/list.php:310
  1746. JROOT/libraries/legacy/model/list.php:171
  1747. JROOT/administrator/components/com_content/models/articles.php:371
  1748. JROOT/administrator/modules/mod_popular/helper.php:72
  1749. JROOT/administrator/modules/mod_popular/mod_popular.php:16
  1750. JROOT/libraries/cms/module/helper.php:190
  1751. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
  1752. JROOT/libraries/legacy/view/legacy.php:663
  1753. JROOT/libraries/legacy/view/legacy.php:211
  1754. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1755. JROOT/libraries/legacy/controller/legacy.php:685
  1756. JROOT/libraries/legacy/controller/legacy.php:722
  1757. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1758. JROOT/libraries/cms/component/helper.php:352
  1759. JROOT/libraries/cms/component/helper.php:332
  1760. JROOT/libraries/cms/application/administrator.php:98
  1761. JROOT/libraries/cms/application/administrator.php:159
  1762. JROOT/libraries/cms/application/cms.php:255
  1763. JROOT/administrator/index.php:42
  1764. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1765. Query Time: 0.24 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 11.264 MB Rows returned: 5
  1766.  
  1767. SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
  1768.  
  1769. FROM an1sp0t_content AS a
  1770.  
  1771. LEFT JOIN `an1sp0t_languages` AS l
  1772. ON l.lang_code = a.language
  1773.  
  1774. LEFT JOIN an1sp0t_users AS uc
  1775. ON uc.id=a.checked_out
  1776.  
  1777. LEFT JOIN an1sp0t_viewlevels AS ag
  1778. ON ag.id = a.access
  1779.  
  1780. LEFT JOIN an1sp0t_categories AS c
  1781. ON c.id = a.catid
  1782.  
  1783. LEFT JOIN an1sp0t_users AS ua
  1784. ON ua.id = a.created_by
  1785.  
  1786. ORDER BY a.hits DESC
  1787. LIMIT 0, 5
  1788.  
  1789. Explain
  1790. id select_type table type possible_keys key key_len ref rows Extra
  1791. 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Using filesort
  1792. 1 SIMPLE l eq_ref idx_langcode idx_langcode 21 anispotc_bd.a.language 1
  1793. 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.checked_out 1
  1794. 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.access 1
  1795. 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.catid 1
  1796. 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.created_by 1
  1797. Profile
  1798. Status Duration
  1799. starting 0.0 ms
  1800. Waiting for query cache lock 0.0 ms
  1801. checking query cache for query 0.0 ms
  1802. checking permissions 0.0 ms
  1803. checking permissions 0.0 ms
  1804. checking permissions 0.0 ms
  1805. checking permissions 0.0 ms
  1806. checking permissions 0.0 ms
  1807. checking permissions 0.0 ms
  1808. Opening tables 0.0 ms
  1809. System lock 0.0 ms
  1810. Waiting for query cache lock 0.0 ms
  1811. init 0.0 ms
  1812. optimizing 0.0 ms
  1813. statistics 0.0 ms
  1814. preparing 0.0 ms
  1815. executing 0.0 ms
  1816. Sorting result 0.0 ms
  1817. Sending data 0.0 ms
  1818. end 0.0 ms
  1819. query end 0.0 ms
  1820. closing tables 0.0 ms
  1821. freeing items 0.0 ms
  1822. Waiting for query cache lock 0.0 ms
  1823. freeing items 0.0 ms
  1824. Waiting for query cache lock 0.0 ms
  1825. freeing items 0.0 ms
  1826. storing result in query cache 0.1 ms
  1827. logging slow query 0.0 ms
  1828. cleaning up 0.0 ms
  1829. Call Stack
  1830. JROOT/libraries/legacy/model/legacy.php:301
  1831. JROOT/libraries/legacy/model/list.php:171
  1832. JROOT/administrator/components/com_content/models/articles.php:371
  1833. JROOT/administrator/modules/mod_popular/helper.php:72
  1834. JROOT/administrator/modules/mod_popular/mod_popular.php:16
  1835. JROOT/libraries/cms/module/helper.php:190
  1836. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
  1837. JROOT/libraries/legacy/view/legacy.php:663
  1838. JROOT/libraries/legacy/view/legacy.php:211
  1839. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1840. JROOT/libraries/legacy/controller/legacy.php:685
  1841. JROOT/libraries/legacy/controller/legacy.php:722
  1842. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1843. JROOT/libraries/cms/component/helper.php:352
  1844. JROOT/libraries/cms/component/helper.php:332
  1845. JROOT/libraries/cms/application/administrator.php:98
  1846. JROOT/libraries/cms/application/administrator.php:159
  1847. JROOT/libraries/cms/application/cms.php:255
  1848. JROOT/administrator/index.php:42
  1849. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1850. Query Time: 0.06 ms After last query: 3.01 ms Query memory: 0.027 MB Memory before query: 11.348 MB Rows returned: 1
  1851. Duplicate queries: #31
  1852.  
  1853. SELECT COUNT(*)
  1854.  
  1855. FROM an1sp0t_content AS a
  1856.  
  1857. LEFT JOIN `an1sp0t_languages` AS l
  1858. ON l.lang_code = a.language
  1859.  
  1860. LEFT JOIN an1sp0t_users AS uc
  1861. ON uc.id=a.checked_out
  1862.  
  1863. LEFT JOIN an1sp0t_viewlevels AS ag
  1864. ON ag.id = a.access
  1865.  
  1866. LEFT JOIN an1sp0t_categories AS c
  1867. ON c.id = a.catid
  1868.  
  1869. LEFT JOIN an1sp0t_users AS ua
  1870. ON ua.id = a.created_by
  1871.  
  1872. Explain
  1873. id select_type table type possible_keys key key_len ref rows Extra
  1874. 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5
  1875. 1 SIMPLE l eq_ref idx_langcode idx_langcode 21 anispotc_bd.a.language 1 Using index
  1876. 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.checked_out 1 Using index
  1877. 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.access 1 Using index
  1878. 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.catid 1 Using index
  1879. 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.created_by 1 Using index
  1880. Profile
  1881. Status Duration
  1882. starting 0.0 ms
  1883. Waiting for query cache lock 0.0 ms
  1884. checking query cache for query 0.0 ms
  1885. checking privileges on cached 0.0 ms
  1886. checking permissions 0.0 ms
  1887. checking permissions 0.0 ms
  1888. checking permissions 0.0 ms
  1889. checking permissions 0.0 ms
  1890. checking permissions 0.0 ms
  1891. checking permissions 0.0 ms
  1892. sending cached result to clien 0.0 ms
  1893. logging slow query 0.0 ms
  1894. cleaning up 0.0 ms
  1895. Call Stack
  1896. JROOT/libraries/legacy/model/legacy.php:327
  1897. JROOT/libraries/legacy/model/list.php:276
  1898. JROOT/libraries/legacy/model/list.php:310
  1899. JROOT/libraries/legacy/model/list.php:171
  1900. JROOT/administrator/components/com_content/models/articles.php:371
  1901. JROOT/administrator/modules/mod_latest/helper.php:83
  1902. JROOT/administrator/modules/mod_latest/mod_latest.php:15
  1903. JROOT/libraries/cms/module/helper.php:190
  1904. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
  1905. JROOT/libraries/legacy/view/legacy.php:663
  1906. JROOT/libraries/legacy/view/legacy.php:211
  1907. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1908. JROOT/libraries/legacy/controller/legacy.php:685
  1909. JROOT/libraries/legacy/controller/legacy.php:722
  1910. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1911. JROOT/libraries/cms/component/helper.php:352
  1912. JROOT/libraries/cms/component/helper.php:332
  1913. JROOT/libraries/cms/application/administrator.php:98
  1914. JROOT/libraries/cms/application/administrator.php:159
  1915. JROOT/libraries/cms/application/cms.php:255
  1916. JROOT/administrator/index.php:42
  1917. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  1918. Query Time: 0.27 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 11.367 MB Rows returned: 5
  1919.  
  1920. SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
  1921.  
  1922. FROM an1sp0t_content AS a
  1923.  
  1924. LEFT JOIN `an1sp0t_languages` AS l
  1925. ON l.lang_code = a.language
  1926.  
  1927. LEFT JOIN an1sp0t_users AS uc
  1928. ON uc.id=a.checked_out
  1929.  
  1930. LEFT JOIN an1sp0t_viewlevels AS ag
  1931. ON ag.id = a.access
  1932.  
  1933. LEFT JOIN an1sp0t_categories AS c
  1934. ON c.id = a.catid
  1935.  
  1936. LEFT JOIN an1sp0t_users AS ua
  1937. ON ua.id = a.created_by
  1938.  
  1939. ORDER BY created DESC
  1940. LIMIT 0, 5
  1941.  
  1942. Explain
  1943. id select_type table type possible_keys key key_len ref rows Extra
  1944. 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Using filesort
  1945. 1 SIMPLE l eq_ref idx_langcode idx_langcode 21 anispotc_bd.a.language 1
  1946. 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.checked_out 1
  1947. 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.access 1
  1948. 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.catid 1
  1949. 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 anispotc_bd.a.created_by 1
  1950. Profile
  1951. Status Duration
  1952. starting 0.0 ms
  1953. Waiting for query cache lock 0.0 ms
  1954. checking query cache for query 0.0 ms
  1955. checking permissions 0.0 ms
  1956. checking permissions 0.0 ms
  1957. checking permissions 0.0 ms
  1958. checking permissions 0.0 ms
  1959. checking permissions 0.0 ms
  1960. checking permissions 0.0 ms
  1961. Opening tables 0.0 ms
  1962. System lock 0.0 ms
  1963. Waiting for query cache lock 0.0 ms
  1964. init 0.0 ms
  1965. optimizing 0.0 ms
  1966. statistics 0.0 ms
  1967. preparing 0.0 ms
  1968. executing 0.0 ms
  1969. Sorting result 0.0 ms
  1970. Sending data 0.1 ms
  1971. end 0.0 ms
  1972. query end 0.0 ms
  1973. closing tables 0.0 ms
  1974. freeing items 0.0 ms
  1975. Waiting for query cache lock 0.0 ms
  1976. freeing items 0.0 ms
  1977. Waiting for query cache lock 0.0 ms
  1978. freeing items 0.0 ms
  1979. storing result in query cache 0.1 ms
  1980. logging slow query 0.0 ms
  1981. cleaning up 0.0 ms
  1982. Call Stack
  1983. JROOT/libraries/legacy/model/legacy.php:301
  1984. JROOT/libraries/legacy/model/list.php:171
  1985. JROOT/administrator/components/com_content/models/articles.php:371
  1986. JROOT/administrator/modules/mod_latest/helper.php:83
  1987. JROOT/administrator/modules/mod_latest/mod_latest.php:15
  1988. JROOT/libraries/cms/module/helper.php:190
  1989. JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
  1990. JROOT/libraries/legacy/view/legacy.php:663
  1991. JROOT/libraries/legacy/view/legacy.php:211
  1992. JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
  1993. JROOT/libraries/legacy/controller/legacy.php:685
  1994. JROOT/libraries/legacy/controller/legacy.php:722
  1995. JROOT/administrator/components/com_cpanel/cpanel.php:15
  1996. JROOT/libraries/cms/component/helper.php:352
  1997. JROOT/libraries/cms/component/helper.php:332
  1998. JROOT/libraries/cms/application/administrator.php:98
  1999. JROOT/libraries/cms/application/administrator.php:159
  2000. JROOT/libraries/cms/application/cms.php:255
  2001. JROOT/administrator/index.php:42
  2002. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  2003. Query Time: 0.15 ms After last query: 2.58 ms Query memory: 0.019 MB Memory before query: 11.504 MB Rows returned: 1
  2004.  
  2005. SELECT params
  2006. FROM an1sp0t_extensions AS e
  2007. WHERE e.element='com_widgetkit'
  2008.  
  2009. Explain
  2010. id select_type table type possible_keys key key_len ref rows Extra
  2011. 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 302 const 1 Using where
  2012. Profile
  2013. Status Duration
  2014. starting 0.0 ms
  2015. Waiting for query cache lock 0.0 ms
  2016. checking query cache for query 0.0 ms
  2017. checking permissions 0.0 ms
  2018. Opening tables 0.0 ms
  2019. System lock 0.0 ms
  2020. Waiting for query cache lock 0.0 ms
  2021. init 0.0 ms
  2022. optimizing 0.0 ms
  2023. statistics 0.0 ms
  2024. preparing 0.0 ms
  2025. executing 0.0 ms
  2026. Sending data 0.0 ms
  2027. end 0.0 ms
  2028. query end 0.0 ms
  2029. closing tables 0.0 ms
  2030. freeing items 0.0 ms
  2031. Waiting for query cache lock 0.0 ms
  2032. freeing items 0.0 ms
  2033. Waiting for query cache lock 0.0 ms
  2034. freeing items 0.0 ms
  2035. storing result in query cache 0.0 ms
  2036. logging slow query 0.0 ms
  2037. cleaning up 0.0 ms
  2038. Call Stack
  2039. JROOT/administrator/components/com_widgetkit/helpers/system.php:254
  2040. JROOT/administrator/components/com_widgetkit/helpers/system.php:54
  2041. JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
  2042. JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
  2043. JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
  2044. JROOT/administrator/components/com_widgetkit/widgetkit.php:17
  2045. JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
  2046. JROOT/libraries/joomla/event/event.php:71
  2047. JROOT/libraries/joomla/event/dispatcher.php:162
  2048. JROOT/libraries/joomla/application/base.php:106
  2049. JROOT/libraries/cms/application/administrator.php:103
  2050. JROOT/libraries/cms/application/administrator.php:159
  2051. JROOT/libraries/cms/application/cms.php:255
  2052. JROOT/administrator/index.php:42
  2053. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  2054. Query Time: 0.16 ms After last query: 3.14 ms Query memory: 0.020 MB Memory before query: 11.549 MB Rows returned: 1
  2055.  
  2056. SELECT extension_id AS id, element AS "option", params, enabled
  2057.  
  2058. FROM an1sp0t_extensions
  2059.  
  2060. WHERE `type` = 'component'
  2061. AND `element` = 'com_media'
  2062.  
  2063. Explain
  2064. id select_type table type possible_keys key key_len ref rows Extra
  2065. 1 SIMPLE an1sp0t_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
  2066. Profile
  2067. Status Duration
  2068. starting 0.0 ms
  2069. Waiting for query cache lock 0.0 ms
  2070. checking query cache for query 0.0 ms
  2071. checking permissions 0.0 ms
  2072. Opening tables 0.0 ms
  2073. System lock 0.0 ms
  2074. Waiting for query cache lock 0.0 ms
  2075. init 0.0 ms
  2076. optimizing 0.0 ms
  2077. statistics 0.0 ms
  2078. preparing 0.0 ms
  2079. executing 0.0 ms
  2080. Sending data 0.0 ms
  2081. end 0.0 ms
  2082. query end 0.0 ms
  2083. closing tables 0.0 ms
  2084. freeing items 0.0 ms
  2085. Waiting for query cache lock 0.0 ms
  2086. freeing items 0.0 ms
  2087. Waiting for query cache lock 0.0 ms
  2088. freeing items 0.0 ms
  2089. storing result in query cache 0.0 ms
  2090. logging slow query 0.0 ms
  2091. cleaning up 0.0 ms
  2092. Call Stack
  2093. JROOT/libraries/joomla/cache/controller/callback.php:158
  2094. JROOT/libraries/cms/component/helper.php:396
  2095. JROOT/libraries/cms/component/helper.php:43
  2096. JROOT/libraries/cms/component/helper.php:91
  2097. JROOT/administrator/components/com_widgetkit/helpers/system.php:80
  2098. JROOT/administrator/components/com_widgetkit/widgetkit.php:17
  2099. JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
  2100. JROOT/libraries/joomla/event/event.php:71
  2101. JROOT/libraries/joomla/event/dispatcher.php:162
  2102. JROOT/libraries/joomla/application/base.php:106
  2103. JROOT/libraries/cms/application/administrator.php:103
  2104. JROOT/libraries/cms/application/administrator.php:159
  2105. JROOT/libraries/cms/application/cms.php:255
  2106. JROOT/administrator/index.php:42
  2107. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  2108. Query Time: 0.14 ms After last query: 12.54 ms Query memory: 0.015 MB Memory before query: 12.366 MB Rows returned: 1
  2109.  
  2110. SELECT COUNT(*)
  2111.  
  2112. FROM an1sp0t_messages
  2113.  
  2114. WHERE state = 0
  2115. AND user_id_to = 105
  2116.  
  2117. Explain
  2118. id select_type table type possible_keys key key_len ref rows Extra
  2119. 1 SIMPLE an1sp0t_messages ref useridto_state useridto_state 5 const,const 1 Using index
  2120. Profile
  2121. Status Duration
  2122. starting 0.0 ms
  2123. Waiting for query cache lock 0.0 ms
  2124. checking query cache for query 0.0 ms
  2125. checking permissions 0.0 ms
  2126. Opening tables 0.0 ms
  2127. System lock 0.0 ms
  2128. Waiting for query cache lock 0.0 ms
  2129. init 0.0 ms
  2130. optimizing 0.0 ms
  2131. statistics 0.0 ms
  2132. preparing 0.0 ms
  2133. executing 0.0 ms
  2134. Sending data 0.0 ms
  2135. end 0.0 ms
  2136. query end 0.0 ms
  2137. closing tables 0.0 ms
  2138. freeing items 0.0 ms
  2139. Waiting for query cache lock 0.0 ms
  2140. freeing items 0.0 ms
  2141. Waiting for query cache lock 0.0 ms
  2142. freeing items 0.0 ms
  2143. storing result in query cache 0.0 ms
  2144. logging slow query 0.0 ms
  2145. cleaning up 0.0 ms
  2146. Call Stack
  2147. JROOT/administrator/modules/mod_status/mod_status.php:25
  2148. JROOT/libraries/cms/module/helper.php:190
  2149. JROOT/libraries/joomla/document/html/renderer/module.php:105
  2150. JROOT/libraries/joomla/document/html/renderer/modules.php:46
  2151. JROOT/libraries/joomla/document/html/html.php:408
  2152. JROOT/libraries/joomla/document/html/html.php:690
  2153. JROOT/libraries/joomla/document/html/html.php:471
  2154. JROOT/libraries/cms/application/cms.php:992
  2155. JROOT/libraries/cms/application/administrator.php:436
  2156. JROOT/libraries/cms/application/cms.php:261
  2157. JROOT/administrator/index.php:42
  2158. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  2159. Query Time: 0.12 ms After last query: 0.08 ms Query memory: 0.015 MB Memory before query: 12.383 MB Rows returned: 1
  2160.  
  2161. SELECT COUNT(session_id)
  2162.  
  2163. FROM an1sp0t_session
  2164.  
  2165. WHERE guest = 0
  2166. AND client_id = 1
  2167.  
  2168. Explain
  2169. id select_type table type possible_keys key key_len ref rows Extra
  2170. 1 SIMPLE an1sp0t_session ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where
  2171. Profile
  2172. Status Duration
  2173. starting 0.0 ms
  2174. Waiting for query cache lock 0.0 ms
  2175. checking query cache for query 0.0 ms
  2176. checking permissions 0.0 ms
  2177. Opening tables 0.0 ms
  2178. System lock 0.0 ms
  2179. Waiting for query cache lock 0.0 ms
  2180. init 0.0 ms
  2181. optimizing 0.0 ms
  2182. statistics 0.0 ms
  2183. preparing 0.0 ms
  2184. executing 0.0 ms
  2185. Sending data 0.0 ms
  2186. end 0.0 ms
  2187. query end 0.0 ms
  2188. closing tables 0.0 ms
  2189. freeing items 0.0 ms
  2190. Waiting for query cache lock 0.0 ms
  2191. freeing items 0.0 ms
  2192. Waiting for query cache lock 0.0 ms
  2193. freeing items 0.0 ms
  2194. storing result in query cache 0.0 ms
  2195. logging slow query 0.0 ms
  2196. cleaning up 0.0 ms
  2197. Call Stack
  2198. JROOT/administrator/modules/mod_status/mod_status.php:34
  2199. JROOT/libraries/cms/module/helper.php:190
  2200. JROOT/libraries/joomla/document/html/renderer/module.php:105
  2201. JROOT/libraries/joomla/document/html/renderer/modules.php:46
  2202. JROOT/libraries/joomla/document/html/html.php:408
  2203. JROOT/libraries/joomla/document/html/html.php:690
  2204. JROOT/libraries/joomla/document/html/html.php:471
  2205. JROOT/libraries/cms/application/cms.php:992
  2206. JROOT/libraries/cms/application/administrator.php:436
  2207. JROOT/libraries/cms/application/cms.php:261
  2208. JROOT/administrator/index.php:42
  2209. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  2210. Query Time: 0.12 ms After last query: 0.14 ms Query memory: 0.015 MB Memory before query: 12.401 MB Rows returned: 1
  2211.  
  2212. SELECT COUNT(session_id)
  2213.  
  2214. FROM an1sp0t_session
  2215.  
  2216. WHERE guest = 0
  2217. AND client_id = 0
  2218.  
  2219. Explain
  2220. id select_type table type possible_keys key key_len ref rows Extra
  2221. 1 SIMPLE an1sp0t_session ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where
  2222. Profile
  2223. Status Duration
  2224. starting 0.0 ms
  2225. Waiting for query cache lock 0.0 ms
  2226. checking query cache for query 0.0 ms
  2227. checking permissions 0.0 ms
  2228. Opening tables 0.0 ms
  2229. System lock 0.0 ms
  2230. Waiting for query cache lock 0.0 ms
  2231. init 0.0 ms
  2232. optimizing 0.0 ms
  2233. statistics 0.0 ms
  2234. preparing 0.0 ms
  2235. executing 0.0 ms
  2236. Sending data 0.0 ms
  2237. end 0.0 ms
  2238. query end 0.0 ms
  2239. closing tables 0.0 ms
  2240. freeing items 0.0 ms
  2241. Waiting for query cache lock 0.0 ms
  2242. freeing items 0.0 ms
  2243. Waiting for query cache lock 0.0 ms
  2244. freeing items 0.0 ms
  2245. storing result in query cache 0.0 ms
  2246. logging slow query 0.0 ms
  2247. cleaning up 0.0 ms
  2248. Call Stack
  2249. JROOT/administrator/modules/mod_status/mod_status.php:63
  2250. JROOT/libraries/cms/module/helper.php:190
  2251. JROOT/libraries/joomla/document/html/renderer/module.php:105
  2252. JROOT/libraries/joomla/document/html/renderer/modules.php:46
  2253. JROOT/libraries/joomla/document/html/html.php:408
  2254. JROOT/libraries/joomla/document/html/html.php:690
  2255. JROOT/libraries/joomla/document/html/html.php:471
  2256. JROOT/libraries/cms/application/cms.php:992
  2257. JROOT/libraries/cms/application/administrator.php:436
  2258. JROOT/libraries/cms/application/cms.php:261
  2259. JROOT/administrator/index.php:42
  2260. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  2261. Query Time: 0.65 ms After last query: 8.12 ms Query memory: 0.019 MB Memory before query: 12.672 MB Rows returned: 1
  2262.  
  2263. SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
  2264.  
  2265. FROM an1sp0t_menu_types AS a
  2266.  
  2267. LEFT JOIN an1sp0t_menu AS b
  2268. ON b.menutype = a.menutype
  2269. AND b.home != 0
  2270.  
  2271. LEFT JOIN an1sp0t_languages AS l
  2272. ON l.lang_code = language
  2273.  
  2274. WHERE (b.client_id = 0 OR b.client_id IS NULL)
  2275.  
  2276. GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
  2277.  
  2278. Explain
  2279. id select_type table type possible_keys key key_len ref rows Extra
  2280. 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using temporary; Using filesort
  2281. 1 SIMPLE b ref idx_menutype idx_menutype 74 anispotc_bd.a.menutype 5 Using where
  2282. 1 SIMPLE l eq_ref idx_langcode idx_langcode 21 anispotc_bd.b.language 1
  2283. Profile
  2284. Status Duration
  2285. starting 0.0 ms
  2286. Waiting for query cache lock 0.0 ms
  2287. checking query cache for query 0.0 ms
  2288. checking permissions 0.0 ms
  2289. checking permissions 0.0 ms
  2290. checking permissions 0.0 ms
  2291. Opening tables 0.1 ms
  2292. System lock 0.0 ms
  2293. Waiting for query cache lock 0.0 ms
  2294. init 0.0 ms
  2295. optimizing 0.0 ms
  2296. statistics 0.0 ms
  2297. preparing 0.0 ms
  2298. Creating tmp table 0.2 ms
  2299. executing 0.0 ms
  2300. Copying to tmp table 0.1 ms
  2301. Sorting result 0.0 ms
  2302. Sending data 0.0 ms
  2303. end 0.0 ms
  2304. removing tmp table 0.1 ms
  2305. end 0.0 ms
  2306. query end 0.0 ms
  2307. closing tables 0.0 ms
  2308. freeing items 0.0 ms
  2309. Waiting for query cache lock 0.0 ms
  2310. freeing items 0.0 ms
  2311. Waiting for query cache lock 0.0 ms
  2312. freeing items 0.0 ms
  2313. storing result in query cache 0.1 ms
  2314. logging slow query 0.0 ms
  2315. cleaning up 0.0 ms
  2316. Call Stack
  2317. JROOT/administrator/modules/mod_menu/helper.php:47
  2318. JROOT/administrator/modules/mod_menu/tmpl/default_enabled.php:139
  2319. JROOT/administrator/modules/mod_menu/tmpl/default.php:14
  2320. JROOT/administrator/modules/mod_menu/mod_menu.php:30
  2321. JROOT/libraries/cms/module/helper.php:190
  2322. JROOT/libraries/joomla/document/html/renderer/module.php:105
  2323. JROOT/libraries/joomla/document/html/renderer/modules.php:46
  2324. JROOT/libraries/joomla/document/html/html.php:408
  2325. JROOT/libraries/joomla/document/html/html.php:690
  2326. JROOT/libraries/joomla/document/html/html.php:471
  2327. JROOT/libraries/cms/application/cms.php:992
  2328. JROOT/libraries/cms/application/administrator.php:436
  2329. JROOT/libraries/cms/application/cms.php:261
  2330. JROOT/administrator/index.php:42
  2331. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  2332. Query Time: 0.45 ms After last query: 0.49 ms Query memory: 0.019 MB Memory before query: 12.702 MB Rows returned: 33
  2333.  
  2334. SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
  2335.  
  2336. FROM an1sp0t_menu AS m
  2337.  
  2338. LEFT JOIN an1sp0t_extensions AS e
  2339. ON m.component_id = e.extension_id
  2340.  
  2341. WHERE m.client_id = 1
  2342. AND e.enabled = 1
  2343. AND m.id > 1
  2344.  
  2345. ORDER BY m.lft
  2346.  
  2347. Explain
  2348. id select_type table type possible_keys key key_len ref rows Extra
  2349. 1 SIMPLE m ref PRIMARY,idx_client_id_parent_id_alias_language,idx_componentid idx_client_id_parent_id_alias_language 1 const 33 Using where; Using filesort
  2350. 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 anispotc_bd.m.component_id 1 Using where
  2351. Profile
  2352. Status Duration
  2353. starting 0.0 ms
  2354. Waiting for query cache lock 0.0 ms
  2355. checking query cache for query 0.0 ms
  2356. checking permissions 0.0 ms
  2357. checking permissions 0.0 ms
  2358. Opening tables 0.0 ms
  2359. System lock 0.0 ms
  2360. Waiting for query cache lock 0.0 ms
  2361. init 0.0 ms
  2362. optimizing 0.0 ms
  2363. statistics 0.0 ms
  2364. preparing 0.0 ms
  2365. executing 0.0 ms
  2366. Sorting result 0.1 ms
  2367. Sending data 0.1 ms
  2368. end 0.0 ms
  2369. query end 0.0 ms
  2370. closing tables 0.0 ms
  2371. freeing items 0.0 ms
  2372. Waiting for query cache lock 0.0 ms
  2373. freeing items 0.1 ms
  2374. Waiting for query cache lock 0.0 ms
  2375. freeing items 0.0 ms
  2376. storing result in query cache 0.0 ms
  2377. logging slow query 0.0 ms
  2378. cleaning up 0.0 ms
  2379. Call Stack
  2380. JROOT/administrator/modules/mod_menu/helper.php:85
  2381. JROOT/administrator/modules/mod_menu/tmpl/default_enabled.php:241
  2382. JROOT/administrator/modules/mod_menu/tmpl/default.php:14
  2383. JROOT/administrator/modules/mod_menu/mod_menu.php:30
  2384. JROOT/libraries/cms/module/helper.php:190
  2385. JROOT/libraries/joomla/document/html/renderer/module.php:105
  2386. JROOT/libraries/joomla/document/html/renderer/modules.php:46
  2387. JROOT/libraries/joomla/document/html/html.php:408
  2388. JROOT/libraries/joomla/document/html/html.php:690
  2389. JROOT/libraries/joomla/document/html/html.php:471
  2390. JROOT/libraries/cms/application/cms.php:992
  2391. JROOT/libraries/cms/application/administrator.php:436
  2392. JROOT/libraries/cms/application/cms.php:261
  2393. JROOT/administrator/index.php:42
  2394. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  2395. Query Time: 0.55 ms After last query: 27.87 ms Query memory: 0.003 MB Memory before query: 12.811 MB
  2396.  
  2397. UPDATE `an1sp0t_session`
  2398.  
  2399. SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1401265942;s:18:\"session.timer.last\";i:1401265944;s:17:\"session.timer.now\";i:1401265945;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}}}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"105\";s:4:\"name\";s:7:\"AniSpot\";s:8:\"username\";s:7:\"anispot\";s:5:\"email\";s:26:\"[email protected]\";s:8:\"password\";s:60:\"$2y$10$w0G58liabngNYJplbZireue/zIexPkfJh2NPDE178xyKW3Z2Rp.ki\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-05-24 16:27:30\";s:13:\"lastvisitDate\";s:19:\"2014-05-27 11:26:01\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"65afa28f88f9411b7061a010fc73921f\";}__wf|a:1:{s:13:\"session.token\";s:32:\"bc3a5c712d27f30cad8c1245d090a498\";}'
  2400. , `time` = '1401265945'
  2401.  
  2402. WHERE `session_id` = '94ede3bdf9b6946f4c5a6bc3f10bb5e2'
  2403.  
  2404. Explain
  2405. EXPLAIN not possible on query: UPDATE `an1sp0t_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1401265942;s:18:\"session.timer.last\";i:1401265944;s:17:\"session.timer.now\";i:1401265945;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}}}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"105\";s:4:\"name\";s:7:\"AniSpot\";s:8:\"username\";s:7:\"anispot\";s:5:\"email\";s:26:\"[email protected]\";s:8:\"password\";s:60:\"$2y$10$w0G58liabngNYJplbZireue/zIexPkfJh2NPDE178xyKW3Z2Rp.ki\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-05-24 16:27:30\";s:13:\"lastvisitDate\";s:19:\"2014-05-27 11:26:01\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"65afa28f88f9411b7061a010fc73921f\";}__wf|a:1:{s:13:\"session.token\";s:32:\"bc3a5c712d27f30cad8c1245d090a498\";}' , `time` = '1401265945' WHERE `session_id` = '94ede3bdf9b6946f4c5a6bc3f10bb5e2'
  2406. Profile
  2407. Status Duration
  2408. starting 0.0 ms
  2409. checking permissions 0.0 ms
  2410. Opening tables 0.0 ms
  2411. System lock 0.0 ms
  2412. init 0.0 ms
  2413. Updating 0.1 ms
  2414. end 0.0 ms
  2415. Waiting for query cache lock 0.0 ms
  2416. end 0.1 ms
  2417. query end 0.3 ms
  2418. closing tables 0.0 ms
  2419. freeing items 0.0 ms
  2420. logging slow query 0.0 ms
  2421. cleaning up 0.0 ms
  2422. Call Stack
  2423. JROOT/libraries/joomla/session/storage/database.php:85
  2424. [Add xdebug.file_link_format directive to your php.ini file to have links for files]
  2425.  
  2426. 30 Query Types Logged, Sorted by Occurrences.
  2427. SELECT Tables:
  2428.  
  2429. 7 × SELECT extension_id AS id, element AS "option", params, enabled
  2430. FROM an1sp0t_extensions
  2431.  
  2432. 2 × SELECT *
  2433. FROM an1sp0t_extensions
  2434.  
  2435. 2 × SELECT COUNT(*)
  2436. FROM an1sp0t_content AS a
  2437. LEFT JOIN `an1sp0t_languages` AS l
  2438. ON l.lang_code = a.language
  2439. LEFT JOIN an1sp0t_users AS uc
  2440. ON uc.id=a.checked_out
  2441. LEFT JOIN an1sp0t_viewlevels AS ag
  2442. ON ag.id = a.access
  2443. LEFT JOIN an1sp0t_categories AS c
  2444. ON c.id = a.catid
  2445. LEFT JOIN an1sp0t_users AS ua
  2446. ON ua.id = a.created_b
  2447.  
  2448. 2 × SELECT COUNT(session_id)
  2449. FROM an1sp0t_session
  2450.  
  2451. 2 × SELECT *
  2452. FROM an1sp0t_wf_profiles
  2453.  
  2454. 2 × SELECT `extension_id`
  2455. FROM `an1sp0t_extensions`
  2456.  
  2457. 1 × SELECT params
  2458. FROM an1sp0t_extensions AS e
  2459.  
  2460. 1 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
  2461. FROM an1sp0t_content AS a
  2462. LEFT JOIN `an1sp0t_languages` AS l
  2463. ON l.lang_code = a.language
  2464. LEFT JOIN an1sp0t_users AS uc
  2465. ON uc.id=a.checked_out
  2466. LEFT JOIN an1sp0t_viewlevels AS ag
  2467. ON ag.id = a.access
  2468. LEFT JOIN an1sp0t_categories AS c
  2469. ON c.id = a.catid
  2470. LEFT JOIN an1sp0t_users AS ua
  2471. ON ua.id = a.created_by
  2472.  
  2473. 1 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
  2474. FROM an1sp0t_content AS a
  2475. LEFT JOIN `an1sp0t_languages` AS l
  2476. ON l.lang_code = a.language
  2477. LEFT JOIN an1sp0t_users AS uc
  2478. ON uc.id=a.checked_out
  2479. LEFT JOIN an1sp0t_viewlevels AS ag
  2480. ON ag.id = a.access
  2481. LEFT JOIN an1sp0t_categories AS c
  2482. ON c.id = a.catid
  2483. LEFT JOIN an1sp0t_users AS ua
  2484. ON ua.id = a.created_by
  2485.  
  2486. 1 × SELECT COUNT(*)
  2487. FROM an1sp0t_messages
  2488.  
  2489. 1 × SELECT b.id
  2490. FROM an1sp0t_user_usergroup_map AS map
  2491. LEFT JOIN an1sp0t_usergroups AS a
  2492. ON a.id = map.group_id
  2493. LEFT JOIN an1sp0t_usergroups AS b
  2494. ON b.lft <= a.lft
  2495. AND b.rgt >= a.rgt
  2496.  
  2497. 1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
  2498. FROM an1sp0t_menu AS m
  2499. LEFT JOIN an1sp0t_extensions AS e
  2500. ON m.component_id = e.extension_id
  2501.  
  2502. 1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
  2503. FROM an1sp0t_menu_types AS a
  2504. LEFT JOIN an1sp0t_menu AS b
  2505. ON b.menutype = a.menutype
  2506. AND b.home != 0
  2507. LEFT JOIN an1sp0t_languages AS l
  2508. ON l.lang_code = language
  2509.  
  2510. 1 × SELECT id, rules
  2511. FROM `an1sp0t_viewlevels
  2512.  
  2513. 1 × SELECT enabled
  2514. FROM `an1sp0t_extensions`
  2515.  
  2516. 1 × SELECT `an1sp0t_postinstall_messages`.*
  2517. FROM `an1sp0t_postinstall_messages`
  2518.  
  2519. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  2520. FROM an1sp0t_modules AS m
  2521. LEFT JOIN an1sp0t_modules_menu AS mm
  2522. ON mm.moduleid = m.id
  2523. LEFT JOIN an1sp0t_extensions AS e
  2524. ON e.element = m.module
  2525. AND e.client_id = m.client_id
  2526.  
  2527. 1 × SELECT `enabled`
  2528. FROM `an1sp0t_extensions`
  2529.  
  2530. 1 × SELECT `data`
  2531. FROM `an1sp0t_session`
  2532.  
  2533. 1 × SELECT s.time, s.client_id, u.id, u.name, u.username
  2534. FROM an1sp0t_session AS s
  2535. LEFT JOIN an1sp0t_users AS u
  2536. ON s.userid = u.id
  2537.  
  2538. 1 × SELECT folder AS type, element AS name, params
  2539. FROM an1sp0t_extensions
  2540.  
  2541. 1 × SELECT template, s.params
  2542. FROM an1sp0t_template_styles as s
  2543. LEFT JOIN an1sp0t_extensions as e
  2544. ON e.type='template'
  2545. AND e.element=s.template
  2546. AND e.client_id=s.client_id
  2547.  
  2548. OTHER Tables:
  2549.  
  2550. 2 × SHOW FULL COLUMNS
  2551. FROM `an1sp0t_postinstall_messages
  2552.  
  2553. 1 × UPDATE `an1sp0t_extensions`
  2554. SET `enabled` = '1'
  2555.  
  2556. 1 × UPDATE `an1sp0t_session`
  2557. SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1401265942;s:18:\"session.timer.last\";i:1401265944;s:17:\"session.timer.now\";i:1401265945;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}}}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"105\";s:4:\"name\";s:7:\"AniSpot\";s:8:\"username\";s:7:\"anispot\";s:5:\"email\";s:26:\"[email protected]\";s:8:\"password\";s:60:\"$2y$10$w0G58liabngNYJplbZireue/zIexPkfJh2NPDE178xyKW3Z2Rp.ki\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-05-24 16:27:30\";s:13:\"lastvisitDate\";s:19:\"2014-05-27 11:26:01\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"65afa28f88f9411b7061a010fc73921f\";}__wf|a:1:{s:13:\"session.token\";s:32:\"bc3a5c712d27f30cad8c1245d090a498\";}' , `time` = '1401265945'
  2558.  
  2559. 1 × SHOW FULL COLUMNS
  2560. FROM `an1sp0t_extensions
  2561.  
  2562. 1 × UPDATE `an1sp0t_extensions`
  2563. SET `enabled` = '0'
  2564.  
  2565. 1 × SHOW TABLE
  2566.  
  2567. 1 × DELETE
  2568. FROM `an1sp0t_session`
  2569.  
  2570. 1 × UPDATE `an1sp0t_extensions`
  2571. SET `params` = '{\"mediaversion\":\"e0a839f0307cf6c2971a305551fd5a5a\"}'
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!