Walter Notermans - Mertens

Allgemeine Bauunternehmung pGmbH

Login-Formular

Aktuelle Seite: Startseite

Bildergalerie

Arbeiten im Innenbereich

Poliebeton

Libermé / Kettenis

Gemehret / Kettenis

Raerenpfad / Kettenis

Oberste Heide / Kettenis

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen

28 ausgeführte Abfragen 28.7 ms

10 Dublikate gefunden!

2 Dublikate: #14 #15

2 Dublikate: #16 #17

2 Dublikate: #18 #19

2 Dublikate: #20 #21

2 Dublikate: #22 #23

Abfragezeit: 0.70 ms
```
SELECT `data`

  FROM `Notermans_session`

  WHERE `session_id` = 'iitjqi3pl9ilkdf5kdiblhh2v3'
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT `data` FROM `Notermans_session` WHERE `session_id` = 'iitjqi3pl9ilkdf5kdiblhh2v3'
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.76 ms Nach letzter Abfrage: 1.29 ms
```
SELECT `session_id`

  FROM `Notermans_session`

  WHERE `session_id` = 'iitjqi3pl9ilkdf5kdiblhh2v3' 
  LIMIT 0, 1
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT `session_id` FROM `Notermans_session` WHERE `session_id` = 'iitjqi3pl9ilkdf5kdiblhh2v3' LIMIT 0, 1
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 3.62 ms Nach letzter Abfrage: 0.19 ms
```
INSERT INTO `Notermans_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('iitjqi3pl9ilkdf5kdiblhh2v3', 0, '1739239700')
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `Notermans_session` (`session_id`, `client_id`, `time`) VALUES ('iitjqi3pl9ilkdf5kdiblhh2v3', 0, '1739239700')
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.63 ms Nach letzter Abfrage: 1.47 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
```
Erklären
„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
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.40 ms Nach letzter Abfrage: 0.32 ms
```
SELECT id, rules

  FROM `Notermans_viewlevels`
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT id, rules FROM `Notermans_viewlevels`
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 1.15 ms Nach letzter Abfrage: 11.22 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
```
Erklären
„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
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 1.31 ms Nach letzter Abfrage: 2.47 ms
```
UPDATE `Notermans_extensions`

  SET `params` = '{\"mediaversion\":\"efb70db346e3ce28c90b07be5e6254ff\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: UPDATE `Notermans_extensions` SET `params` = '{\"mediaversion\":\"efb70db346e3ce28c90b07be5e6254ff\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.56 ms Nach letzter Abfrage: 16.47 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
```
Erklären
„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
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.54 ms Nach letzter Abfrage: 1.70 ms
```
SELECT a.* 
  FROM Notermans_phocagallery_fb_users AS a 
  WHERE a.id =0
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT a.* FROM Notermans_phocagallery_fb_users AS a WHERE a.id =0
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 1.07 ms Nach letzter Abfrage: 2.38 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 = 12 
  LIMIT 0, 1
```
Erklären
„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 = 12 LIMIT 0, 1
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.69 ms Nach letzter Abfrage: 0.39 ms
```
SELECT * 
  FROM Notermans_phocagallery_categories AS c 
  WHERE c.id = 0 
  AND c.published = 1
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT * FROM Notermans_phocagallery_categories AS c WHERE c.id = 0 AND c.published = 1
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.86 ms Nach letzter Abfrage: 0.92 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 = 0 
  AND cc.published = 1 
  AND cc.approved = 1 
  AND cc.id <> 12 
  ORDER BY cc.ordering ASC 
  LIMIT 0, 1
```
Erklären
„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 = 0 AND cc.published = 1 AND cc.approved = 1 AND cc.id <> 12 ORDER BY cc.ordering ASC LIMIT 0, 1
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 2.94 ms Nach letzter Abfrage: 0.56 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 = 12 
  AND cc.published = 1 
  AND cc.approved = 1 
  AND cc.id <> 12 
  GROUP BY cc.id 
  ORDER BY cc.ordering ASC
```
Erklären
„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 = 12 AND cc.published = 1 AND cc.approved = 1 AND cc.id <> 12 GROUP BY cc.id ORDER BY cc.ordering ASC
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.58 ms Nach letzter Abfrage: 0.38 ms
Doppelte Abfragen: #15
```
SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 13
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT COUNT(a.id) FROM Notermans_phocagallery AS a WHERE a.published = 1 AND a.approved = 1 AND a.catid = 13
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/components/com_phocagallery/models/category.php:300
JROOT/components/com_phocagallery/views/category/view.html.php:757
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.74 ms Nach letzter Abfrage: 0.21 ms
Doppelte Abfragen: #14
```
SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 13
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT COUNT(a.id) FROM Notermans_phocagallery AS a WHERE a.published = 1 AND a.approved = 1 AND a.catid = 13
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/components/com_phocagallery/models/category.php:304
JROOT/components/com_phocagallery/views/category/view.html.php:757
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.78 ms Nach letzter Abfrage: 2.23 ms
Doppelte Abfragen: #17
```
SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 14
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT COUNT(a.id) FROM Notermans_phocagallery AS a WHERE a.published = 1 AND a.approved = 1 AND a.catid = 14
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/components/com_phocagallery/models/category.php:300
JROOT/components/com_phocagallery/views/category/view.html.php:757
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.11 ms
Doppelte Abfragen: #16
```
SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 14
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT COUNT(a.id) FROM Notermans_phocagallery AS a WHERE a.published = 1 AND a.approved = 1 AND a.catid = 14
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/components/com_phocagallery/models/category.php:304
JROOT/components/com_phocagallery/views/category/view.html.php:757
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.51 ms Nach letzter Abfrage: 0.71 ms
Doppelte Abfragen: #19
```
SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 15
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT COUNT(a.id) FROM Notermans_phocagallery AS a WHERE a.published = 1 AND a.approved = 1 AND a.catid = 15
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/components/com_phocagallery/models/category.php:300
JROOT/components/com_phocagallery/views/category/view.html.php:757
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.10 ms
Doppelte Abfragen: #18
```
SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 15
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT COUNT(a.id) FROM Notermans_phocagallery AS a WHERE a.published = 1 AND a.approved = 1 AND a.catid = 15
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/components/com_phocagallery/models/category.php:304
JROOT/components/com_phocagallery/views/category/view.html.php:757
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.43 ms Nach letzter Abfrage: 0.58 ms
Doppelte Abfragen: #21
```
SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 16
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT COUNT(a.id) FROM Notermans_phocagallery AS a WHERE a.published = 1 AND a.approved = 1 AND a.catid = 16
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/components/com_phocagallery/models/category.php:300
JROOT/components/com_phocagallery/views/category/view.html.php:757
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.08 ms
Doppelte Abfragen: #20
```
SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 16
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT COUNT(a.id) FROM Notermans_phocagallery AS a WHERE a.published = 1 AND a.approved = 1 AND a.catid = 16
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/components/com_phocagallery/models/category.php:304
JROOT/components/com_phocagallery/views/category/view.html.php:757
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.47 ms
Doppelte Abfragen: #23
```
SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 22
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT COUNT(a.id) FROM Notermans_phocagallery AS a WHERE a.published = 1 AND a.approved = 1 AND a.catid = 22
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/components/com_phocagallery/models/category.php:300
JROOT/components/com_phocagallery/views/category/view.html.php:757
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.53 ms Nach letzter Abfrage: 0.08 ms
Doppelte Abfragen: #22
```
SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 22
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SELECT COUNT(a.id) FROM Notermans_phocagallery AS a WHERE a.published = 1 AND a.approved = 1 AND a.catid = 22
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/components/com_phocagallery/models/category.php:304
JROOT/components/com_phocagallery/views/category/view.html.php:757
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 1.52 ms Nach letzter Abfrage: 0.69 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= 12 
  AND a.published = 1 
  AND a.approved = 1 
  ORDER BY a.ordering ASC 
  LIMIT 0, 20
```
Erklären
„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= 12 AND a.published = 1 AND a.approved = 1 ORDER BY a.ordering ASC LIMIT 0, 20
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 1.39 ms Nach letzter Abfrage: 0.37 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= 12 
  AND a.published = 1 
  AND a.approved = 1 
  ORDER BY a.ordering ASC
```
Erklären
„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= 12 AND a.published = 1 AND a.approved = 1 ORDER BY a.ordering ASC
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 1.36 ms Nach letzter Abfrage: 1.08 ms
```
SHOW FULL COLUMNS 
  FROM `Notermans_phocagallery_categories`
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `Notermans_phocagallery_categories`
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 1.08 ms Nach letzter Abfrage: 0.67 ms
```
UPDATE Notermans_phocagallery_categories

  SET `hits` = (`hits` + 1)

  WHERE `id` = '12'
```
Erklären
„EXPLAIN“ unmöglich für Abfrage: UPDATE Notermans_phocagallery_categories SET `hits` = (`hits` + 1) WHERE `id` = '12'
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 3.03 ms Nach letzter Abfrage: 6.13 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 <= '2025-02-11 02:08:20') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-02-11 02:08:20') 
  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
```
Erklären
„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 <= '2025-02-11 02:08:20') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-02-11 02:08:20') 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
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
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
[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

18 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

10 × SELECT COUNT(a.id) 
  FROM Notermans_phocagallery AS a

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 * 
  FROM Notermans_phocagallery_categories AS c

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 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 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, 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 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`

Andere Tabellen:

1 × UPDATE Notermans_phocagallery_categories 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `Notermans_phocagallery_categories

1 × UPDATE `Notermans_extensions` 
  SET `params` = '{\"mediaversion\":\"efb70db346e3ce28c90b07be5e6254ff\"}'

1 × INSERT INTO `Notermans_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('iitjqi3pl9ilkdf5kdiblhh2v3', 0, '1739239700'