Abfragezeit: 0.39 ms
SELECT `data`
FROM `Notermans_session`
WHERE `session_id` = '31k6fr6fvaevbl9p5kdv8l26m3'
„EXPLAIN“ unmöglich für Abfrage: SELECT `data`
FROM `Notermans_session`
WHERE `session_id` = '31k6fr6fvaevbl9p5kdv8l26m3'
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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
Abfragezeit: 1.29 ms Nach letzter Abfrage: 0.76 ms
DELETE
FROM `Notermans_session`
WHERE `time` < '1776528177'
„EXPLAIN“ unmöglich für Abfrage: DELETE
FROM `Notermans_session`
WHERE `time` < '1776528177'
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
JROOT/libraries/cms/application/cms.php:756
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
Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.25 ms
SELECT `session_id`
FROM `Notermans_session`
WHERE `session_id` = '31k6fr6fvaevbl9p5kdv8l26m3'
LIMIT 0, 1
„EXPLAIN“ unmöglich für Abfrage: SELECT `session_id`
FROM `Notermans_session`
WHERE `session_id` = '31k6fr6fvaevbl9p5kdv8l26m3' LIMIT 0, 1
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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
Abfragezeit: 0.65 ms Nach letzter Abfrage: 0.17 ms
INSERT INTO `Notermans_session`
(`session_id`, `client_id`, `time`)
VALUES
('31k6fr6fvaevbl9p5kdv8l26m3', 0, '1776529077')
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `Notermans_session`
(`session_id`, `client_id`, `time`) VALUES
('31k6fr6fvaevbl9p5kdv8l26m3', 0, '1776529077')
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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
Abfragezeit: 0.56 ms Nach letzter Abfrage: 1.69 ms
SELECT b.id
FROM Notermans_usergroups AS a
LEFT JOIN Notermans_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
„EXPLAIN“ unmöglich für Abfrage: SELECT b.id
FROM Notermans_usergroups AS a
LEFT JOIN Notermans_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 9
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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
Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.29 ms
SELECT id, rules
FROM `Notermans_viewlevels`
„EXPLAIN“ unmöglich für Abfrage: SELECT id, rules
FROM `Notermans_viewlevels`
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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
Abfragezeit: 0.92 ms Nach letzter Abfrage: 9.15 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 Notermans_menu AS m
LEFT JOIN Notermans_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“ unmöglich für Abfrage: 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 Notermans_menu AS m
LEFT JOIN Notermans_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
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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
Abfragezeit: 1.23 ms Nach letzter Abfrage: 2.02 ms
UPDATE `Notermans_extensions`
SET `params` = '{\"mediaversion\":\"8942c3b7c327332f9dbd2c4784b5f754\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `Notermans_extensions`
SET `params` = '{\"mediaversion\":\"8942c3b7c327332f9dbd2c4784b5f754\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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/sef/sef.php:29
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
Abfragezeit: 0.63 ms Nach letzter Abfrage: 15.38 ms
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM Notermans_phocagallery_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASC
„EXPLAIN“ unmöglich für Abfrage: SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM Notermans_phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 0.57 ms Nach letzter Abfrage: 1.29 ms
SELECT a.*
FROM Notermans_phocagallery_fb_users AS a
WHERE a.id =0
„EXPLAIN“ unmöglich für Abfrage: SELECT a.* FROM Notermans_phocagallery_fb_users AS a WHERE a.id =0
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 0.55 ms Nach letzter Abfrage: 1.56 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 Notermans_phocagallery_categories AS c
WHERE c.id = 2
LIMIT 0, 1
„EXPLAIN“ unmöglich für Abfrage: 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 Notermans_phocagallery_categories AS c WHERE c.id = 2 LIMIT 0, 1
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
JROOT/components/com_phocagallery/models/category.php:212
JROOT/components/com_phocagallery/models/category.php:169
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_phocagallery/views/category/view.html.php:374
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.21 ms
SELECT *
FROM Notermans_phocagallery_categories AS c
WHERE c.id = 8
AND c.published = 1
„EXPLAIN“ unmöglich für Abfrage: SELECT * FROM Notermans_phocagallery_categories AS c WHERE c.id = 8 AND c.published = 1
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
JROOT/components/com_phocagallery/views/category/view.html.php:2061
JROOT/components/com_phocagallery/views/category/view.html.php:424
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 0.43 ms Nach letzter Abfrage: 0.28 ms
SELECT *
FROM Notermans_phocagallery_categories AS c
WHERE c.id = 0
AND c.published = 1
„EXPLAIN“ unmöglich für Abfrage: SELECT * FROM Notermans_phocagallery_categories AS c WHERE c.id = 0 AND c.published = 1
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
JROOT/components/com_phocagallery/views/category/view.html.php:2061
JROOT/components/com_phocagallery/views/category/view.html.php:424
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 0.46 ms Nach letzter Abfrage: 1.09 ms
SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access
FROM Notermans_phocagallery_categories AS cc
WHERE cc.id = 8
AND cc.published = 1
AND cc.approved = 1
AND cc.id <> 2
ORDER BY cc.ordering ASC
LIMIT 0, 1
„EXPLAIN“ unmöglich für Abfrage: SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access FROM Notermans_phocagallery_categories AS cc WHERE cc.id = 8 AND cc.published = 1 AND cc.approved = 1 AND cc.id <> 2 ORDER BY cc.ordering ASC LIMIT 0, 1
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
JROOT/components/com_phocagallery/models/category.php:240
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_phocagallery/views/category/view.html.php:569
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 1.64 ms Nach letzter Abfrage: 0.35 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 Notermans_phocagallery_categories AS cc
LEFT JOIN Notermans_phocagallery AS a
ON cc.id = a.catid
WHERE cc.parent_id = 2
AND cc.published = 1
AND cc.approved = 1
AND cc.id <> 2
GROUP BY cc.id
ORDER BY cc.ordering ASC
„EXPLAIN“ unmöglich für Abfrage: 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 Notermans_phocagallery_categories AS cc LEFT JOIN Notermans_phocagallery AS a ON cc.id = a.catid WHERE cc.parent_id = 2 AND cc.published = 1 AND cc.approved = 1 AND cc.id <> 2 GROUP BY cc.id ORDER BY cc.ordering ASC
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
JROOT/components/com_phocagallery/models/category.php:282
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_phocagallery/views/category/view.html.php:727
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 1.89 ms Nach letzter Abfrage: 0.26 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 Notermans_phocagallery AS a
LEFT JOIN Notermans_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id
LEFT JOIN Notermans_phocagallery_categories AS cc
ON cc.id = a.catid
WHERE a.catid= 2
AND a.published = 1
AND a.approved = 1
ORDER BY a.ordering ASC
LIMIT 0, 20
„EXPLAIN“ unmöglich für Abfrage: 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 Notermans_phocagallery AS a LEFT JOIN Notermans_phocagallery_img_votes_statistics AS r ON r.imgid = a.id LEFT JOIN Notermans_phocagallery_categories AS cc ON cc.id = a.catid WHERE a.catid= 2 AND a.published = 1 AND a.approved = 1 ORDER BY a.ordering ASC LIMIT 0, 20
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
JROOT/libraries/legacy/model/legacy.php:312
JROOT/components/com_phocagallery/models/category.php:67
JROOT/components/com_phocagallery/views/category/view.html.php:944
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 2.80 ms Nach letzter Abfrage: 1.25 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 Notermans_phocagallery AS a
LEFT JOIN Notermans_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id
LEFT JOIN Notermans_phocagallery_categories AS cc
ON cc.id = a.catid
WHERE a.catid= 2
AND a.published = 1
AND a.approved = 1
ORDER BY a.ordering ASC
„EXPLAIN“ unmöglich für Abfrage: 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 Notermans_phocagallery AS a LEFT JOIN Notermans_phocagallery_img_votes_statistics AS r ON r.imgid = a.id LEFT JOIN Notermans_phocagallery_categories AS cc ON cc.id = a.catid WHERE a.catid= 2 AND a.published = 1 AND a.approved = 1 ORDER BY a.ordering ASC
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
JROOT/libraries/legacy/model/legacy.php:354
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:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 1.39 ms Nach letzter Abfrage: 9.21 ms
SHOW FULL COLUMNS
FROM `Notermans_phocagallery_categories`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `Notermans_phocagallery_categories`
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/administrator/components/com_phocagallery/tables/phocagalleryc.php:16
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_phocagallery/models/category.php:542
JROOT/components/com_phocagallery/views/category/view.html.php:1879
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 1.20 ms Nach letzter Abfrage: 0.86 ms
UPDATE Notermans_phocagallery_categories
SET `hits` = (`hits` + 1)
WHERE `id` = '2'
„EXPLAIN“ unmöglich für Abfrage: UPDATE Notermans_phocagallery_categories
SET `hits` = (`hits` + 1)
WHERE `id` = '2'
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
JROOT/libraries/joomla/table/table.php:1239
JROOT/components/com_phocagallery/models/category.php:543
JROOT/components/com_phocagallery/views/category/view.html.php:1879
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_phocagallery/controller.php:30
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_phocagallery/phocagallery.php:55
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
Abfragezeit: 1.16 ms Nach letzter Abfrage: 16.76 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM Notermans_modules AS m
LEFT JOIN Notermans_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN Notermans_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 <= '2026-04-18 16:17:57')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-18 16:17:57')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 124 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
„EXPLAIN“ unmöglich für Abfrage: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM Notermans_modules AS m
LEFT JOIN Notermans_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN Notermans_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 <= '2026-04-18 16:17:57') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-18 16:17:57') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 124 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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/notermansmertens3/library/Artx/Page.php:43
JROOT/templates/notermansmertens3/index.php:73
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
2 × SELECT *
FROM Notermans_phocagallery_categories AS c
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 Notermans_phocagallery AS a
LEFT JOIN Notermans_phocagallery_img_votes_statistics AS r
ON r.imgid = a.id
LEFT JOIN Notermans_phocagallery_categories AS cc
ON cc.id = a.catid
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM Notermans_modules AS m
LEFT JOIN Notermans_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN Notermans_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access
FROM Notermans_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 Notermans_phocagallery_categories AS cc
LEFT JOIN Notermans_phocagallery AS a
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 Notermans_phocagallery_categories AS c
1 × SELECT a.*
FROM Notermans_phocagallery_fb_users AS a
1 × SELECT b.id
FROM Notermans_usergroups AS a
LEFT JOIN Notermans_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `Notermans_session`
1 × SELECT id, rules
FROM `Notermans_viewlevels
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 Notermans_menu AS m
LEFT JOIN Notermans_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM Notermans_phocagallery_styles AS a
1 × SELECT `data`
FROM `Notermans_session`
