Bis zur nächsten Veranstaltung
Veranstaltung startet in
Gestartete Veranstaltung:
Beerenjagt - Lebensmittel retten, Obst/Nüsse sammeln, verarbeiten, anbieten
Position: bottom3
Style: outline
Beerenjagt - Lebensmittel retten, Obst/Nüsse sammeln, verarbeiten, anbieten
16.12.2018
10:30
-
11:30
Streifzüge durch die Region (öffentliche, private und eigene Plätze) -
Wir sammeln Lebensmittel, Obst, Nüsse-
Ernten, Verarbeiten und bieten den Überschuss an
Du kommst mit dem Ernten nicht hinterher oder kennst einen Platz mit Beeren, Obst etc. was am kaputt gehen ist?
Schreib uns eine Email
Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
oder rufe an unter der
01573-1800666
Über Kochmöglichkeiten zum Verarbeiten, Einmachen etc. sind wir ebenso sehr dankbar.
Auf unserer Beerenjägermap tragen wir alle Sammelplätze ein.
Bitte geeigneten Behälter zum sammeln mitbringen. Und natürlich Neugierde und Hunger :)
Treffpunkt um 10.30 Uhr an der Kultur Bar Impuls
Körperkraft - Für einen wachen, gesunden und kräftigen Körper in Weingarten
19.12.2018
07:00
-
08:30
Körperkraft - für einen gesunden, wachen und Kräftigen Körper
Das Mittwoch Training ist für jeden und besonders Berufstätige gedacht.
Wir joggen am Trimm- Dich- Pfad oberhalb des Sechser-Weges.Zwischendurch stärken, spüren und trainieren wir unseren Körper.
Unser Körper soll gut mit uns in Verbindung stehen und bis wir alt sind funktionieren.
Das brauchst Du:
- geeignete Schuhe für Waldwege
- bei Kälte geeignete Kleidung
- eventuell etwas zu trinken
Wir freuen uns auf dich und einen kraftvollen Start in den Tag !
Schrittweise Freitanz und Lebenstanz
19.12.2018
19:30
-
21:00
Liebe/r Tanzfreudige/r, hier nun unseren neuen Termin für SchrittWeise Freitanz und Lebenstanz im Haus der Familie, Großer Saal im I. Stock, Weingarten jeweils von 19.30 Uhr bis ca. 21 Uhr noch ein Hinweis: gerne kannst Du bereits ab 19.20 Uhr kommen, damit wir gemeinsam beginnen können und eine Decke mitbringen
Wir freuen uns auf Dich!
Mit tanzenden Grüßen
Marc und Christine
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1544948135,
"last": 1544948135,
"now": 1544948135
},
"token": "eYJWMHNf3mVUY34DVSl4CKhMgFUGKgU8"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 14.50 ms / 14.50 ms Memory: 1.592 MB / 1.92 MB Application: afterLoad
Time: 97.24 ms / 111.74 ms Memory: 5.394 MB / 7.32 MB Application: afterInitialise
Time: 10.90 ms / 122.64 ms Memory: 0.736 MB / 8.05 MB Application: afterRoute
Time: 7.84 ms / 130.48 ms Memory: 0.285 MB / 8.34 MB Application: beforeRenderComponent com_comprofiler
Time: 78.28 ms / 208.77 ms Memory: 6.174 MB / 14.51 MB Application: afterRenderComponent com_comprofiler
Time: 4.13 ms / 212.90 ms Memory: 0.268 MB / 14.78 MB Application: afterDispatch
Time: 22.44 ms / 235.35 ms Memory: 1.101 MB / 15.88 MB Application: beforeRenderModule mod_login (Login)
Time: 5.22 ms / 240.57 ms Memory: 0.366 MB / 16.25 MB Application: afterRenderModule mod_login (Login)
Time: 13.51 ms / 254.08 ms Memory: 0.197 MB / 16.44 MB Application: beforeRenderModule mod_menu (Impressum)
Time: 2.58 ms / 256.66 ms Memory: 0.049 MB / 16.49 MB Application: afterRenderModule mod_menu (Impressum)
Time: 0.04 ms / 256.70 ms Memory: 0.000 MB / 16.48 MB Application: beforeRenderModule mod_menu (Datenschutzerklärung)
Time: 1.22 ms / 257.92 ms Memory: 0.016 MB / 16.50 MB Application: afterRenderModule mod_menu (Datenschutzerklärung)
Time: 0.12 ms / 258.04 ms Memory: 0.000 MB / 16.49 MB Application: beforeRenderModule mod_login (Login)
Time: 0.89 ms / 258.93 ms Memory: 0.007 MB / 16.50 MB Application: afterRenderModule mod_login (Login)
Time: 0.07 ms / 259.00 ms Memory: 0.004 MB / 16.50 MB Application: beforeRenderModule mod_dpcalendar_mini (DPCalendar Mini)
Time: 9.72 ms / 268.72 ms Memory: 0.570 MB / 17.07 MB Application: Before Access::preloadComponents (all components)
Time: 1.47 ms / 270.19 ms Memory: 0.065 MB / 17.14 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 270.22 ms Memory: 0.000 MB / 17.14 MB Application: Before Access::preloadPermissions (com_dpcalendar)
Time: 1.27 ms / 271.49 ms Memory: 0.017 MB / 17.15 MB Application: After Access::preloadPermissions (com_dpcalendar)
Time: 0.03 ms / 271.51 ms Memory: 0.000 MB / 17.15 MB Application: Before Access::getAssetRules (id:111 name:com_dpcalendar.category.9)
Time: 0.73 ms / 272.25 ms Memory: 0.027 MB / 17.18 MB Application: After Access::getAssetRules (id:111 name:com_dpcalendar.category.9)
Time: 6.60 ms / 278.84 ms Memory: 0.130 MB / 17.31 MB Application: afterRenderModule mod_dpcalendar_mini (DPCalendar Mini)
Time: 0.11 ms / 278.96 ms Memory: 0.000 MB / 17.29 MB Application: beforeRenderModule mod_dpcalendar_upcoming (Kommende Veranstaltungen)
Time: 5.51 ms / 284.47 ms Memory: 0.330 MB / 17.62 MB Application: Before Access::getAssetRules (id:110 name:com_dpcalendar)
Time: 0.02 ms / 284.49 ms Memory: 0.002 MB / 17.63 MB Application: After Access::getAssetRules (id:110 name:com_dpcalendar)
Time: 88.83 ms / 373.33 ms Memory: 2.206 MB / 19.83 MB Application: afterRenderModule mod_dpcalendar_upcoming (Kommende Veranstaltungen)
Time: 0.12 ms / 373.45 ms Memory: 0.000 MB / 19.74 MB Application: beforeRenderModule mod_dpcalendar_counter (Bis zur nächsten Veranstaltung)
Time: 7.98 ms / 381.43 ms Memory: 0.114 MB / 19.86 MB Application: afterRenderModule mod_dpcalendar_counter (Bis zur nächsten Veranstaltung)
Time: 2.45 ms / 383.88 ms Memory: 0.163 MB / 20.02 MB Application: afterRender
Database queries total: 101.97 ms
20.68 MB (21,688,072 Bytes)
48 ausgeführte Abfragen 101.97 ms
- Query Time: 1.40 ms Query memory: 0.027 MB Memory before query: 3.468 MB Rows returned: 0
SELECT `data`
FROM `yqj0_session`
WHERE `session_id` = '6446a38503bdb0c0606dc43823c9f40c'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_session const PRIMARY PRIMARY 194 const 1 Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 5.57 ms After last query: 1.30 ms Query memory: 0.023 MB Memory before query: 3.574 MB Rows returned: 0
SELECT `session_id`
FROM `yqj0_session`
WHERE `session_id` = '6446a38503bdb0c0606dc43823c9f40c'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 4.02 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 3.581 MB
INSERT INTO `yqj0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('6446a38503bdb0c0606dc43823c9f40c', 1, 1544948135, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `yqj0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('6446a38503bdb0c0606dc43823c9f40c', 1, 1544948135, 0, '', 0)Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.00 ms init 0.03 ms update 0.04 ms Waiting for query cache lock 0.00 ms update 0.00 ms end 0.00 ms query end 0.63 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 7.34 ms After last query: 2.87 ms Query memory: 0.043 MB Memory before query: 3.857 MB Rows returned: 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `yqj0_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_extensions ref extension extension 82 const 44 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sending data 3.60 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms logging slow query 0.01 ms cleaning up 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.46 ms After last query: 2.46 ms Query memory: 0.025 MB Memory before query: 4.081 MB Rows returned: 6
SELECT id, rules
FROM `yqj0_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.01 ms cleaning up 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.67 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 4.096 MB Rows returned: 2
SELECT b.id
FROM yqj0_usergroups AS a
LEFT JOIN yqj0_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 5.62 ms After last query: 0.73 ms Query memory: 0.038 MB Memory before query: 4.163 MB Rows returned: 92
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM yqj0_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_extensions ref extension extension 82 const 151 Using where; Using filesort Status Duration starting 0.07 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.06 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sorting result 1.33 ms Sending data 0.24 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.58 ms After last query: 36.19 ms Query memory: 0.070 MB Memory before query: 7.001 MB Rows returned: 37
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 yqj0_menu AS m
LEFT JOIN yqj0_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 54 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 db665772483.m.component_id 1 Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.12 ms Sending data 0.46 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/communitybuilder/communitybuilder.php:217 8 plgSystemCommunityBuilder->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.38 ms After last query: 13.01 ms Query memory: 0.028 MB Memory before query: 8.087 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `yqj0_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1119 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.01 ms After last query: 0.16 ms Query memory: 0.007 MB Memory before query: 8.081 MB
UPDATE `yqj0_extensions`
SET `params` = '{\"mediaversion\":\"caa33964d5f722e3e2e7517b3e7227fd\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `yqj0_extensions` SET `params` = '{\"mediaversion\":\"caa33964d5f722e3e2e7517b3e7227fd\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.00 ms init 0.05 ms Updating 0.03 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.69 ms closing tables 0.01 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1119 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 2.06 ms Query memory: 0.026 MB Memory before query: 8.252 MB Rows returned: 2
SELECT *
FROM yqj0_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using filesort Status Duration starting 0.02 ms checking permissions 0.02 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.02 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.78 ms After last query: 0.23 ms Query memory: 0.054 MB Memory before query: 8.265 MB Rows returned: 8
SELECT id, home, template, s.params
FROM yqj0_template_styles as s
LEFT JOIN yqj0_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 8 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 db665772483.s.template,const 1 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.15 ms end 0.01 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.51 ms After last query: 31.71 ms Query memory: 0.033 MB Memory before query: 10.294 MB Rows returned: 1
SELECT `params`
FROM `yqj0_comprofiler_plugin`
WHERE `id` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_comprofiler_plugin const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 23 JDatabaseDriver->loadResult() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345 22 CBLib\Database\Driver\CmsDatabaseDriver->loadResult() JROOT/libraries/CBLib/CB/Application/CBConfig.php:43 21 CB\Application\CBConfig::getConfig() JROOT/libraries/CBLib/CB/Application/CBApplication.php:45 20 CB\Application\CBApplication::CB\Application\{closure}() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/CBLib/CBLib/Application/Config.php:38 18 CBLib\Application\Config::setMainConfig() JROOT/libraries/CBLib/CBLib/Core/CBLib.php:70 17 CBLib\Core\CBLib::CBLib\Core\{closure}() JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:605 16 CBLib\DependencyInjection\Container->build() JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496 15 CBLib\DependencyInjection\Container->make() JROOT/libraries/CBLib/CBLib/Application/Application.php:179 14 CBLib\Application\Application::__callStatic() JROOT/libraries/CBLib/CB/Application/CBConfig.php:77 13 CB\Application\CBConfig::loadLegacyCBueConfig() JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:109 12 CB\Legacy\LegacyFoundationFunctions->__construct() Same as call in the line below. 11 ReflectionClass->newInstanceArgs() JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:643 10 CBLib\DependencyInjection\Container->build() JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496 9 CBLib\DependencyInjection\Container->make() JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:132 8 CBLib\DependencyInjection\Container->get() JROOT/administrator/components/com_comprofiler/plugin.foundation.php:33 7 include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php JROOT/components/com_comprofiler/comprofiler.php:60 6 require_once JROOT/components/com_comprofiler/comprofiler.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.05 ms After last query: 15.18 ms Query memory: 0.031 MB Memory before query: 11.948 MB Rows returned: 6
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `yqj0_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1,5)
AND `type` = 'user'
ORDER BY `ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_comprofiler_plugin ref idx_folder,type_pub_order type_pub_order 104 const,const 6 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.05 ms System lock 0.02 ms init 0.04 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.05 ms executing 0.00 ms Sorting result 0.00 ms Sending data 0.11 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.04 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 11 JDatabaseDriver->loadAssocList() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394 10 CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446 9 CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181 8 cbPluginHandler->loadPluginGroup() JROOT/components/com_comprofiler/comprofiler.php:568 7 userProfile() JROOT/components/com_comprofiler/comprofiler.php:289 6 require_once JROOT/components/com_comprofiler/comprofiler.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 53.37 ms Query memory: 0.031 MB Memory before query: 15.785 MB Rows returned: 1
SELECT id, title, module, position, content, showtitle, params
FROM yqj0_modules AS m
WHERE m.published = 1
AND m.id = 16
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-12-16 08:15:36')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-12-16 08:15:36')
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY position, orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m const PRIMARY,published PRIMARY 4 const 1 Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.02 ms query end 0.00 ms closing tables 0.04 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/plugins/system/helix3/core/classes/menu.php:516 17 Helix3Menu->load_module() JROOT/plugins/system/helix3/core/classes/menu.php:354 16 Helix3Menu->mega() JROOT/plugins/system/helix3/core/classes/menu.php:214 15 Helix3Menu->getItem() JROOT/plugins/system/helix3/core/classes/menu.php:189 14 Helix3Menu->navigation() JROOT/plugins/system/helix3/core/classes/menu.php:132 13 Helix3Menu->render() JROOT/plugins/system/helix3/core/classes/menu.php:32 12 Helix3Menu->__construct() JROOT/plugins/system/helix3/core/helix3.php:838 11 Helix3::loadMegaMenu() JROOT/templates/jl_redchili_free/features/menu.php:29 10 Helix3FeatureMenu->renderFeature() JROOT/plugins/system/helix3/core/helix3.php:204 9 Helix3::importFeatures() JROOT/plugins/system/helix3/core/helix3.php:246 8 Helix3::generatelayout() JROOT/templates/jl_redchili_free/index.php:172 7 require JROOT/templates/jl_redchili_free/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.88 ms After last query: 7.11 ms Query memory: 0.033 MB Memory before query: 16.282 MB Rows returned: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM yqj0_modules AS m
LEFT JOIN yqj0_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN yqj0_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-12-16 08:15:36')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-12-16 08:15:36')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 34 Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 db665772483.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 db665772483.m.module,const 1 Using where Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.12 ms Sending data 0.21 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 14 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 13 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 12 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 11 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/helix3/core/helix3.php:512 10 Helix3::countModules() JROOT/plugins/system/helix3/core/helix3.php:459 9 Helix3::rowColumns() JROOT/plugins/system/helix3/core/helix3.php:268 8 Helix3::generatelayout() JROOT/templates/jl_redchili_free/index.php:172 7 require JROOT/templates/jl_redchili_free/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.81 ms After last query: 24.70 ms Query memory: 0.040 MB Memory before query: 17.025 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `yqj0_categories` AS `s`
INNER JOIN `yqj0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 9
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using filesort 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 8 Using where Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.04 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.03 ms Sending data 0.04 ms end 0.00 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 14 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 13 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:42 10 include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.13 ms After last query: 0.92 ms Query memory: 0.036 MB Memory before query: 17.077 MB Rows returned: 44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `yqj0_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_cjblog','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jce','com_joomgallery','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_simplecalendar','com_socialloginandsocialshare','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 161 Using where Status Duration starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.00 ms init 0.07 ms optimizing 0.01 ms statistics 0.22 ms preparing 0.01 ms executing 0.00 ms Sending data 0.32 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 17 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 16 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:53 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:42 10 include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.04 ms After last query: 0.35 ms Query memory: 0.031 MB Memory before query: 17.137 MB Rows returned: 4
SELECT `id`,`name`,`rules`,`parent_id`
FROM `yqj0_assets`
WHERE `name` LIKE 'com_dpcalendar.%' OR `name` = 'com_dpcalendar' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 161 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.09 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 17 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 16 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:53 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:42 10 include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.65 ms After last query: 2.89 ms Query memory: 0.036 MB Memory before query: 17.286 MB Rows returned: 0
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `yqj0_dpcalendar_caldav_calendarinstances` c
LEFT
OUTER JOIN yqj0_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from yqj0_dpcalendar_caldav_principals memberp
inner join yqj0_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join yqj0_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
LIMIT 20id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using filesort 1 PRIMARY mainp eq_ref uri uri 202 db665772483.c.principaluri 1 Using where 2 DERIVED m index principal_id principal_id 8 NULL 1 Using index 2 DERIVED memberp eq_ref PRIMARY PRIMARY 4 db665772483.m.member_id 1 2 DERIVED linkp eq_ref PRIMARY PRIMARY 4 db665772483.m.principal_id 1 Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.02 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 18 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/profile.php:36 17 DPCalendarModelProfile->getItems() JROOT/plugins/system/dpcalendar/dpcalendar.php:301 16 PlgSystemDpcalendar->fetchCalendars() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:436 15 DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 12 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/components/com_dpcalendar/models/calendar.php:93 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:42 10 include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.96 ms After last query: 6.96 ms Query memory: 0.035 MB Memory before query: 17.570 MB Rows returned: 8
SHOW FULL COLUMNS
FROM `yqj0_assets`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `yqj0_assets`Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.25 ms System lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.09 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 21 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 20 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 19 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 18 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Asset.php:61 17 Joomla\CMS\Table\Asset->__construct() JROOT/libraries/src/Access/Access.php:783 16 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:53 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.60 ms After last query: 0.92 ms Query memory: 0.032 MB Memory before query: 17.617 MB Rows returned: 0
SELECT *
FROM yqj0_assets
WHERE `name` = 'com_dpcalendar.category.root'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 17 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 16 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:53 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.77 ms After last query: 0.28 ms Query memory: 0.032 MB Memory before query: 17.631 MB Rows returned: 0
SELECT *
FROM yqj0_assets
WHERE `name` = 'com_dpcalendar.category.root'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.04 ms init 0.03 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.00 ms executing 0.01 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 17 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 16 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:54 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 0.23 ms Query memory: 0.032 MB Memory before query: 17.644 MB Rows returned: 0
SELECT *
FROM yqj0_assets
WHERE `name` = 'com_dpcalendar.category.root'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 17 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 16 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:55 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.80 ms After last query: 0.26 ms Query memory: 0.032 MB Memory before query: 17.656 MB Rows returned: 0
SELECT *
FROM yqj0_assets
WHERE `name` = 'com_dpcalendar.category.root'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.05 ms checking permissions 0.02 ms Opening tables 0.02 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 17 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 16 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:56 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.78 ms After last query: 0.22 ms Query memory: 0.032 MB Memory before query: 17.669 MB Rows returned: 0
SELECT *
FROM yqj0_assets
WHERE `name` = 'com_dpcalendar.category.root'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 17 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 16 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:57 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.09 ms After last query: 0.15 ms Query memory: 0.039 MB Memory before query: 17.677 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `yqj0_categories` AS `c`
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL cat_idx,idx_access NO INDEX KEY COULD BE USED NULL NULL 8 Using where; Using filesort Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.04 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.03 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 14 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 13 Joomla\CMS\Categories\Categories->get() JROOT/libraries/src/Categories/CategoryNode.php:421 12 Joomla\CMS\Categories\CategoryNode->getChildren() JROOT/components/com_dpcalendar/models/calendar.php:78 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.98 ms After last query: 0.44 ms Query memory: 0.036 MB Memory before query: 17.701 MB Rows returned: 0
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `yqj0_dpcalendar_caldav_calendarinstances` c
LEFT
OUTER JOIN yqj0_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from yqj0_dpcalendar_caldav_principals memberp
inner join yqj0_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join yqj0_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
LIMIT 20id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using filesort 1 PRIMARY mainp eq_ref uri uri 202 db665772483.c.principaluri 1 Using where 2 DERIVED m index principal_id principal_id 8 NULL 1 Using index 2 DERIVED memberp eq_ref PRIMARY PRIMARY 4 db665772483.m.member_id 1 2 DERIVED linkp eq_ref PRIMARY PRIMARY 4 db665772483.m.principal_id 1 Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms System lock 0.07 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms init 0.04 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sorting result 0.03 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.02 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 18 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/profile.php:36 17 DPCalendarModelProfile->getItems() JROOT/plugins/system/dpcalendar/dpcalendar.php:301 16 PlgSystemDpcalendar->fetchCalendars() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:436 15 DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 12 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/components/com_dpcalendar/models/calendar.php:93 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 5.83 ms After last query: 1.31 ms Query memory: 0.053 MB Memory before query: 17.804 MB Rows returned: 5
SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
FROM `yqj0_dpcalendar_events` AS a
LEFT JOIN yqj0_categories AS c
ON c.id = a.catid
LEFT JOIN yqj0_dpcalendar_events_location AS rel
ON a.id = rel.event_id
LEFT JOIN yqj0_dpcalendar_locations AS v
ON rel.location_id = v.id
LEFT JOIN yqj0_users AS ua
ON ua.id = a.created_by
LEFT JOIN yqj0_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.original_id > -1
AND a.catid IN ('9')
AND (c.access IN (1,1,5) or c.access is null)
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-16 08:15:36')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-16 08:15:36')
AND (a.start_date >= '2018-12-16 08:15:00')
AND a.language in ('de-DE','*')
GROUP BY a.id
ORDER BY a.start_date asc
LIMIT 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range idx_access,idx_start_date,idx_state,idx_catid,idx_language idx_start_date 8 NULL 44 Using where; Using temporary 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 db665772483.a.catid 1 Using where 1 SIMPLE rel ref PRIMARY PRIMARY 4 db665772483.a.id 2 Using index 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 db665772483.rel.location_id 1 Using index 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 db665772483.a.created_by 1 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 db665772483.a.modified_by 1 Using index Status Duration starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms System lock 0.01 ms init 0.11 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.10 ms Creating tmp table 0.34 ms Sorting for group 0.12 ms executing 0.00 ms Copying to tmp table 0.55 ms Sorting result 0.05 ms Sending data 0.07 ms end 0.01 ms removing tmp table 0.08 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms removing tmp table 0.05 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 12 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/events.php:108 11 DPCalendarModelEvents->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:91 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.78 ms After last query: 0.69 ms Query memory: 0.039 MB Memory before query: 17.910 MB Rows returned: 1Duplicate queries: #48
SELECT a.*,l.title AS language_title,uc.name AS editor
FROM `yqj0_dpcalendar_locations` AS a
LEFT JOIN `yqj0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yqj0_users AS uc
ON uc.id=a.checked_out
WHERE a.id in (19)
ORDER BY ordering ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE l const idx_langcode idx_langcode 28 const 0 unique row not found 1 SIMPLE uc const PRIMARY PRIMARY 4 const 0 unique row not found Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.03 ms init 0.03 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_dpcalendar/models/locations.php:91 12 DPCalendarModelLocations->getItems() JROOT/components/com_dpcalendar/models/events.php:135 11 DPCalendarModelEvents->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:91 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.07 ms After last query: 0.16 ms Query memory: 0.039 MB Memory before query: 17.926 MB Rows returned: 1
SELECT a.*,l.title AS language_title,uc.name AS editor
FROM `yqj0_dpcalendar_locations` AS a
LEFT JOIN `yqj0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yqj0_users AS uc
ON uc.id=a.checked_out
WHERE a.id in (66)
ORDER BY ordering ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE l const idx_langcode idx_langcode 28 const 0 unique row not found 1 SIMPLE uc const PRIMARY PRIMARY 4 const 0 unique row not found Status Duration starting 0.06 ms checking permissions 0.03 ms checking permissions 0.00 ms checking permissions 0.04 ms Opening tables 0.02 ms System lock 0.01 ms init 0.04 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_dpcalendar/models/locations.php:91 12 DPCalendarModelLocations->getItems() JROOT/components/com_dpcalendar/models/events.php:135 11 DPCalendarModelEvents->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:91 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.78 ms After last query: 0.15 ms Query memory: 0.039 MB Memory before query: 17.942 MB Rows returned: 1
SELECT a.*,l.title AS language_title,uc.name AS editor
FROM `yqj0_dpcalendar_locations` AS a
LEFT JOIN `yqj0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yqj0_users AS uc
ON uc.id=a.checked_out
WHERE a.id in (43)
ORDER BY ordering ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE l const idx_langcode idx_langcode 28 const 0 unique row not found 1 SIMPLE uc const PRIMARY PRIMARY 4 const 0 unique row not found Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.06 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_dpcalendar/models/locations.php:91 12 DPCalendarModelLocations->getItems() JROOT/components/com_dpcalendar/models/events.php:135 11 DPCalendarModelEvents->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:91 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.16 ms After last query: 0.15 ms Query memory: 0.040 MB Memory before query: 17.965 MB Rows returned: 1
SELECT a.*,l.title AS language_title,uc.name AS editor
FROM `yqj0_dpcalendar_locations` AS a
LEFT JOIN `yqj0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yqj0_users AS uc
ON uc.id=a.checked_out
WHERE a.id in (58)
ORDER BY ordering ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE l const idx_langcode idx_langcode 28 const 0 unique row not found 1 SIMPLE uc const PRIMARY PRIMARY 4 const 0 unique row not found Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms System lock 0.01 ms init 0.13 ms optimizing 0.07 ms statistics 0.05 ms preparing 0.01 ms executing 0.06 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_dpcalendar/models/locations.php:91 12 DPCalendarModelLocations->getItems() JROOT/components/com_dpcalendar/models/events.php:135 11 DPCalendarModelEvents->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:91 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.09 ms After last query: 9.07 ms Query memory: 0.041 MB Memory before query: 18.382 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM yqj0_fields AS a
LEFT JOIN `yqj0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yqj0_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yqj0_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yqj0_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yqj0_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `yqj0_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_dpcalendar.event'
AND (fc.category_id IS NULL OR fc.category_id IN (9,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 db665772483.a.language 1 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 db665772483.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 db665772483.a.access 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 db665772483.a.created_user_id 1 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 db665772483.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 db665772483.a.id 1 Using where; Using index Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms System lock 0.01 ms init 0.07 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.04 ms executing 0.01 ms Sorting result 0.03 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.01 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:478 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 11 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:131 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.63 ms After last query: 5.81 ms Query memory: 0.040 MB Memory before query: 18.737 MB Rows returned: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `yqj0_categories` AS `s`
INNER JOIN `yqj0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = -1
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.07 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.01 ms cleaning up 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 16 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 15 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41 14 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/helpers/route.php:389 13 DPCalendarHelperRoute::findItem() JROOT/components/com_dpcalendar/helpers/route.php:47 12 DPCalendarHelperRoute::getEventRoute() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:29 11 DPCalendar\Router\Router->getEventRoute() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:137 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.70 ms After last query: 0.36 ms Query memory: 0.044 MB Memory before query: 18.766 MB Rows returned: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `yqj0_categories` AS `s`
INNER JOIN `yqj0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 223
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.03 ms init 0.05 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 23 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41 22 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/helpers/legacyrouter.php:85 21 DPCalendarRouterLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 20 Joomla\CMS\Component\Router\RouterView->build() JROOT/components/com_dpcalendar/router.php:78 19 DPCalendarRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52 13 Joomla\CMS\Router\Route::_() JROOT/components/com_dpcalendar/helpers/route.php:58 12 DPCalendarHelperRoute::getEventRoute() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:29 11 DPCalendar\Router\Router->getEventRoute() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:137 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.55 ms After last query: 0.91 ms Query memory: 0.044 MB Memory before query: 18.791 MB Rows returned: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `yqj0_categories` AS `s`
INNER JOIN `yqj0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 246
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.08 ms checking permissions 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.00 ms executing 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 23 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41 22 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/helpers/legacyrouter.php:85 21 DPCalendarRouterLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 20 Joomla\CMS\Component\Router\RouterView->build() JROOT/components/com_dpcalendar/router.php:78 19 DPCalendarRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52 13 Joomla\CMS\Router\Route::_() JROOT/components/com_dpcalendar/helpers/route.php:58 12 DPCalendarHelperRoute::getEventRoute() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:29 11 DPCalendar\Router\Router->getEventRoute() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:137 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.67 ms After last query: 0.40 ms Query memory: 0.044 MB Memory before query: 18.809 MB Rows returned: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `yqj0_categories` AS `s`
INNER JOIN `yqj0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 218
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.06 ms optimizing 0.04 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.03 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.08 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 23 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41 22 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/helpers/legacyrouter.php:85 21 DPCalendarRouterLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 20 Joomla\CMS\Component\Router\RouterView->build() JROOT/components/com_dpcalendar/router.php:78 19 DPCalendarRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52 13 Joomla\CMS\Router\Route::_() JROOT/components/com_dpcalendar/helpers/route.php:58 12 DPCalendarHelperRoute::getEventRoute() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:29 11 DPCalendar\Router\Router->getEventRoute() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:137 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.81 ms After last query: 0.39 ms Query memory: 0.044 MB Memory before query: 18.827 MB Rows returned: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `yqj0_categories` AS `s`
INNER JOIN `yqj0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 256
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.00 ms executing 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 23 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41 22 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/helpers/legacyrouter.php:85 21 DPCalendarRouterLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 20 Joomla\CMS\Component\Router\RouterView->build() JROOT/components/com_dpcalendar/router.php:78 19 DPCalendarRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52 13 Joomla\CMS\Router\Route::_() JROOT/components/com_dpcalendar/helpers/route.php:58 12 DPCalendarHelperRoute::getEventRoute() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:29 11 DPCalendar\Router\Router->getEventRoute() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:137 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 0.36 ms Query memory: 0.044 MB Memory before query: 18.846 MB Rows returned: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `yqj0_categories` AS `s`
INNER JOIN `yqj0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 247
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms System lock 0.01 ms init 0.03 ms optimizing 0.03 ms statistics 0.05 ms preparing 0.00 ms executing 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.02 ms cleaning up 0.01 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 23 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41 22 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/helpers/legacyrouter.php:85 21 DPCalendarRouterLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 20 Joomla\CMS\Component\Router\RouterView->build() JROOT/components/com_dpcalendar/router.php:78 19 DPCalendarRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52 13 Joomla\CMS\Router\Route::_() JROOT/components/com_dpcalendar/helpers/route.php:58 12 DPCalendarHelperRoute::getEventRoute() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:29 11 DPCalendar\Router\Router->getEventRoute() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:137 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.44 ms After last query: 4.82 ms Query memory: 0.043 MB Memory before query: 19.041 MB Rows returned: 16
SHOW FULL COLUMNS
FROM `yqj0_users`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `yqj0_users`Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.32 ms System lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.22 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.05 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.21 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.01 ms # Caller File and line number 32 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 31 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 30 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 29 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 28 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:40 27 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:312 26 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 25 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:880 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:16 20 DPCalendar\Helper\UserHelper->getUser() JROOT/components/com_dpcalendar/layouts/schema/performer.php:10 19 include JROOT/components/com_dpcalendar/layouts/schema/performer.php JROOT/libraries/src/Layout/FileLayout.php:125 18 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 17 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16 16 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/components/com_dpcalendar/layouts/schema/event.php:15 15 include JROOT/components/com_dpcalendar/layouts/schema/event.php JROOT/libraries/src/Layout/FileLayout.php:125 14 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 13 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16 12 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/modules/mod_dpcalendar_upcoming/tmpl/simple.php:67 11 require JROOT/modules/mod_dpcalendar_upcoming/tmpl/simple.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:168 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.52 ms After last query: 0.14 ms Query memory: 0.039 MB Memory before query: 19.092 MB Rows returned: 1
SELECT *
FROM `yqj0_users`
WHERE `id` = 944id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_users const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.02 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 26 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:86 25 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:883 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:16 20 DPCalendar\Helper\UserHelper->getUser() JROOT/components/com_dpcalendar/layouts/schema/performer.php:10 19 include JROOT/components/com_dpcalendar/layouts/schema/performer.php JROOT/libraries/src/Layout/FileLayout.php:125 18 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 17 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16 16 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/components/com_dpcalendar/layouts/schema/event.php:15 15 include JROOT/components/com_dpcalendar/layouts/schema/event.php JROOT/libraries/src/Layout/FileLayout.php:125 14 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 13 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16 12 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/modules/mod_dpcalendar_upcoming/tmpl/simple.php:67 11 require JROOT/modules/mod_dpcalendar_upcoming/tmpl/simple.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:168 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 3.55 ms Query memory: 0.035 MB Memory before query: 19.851 MB Rows returned: 1
SELECT `g`.`id`,`g`.`title`
FROM `yqj0_usergroups` AS g
INNER JOIN `yqj0_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 944id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 db665772483.m.group_id 1 Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.02 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.01 ms cleaning up 0.00 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 26 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:111 25 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:883 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:16 20 DPCalendar\Helper\UserHelper->getUser() JROOT/components/com_dpcalendar/layouts/schema/performer.php:10 19 include JROOT/components/com_dpcalendar/layouts/schema/performer.php JROOT/libraries/src/Layout/FileLayout.php:125 18 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 17 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16 16 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/components/com_dpcalendar/layouts/schema/event.php:15 15 include JROOT/components/com_dpcalendar/layouts/schema/event.php JROOT/libraries/src/Layout/FileLayout.php:125 14 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 13 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16 12 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/modules/mod_dpcalendar_upcoming/tmpl/simple.php:67 11 require JROOT/modules/mod_dpcalendar_upcoming/tmpl/simple.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:168 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 6.31 ms Query memory: 0.039 MB Memory before query: 19.872 MB Rows returned: 1
SELECT *
FROM `yqj0_users`
WHERE `id` = 1358id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE yqj0_users const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 26 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:86 25 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:883 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:16 20 DPCalendar\Helper\UserHelper->getUser() JROOT/components/com_dpcalendar/layouts/schema/performer.php:10 19 include JROOT/components/com_dpcalendar/layouts/schema/performer.php JROOT/libraries/src/Layout/FileLayout.php:125 18 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 17 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16 16 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/components/com_dpcalendar/layouts/schema/event.php:15 15 include JROOT/components/com_dpcalendar/layouts/schema/event.php JROOT/libraries/src/Layout/FileLayout.php:125 14 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 13 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16 12 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/modules/mod_dpcalendar_upcoming/tmpl/simple.php:67 11 require JROOT/modules/mod_dpcalendar_upcoming/tmpl/simple.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:168 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 0.16 ms Query memory: 0.035 MB Memory before query: 19.894 MB Rows returned: 1
SELECT `g`.`id`,`g`.`title`
FROM `yqj0_usergroups` AS g
INNER JOIN `yqj0_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 1358id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 db665772483.m.group_id 1 Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 26 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:111 25 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:883 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:16 20 DPCalendar\Helper\UserHelper->getUser() JROOT/components/com_dpcalendar/layouts/schema/performer.php:10 19 include JROOT/components/com_dpcalendar/layouts/schema/performer.php JROOT/libraries/src/Layout/FileLayout.php:125 18 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 17 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16 16 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/components/com_dpcalendar/layouts/schema/event.php:15 15 include JROOT/components/com_dpcalendar/layouts/schema/event.php JROOT/libraries/src/Layout/FileLayout.php:125 14 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 13 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16 12 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/modules/mod_dpcalendar_upcoming/tmpl/simple.php:67 11 require JROOT/modules/mod_dpcalendar_upcoming/tmpl/simple.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:168 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.70 ms After last query: 3.83 ms Query memory: 0.036 MB Memory before query: 19.793 MB Rows returned: 0
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `yqj0_dpcalendar_caldav_calendarinstances` c
LEFT
OUTER JOIN yqj0_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from yqj0_dpcalendar_caldav_principals memberp
inner join yqj0_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join yqj0_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
LIMIT 20id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using filesort 1 PRIMARY mainp eq_ref uri uri 202 db665772483.c.principaluri 1 Using where 2 DERIVED m index principal_id principal_id 8 NULL 1 Using index 2 DERIVED memberp eq_ref PRIMARY PRIMARY 4 db665772483.m.member_id 1 2 DERIVED linkp eq_ref PRIMARY PRIMARY 4 db665772483.m.principal_id 1 Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.05 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms init 0.04 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.02 ms Sending data 0.03 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.01 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 18 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/profile.php:36 17 DPCalendarModelProfile->getItems() JROOT/plugins/system/dpcalendar/dpcalendar.php:301 16 PlgSystemDpcalendar->fetchCalendars() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:436 15 DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 12 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/components/com_dpcalendar/models/calendar.php:93 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_counter/mod_dpcalendar_counter.php:42 10 include JROOT/modules/mod_dpcalendar_counter/mod_dpcalendar_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.41 ms After last query: 0.30 ms Query memory: 0.046 MB Memory before query: 19.810 MB Rows returned: 1
SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
FROM `yqj0_dpcalendar_events` AS a
LEFT JOIN yqj0_categories AS c
ON c.id = a.catid
LEFT JOIN yqj0_dpcalendar_events_location AS rel
ON a.id = rel.event_id
LEFT JOIN yqj0_dpcalendar_locations AS v
ON rel.location_id = v.id
LEFT JOIN yqj0_users AS ua
ON ua.id = a.created_by
LEFT JOIN yqj0_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.original_id > -1
AND a.catid IN ('9')
AND (c.access IN (1,1,5) or c.access is null)
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-16 08:15:36')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-16 08:15:36')
AND ((a.end_date between '2018-12-16 08:15:00'
and '2019-12-16 08:15:00' or a.start_date between '2018-12-16 08:15:00'
and '2019-12-16 08:15:00' or (a.start_date < '2018-12-16 08:15:00'
and a.end_date > '2019-12-16 08:15:00')))
AND a.language in ('de-DE','*')
GROUP BY a.id
ORDER BY a.start_date asc
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a index idx_access,idx_start_date,idx_end_date,idx_state,idx_catid,idx_language idx_start_date 8 NULL 1 Using where; Using temporary 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 db665772483.a.catid 1 Using where 1 SIMPLE rel ref PRIMARY PRIMARY 4 db665772483.a.id 2 Using index 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 db665772483.rel.location_id 1 Using index 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 db665772483.a.created_by 1 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 db665772483.a.modified_by 1 Using index Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.17 ms optimizing 0.03 ms statistics 0.24 ms preparing 0.04 ms Creating tmp table 0.58 ms Sorting for group 0.97 ms executing 0.01 ms Copying to tmp table 0.55 ms Sorting result 0.03 ms Sending data 0.13 ms end 0.01 ms removing tmp table 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms removing tmp table 0.01 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 12 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/events.php:108 11 DPCalendarModelEvents->getItems() JROOT/modules/mod_dpcalendar_counter/mod_dpcalendar_counter.php:78 10 include JROOT/modules/mod_dpcalendar_counter/mod_dpcalendar_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 0.16 ms Query memory: 0.039 MB Memory before query: 19.841 MB Rows returned: 1Duplicate queries: #30
SELECT a.*,l.title AS language_title,uc.name AS editor
FROM `yqj0_dpcalendar_locations` AS a
LEFT JOIN `yqj0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yqj0_users AS uc
ON uc.id=a.checked_out
WHERE a.id in (19)
ORDER BY ordering ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE l const idx_langcode idx_langcode 28 const 0 unique row not found 1 SIMPLE uc const PRIMARY PRIMARY 4 const 0 unique row not found Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_dpcalendar/models/locations.php:91 12 DPCalendarModelLocations->getItems() JROOT/components/com_dpcalendar/models/events.php:135 11 DPCalendarModelEvents->getItems() JROOT/modules/mod_dpcalendar_counter/mod_dpcalendar_counter.php:78 10 include JROOT/modules/mod_dpcalendar_counter/mod_dpcalendar_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
27 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
7 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `yqj0_categories` AS `s`
INNER JOIN `yqj0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)5 × SELECT a.*,l.title AS language_title,uc.name AS editor
FROM `yqj0_dpcalendar_locations` AS a
LEFT JOIN `yqj0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yqj0_users AS uc
ON uc.id=a.checked_out5 × SELECT *
FROM yqj0_assets3 × SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `yqj0_dpcalendar_caldav_calendarinstances` c
LEFT
OUTER JOIN yqj0_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from yqj0_dpcalendar_caldav_principals memberp
inner join yqj0_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join yqj0_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')2 × SELECT `g`.`id`,`g`.`title`
FROM `yqj0_usergroups` AS g
INNER JOIN `yqj0_user_usergroup_map` AS m
ON m.group_id = g.id2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `yqj0_extensions`2 × SELECT *
FROM `yqj0_users`2 × SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
FROM `yqj0_dpcalendar_events` AS a
LEFT JOIN yqj0_categories AS c
ON c.id = a.catid
LEFT JOIN yqj0_dpcalendar_events_location AS rel
ON a.id = rel.event_id
LEFT JOIN yqj0_dpcalendar_locations AS v
ON rel.location_id = v.id
LEFT JOIN yqj0_users AS ua
ON ua.id = a.created_by
LEFT JOIN yqj0_users AS uam
ON uam.id = a.modified_by2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `yqj0_assets`1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM yqj0_fields AS a
LEFT JOIN `yqj0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yqj0_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yqj0_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yqj0_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yqj0_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `yqj0_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `yqj0_categories` AS `c`1 × SELECT `data`
FROM `yqj0_session`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM yqj0_modules AS m
LEFT JOIN yqj0_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN yqj0_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `session_id`
FROM `yqj0_session`1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `yqj0_comprofiler_plugin`1 × SELECT `params`
FROM `yqj0_comprofiler_plugin`1 × SELECT id, home, template, s.params
FROM yqj0_template_styles as s
LEFT JOIN yqj0_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM yqj0_languages1 × 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 yqj0_menu AS m
LEFT JOIN yqj0_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM yqj0_extensions1 × SELECT b.id
FROM yqj0_usergroups AS a
LEFT JOIN yqj0_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `yqj0_viewlevels1 × SELECT id, title, module, position, content, showtitle, params
FROM yqj0_modules AS m
Andere Tabellen:
1 × INSERT INTO `yqj0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('6446a38503bdb0c0606dc43823c9f40c', 1, 1544948135, 0, '', 01 × UPDATE `yqj0_extensions`
SET `params` = '{\"mediaversion\":\"caa33964d5f722e3e2e7517b3e7227fd\"}'1 × SHOW FULL COLUMNS
FROM `yqj0_assets1 × SHOW FULL COLUMNS
FROM `yqj0_users