Query Time: 0.28 ms
SELECT `data`
FROM `d3upb_session`
WHERE `session_id` = 'cc22cf80e91e1adffe237109b4935339'
EXPLAIN not possible on query: SELECT `data`
FROM `d3upb_session`
WHERE `session_id` = 'cc22cf80e91e1adffe237109b4935339'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:658
JROOT/libraries/joomla/session/session.php:596
JROOT/libraries/cms/application/cms.php:662
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:322
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
Query Time: 0.20 ms After last query: 2.64 ms
DELETE
FROM `d3upb_session`
WHERE `time` < '1527167521'
EXPLAIN not possible on query: DELETE
FROM `d3upb_session`
WHERE `time` < '1527167521'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:679
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:322
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
Query Time: 0.19 ms After last query: 0.17 ms
SELECT `session_id`
FROM `d3upb_session`
WHERE `session_id` = 'cc22cf80e91e1adffe237109b4935339'
LIMIT 0, 1
EXPLAIN not possible on query: SELECT `session_id`
FROM `d3upb_session`
WHERE `session_id` = 'cc22cf80e91e1adffe237109b4935339' LIMIT 0, 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:688
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:322
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
Query Time: 0.27 ms After last query: 0.17 ms
INSERT INTO `d3upb_session`
(`session_id`, `client_id`, `time`)
VALUES
('cc22cf80e91e1adffe237109b4935339', 0, '1527168421')
EXPLAIN not possible on query: INSERT INTO `d3upb_session`
(`session_id`, `client_id`, `time`) VALUES
('cc22cf80e91e1adffe237109b4935339', 0, '1527168421')
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:688
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:322
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
Query Time: 0.30 ms After last query: 5.74 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_extensions
WHERE `type` = 'component' AND `element` = 'com_users'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:557
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.15 ms After last query: 1.93 ms
SELECT b.id
FROM d3upb_usergroups AS a
LEFT JOIN d3upb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
EXPLAIN not possible on query: SELECT b.id
FROM d3upb_usergroups AS a
LEFT JOIN d3upb_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 9
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:336
JROOT/libraries/joomla/access/access.php:405
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:562
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.11 ms After last query: 0.90 ms
SELECT id, rules
FROM `d3upb_viewlevels`
EXPLAIN not possible on query: SELECT id, rules
FROM `d3upb_viewlevels`
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:422
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:562
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.57 ms After last query: 0.21 ms
SELECT folder AS type, element AS name, params
FROM d3upb_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,5)
ORDER BY ordering
EXPLAIN not possible on query: SELECT folder AS type, element AS name, params
FROM d3upb_extensions
WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,5)
ORDER BY ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:562
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.26 ms After last query: 0.31 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_extensions
WHERE `type` = 'component' AND `element` = 'com_languages'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:615
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.70 ms After last query: 16.04 ms
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 d3upb_menu AS m
LEFT JOIN d3upb_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 d3upb_menu AS m
LEFT JOIN d3upb_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:47
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:347
JROOT/libraries/cms/application/site.php:266
JROOT/libraries/cms/router/site.php:218
JROOT/libraries/cms/router/router.php:408
JROOT/libraries/cms/router/router.php:192
JROOT/libraries/cms/router/site.php:90
JROOT/libraries/cms/application/cms.php:1012
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.27 ms After last query: 1.93 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_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:158
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:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/sef/sef.php:30
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1021
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.56 ms After last query: 0.30 ms
UPDATE `d3upb_extensions`
SET `params` = '{\"mediaversion\":\"f5a58350ea53ce8ca517d08fbf97e3b4\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `d3upb_extensions`
SET `params` = '{\"mediaversion\":\"f5a58350ea53ce8ca517d08fbf97e3b4\"}'
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:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/sef/sef.php:30
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1021
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.39 ms After last query: 9.54 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_extensions
WHERE `type` = 'component'
AND `element` = 'com_phocagallery'
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_extensions
WHERE `type` = 'component' AND `element` = 'com_phocagallery'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:315
JROOT/libraries/cms/application/site.php:122
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.21 ms After last query: 1.65 ms
SELECT *
FROM d3upb_languages
WHERE published=1
ORDER BY ordering ASC
EXPLAIN not possible on query: SELECT *
FROM d3upb_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:166
JROOT/libraries/cms/application/site.php:323
JROOT/libraries/cms/application/site.php:122
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.36 ms After last query: 0.51 ms
SELECT id, home, template, s.params
FROM d3upb_template_styles as s
LEFT JOIN d3upb_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 d3upb_template_styles as s
LEFT JOIN d3upb_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:473
JROOT/libraries/cms/application/site.php:152
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.33 ms After last query: 27.46 ms
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM d3upb_phocagallery_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASC
EXPLAIN not possible on query: SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM d3upb_phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:722
JROOT/components/com_phocagallery/views/category/view.html.php:63
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_phocagallery/phocagallery.php:55
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.17 ms After last query: 6.07 ms
SELECT a.*
FROM d3upb_phocagallery_fb_users AS a
WHERE a.id =0
EXPLAIN not possible on query: SELECT a.* FROM d3upb_phocagallery_fb_users AS a WHERE a.id =0
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:46
JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:53
JROOT/components/com_phocagallery/views/category/view.html.php:203
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_phocagallery/phocagallery.php:55
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.33 ms After last query: 6.30 ms
SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM d3upb_phocagallery_categories AS c
WHERE c.id = 1
LIMIT 0, 1
EXPLAIN not possible on query: SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM d3upb_phocagallery_categories AS c WHERE c.id = 1 LIMIT 0, 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_phocagallery/models/category.php:212
JROOT/components/com_phocagallery/models/category.php:169
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_phocagallery/views/category/view.html.php:374
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_phocagallery/phocagallery.php:55
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.24 ms After last query: 2.32 ms
SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access
FROM d3upb_phocagallery_categories AS cc
WHERE cc.id = 0
AND cc.published = 1
AND cc.approved = 1
AND cc.id <> 1
ORDER BY cc.ordering ASC
LIMIT 0, 1
EXPLAIN not possible on query: SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access FROM d3upb_phocagallery_categories AS cc WHERE cc.id = 0 AND cc.published = 1 AND cc.approved = 1 AND cc.id <> 1 ORDER BY cc.ordering ASC LIMIT 0, 1
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_phocagallery/models/category.php:240
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_phocagallery/views/category/view.html.php:569
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_phocagallery/phocagallery.php:55
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.61 ms After last query: 3.27 ms
SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, a.filename, a.extm, a.exts, a.extw, a.exth, a.extid
FROM d3upb_phocagallery_categories AS cc
LEFT JOIN d3upb_phocagallery AS a
ON cc.id = a.catid
WHERE cc.parent_id = 1
AND cc.published = 1
AND cc.approved = 1
AND cc.id <> 1
GROUP BY cc.id
ORDER BY cc.ordering ASC
EXPLAIN not possible on query: SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, a.filename, a.extm, a.exts, a.extw, a.exth, a.extid FROM d3upb_phocagallery_categories AS cc LEFT JOIN d3upb_phocagallery AS a ON cc.id = a.catid WHERE cc.parent_id = 1 AND cc.published = 1 AND cc.approved = 1 AND cc.id <> 1 GROUP BY cc.id ORDER BY cc.ordering ASC
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_phocagallery/models/category.php:282
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_phocagallery/views/category/view.html.php:727
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_phocagallery/phocagallery.php:55
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 5.06 ms After last query: 0.16 ms
SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM d3upb_phocagallery AS a
LEFT JOIN d3upb_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id
LEFT JOIN d3upb_phocagallery_categories AS cc
ON cc.id = a.catid
WHERE a.catid= 1
AND a.published = 1
AND a.approved = 1
ORDER BY a.ordering ASC
LIMIT 0, 100
EXPLAIN not possible on query: SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM d3upb_phocagallery AS a LEFT JOIN d3upb_phocagallery_img_votes_statistics AS r ON r.imgid = a.id LEFT JOIN d3upb_phocagallery_categories AS cc ON cc.id = a.catid WHERE a.catid= 1 AND a.published = 1 AND a.approved = 1 ORDER BY a.ordering ASC LIMIT 0, 100
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/legacy/model/legacy.php:301
JROOT/components/com_phocagallery/models/category.php:67
JROOT/components/com_phocagallery/views/category/view.html.php:944
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_phocagallery/phocagallery.php:55
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 4.73 ms After last query: 4.92 ms
SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM d3upb_phocagallery AS a
LEFT JOIN d3upb_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id
LEFT JOIN d3upb_phocagallery_categories AS cc
ON cc.id = a.catid
WHERE a.catid= 1
AND a.published = 1
AND a.approved = 1
ORDER BY a.ordering ASC
EXPLAIN not possible on query: SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM d3upb_phocagallery AS a LEFT JOIN d3upb_phocagallery_img_votes_statistics AS r ON r.imgid = a.id LEFT JOIN d3upb_phocagallery_categories AS cc ON cc.id = a.catid WHERE a.catid= 1 AND a.published = 1 AND a.approved = 1 ORDER BY a.ordering ASC
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/legacy/model/legacy.php:332
JROOT/components/com_phocagallery/models/category.php:75
JROOT/components/com_phocagallery/models/category.php:83
JROOT/components/com_phocagallery/views/category/view.html.php:945
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_phocagallery/phocagallery.php:55
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 1.16 ms After last query: 120.68 ms
SHOW FULL COLUMNS
FROM `d3upb_phocagallery_categories`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `d3upb_phocagallery_categories`
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:229
JROOT/libraries/joomla/table/table.php:150
JROOT/administrator/components/com_phocagallery/tables/phocagalleryc.php:16
JROOT/libraries/joomla/table/table.php:294
JROOT/components/com_phocagallery/models/category.php:542
JROOT/components/com_phocagallery/views/category/view.html.php:1879
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_phocagallery/phocagallery.php:55
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.44 ms After last query: 1.84 ms
UPDATE d3upb_phocagallery_categories
SET `hits` = (`hits` + 1)
WHERE `id` = '1'
EXPLAIN not possible on query: UPDATE d3upb_phocagallery_categories
SET `hits` = (`hits` + 1)
WHERE `id` = '1'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:1215
JROOT/components/com_phocagallery/models/category.php:543
JROOT/components/com_phocagallery/views/category/view.html.php:1879
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_phocagallery/phocagallery.php:55
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
Query Time: 0.34 ms After last query: 24.19 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_extensions
WHERE `type` = 'component' AND `element` = 'com_content'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:315
JROOT/templates/as002066free/includes/includes.php:17
JROOT/templates/as002066free/index.php:13
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:968
JROOT/libraries/cms/application/site.php:718
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
Query Time: 0.65 ms After last query: 9.22 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM d3upb_modules AS m
LEFT JOIN d3upb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN d3upb_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 <= '2018-05-24 13:27:01')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-05-24 13:27:01')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 128 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 d3upb_modules AS m
LEFT JOIN d3upb_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN d3upb_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 <= '2018-05-24 13:27:01') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-05-24 13:27:01') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 128 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:376
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:497
JROOT/templates/as002066free/params.php:142
JROOT/templates/as002066free/index.php:60
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:968
JROOT/libraries/cms/application/site.php:718
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
Query Time: 0.27 ms After last query: 17.70 ms
SELECT *
FROM d3upb_modules
WHERE published=1
ORDER BY id
;
EXPLAIN not possible on query: SELECT *
FROM d3upb_modules
WHERE published=1
ORDER BY id
;
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/modules/mod_maximenuck/helper.php:352
JROOT/modules/mod_maximenuck/helper.php:55
JROOT/modules/mod_maximenuck/mod_maximenuck.php:21
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:982
JROOT/libraries/cms/application/site.php:718
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
Query Time: 0.37 ms After last query: 21.24 ms
UPDATE `d3upb_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1527168421;s:18:\"session.timer.last\";i:1527168421;s:17:\"session.timer.now\";i:1527168421;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{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:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"158aad36fb05b6894407030f883bdb49\";}'
, `time` = '1527168421'
WHERE `session_id` = 'cc22cf80e91e1adffe237109b4935339'
EXPLAIN not possible on query: UPDATE `d3upb_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1527168421;s:18:\"session.timer.last\";i:1527168421;s:17:\"session.timer.now\";i:1527168421;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{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:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"158aad36fb05b6894407030f883bdb49\";}'
, `time` = '1527168421'
WHERE `session_id` = 'cc22cf80e91e1adffe237109b4935339'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/session/storage/database.php:85
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM d3upb_extensions
2 × SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM d3upb_phocagallery AS a
LEFT JOIN d3upb_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id
LEFT JOIN d3upb_phocagallery_categories AS cc
ON cc.id = a.catid
1 × SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM d3upb_phocagallery_categories AS c
1 × SELECT a.*
FROM d3upb_phocagallery_fb_users AS a
1 × SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access
FROM d3upb_phocagallery_categories AS cc
1 × SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, a.filename, a.extm, a.exts, a.extw, a.exth, a.extid
FROM d3upb_phocagallery_categories AS cc
LEFT JOIN d3upb_phocagallery AS a
ON cc.id = a.catid
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM d3upb_modules AS m
LEFT JOIN d3upb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN d3upb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM d3upb_phocagallery_styles AS a
1 × SELECT *
FROM d3upb_modules
1 × SELECT id, home, template, s.params
FROM d3upb_template_styles as s
LEFT JOIN d3upb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT b.id
FROM d3upb_usergroups AS a
LEFT JOIN d3upb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `d3upb_session`
1 × SELECT id, rules
FROM `d3upb_viewlevels
1 × SELECT folder AS type, element AS name, params
FROM d3upb_extensions
1 × SELECT *
FROM d3upb_languages
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 d3upb_menu AS m
LEFT JOIN d3upb_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `data`
FROM `d3upb_session`
