Query Time: 0.64 ms Query memory: 0.015 MB Memory before query: 2.491 MB Rows returned: 0
SELECT `data`
FROM `zqbnp_session`
WHERE `session_id` = '9lblql8hhv61com9kjil2635r3'
EXPLAIN not possible on query: SELECT `data`
FROM `zqbnp_session`
WHERE `session_id` = '9lblql8hhv61com9kjil2635r3'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:651
JROOT/libraries/joomla/session/session.php:589
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
Query Time: 0.50 ms After last query: 2.64 ms Query memory: 0.012 MB Memory before query: 2.681 MB Rows returned: 0
SELECT `session_id`
FROM `zqbnp_session`
WHERE `session_id` = '9lblql8hhv61com9kjil2635r3'
LIMIT 0, 1
EXPLAIN not possible on query: SELECT `session_id`
FROM `zqbnp_session`
WHERE `session_id` = '9lblql8hhv61com9kjil2635r3' LIMIT 0, 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
Query Time: 3.32 ms After last query: 0.29 ms Query memory: 0.009 MB Memory before query: 2.694 MB
INSERT INTO `zqbnp_session`
(`session_id`, `client_id`, `time`)
VALUES
('9lblql8hhv61com9kjil2635r3', 0, '1743063102')
EXPLAIN not possible on query: INSERT INTO `zqbnp_session`
(`session_id`, `client_id`, `time`) VALUES
('9lblql8hhv61com9kjil2635r3', 0, '1743063102')
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
Query Time: 1.05 ms After last query: 4.49 ms Query memory: 0.024 MB Memory before query: 3.062 MB Rows returned: 43
SELECT extension_id AS id, element AS "option", params, enabled
FROM zqbnp_extensions
WHERE `type` = 'component'
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM zqbnp_extensions
WHERE `type` = 'component'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:435
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:120
JROOT/libraries/cms/application/site.php:584
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.72 ms After last query: 1.86 ms Query memory: 0.014 MB Memory before query: 3.234 MB Rows returned: 1
SELECT b.id
FROM zqbnp_usergroups AS a
LEFT JOIN zqbnp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
EXPLAIN not possible on query: SELECT b.id
FROM zqbnp_usergroups AS a
LEFT JOIN zqbnp_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.50 ms After last query: 0.73 ms Query memory: 0.013 MB Memory before query: 3.290 MB Rows returned: 3
SELECT id, rules
FROM `zqbnp_viewlevels`
EXPLAIN not possible on query: SELECT id, rules
FROM `zqbnp_viewlevels`
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 1.25 ms After last query: 0.29 ms Query memory: 0.013 MB Memory before query: 3.308 MB Rows returned: 71
SELECT folder AS type, element AS name, params
FROM zqbnp_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
EXPLAIN not possible on query: SELECT folder AS type, element AS name, params
FROM zqbnp_extensions
WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1)
ORDER BY ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.64 ms After last query: 27.29 ms Query memory: 0.015 MB Memory before query: 5.303 MB Rows returned: 0
SELECT *
FROM `zqbnp_rsseo_redirects`
WHERE `published` = 1
EXPLAIN not possible on query: SELECT *
FROM `zqbnp_rsseo_redirects`
WHERE `published` = 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rsseo/rsseo.php:124
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:654
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 1.69 ms After last query: 5.90 ms Query memory: 0.032 MB Memory before query: 5.805 MB Rows returned: 54
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 zqbnp_menu AS m
LEFT JOIN zqbnp_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.lft
EXPLAIN not possible on query: 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 zqbnp_menu AS m
LEFT JOIN zqbnp_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.lft
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/router/site.php:57
JROOT/libraries/cms/router/router.php:196
JROOT/libraries/cms/application/cms.php:520
JROOT/libraries/cms/application/site.php:407
JROOT/libraries/cms/application/cms.php:1088
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.63 ms After last query: 9.65 ms Query memory: 0.024 MB Memory before query: 6.690 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM zqbnp_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM zqbnp_extensions
WHERE `type` = 'library' AND `element` = 'joomla'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/k2/k2.php:52
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 2.85 ms After last query: 0.36 ms Query memory: 0.017 MB Memory before query: 6.698 MB
UPDATE `zqbnp_extensions`
SET `params` = '{\"mediaversion\":\"1ab120c0c2fec7aa21b59c4a1a89bf42\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `zqbnp_extensions`
SET `params` = '{\"mediaversion\":\"1ab120c0c2fec7aa21b59c4a1a89bf42\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/k2/k2.php:52
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.56 ms After last query: 4.05 ms Query memory: 0.022 MB Memory before query: 7.075 MB Rows returned: 1
SELECT *
FROM zqbnp_languages
WHERE published=1
ORDER BY ordering ASC
EXPLAIN not possible on query: SELECT *
FROM zqbnp_languages
WHERE published=1
ORDER BY ordering ASC
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/language/helper.php:164
JROOT/libraries/cms/application/site.php:329
JROOT/components/com_k2/helpers/utilities.php:315
JROOT/administrator/components/com_k2/helpers/html.php:56
JROOT/plugins/system/k2/k2.php:55
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.79 ms After last query: 3.31 ms Query memory: 0.027 MB Memory before query: 7.370 MB Rows returned: 8
SELECT id, home, template, s.params
FROM zqbnp_template_styles as s
LEFT JOIN zqbnp_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 = 1
EXPLAIN not possible on query: SELECT id, home, template, s.params
FROM zqbnp_template_styles as s
LEFT JOIN zqbnp_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 = 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/site.php:484
JROOT/libraries/cms/html/html.php:334
JROOT/libraries/cms/html/html.php:680
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/libraries/cms/html/behavior.php:61
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/administrator/components/com_k2/helpers/html.php:76
JROOT/plugins/system/k2/k2.php:55
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 2.48 ms After last query: 30.70 ms Query memory: 0.031 MB Memory before query: 8.963 MB Rows returned: 4
SHOW FULL COLUMNS
FROM `zqbnp_socialbacklinks_configs`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zqbnp_socialbacklinks_configs`
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/administrator/components/com_socialbacklinks/tables/config.php:31
JROOT/libraries/joomla/table/table.php:305
JROOT/libraries/legacy/model/legacy.php:383
JROOT/libraries/legacy/model/legacy.php:467
JROOT/administrator/components/com_socialbacklinks/models/base.php:148
JROOT/administrator/components/com_socialbacklinks/models/base.php:197
JROOT/administrator/components/com_socialbacklinks/models/base.php:303
JROOT/administrator/components/com_socialbacklinks/helpers/config.php:67
JROOT/administrator/components/com_socialbacklinks/helpers/config.php:164
JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.52 ms After last query: 0.83 ms Query memory: 0.021 MB Memory before query: 9.019 MB Rows returned: 10
SELECT DISTINCT *
FROM zqbnp_socialbacklinks_configs
EXPLAIN not possible on query: SELECT DISTINCT * FROM zqbnp_socialbacklinks_configs
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/legacy/model/legacy.php:312
JROOT/administrator/components/com_socialbacklinks/models/base.php:304
JROOT/administrator/components/com_socialbacklinks/helpers/config.php:67
JROOT/administrator/components/com_socialbacklinks/helpers/config.php:164
JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.62 ms After last query: 2.17 ms Query memory: 0.020 MB Memory before query: 9.189 MB Rows returned: 1
SELECT *
FROM zqbnp_socialbacklinks_configs
WHERE `section` = 'basic'
AND `name` = 'last_sync'
EXPLAIN not possible on query: SELECT *
FROM zqbnp_socialbacklinks_configs
WHERE `section` = 'basic' AND `name` = 'last_sync'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:728
JROOT/administrator/components/com_socialbacklinks/models/base.php:316
JROOT/administrator/components/com_socialbacklinks/helpers/sync.php:131
JROOT/administrator/components/com_socialbacklinks/helpers/sync.php:84
JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:73
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.44 ms After last query: 0.56 ms Query memory: 0.019 MB Memory before query: 9.209 MB Rows returned: 1
SELECT *
FROM zqbnp_socialbacklinks_configs
WHERE `section` = 'basic'
AND `name` = 'sync_periodicity'
EXPLAIN not possible on query: SELECT *
FROM zqbnp_socialbacklinks_configs
WHERE `section` = 'basic' AND `name` = 'sync_periodicity'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:728
JROOT/administrator/components/com_socialbacklinks/models/base.php:316
JROOT/administrator/components/com_socialbacklinks/helpers/sync.php:88
JROOT/plugins/system/sbsynchronizer/sbsynchronizer.php:73
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.70 ms After last query: 10.85 ms Query memory: 0.023 MB Memory before query: 10.023 MB Rows returned: 1
SELECT a.rules
FROM zqbnp_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
EXPLAIN not possible on query: SELECT a.rules
FROM zqbnp_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/components/com_phocaguestbook/models/guestbook.php:167
JROOT/libraries/legacy/model/legacy.php:439
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:34
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocaguestbook/controller.php:42
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocaguestbook/phocaguestbook.php:18
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 1.16 ms After last query: 0.78 ms Query memory: 0.024 MB Memory before query: 10.078 MB Rows returned: 2
SELECT b.rules
FROM zqbnp_assets AS a
LEFT JOIN zqbnp_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_phocaguestbook')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
EXPLAIN not possible on query: SELECT b.rules
FROM zqbnp_assets AS a
LEFT JOIN zqbnp_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_phocaguestbook')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/components/com_phocaguestbook/models/guestbook.php:167
JROOT/libraries/legacy/model/legacy.php:439
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:34
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocaguestbook/controller.php:42
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocaguestbook/phocaguestbook.php:18
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 2.39 ms After last query: 1.68 ms Query memory: 0.028 MB Memory before query: 10.223 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM zqbnp_categories as c
LEFT JOIN zqbnp_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM zqbnp_categories AS cat JOIN zqbnp_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_phocaguestbook'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_phocaguestbook' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=49
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
EXPLAIN not possible on query: SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM zqbnp_categories as c
LEFT JOIN zqbnp_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id FROM zqbnp_categories AS cat JOIN zqbnp_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_phocaguestbook' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE (c.extension='com_phocaguestbook' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=49 AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_phocaguestbook/models/guestbook.php:362
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:35
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocaguestbook/controller.php:42
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocaguestbook/phocaguestbook.php:18
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.85 ms After last query: 0.32 ms Query memory: 0.023 MB Memory before query: 10.256 MB Rows returned: 3
SELECT b.rules
FROM zqbnp_assets AS a
LEFT JOIN zqbnp_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_phocaguestbook.category.49')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
EXPLAIN not possible on query: SELECT b.rules
FROM zqbnp_assets AS a
LEFT JOIN zqbnp_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_phocaguestbook.category.49')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/components/com_phocaguestbook/models/guestbook.php:372
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:35
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocaguestbook/controller.php:42
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocaguestbook/phocaguestbook.php:18
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 16.11 ms After last query: 0.95 ms Query memory: 0.026 MB Memory before query: 10.316 MB Rows returned: 5
SELECT aOrd, bOrd, d.*, d.lft AS dOrd
FROM ( SELECT mainOrd AS aOrd, b.lft AS bOrd, b.*
FROM ( SELECT *, rgt AS mainOrd
FROM `zqbnp_phocaguestbook_items`
WHERE catid = 49
AND published = 1
AND level = 1
ORDER BY rgt DESC
LIMIT 10,5 ) AS a JOIN `zqbnp_phocaguestbook_items` AS b
ON (a.id=b.parent_id
AND b.level=2) OR a.id=b.id
WHERE b.catid = 49
AND b.published = 1 ) AS c JOIN `zqbnp_phocaguestbook_items` AS d
ON (c.id=d.parent_id
AND d.level>=3) OR c.id=d.id
WHERE d.catid = 49
AND d.published = 1
ORDER BY aOrd DESC, bOrd ASC, dOrd ASC
EXPLAIN not possible on query: SELECT aOrd, bOrd, d.*, d.lft AS dOrd FROM ( SELECT mainOrd AS aOrd, b.lft AS bOrd, b.*FROM ( SELECT *, rgt AS mainOrd FROM `zqbnp_phocaguestbook_items` WHERE catid = 49 AND published = 1 AND level = 1 ORDER BY rgt DESC LIMIT 10,5 ) AS a JOIN `zqbnp_phocaguestbook_items` AS b ON (a.id=b.parent_id AND b.level=2) OR a.id=b.id WHERE b.catid = 49 AND b.published = 1 ) AS c JOIN `zqbnp_phocaguestbook_items` AS d ON (c.id=d.parent_id AND d.level>=3) OR c.id=d.id WHERE d.catid = 49 AND d.published = 1 ORDER BY aOrd DESC, bOrd ASC, dOrd ASC
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/legacy/model/legacy.php:312
JROOT/components/com_phocaguestbook/models/guestbook.php:324
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:101
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocaguestbook/controller.php:42
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocaguestbook/phocaguestbook.php:18
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 1.73 ms After last query: 0.36 ms Query memory: 0.021 MB Memory before query: 10.372 MB Rows returned: 1
SELECT COUNT(*)
FROM `zqbnp_phocaguestbook_items`
WHERE catid = 49
AND published = 1
AND level = 1
EXPLAIN not possible on query: SELECT COUNT(*)
FROM `zqbnp_phocaguestbook_items`
WHERE catid = 49 AND published = 1 AND level = 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/legacy/model/legacy.php:341
JROOT/components/com_phocaguestbook/models/guestbook.php:337
JROOT/components/com_phocaguestbook/models/guestbook.php:350
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:102
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocaguestbook/controller.php:42
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocaguestbook/phocaguestbook.php:18
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.61 ms After last query: 30.74 ms Query memory: 0.021 MB Memory before query: 11.839 MB Rows returned: 1
SELECT params
FROM zqbnp_extensions AS e
WHERE e.element='com_widgetkit'
EXPLAIN not possible on query: SELECT params FROM zqbnp_extensions AS e WHERE e.element='com_widgetkit'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_widgetkit/helpers/system.php:254
JROOT/administrator/components/com_widgetkit/helpers/system.php:54
JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
JROOT/administrator/components/com_widgetkit/widgetkit.php:17
JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.59 ms After last query: 20.23 ms Query memory: 0.015 MB Memory before query: 12.716 MB Rows returned: 1
SELECT `params`
FROM zqbnp_extensions
WHERE `type` = 'component'
AND `element` = 'com_rsseo'
EXPLAIN not possible on query: SELECT `params`
FROM zqbnp_extensions
WHERE `type` = 'component' AND `element` = 'com_rsseo'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_rsseo/helpers/rsseo.php:42
JROOT/plugins/system/rsseo/rsseo.php:68
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.64 ms After last query: 0.41 ms Query memory: 0.016 MB Memory before query: 12.742 MB Rows returned: 0
SELECT `id`, `title`, `description`, `keywords`, `level`, `crawled`, `modified`, `canonical`, `robots`
FROM `zqbnp_rsseo_pages`
WHERE `url` = 'testimonials?start=10'
AND `published` = 1
LIMIT 0, 1
EXPLAIN not possible on query: SELECT `id`, `title`, `description`, `keywords`, `level`, `crawled`, `modified`, `canonical`, `robots`
FROM `zqbnp_rsseo_pages`
WHERE `url` = 'testimonials?start=10' AND `published` = 1 LIMIT 0, 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rsseo/rsseo.php:353
JROOT/plugins/system/rsseo/rsseo.php:101
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Query Time: 0.53 ms After last query: 2.62 ms Query memory: 0.016 MB Memory before query: 13.002 MB Rows returned: 1
SELECT *
FROM zqbnp_template_styles
WHERE template = 'traction';
EXPLAIN not possible on query: SELECT * FROM zqbnp_template_styles WHERE template = 'traction';
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/templates/traction/vertex/parameters.php:19
JROOT/templates/traction/vertex/parameters.php:144
JROOT/templates/traction/index.php:21
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Query Time: 0.56 ms After last query: 0.17 ms Query memory: 0.020 MB Memory before query: 13.020 MB Rows returned: 0
SELECT *
FROM zqbnp_menu
WHERE template_style_id IN (23)
AND alias = 'testimonials'
EXPLAIN not possible on query: SELECT * FROM zqbnp_menu WHERE template_style_id IN (23) AND alias = 'testimonials'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/templates/traction/vertex/parameters.php:40
JROOT/templates/traction/vertex/parameters.php:144
JROOT/templates/traction/index.php:21
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Query Time: 2.30 ms After last query: 8.45 ms Query memory: 0.021 MB Memory before query: 13.412 MB Rows returned: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zqbnp_modules AS m
LEFT JOIN zqbnp_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN zqbnp_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 <= '2025-03-27 08:11:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-27 08:11:42')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 302 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zqbnp_modules AS m
LEFT JOIN zqbnp_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN zqbnp_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 <= '2025-03-27 08:11:42') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-27 08:11:42') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 302 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/module/helper.php:407
JROOT/libraries/cms/module/helper.php:350
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:501
JROOT/templates/traction/vertex/module_calcs.php:15
JROOT/templates/traction/index.php:23
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Query Time: 0.50 ms After last query: 4.58 ms Query memory: 0.017 MB Memory before query: 13.335 MB Rows returned: 0
SELECT menutype
FROM zqbnp_menu
WHERE language = 'en-GB'
AND home = 1
EXPLAIN not possible on query: SELECT menutype FROM zqbnp_menu WHERE language = 'en-GB' AND home = 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/templates/traction/vertex/responsive/responsive_mobile_menu.php:139
JROOT/templates/traction/vertex/responsive/responsive_mobile_top_bar.php:75
JROOT/templates/traction/vertex/includes/vertex_includes_top.php:3
JROOT/templates/traction/index.php:151
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Query Time: 0.46 ms After last query: 9.20 ms Query memory: 0.015 MB Memory before query: 13.693 MB Rows returned: 0
SELECT menutype
FROM zqbnp_menu
WHERE language = 'en-GB'
AND home = 1
EXPLAIN not possible on query: SELECT menutype FROM zqbnp_menu WHERE language = 'en-GB' AND home = 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/templates/traction/vertex/s5flex_menu/default.php:45
JROOT/templates/traction/index.php:205
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Query Time: 1.30 ms After last query: 2.35 ms Query memory: 0.031 MB Memory before query: 13.923 MB Rows returned: 54
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 zqbnp_menu AS m
LEFT JOIN zqbnp_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.lft
EXPLAIN not possible on query: 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 zqbnp_menu AS m
LEFT JOIN zqbnp_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.lft
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/templates/traction/vertex/s5flex_menu/helpers.php:41
JROOT/templates/traction/vertex/s5flex_menu/helpers.php:141
JROOT/templates/traction/vertex/s5flex_menu/default.php:54
JROOT/templates/traction/index.php:205
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Query Time: 0.67 ms After last query: 23.29 ms Query memory: 0.021 MB Memory before query: 14.380 MB Rows returned: 1
SELECT *
FROM zqbnp_widgetkit_widget
WHERE id=1
EXPLAIN not possible on query: SELECT * FROM zqbnp_widgetkit_widget WHERE id=1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_widgetkit/helpers/widget.php:42
JROOT/administrator/components/com_widgetkit/helpers/widget.php:160
JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Query Time: 3.67 ms After last query: 1.15 ms Query memory: 0.032 MB Memory before query: 14.470 MB Rows returned: 30
SHOW FULL COLUMNS
FROM `zqbnp_content`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `zqbnp_content`
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/legacy/table/content.php:31
JROOT/libraries/joomla/table/table.php:305
JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:101
JROOT/administrator/components/com_widgetkit/classes/helper.php:64
JROOT/administrator/components/com_widgetkit/helpers/event.php:53
JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Query Time: 1.22 ms After last query: 77.45 ms Query memory: 0.017 MB Memory before query: 15.145 MB Rows returned: 2
SELECT b.rules
FROM zqbnp_assets AS a
LEFT JOIN zqbnp_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_categories')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
EXPLAIN not possible on query: SELECT b.rules
FROM zqbnp_assets AS a
LEFT JOIN zqbnp_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_categories')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/plugins/system/aclmanager/aclmanager.php:121
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1065
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Query Time: 0.61 ms After last query: 1.26 ms Query memory: 0.016 MB Memory before query: 15.225 MB Rows returned: 5
SELECT *
FROM `zqbnp_rsseo_keywords`
ORDER BY CHAR_LENGTH(keyword) DESC
EXPLAIN not possible on query: SELECT *
FROM `zqbnp_rsseo_keywords`
ORDER BY CHAR_LENGTH(keyword) DESC
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rsseo/rsseo.php:198
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1065
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
3 × SELECT b.rules
FROM zqbnp_assets AS a
LEFT JOIN zqbnp_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
2 × SELECT *
FROM zqbnp_socialbacklinks_configs
2 × SELECT menutype
FROM zqbnp_menu
2 × 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 zqbnp_menu AS m
LEFT JOIN zqbnp_extensions AS e
ON m.component_id = e.extension_id
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM zqbnp_extensions
1 × SELECT params
FROM zqbnp_extensions AS e
1 × SELECT *
FROM `zqbnp_rsseo_keywords`
1 × SELECT COUNT(*)
FROM `zqbnp_phocaguestbook_items`
1 × SELECT `params`
FROM zqbnp_extensions
1 × SELECT `id`, `title`, `description`, `keywords`, `level`, `crawled`, `modified`, `canonical`, `robots`
FROM `zqbnp_rsseo_pages`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zqbnp_modules AS m
LEFT JOIN zqbnp_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN zqbnp_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM zqbnp_menu
1 × SELECT aOrd, bOrd, d.*, d.lft AS dOrd
FROM ( SELECT mainOrd AS aOrd, b.lft AS bOrd, b.*
FROM ( SELECT *, rgt AS mainOrd
FROM `zqbnp_phocaguestbook_items`
1 × SELECT *
FROM zqbnp_template_styles
1 × SELECT *
FROM zqbnp_widgetkit_widget
1 × SELECT a.rules
FROM zqbnp_assets AS a
1 × SELECT folder AS type, element AS name, params
FROM zqbnp_extensions
1 × SELECT id, rules
FROM `zqbnp_viewlevels
1 × SELECT b.id
FROM zqbnp_usergroups AS a
LEFT JOIN zqbnp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `zqbnp_session`
1 × SELECT *
FROM `zqbnp_rsseo_redirects`
1 × SELECT *
FROM zqbnp_languages
1 × SELECT `data`
FROM `zqbnp_session`
1 × SELECT DISTINCT *
FROM zqbnp_socialbacklinks_config
1 × SELECT id, home, template, s.params
FROM zqbnp_template_styles as s
LEFT JOIN zqbnp_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM zqbnp_categories as c
LEFT JOIN zqbnp_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM zqbnp_categories AS cat JOIN zqbnp_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
