Panasonic AJ-HPX3700 DVCPRO HD Camcorder |
ID : 208 |
Panasonic AJ-HPX3700
Don't Pay Too Much !!
Package deals & Trade-ins Available
Full Local Warranty and Free Delivery within Australia
Overview
Designed to capture feature films, television episodics and commercials, the AJ-HPX3700 is Panasonic's new workhorse camera producing uncompromising cinematic image quality with the exceptional reliability and faster workflow of solid-state P2 HD.
Recognized worldwide as the industry's premier digital cinematography camera, Panasonic's VariCam
We Make it Safe for both Buyer and Seller
Seller Login
Featured New Ads
Joomla! Debug Console
Time
Memory
Time: 0.0 ms / 0.0 ms Memory: 0.611 MB / 0.61 MB Application: afterLoad
Time: 51.9 ms / 51.9 ms Memory: 5.641 MB / 6.25 MB Application: afterInitialise
Time: 28.6 ms / 80.5 ms Memory: 2.737 MB / 8.99 MB Application: afterRoute
Time: 29.3 ms / 109.7 ms Memory: 2.187 MB / 11.18 MB Application: beforeRenderModule mod_adsnew_prevNext (AdsNew Navigation)
Time: 23.7 ms / 133.5 ms Memory: 3.294 MB / 14.47 MB Application: afterRenderModule mod_adsnew_prevNext (AdsNew Navigation)
Time: 6.2 ms / 139.7 ms Memory: 0.000 MB / 12.35 MB Application: afterDispatch
Time: 28.6 ms / 168.2 ms Memory: 3.036 MB / 15.38 MB Application: beforeRenderModule mod_roknavmenu ()
Time: 21.4 ms / 189.6 ms Memory: 1.650 MB / 17.03 MB Application: afterRenderModule mod_roknavmenu ()
Time: 6.5 ms / 196.1 ms Memory: 0.025 MB / 17.06 MB Application: beforeRenderModule mod_menu (Footer Menu)
Time: 2.7 ms / 198.8 ms Memory: 0.060 MB / 17.12 MB Application: afterRenderModule mod_menu (Footer Menu)
Time: 0.1 ms / 198.9 ms Memory: 0.000 MB / 17.11 MB Application: beforeRenderModule mod_custom (Follow Us)
Time: 0.9 ms / 199.9 ms Memory: 0.009 MB / 17.12 MB Application: afterRenderModule mod_custom (Follow Us)
Time: 0.1 ms / 200.0 ms Memory: 0.005 MB / 17.13 MB Application: beforeRenderModule mod_acymailing (Newsletter)
Time: 10.5 ms / 210.5 ms Memory: 1.239 MB / 18.36 MB Application: afterRenderModule mod_acymailing (Newsletter)
Time: 0.1 ms / 210.6 ms Memory: 0.000 MB / 18.34 MB Application: beforeRenderModule mod_menu ( Used Equipment)
Time: 4.2 ms / 214.8 ms Memory: 0.249 MB / 18.59 MB Application: afterRenderModule mod_menu ( Used Equipment)
Time: 0.1 ms / 214.9 ms Memory: 0.000 MB / 18.58 MB Application: beforeRenderModule mod_menu (New Equipment)
Time: 2.2 ms / 217.1 ms Memory: 0.116 MB / 18.70 MB Application: afterRenderModule mod_menu (New Equipment)
Time: 0.1 ms / 217.2 ms Memory: 0.001 MB / 18.70 MB Application: beforeRenderModule mod_cblogin (Seller Login)
Time: 66.2 ms / 283.4 ms Memory: 11.736 MB / 30.43 MB Application: afterRenderModule mod_cblogin (Seller Login)
Time: 0.1 ms / 283.5 ms Memory: 0.000 MB / 30.41 MB Application: beforeRenderModule mod_adsnew_ads (Featured New Ads)
Time: 19.9 ms / 303.5 ms Memory: 0.188 MB / 30.60 MB Application: afterRenderModule mod_adsnew_ads (Featured New Ads)
Time: 0.2 ms / 303.7 ms Memory: 0.000 MB / 30.55 MB Application: beforeRenderModule mod_adsused_ads (Featured Used Ads)
Time: 11.9 ms / 315.6 ms Memory: 0.807 MB / 31.36 MB Application: afterRenderModule mod_adsused_ads (Featured Used Ads)
Time: 0.2 ms / 315.8 ms Memory: 0.000 MB / 31.30 MB Application: beforeRenderModule mod_adsnew_search (New Equipment Search)
Time: 5.9 ms / 321.6 ms Memory: 0.201 MB / 31.50 MB Application: afterRenderModule mod_adsnew_search (New Equipment Search)
Time: 0.2 ms / 321.9 ms Memory: 0.000 MB / 31.40 MB Application: beforeRenderModule mod_custom (Tagline)
Time: 0.4 ms / 322.3 ms Memory: 0.007 MB / 31.41 MB Application: afterRenderModule mod_custom (Tagline)
Time: 8.0 ms / 330.3 ms Memory: 0.255 MB / 31.67 MB Application: afterRender
Database queries total: 61.8 ms
32.16 MB (33,719,240 Bytes)
114 Queries Logged 61.8 ms
36 duplicate found!
- Query Time: 0.50 ms Query memory: 0.015 MB Memory before query: 2.273 MB Rows returned: 0
SELECT `data`
FROM `fly9i_session`
WHERE `session_id` = 'g8ts0qlorp5217i4orivjfjnn7'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_session const PRIMARY PRIMARY 602 const 1 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/session/storage/database.php:46JROOT/libraries/joomla/session/session.php:658JROOT/libraries/joomla/session/session.php:596JROOT/libraries/cms/application/cms.php:672JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:332JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - Query Time: 0.33 ms After last query: 1.15 ms Query memory: 0.008 MB Memory before query: 2.411 MB
DELETE
FROM `fly9i_session`
WHERE `time` < '1714361393'EXPLAIN not possible on query: DELETE FROM `fly9i_session` WHERE `time` < '1714361393'No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/cms.php:689JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:332JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - Query Time: 0.83 ms After last query: 0.23 ms Query memory: 0.012 MB Memory before query: 2.423 MB Rows returned: 0
SELECT `session_id`
FROM `fly9i_session`
WHERE `session_id` = 'g8ts0qlorp5217i4orivjfjnn7'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_session const PRIMARY PRIMARY 602 const 1 Using index No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/cms.php:175JROOT/libraries/cms/application/cms.php:698JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:332JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - Query Time: 0.88 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 2.435 MB
INSERT INTO `fly9i_session` (`session_id`, `client_id`, `time`)
VALUES ('g8ts0qlorp5217i4orivjfjnn7', 0, '1714362293')EXPLAIN not possible on query: INSERT INTO `fly9i_session` (`session_id`, `client_id`, `time`) VALUES ('g8ts0qlorp5217i4orivjfjnn7', 0, '1714362293')No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/cms.php:207JROOT/libraries/cms/application/cms.php:698JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:332JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - Query Time: 1.13 ms After last query: 3.02 ms Query memory: 0.015 MB Memory before query: 2.792 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:396JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/libraries/cms/application/site.php:541JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.13 ms After last query: 1.14 ms Query memory: 0.014 MB Memory before query: 2.897 MB Rows returned: 1
SELECT b.id
FROM fly9i_usergroups AS a
LEFT JOIN fly9i_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:336JROOT/libraries/joomla/access/access.php:405JROOT/libraries/joomla/user/user.php:420JROOT/libraries/cms/plugin/helper.php:298JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:546JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.49 ms Query memory: 0.013 MB Memory before query: 2.960 MB Rows returned: 5
SELECT id, rules
FROM `fly9i_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:422JROOT/libraries/joomla/user/user.php:420JROOT/libraries/cms/plugin/helper.php:298JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:546JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.99 ms After last query: 0.16 ms Query memory: 0.014 MB Memory before query: 2.979 MB Rows returned: 66
SELECT folder AS type, element AS name, params
FROM fly9i_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 216 Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/plugin/helper.php:312JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:546JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.49 ms After last query: 0.43 ms Query memory: 0.014 MB Memory before query: 3.066 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:396JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/libraries/cms/application/site.php:599JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.16 ms After last query: 10.11 ms Query memory: 0.016 MB Memory before query: 4.407 MB Rows returned: 0
SELECT *
FROM `fly9i_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/plugins/system/admintools/admintools/main.php:526JROOT/plugins/system/admintools/admintools/main.php:447JROOT/plugins/system/admintools/admintools/main.php:90JROOT/libraries/cms/plugin/helper.php:257JROOT/libraries/cms/plugin/helper.php:172JROOT/libraries/cms/application/cms.php:586JROOT/libraries/cms/application/site.php:620JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.64 ms Query memory: 0.018 MB Memory before query: 4.480 MB Rows returned: 1
SELECT `value`
FROM `fly9i_admintools_storage`
WHERE `key` = 'cparams'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_admintools_storage const PRIMARY PRIMARY 302 const 1 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/administrator/components/com_admintools/models/storage.php:99JROOT/administrator/components/com_admintools/models/storage.php:49JROOT/plugins/system/admintools/feature/httpsizer.php:26JROOT/plugins/system/admintools/admintools/main.php:356JROOT/plugins/system/admintools/admintools/main.php:93JROOT/libraries/cms/plugin/helper.php:257JROOT/libraries/cms/plugin/helper.php:172JROOT/libraries/cms/application/cms.php:586JROOT/libraries/cms/application/site.php:620JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.82 ms After last query: 11.35 ms Query memory: 0.022 MB Memory before query: 5.756 MB Rows returned: 149
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLESNo SHOW PROFILE (maybe because there are more than 100 queries)JROOT/plugins/system/admintools/feature/utf8mb4.php:28JROOT/plugins/system/admintools/admintools/main.php:685JROOT/plugins/system/admintools/admintools/main.php:118JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:587JROOT/libraries/cms/application/site.php:620JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.73 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 5.802 MB Rows returned: 21
SHOW FULL COLUMNS
FROM fly9i_acymailing_actionEXPLAIN not possible on query: SHOW FULL COLUMNS FROM fly9i_acymailing_actionNo SHOW PROFILE (maybe because there are more than 100 queries)JROOT/plugins/system/admintools/feature/utf8mb4.php:28JROOT/plugins/system/admintools/admintools/main.php:685JROOT/plugins/system/admintools/admintools/main.php:118JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:587JROOT/libraries/cms/application/site.php:620JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 1.33 ms After last query: 4.53 ms Query memory: 0.033 MB Memory before query: 6.316 MB Rows returned: 48
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM fly9i_menu AS m
LEFT JOIN fly9i_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 78 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 broadcas_2015.m.component_id 1 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/menu/site.php:47JROOT/libraries/cms/menu/menu.php:64JROOT/libraries/cms/menu/menu.php:118JROOT/libraries/cms/application/cms.php:357JROOT/libraries/cms/application/site.php:250JROOT/libraries/cms/router/site.php:210JROOT/libraries/cms/router/router.php:391JROOT/libraries/cms/router/router.php:184JROOT/libraries/cms/router/site.php:82JROOT/libraries/cms/application/cms.php:1022JROOT/libraries/cms/application/site.php:720JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.19 ms After last query: 8.92 ms Query memory: 0.022 MB Memory before query: 7.762 MB Rows returned: 3Duplicate queries: #65
SELECT id, home, template, s.params
FROM fly9i_template_styles as s
LEFT JOIN fly9i_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 62 const 5 Using index condition; Using where 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 5 Using where; Using join buffer (flat, BNL join) No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/site.php:457JROOT/components/com_adsnew/lib/core.php:78JROOT/components/com_adsnew/router.php:13JROOT/libraries/cms/router/site.php:381JROOT/libraries/cms/router/router.php:391JROOT/libraries/cms/router/router.php:184JROOT/libraries/cms/router/site.php:82JROOT/libraries/cms/application/cms.php:1022JROOT/libraries/cms/application/site.php:720JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.46 ms After last query: 0.56 ms Query memory: 0.038 MB Memory before query: 7.815 MB Rows returned: 1
SELECT *
FROM fly9i_adsnew_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.3 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/lib/core.php:94JROOT/components/com_adsnew/router.php:13JROOT/libraries/cms/router/site.php:381JROOT/libraries/cms/router/router.php:391JROOT/libraries/cms/router/router.php:184JROOT/libraries/cms/router/site.php:82JROOT/libraries/cms/application/cms.php:1022JROOT/libraries/cms/application/site.php:720JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.51 ms After last query: 0.64 ms Query memory: 0.026 MB Memory before query: 7.897 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using index condition Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/library/helper.php:156JROOT/libraries/cms/library/helper.php:47JROOT/libraries/cms/library/helper.php:90JROOT/libraries/cms/version/version.php:179JROOT/libraries/joomla/factory.php:734JROOT/libraries/joomla/factory.php:215JROOT/components/com_adsnew/lib/core.php:127JROOT/components/com_adsnew/router.php:13JROOT/libraries/cms/router/site.php:381JROOT/libraries/cms/router/router.php:391JROOT/libraries/cms/router/router.php:184JROOT/libraries/cms/router/site.php:82JROOT/libraries/cms/application/cms.php:1022JROOT/libraries/cms/application/site.php:720JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 1.18 ms After last query: 0.25 ms Query memory: 0.020 MB Memory before query: 7.908 MB
UPDATE `fly9i_extensions`
SET `params` = '{\"mediaversion\":\"35e7d527e92e4192b2270d2d00bcb220\",\"Array\":[\"28e48f90f35034c8274bcd7e437a465a\"]}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `fly9i_extensions` SET `params` = '{\"mediaversion\":\"35e7d527e92e4192b2270d2d00bcb220\",\"Array\":[\"28e48f90f35034c8274bcd7e437a465a\"]}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms init for update 0.0 ms Updating 0.1 ms End of update loop 0.0 ms Waiting for query cache lock 0.0 ms End of update loop 0.5 ms Query end 0.0 ms Commit 0.3 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/library/helper.php:119JROOT/libraries/cms/version/version.php:230JROOT/libraries/cms/version/version.php:189JROOT/libraries/joomla/factory.php:734JROOT/libraries/joomla/factory.php:215JROOT/components/com_adsnew/lib/core.php:127JROOT/components/com_adsnew/router.php:13JROOT/libraries/cms/router/site.php:381JROOT/libraries/cms/router/router.php:391JROOT/libraries/cms/router/router.php:184JROOT/libraries/cms/router/site.php:82JROOT/libraries/cms/application/cms.php:1022JROOT/libraries/cms/application/site.php:720JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.96 ms After last query: 9.92 ms Query memory: 0.024 MB Memory before query: 8.895 MB Rows returned: 30
SHOW FULL COLUMNS
FROM `fly9i_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `fly9i_content`Status Duration Starting 0.1 ms checking permissions 0.0 ms closing tables 0.0 ms Opening tables 0.3 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Filling schema table 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms checking permissions 0.1 ms closing tables 0.0 ms Executing 0.0 ms Sending data 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Removing tmp table 0.1 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/plugins/system/articlesanywhere/helper.php:56JROOT/plugins/system/nnframework/helpers/helper.php:29JROOT/plugins/system/articlesanywhere/articlesanywhere.php:102JROOT/plugins/system/articlesanywhere/articlesanywhere.php:30JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1031JROOT/libraries/cms/application/site.php:720JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.44 ms After last query: 0.36 ms Query memory: 0.024 MB Memory before query: 8.938 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:396JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/plugins/system/articlesanywhere/helper.php:70JROOT/plugins/system/nnframework/helpers/helper.php:29JROOT/plugins/system/articlesanywhere/articlesanywhere.php:102JROOT/plugins/system/articlesanywhere/articlesanywhere.php:30JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1031JROOT/libraries/cms/application/site.php:720JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.21 ms After last query: 0.91 ms Query memory: 0.022 MB Memory before query: 8.926 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 24id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:76JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/plugins/system/sef/sef.php:49JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1031JROOT/libraries/cms/application/site.php:720JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.41 ms After last query: 0.34 ms Query memory: 0.022 MB Memory before query: 8.972 MB Rows returned: 1
SELECT ad_headline
FROM fly9i_adsnew_ads
WHERE id = 208id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_ads const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:31JROOT/components/com_adsnew/router.php:77JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/plugins/system/sef/sef.php:49JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1031JROOT/libraries/cms/application/site.php:720JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.42 ms After last query: 0.44 ms Query memory: 0.015 MB Memory before query: 9.012 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
WHERE `type` = 'component'
AND `element` = 'com_adsnew'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:396JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/libraries/cms/application/site.php:299JROOT/libraries/cms/application/site.php:122JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.12 ms After last query: 0.58 ms Query memory: 0.013 MB Memory before query: 9.037 MB Rows returned: 1
SELECT *
FROM fly9i_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/language/helper.php:166JROOT/libraries/cms/application/site.php:307JROOT/libraries/cms/application/site.php:122JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.19 ms After last query: 9.22 ms Query memory: 0.036 MB Memory before query: 10.200 MB Rows returned: 1
SELECT *
FROM fly9i_adsnew_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/configuration.php:27JROOT/components/com_adsnew/controller.php:98JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.34 ms Query memory: 0.018 MB Memory before query: 10.238 MB Rows returned: 1
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/helpers/usergroups.php:19JROOT/components/com_adsnew/lib/tpermissions.php:21JROOT/administrator/components/com_adsnew/models/content.php:139JROOT/components/com_adsnew/controller.php:115JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 10.256 MB Rows returned: 22
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 22 Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:69JROOT/components/com_adsnew/lib/tpermissions.php:26JROOT/administrator/components/com_adsnew/models/content.php:139JROOT/components/com_adsnew/controller.php:115JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.64 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 10.273 MB Rows returned: 1Duplicate queries: #44
SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
WHERE a.id = 208
AND adcat.catid IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE adcat range PRIMARY PRIMARY 8 NULL 22 Using where; Using index 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 broadcas_2015.adcat.catid 1 1 SIMPLE p eq_ref PRIMARY PRIMARY 4 broadcas_2015.c.parent 1 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.1 ms Optimizing 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.2 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/content.php:156JROOT/components/com_adsnew/controller.php:115JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 1.23 ms After last query: 0.08 ms Query memory: 0.014 MB Memory before query: 10.297 MB
UPDATE fly9i_adsnew_ads
SET views = LAST_INSERT_ID(views+1)
WHERE id = 208EXPLAIN not possible on query: UPDATE fly9i_adsnew_ads SET views = LAST_INSERT_ID(views+1) WHERE id = 208Status Duration Starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms init for update 0.0 ms Updating 0.1 ms End of update loop 0.0 ms Waiting for query cache lock 0.0 ms End of update loop 0.5 ms Query end 0.0 ms Commit 0.4 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/content.php:421JROOT/components/com_adsnew/controller.php:118JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.34 ms After last query: 0.64 ms Query memory: 0.020 MB Memory before query: 10.351 MB Rows returned: 1Duplicate queries: #52
SELECT *
FROM fly9i_adsnew_categories
WHERE id = 24id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:23JROOT/components/com_adsnew/views/details/view.html.php:44JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 10.371 MB Rows returned: 1
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/helpers/usergroups.php:19JROOT/components/com_adsnew/lib/tpermissions.php:21JROOT/administrator/components/com_adsnew/models/category.php:56JROOT/administrator/components/com_adsnew/models/category.php:78JROOT/components/com_adsnew/views/details/view.html.php:55JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 10.393 MB Rows returned: 22
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 22 Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:69JROOT/components/com_adsnew/lib/tpermissions.php:26JROOT/administrator/components/com_adsnew/models/category.php:56JROOT/administrator/components/com_adsnew/models/category.php:78JROOT/components/com_adsnew/views/details/view.html.php:55JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.67 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 10.413 MB Rows returned: 22
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE c.published = 1
AND c.id IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)
ORDER BY c.parent,c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 22 Using where; Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.3 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:69JROOT/administrator/components/com_adsnew/models/category.php:78JROOT/components/com_adsnew/views/details/view.html.php:55JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.69 ms Query memory: 0.020 MB Memory before query: 10.515 MB Rows returned: 0
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=list%'
AND published ='1'
AND type ='component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/lib/route.php:210JROOT/components/com_adsnew/lib/route.php:94JROOT/administrator/components/com_adsnew/models/category.php:96JROOT/components/com_adsnew/views/details/view.html.php:55JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 10.535 MB Rows returned: 1
SELECT id
FROM fly9i_menu
WHERE link = 'index.php?option=com_adsnew&view=front'
AND published ='1'
AND type ='component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/lib/route.php:321JROOT/components/com_adsnew/lib/route.php:117JROOT/administrator/components/com_adsnew/models/category.php:96JROOT/components/com_adsnew/views/details/view.html.php:55JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.21 ms Query memory: 0.027 MB Memory before query: 10.559 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 24id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/administrator/components/com_adsnew/models/category.php:96JROOT/components/com_adsnew/views/details/view.html.php:55JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.24 ms Query memory: 0.027 MB Memory before query: 10.584 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 18id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/administrator/components/com_adsnew/models/category.php:110JROOT/components/com_adsnew/views/details/view.html.php:55JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.66 ms After last query: 0.24 ms Query memory: 0.018 MB Memory before query: 10.553 MB Rows returned: 6
SELECT *
FROM fly9i_adsnew_positions
WHERE 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_positions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.2 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.2 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/position.php:23JROOT/components/com_adsnew/views/details/view.html.php:58JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 1.15 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 10.576 MB Rows returned: 2
SELECT f.*
FROM fly9i_adsnew_fields AS f
WHERE f.pos != -1
AND f.published = 1
ORDER by f.posorderid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE f ALL NULL NO INDEX KEY COULD BE USED NULL NULL 13 Using where; Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.1 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.6 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.2 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/field.php:176JROOT/components/com_adsnew/views/details/view.html.php:59JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.62 ms After last query: 0.08 ms Query memory: 0.020 MB Memory before query: 10.606 MB Rows returned: 12
SELECT *
FROM fly9i_adsnew_field_values
ORDER by orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_field_values ALL NULL NO INDEX KEY COULD BE USED NULL NULL 12 Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.1 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.1 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/field.php:223JROOT/components/com_adsnew/views/details/view.html.php:61JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.36 ms After last query: 0.10 ms Query memory: 0.018 MB Memory before query: 10.643 MB Rows returned: 11
SELECT fieldid,cbfieldvalues
FROM fly9i_adsnew_fields as f
WHERE published = 1
ORDER by f.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE f ALL NULL NO INDEX KEY COULD BE USED NULL NULL 13 Using where; Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/field.php:242JROOT/components/com_adsnew/views/details/view.html.php:61JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.12 ms After last query: 0.13 ms Query memory: 0.020 MB Memory before query: 10.658 MB Rows returned: 1
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/helpers/usergroups.php:19JROOT/components/com_adsnew/lib/tpermissions.php:21JROOT/administrator/components/com_adsnew/models/content.php:139JROOT/components/com_adsnew/views/details/view.html.php:64JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 10.678 MB Rows returned: 22
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 22 Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:69JROOT/components/com_adsnew/lib/tpermissions.php:26JROOT/administrator/components/com_adsnew/models/content.php:139JROOT/components/com_adsnew/views/details/view.html.php:64JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.80 ms After last query: 0.25 ms Query memory: 0.025 MB Memory before query: 10.697 MB Rows returned: 1Duplicate queries: #28
SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
WHERE a.id = 208
AND adcat.catid IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE adcat range PRIMARY PRIMARY 8 NULL 22 Using where; Using index 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 broadcas_2015.adcat.catid 1 1 SIMPLE p eq_ref PRIMARY PRIMARY 4 broadcas_2015.c.parent 1 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.1 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/content.php:156JROOT/components/com_adsnew/views/details/view.html.php:64JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.48 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 10.724 MB Rows returned: 11
SELECT *
FROM fly9i_adsnew_fields as f
WHERE f.published = 1
ORDER by f.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE f ALL NULL NO INDEX KEY COULD BE USED NULL NULL 13 Using where; Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.1 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/field.php:88JROOT/components/com_adsnew/views/details/view.html.php:92JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.44 ms After last query: 0.24 ms Query memory: 0.023 MB Memory before query: 10.816 MB Rows returned: 22
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE c.published = 1
ORDER BY c.parent,c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 22 Using where; Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.1 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:69JROOT/administrator/components/com_adsnew/models/category.php:78JROOT/components/com_adsnew/views/details/view.html.php:98JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.40 ms Query memory: 0.027 MB Memory before query: 10.892 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 24id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/administrator/components/com_adsnew/models/category.php:96JROOT/components/com_adsnew/views/details/view.html.php:98JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.25 ms Query memory: 0.027 MB Memory before query: 10.918 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 18id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/administrator/components/com_adsnew/models/category.php:110JROOT/components/com_adsnew/views/details/view.html.php:98JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.57 ms After last query: 1.56 ms Query memory: 0.023 MB Memory before query: 11.000 MB Rows returned: 0
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=edit%'
AND published ='1'
AND type ='component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.1 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/lib/route.php:210JROOT/components/com_adsnew/lib/route.php:94JROOT/components/com_adsnew/views/details/tmpl/default.php:20JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 1.30 ms After last query: 1.12 ms Query memory: 0.028 MB Memory before query: 11.108 MB Rows returned: 55
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM fly9i_modules AS m
LEFT JOIN fly9i_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN fly9i_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-29 03:44:53')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-29 03:44:53')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 470 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds NO INDEX KEY COULD BE USED NULL NULL 96 Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 broadcas_2015.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 broadcas_2015.m.module,const 1 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.4 ms Waiting for query cache lock 0.0 ms Creating sort index 0.2 ms Waiting for query cache lock 0.0 ms Creating sort index 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/libraries/cms/module/helper.php:376JROOT/libraries/cms/module/helper.php:34JROOT/components/com_adsnew/views/details/tmpl/default.php:69JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.20 ms After last query: 1.91 ms Query memory: 0.045 MB Memory before query: 11.259 MB Rows returned: 1
SELECT *
FROM fly9i_adsnew_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/configuration.php:27JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:125JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.12 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 11.303 MB Rows returned: 1Duplicate queries: #30
SELECT *
FROM fly9i_adsnew_categories
WHERE id = 24id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:23JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:128JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.48 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 11.332 MB Rows returned: 22
SELECT c.id, c.name,c.parent
FROM fly9i_adsnew_categories as c
WHERE c.published = 1
ORDER BY c.parent,c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 22 Using where; Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/content.php:213JROOT/administrator/components/com_adsnew/models/content.php:324JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:142JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 11.356 MB Rows returned: 1
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/helpers/usergroups.php:19JROOT/components/com_adsnew/lib/tpermissions.php:21JROOT/administrator/components/com_adsnew/models/content.php:331JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:142JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.12 ms After last query: 0.06 ms Query memory: 0.031 MB Memory before query: 11.383 MB Rows returned: 22
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 22 Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:69JROOT/components/com_adsnew/lib/tpermissions.php:26JROOT/administrator/components/com_adsnew/models/content.php:331JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:142JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 10.31 ms After last query: 0.23 ms Query memory: 0.109 MB Memory before query: 11.408 MB Rows returned: 130
SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_comprofiler as cb
ON cb.user_id = a.userid
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
WHERE a.published = 1
AND c.published = TRUE
AND c.id IN (24)
AND c.id IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)
GROUP BY a.id
ORDER BY a.date_created DESC ,a.id DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort 1 SIMPLE p const PRIMARY PRIMARY 4 const 1 1 SIMPLE adcat index PRIMARY PRIMARY 8 NULL 394 Using where; Using index 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 broadcas_2015.adcat.adid 1 Using where 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 broadcas_2015.a.userid 1 Using where Status Duration Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.7 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms Removing tmp table 1.9 ms Creating sort index 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/content.php:361JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:142JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.22 ms After last query: 7.37 ms Query memory: 0.033 MB Memory before query: 14.306 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 24id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/modules/mod_adsnew_prevNext/tmpl/default.php:29JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:181JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.27 ms Query memory: 0.027 MB Memory before query: 14.336 MB Rows returned: 0
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=details%'
AND published ='1'
AND type ='component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/lib/route.php:257JROOT/components/com_adsnew/lib/route.php:92JROOT/modules/mod_adsnew_prevNext/tmpl/default.php:78JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:181JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 14.362 MB Rows returned: 0
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=list%'
AND link LIKE '%catid=24%'
AND published ='1'
AND type ='component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/lib/route.php:281JROOT/components/com_adsnew/lib/route.php:92JROOT/modules/mod_adsnew_prevNext/tmpl/default.php:78JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:181JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.15 ms Query memory: 0.033 MB Memory before query: 14.392 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 24id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:76JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/modules/mod_adsnew_prevNext/tmpl/default.php:78JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:181JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.42 ms After last query: 0.07 ms Query memory: 0.033 MB Memory before query: 14.424 MB Rows returned: 1
SELECT ad_headline
FROM fly9i_adsnew_ads
WHERE id = 210id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_ads const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:31JROOT/components/com_adsnew/router.php:77JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/modules/mod_adsnew_prevNext/tmpl/default.php:78JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:181JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.24 ms Query memory: 0.033 MB Memory before query: 14.456 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 24id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:76JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/modules/mod_adsnew_prevNext/tmpl/default.php:115JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:181JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.29 ms After last query: 0.07 ms Query memory: 0.033 MB Memory before query: 14.488 MB Rows returned: 1
SELECT ad_headline
FROM fly9i_adsnew_ads
WHERE id = 207id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_ads const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:31JROOT/components/com_adsnew/router.php:77JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/modules/mod_adsnew_prevNext/tmpl/default.php:115JROOT/modules/mod_adsnew_prevNext/mod_adsnew_prevNext.php:181JROOT/libraries/cms/module/helper.php:190JROOT/components/com_adsnew/views/details/tmpl/default.php:70JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.36 ms After last query: 1.83 ms Query memory: 0.030 MB Memory before query: 11.918 MB Rows returned: 1
SELECT username
FROM fly9i_users
WHERE id = 93id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_users const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:42JROOT/components/com_adsnew/router.php:100JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/components/com_adsnew/lib/link.php:73JROOT/components/com_adsnew/views/details/tmpl/default.php:106JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_adsnew/views/details/view.html.php:154JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_adsnew/controller.php:152JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_adsnew/adsnew.php:27JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:255JROOT/index.php:40 - Query Time: 0.70 ms After last query: 17.93 ms Query memory: 0.025 MB Memory before query: 14.619 MB Rows returned: 3Duplicate queries: #15
SELECT id, home, template, s.params
FROM fly9i_template_styles as s
LEFT JOIN fly9i_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 62 const 5 Using index condition; Using where 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 5 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/gantry/core/gantrytemplate.class.php:638JROOT/libraries/gantry/core/gantrytemplate.class.php:590JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36JROOT/libraries/gantry/core/gantry.class.php:1843JROOT/libraries/gantry/core/gantry.class.php:392JROOT/libraries/gantry/gantry.php:275JROOT/libraries/gantry/gantry.php:432JROOT/templates/gantry/lib/gantry/gantry.php:21JROOT/templates/gantry/index.php:15JROOT/libraries/joomla/document/html/html.php:570JROOT/libraries/joomla/document/html/html.php:628JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:978JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.21 ms After last query: 22.37 ms Query memory: 0.024 MB Memory before query: 16.173 MB Rows returned: 0
SELECT ts.template
FROM fly9i_template_styles AS ts
INNER JOIN fly9i_menu AS m
ON ts.id=m.template_style_id
WHERE m.id = 470
AND m.template_style_id != 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.1 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:98JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/templates/gantry/features/dropdownmenu.php:56JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65JROOT/libraries/gantry/core/gantry.class.php:867JROOT/templates/gantry/index.php:87JROOT/libraries/joomla/document/html/html.php:570JROOT/libraries/joomla/document/html/html.php:628JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:978JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 16.195 MB Rows returned: 1
SELECT template
FROM fly9i_template_styles
WHERE home = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_template_styles ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 5 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:113JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/templates/gantry/features/dropdownmenu.php:56JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65JROOT/libraries/gantry/core/gantry.class.php:867JROOT/templates/gantry/index.php:87JROOT/libraries/joomla/document/html/html.php:570JROOT/libraries/joomla/document/html/html.php:628JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:978JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.19 ms After last query: 6.01 ms Query memory: 0.056 MB Memory before query: 16.854 MB Rows returned: 1Duplicate queries: #98
SELECT *
FROM fly9i_adsused_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsused_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/lib/core.php:94JROOT/components/com_adsused/router.php:13JROOT/libraries/cms/router/site.php:452JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_roknavmenu/lib/providers/RokMenuProviderJoomla16.php:174JROOT/modules/mod_roknavmenu/lib/providers/RokMenuProviderJoomla16.php:207JROOT/modules/mod_roknavmenu/lib/providers/RokMenuProviderJoomla16.php:273JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenuDefaultRenderer.php:65JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenu.php:88JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:22JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/templates/gantry/features/dropdownmenu.php:56JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65JROOT/libraries/gantry/core/gantry.class.php:867JROOT/templates/gantry/index.php:87JROOT/libraries/joomla/document/html/html.php:570JROOT/libraries/joomla/document/html/html.php:628JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:978JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.23 ms After last query: 23.73 ms Query memory: 0.025 MB Memory before query: 17.964 MB Rows returned: 138
SELECT *
FROM fly9i_acymailing_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_acymailing_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 138 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_acymailing/classes/cpanel.php:17JROOT/administrator/components/com_acymailing/helpers/helper.php:473JROOT/administrator/components/com_acymailing/helpers/helper.php:1183JROOT/modules/mod_acymailing/mod_acymailing.php:12JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.14 ms After last query: 2.76 ms Query memory: 0.022 MB Memory before query: 18.442 MB Rows returned: 1
SELECT *
FROM fly9i_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_acymailing_list system typeorderingindex,typeuseridindex NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_acymailing/classes/list.php:29JROOT/modules/mod_acymailing/mod_acymailing.php:125JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.11 ms After last query: 1.55 ms Query memory: 0.025 MB Memory before query: 18.373 MB Rows returned: 0
SELECT name
FROM fly9i_adsused_categories
WHERE id = 23id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:20JROOT/components/com_adsused/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.29 ms Query memory: 0.025 MB Memory before query: 18.399 MB Rows returned: 0
SELECT name
FROM fly9i_adsused_categories
WHERE id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:20JROOT/components/com_adsused/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 18.425 MB Rows returned: 1
SELECT name
FROM fly9i_adsused_categories
WHERE id = 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsused_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:20JROOT/components/com_adsused/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 18.451 MB Rows returned: 1
SELECT name
FROM fly9i_adsused_categories
WHERE id = 6id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsused_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:20JROOT/components/com_adsused/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 18.477 MB Rows returned: 1
SELECT name
FROM fly9i_adsused_categories
WHERE id = 7id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsused_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:20JROOT/components/com_adsused/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.08 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 18.504 MB Rows returned: 0
SELECT name
FROM fly9i_adsused_categories
WHERE id = 22id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:20JROOT/components/com_adsused/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 18.530 MB Rows returned: 1
SELECT name
FROM fly9i_adsused_categories
WHERE id = 8id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsused_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:20JROOT/components/com_adsused/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 18.556 MB Rows returned: 0
SELECT name
FROM fly9i_adsused_categories
WHERE id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:20JROOT/components/com_adsused/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 18.582 MB Rows returned: 1
SELECT name
FROM fly9i_adsused_categories
WHERE id = 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsused_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:20JROOT/components/com_adsused/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.10 ms After last query: 1.83 ms Query memory: 0.025 MB Memory before query: 18.615 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 18id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 18.642 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 18.668 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.23 ms Query memory: 0.025 MB Memory before query: 18.694 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 29id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:96JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:120JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.28 ms After last query: 17.68 ms Query memory: 0.036 MB Memory before query: 21.308 MB Rows returned: 1
SELECT `params`
FROM `fly9i_comprofiler_plugin`
WHERE `id` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_comprofiler_plugin const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345JROOT/libraries/CBLib/CB/Application/CBConfig.php:43JROOT/libraries/CBLib/CB/Application/CBApplication.php:44JROOT/libraries/CBLib/CBLib/Application/Config.php:38JROOT/libraries/CBLib/CBLib/Core/CBLib.php:70JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:605JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496JROOT/libraries/CBLib/CBLib/Application/Application.php:179JROOT/libraries/CBLib/CB/Application/CBConfig.php:77JROOT/libraries/CBLib/CB/Application/CBConfig.php:77JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:109JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:643JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:132JROOT/administrator/components/com_comprofiler/plugin.foundation.php:33JROOT/modules/mod_cblogin/mod_cblogin.php:17JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.95 ms After last query: 13.37 ms Query memory: 0.033 MB Memory before query: 23.492 MB Rows returned: 16
SHOW FULL COLUMNS
FROM `fly9i_users`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `fly9i_users`Status Duration Starting 0.1 ms checking permissions 0.0 ms closing tables 0.0 ms Opening tables 0.3 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Filling schema table 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms checking permissions 0.1 ms closing tables 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Removing tmp table 0.1 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/table/table.php:229JROOT/libraries/joomla/table/table.php:150JROOT/libraries/joomla/table/user.php:38JROOT/libraries/joomla/table/table.php:294JROOT/libraries/joomla/user/user.php:533JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:160JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:120JROOT/libraries/CBLib/CB/Legacy/CBuser.php:194JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84JROOT/libraries/CBLib/CB/Legacy/CBuser.php:68JROOT/modules/mod_cblogin/mod_cblogin.php:33JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.17 ms After last query: 2.86 ms Query memory: 0.038 MB Memory before query: 23.957 MB Rows returned: 30
SELECT f.*
FROM fly9i_comprofiler_fields f
INNER JOIN fly9i_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
ORDER BY t.position, t.ordering, f.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE f ALL tabid_pub_prof_order NO INDEX KEY COULD BE USED NULL NULL 36 Using where; Using temporary; Using filesort 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 broadcas_2015.f.tabid 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:958JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1075JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1125JROOT/libraries/CBLib/CB/Legacy/CBuser.php:640JROOT/modules/mod_cblogin/mod_cblogin.php:93JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.13 ms After last query: 1.01 ms Query memory: 0.031 MB Memory before query: 24.186 MB Rows returned: 6
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `fly9i_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1)
AND `type` = 'user'
ORDER BY `ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_comprofiler_plugin ref type_pub_order,idx_folder type_pub_order 304 const,const 6 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1004JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1075JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1125JROOT/libraries/CBLib/CB/Legacy/CBuser.php:640JROOT/modules/mod_cblogin/mod_cblogin.php:93JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.21 ms After last query: 24.83 ms Query memory: 0.021 MB Memory before query: 30.013 MB Rows returned: 1
SELECT `id`
FROM `fly9i_menu`
WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
AND `published` = 1
AND `access` IN ( 1 )
AND `language` IN ( 'en-GB', '*', '' )id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL idx_language NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:242JROOT/libraries/CBLib/CB/Legacy/CBframework.php:921JROOT/libraries/CBLib/CB/Legacy/CBframework.php:825JROOT/modules/mod_cblogin/mod_cblogin.php:157JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.15 ms After last query: 4.11 ms Query memory: 0.021 MB Memory before query: 30.499 MB Rows returned: 1
SELECT `id`
FROM `fly9i_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' )
AND `published` = 1
AND `access` IN ( 1 )
AND `language` IN ( 'en-GB', '*', '' )id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL idx_language NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222JROOT/libraries/CBLib/CB/Legacy/CBframework.php:921JROOT/modules/mod_cblogin/tmpl/bootstrap.php:15JROOT/modules/mod_cblogin/mod_cblogin.php:178JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.51 ms Query memory: 0.021 MB Memory before query: 30.520 MB Rows returned: 1
SELECT `id`
FROM `fly9i_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' )
AND `published` = 1
AND `access` IN ( 1 )
AND `language` IN ( 'en-GB', '*', '' )id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL idx_language NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222JROOT/libraries/CBLib/CB/Legacy/CBframework.php:921JROOT/modules/mod_cblogin/tmpl/bootstrap.php:151JROOT/modules/mod_cblogin/mod_cblogin.php:178JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.29 ms Query memory: 0.021 MB Memory before query: 30.541 MB Rows returned: 1
SELECT `id`
FROM `fly9i_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' )
AND `published` = 1
AND `access` IN ( 1 )
AND `language` IN ( 'en-GB', '*', '' )id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL idx_language NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222JROOT/libraries/CBLib/CB/Legacy/CBframework.php:921JROOT/modules/mod_cblogin/tmpl/bootstrap.php:165JROOT/modules/mod_cblogin/mod_cblogin.php:178JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.14 ms After last query: 2.50 ms Query memory: 0.039 MB Memory before query: 30.473 MB Rows returned: 1
SELECT *
FROM fly9i_adsnew_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/configuration.php:27JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:80JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.14 ms Query memory: 0.020 MB Memory before query: 30.511 MB Rows returned: 1
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/helpers/usergroups.php:19JROOT/components/com_adsnew/lib/tpermissions.php:21JROOT/administrator/components/com_adsnew/models/content.php:452JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:84JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 30.532 MB Rows returned: 22
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 22 Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:69JROOT/components/com_adsnew/lib/tpermissions.php:26JROOT/administrator/components/com_adsnew/models/content.php:452JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:84JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 14.63 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 30.551 MB Rows returned: 1
SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
WHERE 1
AND c.published = 1
and a.published = 1
GROUP BY a.id
ORDER BY a.ad_featureditem DESC, a.id DESC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a index PRIMARY PRIMARY 4 NULL 323 Using where; Using temporary; Using filesort 1 SIMPLE adcat ref PRIMARY PRIMARY 4 broadcas_2015.a.id 1 Using index 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 broadcas_2015.adcat.catid 1 Using where 1 SIMPLE p eq_ref PRIMARY PRIMARY 4 broadcas_2015.c.parent 1 Using where 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 broadcas_2015.a.userid 1 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.1 ms Optimizing 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Creating tmp table 0.1 ms Sorting for group 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 7.4 ms Creating sort index 1.1 ms Removing tmp table 5.2 ms Creating sort index 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/content.php:523JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:84JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.16 ms After last query: 1.31 ms Query memory: 0.027 MB Memory before query: 30.610 MB Rows returned: 1
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 24id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:20JROOT/components/com_adsnew/router.php:76JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/modules/mod_adsnew_ads/tmpl/vertical.php:21JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:128JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.43 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 30.636 MB Rows returned: 1
SELECT ad_headline
FROM fly9i_adsnew_ads
WHERE id = 471id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_ads const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/router.php:31JROOT/components/com_adsnew/router.php:77JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsnew/lib/route.php:176JROOT/modules/mod_adsnew_ads/tmpl/vertical.php:21JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:128JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.24 ms After last query: 8.54 ms Query memory: 0.039 MB Memory before query: 31.163 MB Rows returned: 1Duplicate queries: #68
SELECT *
FROM fly9i_adsused_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsused_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsused/models/configuration.php:27JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:80JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.13 ms After last query: 0.29 ms Query memory: 0.020 MB Memory before query: 31.205 MB Rows returned: 1
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/helpers/usergroups.php:19JROOT/components/com_adsused/lib/tpermissions.php:21JROOT/administrator/components/com_adsused/models/content.php:484JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:84JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.13 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 31.225 MB Rows returned: 27
SELECT c.*
FROM fly9i_adsused_categories as c
WHERE 1
ORDER BY c.parent,c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 27 Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsused/models/category.php:69JROOT/components/com_adsused/lib/tpermissions.php:26JROOT/administrator/components/com_adsused/models/content.php:484JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:84JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.15 ms After last query: 0.51 ms Query memory: 0.031 MB Memory before query: 31.244 MB Rows returned: 1
SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user
FROM fly9i_adsused_ads as a
INNER JOIN fly9i_adsused_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsused_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsused_categories as p
ON c.parent = p.id
WHERE 1
AND c.published = 1
and a.published = 1
GROUP BY a.id
ORDER BY a.ad_featureditem DESC, a.id DESC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE adcat index PRIMARY PRIMARY 8 NULL 1302 Using index; Using temporary; Using filesort 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 broadcas_2015.adcat.catid 1 Using where 1 SIMPLE p eq_ref PRIMARY PRIMARY 4 broadcas_2015.c.parent 1 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 broadcas_2015.adcat.adid 1 Using where 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 broadcas_2015.a.userid 1 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsused/models/content.php:555JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:84JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.80 ms Query memory: 0.020 MB Memory before query: 31.308 MB Rows returned: 0
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsused&view=details%'
AND published ='1'
AND type ='component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/lib/route.php:257JROOT/components/com_adsused/lib/route.php:92JROOT/modules/mod_adsused_ads/tmpl/horizontal.php:29JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:133JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.11 ms Query memory: 0.020 MB Memory before query: 31.328 MB Rows returned: 0
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsused&view=list%'
AND link LIKE '%catid=13%'
AND published ='1'
AND type ='component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/lib/route.php:281JROOT/components/com_adsused/lib/route.php:92JROOT/modules/mod_adsused_ads/tmpl/horizontal.php:29JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:133JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.11 ms Query memory: 0.020 MB Memory before query: 31.347 MB Rows returned: 1
SELECT id
FROM fly9i_menu
WHERE link = 'index.php?option=com_adsused&view=front'
AND published ='1'
AND type ='component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/lib/route.php:321JROOT/components/com_adsused/lib/route.php:117JROOT/modules/mod_adsused_ads/tmpl/horizontal.php:29JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:133JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.12 ms After last query: 0.32 ms Query memory: 0.027 MB Memory before query: 31.371 MB Rows returned: 1
SELECT name
FROM fly9i_adsused_categories
WHERE id = 13id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsused_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:20JROOT/components/com_adsused/router.php:76JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsused/lib/route.php:176JROOT/modules/mod_adsused_ads/tmpl/horizontal.php:29JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:133JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.09 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 31.397 MB Rows returned: 1
SELECT ad_headline
FROM fly9i_adsused_ads
WHERE id = 1799id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsused_ads const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsused/router.php:31JROOT/components/com_adsused/router.php:77JROOT/libraries/cms/router/site.php:455JROOT/libraries/cms/router/site.php:413JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/components/com_adsused/lib/route.php:176JROOT/modules/mod_adsused_ads/tmpl/horizontal.php:29JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:133JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.20 ms After last query: 3.65 ms Query memory: 0.039 MB Memory before query: 31.350 MB Rows returned: 1
SELECT *
FROM fly9i_adsnew_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_adsnew_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/configuration.php:27JROOT/modules/mod_adsnew_search/mod_adsnew_search.php:66JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.12 ms After last query: 0.26 ms Query memory: 0.021 MB Memory before query: 31.388 MB Rows returned: 1
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/helpers/usergroups.php:19JROOT/components/com_adsnew/lib/tpermissions.php:21JROOT/administrator/components/com_adsnew/models/category.php:220JROOT/administrator/components/com_adsnew/models/category.php:194JROOT/modules/mod_adsnew_search/mod_adsnew_search.php:75JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 31.410 MB Rows returned: 22
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 22 Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:69JROOT/components/com_adsnew/lib/tpermissions.php:26JROOT/administrator/components/com_adsnew/models/category.php:220JROOT/administrator/components/com_adsnew/models/category.php:194JROOT/modules/mod_adsnew_search/mod_adsnew_search.php:75JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.33 ms Query memory: 0.023 MB Memory before query: 31.429 MB Rows returned: 22
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE c.published = 1
AND c.id IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)
ORDER BY c.parent,c.ordering,c.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 22 Using where; Using filesort Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_adsnew/models/category.php:233JROOT/administrator/components/com_adsnew/models/category.php:194JROOT/modules/mod_adsnew_search/mod_adsnew_search.php:75JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.81 ms Query memory: 0.020 MB Memory before query: 31.523 MB Rows returned: 0
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=result%'
AND published ='1'
AND type ='component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 148 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/components/com_adsnew/lib/route.php:210JROOT/components/com_adsnew/lib/route.php:94JROOT/modules/mod_adsnew_search/tmpl/default.php:30JROOT/modules/mod_adsnew_search/mod_adsnew_search.php:88JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 1.10 ms After last query: 2.30 ms Query memory: 0.031 MB Memory before query: 31.497 MB Rows returned: 6
SHOW FULL COLUMNS
FROM `fly9i_template_styles`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `fly9i_template_styles`Status Duration Starting 0.1 ms checking permissions 0.0 ms closing tables 0.0 ms Opening tables 0.4 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Filling schema table 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms checking permissions 0.1 ms closing tables 0.0 ms Executing 0.0 ms Sending data 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms closing tables 0.0 ms Removing tmp table 0.1 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/table/table.php:229JROOT/libraries/joomla/table/table.php:150JROOT/administrator/components/com_templates/tables/style.php:30JROOT/libraries/joomla/table/table.php:294JROOT/plugins/system/gantry/gantry.php:194JROOT/plugins/system/gantry/gantry.php:165JROOT/plugins/system/gantry/gantry.php:234JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/joomla/document/html/renderer/head.php:64JROOT/libraries/joomla/document/html/renderer/head.php:37JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 31.541 MB Rows returned: 1
SELECT *
FROM fly9i_template_styles
WHERE `id` = '10'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fly9i_template_styles const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms starting 0.0 ms Checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/table/table.php:705JROOT/plugins/system/gantry/gantry.php:168JROOT/plugins/system/gantry/gantry.php:234JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/joomla/document/html/renderer/head.php:64JROOT/libraries/joomla/document/html/renderer/head.php:37JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:992JROOT/libraries/cms/application/site.php:702JROOT/libraries/cms/application/cms.php:261JROOT/index.php:40 - Query Time: 1.16 ms After last query: 5.94 ms Query memory: 0.003 MB Memory before query: 31.659 MB
UPDATE `fly9i_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714362293;s:18:\"session.timer.last\";i:1714362293;s:17:\"session.timer.now\";i:1714362293;s:24:\"session.client.forwarded\";s:12:\"3.145.58.169\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}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;}}' , `time` = '1714362293'
WHERE `session_id` = 'g8ts0qlorp5217i4orivjfjnn7'EXPLAIN not possible on query: UPDATE `fly9i_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714362293;s:18:\"session.timer.last\";i:1714362293;s:17:\"session.timer.now\";i:1714362293;s:24:\"session.client.forwarded\";s:12:\"3.145.58.169\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}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;}}' , `time` = '1714362293' WHERE `session_id` = 'g8ts0qlorp5217i4orivjfjnn7'Status Duration Starting 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms table lock 0.0 ms init for update 0.1 ms Updating 0.1 ms End of update loop 0.0 ms Waiting for query cache lock 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.6 ms closing tables 0.0 ms Unlocking tables 0.0 ms closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/session/storage/database.php:85
54 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
13 × SELECT name
FROM fly9i_adsnew_categories10 × SELECT name
FROM fly9i_adsused_categories9 × SELECT c.*
FROM fly9i_adsnew_categories as c7 × SELECT id,language
FROM fly9i_menu7 × SELECT group_id
FROM fly9i_user_usergroup_map5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions5 × SELECT *
FROM fly9i_adsnew_confi4 × SELECT ad_headline
FROM fly9i_adsnew_ads4 × SELECT `id`
FROM `fly9i_menu`2 × SELECT *
FROM fly9i_adsnew_categories2 × SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id2 × SELECT id, home, template, s.params
FROM fly9i_template_styles as s
LEFT JOIN fly9i_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id2 × SELECT *
FROM fly9i_adsused_confi2 × SELECT id
FROM fly9i_menu1 × SELECT ts.template
FROM fly9i_template_styles AS ts
INNER JOIN fly9i_menu AS m
ON ts.id=m.template_style_id1 × SELECT template
FROM fly9i_template_styles1 × SELECT *
FROM fly9i_acymailing_confi1 × SELECT `params`
FROM `fly9i_comprofiler_plugin`1 × SELECT *
FROM fly9i_acymailing_list1 × SELECT f.*
FROM fly9i_comprofiler_fields f
INNER JOIN fly9i_comprofiler_tabs AS t
ON (f.tabid = t.tabid)1 × SELECT ad_headline
FROM fly9i_adsused_ads1 × SELECT *
FROM fly9i_template_styles1 × SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user
FROM fly9i_adsused_ads as a
INNER JOIN fly9i_adsused_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsused_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsused_categories as p
ON c.parent = p.id1 × SELECT c.*
FROM fly9i_adsused_categories as c1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `fly9i_comprofiler_plugin`1 × SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id1 × SELECT username
FROM fly9i_users1 × SELECT f.*
FROM fly9i_adsnew_fields AS f1 × SELECT *
FROM `fly9i_admintools_wafexceptions`1 × SELECT `value`
FROM `fly9i_admintools_storage`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM fly9i_menu AS m
LEFT JOIN fly9i_extensions AS e
ON m.component_id = e.extension_id1 × SELECT folder AS type, element AS name, params
FROM fly9i_extensions1 × SELECT id, rules
FROM `fly9i_viewlevels1 × SELECT `session_id`
FROM `fly9i_session`1 × SELECT b.id
FROM fly9i_usergroups AS a
LEFT JOIN fly9i_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM fly9i_languages1 × SELECT *
FROM fly9i_adsnew_positions1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM fly9i_modules AS m
LEFT JOIN fly9i_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN fly9i_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT c.id, c.name,c.parent
FROM fly9i_adsnew_categories as c1 × SELECT *
FROM fly9i_adsnew_fields as f1 × SELECT fieldid,cbfieldvalues
FROM fly9i_adsnew_fields as f1 × SELECT `data`
FROM `fly9i_session`1 × SELECT *
FROM fly9i_adsnew_field_values1 × SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_comprofiler as cb
ON cb.user_id = a.userid
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
OTHER Tables:
1 × UPDATE fly9i_adsnew_ads
SET views = LAST_INSERT_ID(views+1)1 × SHOW FULL COLUMNS
FROM `fly9i_users1 × SHOW FULL COLUMNS
FROM `fly9i_template_styles1 × UPDATE `fly9i_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714362293;s:18:\"session.timer.last\";i:1714362293;s:17:\"session.timer.now\";i:1714362293;s:24:\"session.client.forwarded\";s:12:\"3.145.58.169\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}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;}}' , `time` = '1714362293'1 × SHOW FULL COLUMNS
FROM `fly9i_content1 × UPDATE `fly9i_extensions`
SET `params` = '{\"mediaversion\":\"35e7d527e92e4192b2270d2d00bcb220\",\"Array\":[\"28e48f90f35034c8274bcd7e437a465a\"]}'1 × INSERT INTO `fly9i_session` (`session_id`, `client_id`, `time`)
VALUES ('g8ts0qlorp5217i4orivjfjnn7', 0, '1714362293'1 × SHOW TABLE
1 × SHOW FULL COLUMNS
FROM fly9i_acymailing_actio1 × DELETE
FROM `fly9i_session`