- Klinikker
- BeneFiT Randers
- BeneFiT Skagen
- BeneFiT Søndersø
- BeneFiT Frederikshavn
- BeneFiT Sæby
- BeneFiT Holstebro
- BeneFiT Dronninglund
- BeneFiT Støvring
- BeneFiT Skørping
- BeneFiT Hadsund
- BeneFiT Hobro
- BeneFiT Viborg
- BeneFiT Karup
- BeneFiT Holbæk
- BeneFiT Højbjerg
- BeneFiT Herning
- BeneFiT Lind
- BeneFiT Morud
- BeneFiT Hals
- BeneFiT Odense
- BeneFiT Stenstrup
- BeneFiT Rudkøbing
- BeneFiT Osted
- BeneFiT Ergoterapi
- BeneFiT Thorning
- Sund virksomhed
- Viden om
- Øvelsesbank
- Om BeneFiT Danmark
- Kontakt os
-
Odensevej 73 Se kort5471 SøndersøTelefon 64 89 30 01Email Denne e-mail adresse bliver beskyttet mod spambots. Du skal have JavaScript aktiveret for at vise den.
BeneFiT Randers
Hele vores organisation arbejder tæt sammen på tværs af sundhedsfaglige specialer og på tværs af geografien, for aktivt at udnytte den nyeste viden om sundhed og menneskelig adfærd.
© BeneFiT Danmark
Joomla! fejlsøgningskonsol
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1642469479,
"last": 1642469479,
"now": 1642469479
},
"token": "QJYgPvWq9fteJwCISXMAaIu8zrid89To"
},
"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
},
"com_zoo": {
"zootrack": {
"items": {
"current": null
},
"categories": {
"current": "538"
}
}
}
}
}
Tid
Hukommelse
Tid: 3.83 ms / 3.83 ms Hukommelse: 0.512 MB / 0.88 MB Application: afterLoad
Tid: 63.41 ms / 67.24 ms Hukommelse: 2.194 MB / 3.07 MB Application: afterInitialise
Tid: 19.24 ms / 86.48 ms Hukommelse: 2.678 MB / 5.75 MB Application: afterRoute
Tid: 0.44 ms / 86.92 ms Hukommelse: 0.013 MB / 5.76 MB Application: beforeRenderComponent com_zoo
Tid: 2.04 ms / 88.96 ms Hukommelse: 0.218 MB / 5.98 MB Application: Before Access::preloadComponents (all components)
Tid: 0.55 ms / 89.51 ms Hukommelse: 0.043 MB / 6.02 MB Application: After Access::preloadComponents (all components)
Tid: 0.02 ms / 89.52 ms Hukommelse: -0.003 MB / 6.02 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Tid: 0.11 ms / 89.63 ms Hukommelse: 0.009 MB / 6.03 MB Application: After Access::getAssetRules (id:1 name:root.1)
Tid: 237.90 ms / 327.53 ms Hukommelse: 22.479 MB / 28.51 MB Application: afterRenderComponent com_zoo
Tid: 0.87 ms / 328.40 ms Hukommelse: 0.021 MB / 28.53 MB Application: afterDispatch
Tid: 26.92 ms / 355.32 ms Hukommelse: 2.102 MB / 30.63 MB Application: beforeRenderModule mod_finder ()
Tid: 5.98 ms / 361.31 ms Hukommelse: -0.178 MB / 30.45 MB Application: afterRenderModule mod_finder ()
Tid: 0.16 ms / 361.46 ms Hukommelse: -0.002 MB / 30.45 MB Application: beforeRenderModule mod_menu ()
Tid: 3.60 ms / 365.06 ms Hukommelse: 0.263 MB / 30.71 MB Application: afterRenderModule mod_menu ()
Tid: 0.12 ms / 365.18 ms Hukommelse: -0.118 MB / 30.59 MB Application: beforeRenderModule mod_menu (Menu Mobil Søndersø)
Tid: 0.53 ms / 365.71 ms Hukommelse: 0.049 MB / 30.64 MB Application: afterRenderModule mod_menu (Menu Mobil Søndersø)
Tid: 0.02 ms / 365.73 ms Hukommelse: -0.024 MB / 30.62 MB Application: beforeRenderModule mod_menu (Mobile Menu (BeneFIT DK))
Tid: 1.24 ms / 366.98 ms Hukommelse: 0.176 MB / 30.79 MB Application: afterRenderModule mod_menu (Mobile Menu (BeneFIT DK))
Tid: 0.02 ms / 366.99 ms Hukommelse: -0.098 MB / 30.70 MB Application: beforeRenderModule mod_finder ()
Tid: 0.60 ms / 367.59 ms Hukommelse: 0.012 MB / 30.71 MB Application: afterRenderModule mod_finder ()
Tid: 3.27 ms / 370.86 ms Hukommelse: 0.279 MB / 30.99 MB Application: afterRender
Database forespørgsler total: 35.47 ms
31.59 MB (33,127,568 Bytes)
50 forespørgsler logget 35.47 ms
10 dubletter fundet!
- Forespørgsels tid: 0.56 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 1.239 MB Rækker returneret: 0
SELECT `data`
FROM `zoo4_session`
WHERE `session_id` = X'3033623962316634313631633638333937393761313338613836303536376430'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.04 ms init 0.03 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.06 ms executing 0.03 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Samme som kald i linjen nedenunder. 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:854 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Forespørgsels tid: 0.56 ms Efter sidste forespørgsel: 0.74 ms Forespørgsels hukommelse: 0.020 MB hukommelse før forespørgsel: 1.254 MB Rækker returneret: 0
SELECT `session_id`
FROM `zoo4_session`
WHERE `session_id` = X'3033623962316634313631633638333937393761313338613836303536376430'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.13 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms executing 0.03 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Forespørgsels tid: 6.95 ms Efter sidste forespørgsel: 0.21 ms Forespørgsels hukommelse: 0.004 MB hukommelse før forespørgsel: 1.260 MB
INSERT INTO `zoo4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3033623962316634313631633638333937393761313338613836303536376430', 1, 1642469479, 0, '', 0)FORKLAR ikke mulig på forespørgsel: INSERT INTO `zoo4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3033623962316634313631633638333937393761313338613836303536376430', 1, 1642469479, 0, '', 0)Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.05 ms init 0.03 ms System lock 0.02 ms update 0.14 ms end 0.01 ms query end 6.38 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Forespørgsels tid: 1.12 ms Efter sidste forespørgsel: 1.09 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 1.295 MB Rækker returneret: 39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `zoo4_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_extensions NULL ref extension extension 82 const 39 1.00 Using where Status Duration starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.04 ms executing 0.01 ms Sending data 0.42 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Kalder Fil og linjenummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Samme som kald i linjen nedenunder. 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.49 ms Efter sidste forespørgsel: 1.04 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 1.389 MB Rækker returneret: 5
SELECT id, rules
FROM `zoo4_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_viewlevels NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL 5 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.75 ms Efter sidste forespørgsel: 0.23 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 1.401 MB Rækker returneret: 2
SELECT b.id
FROM zoo4_usergroups AS a
LEFT JOIN zoo4_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.04 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 2.19 ms Efter sidste forespørgsel: 0.35 ms Forespørgsels hukommelse: 0.030 MB hukommelse før forespørgsel: 1.424 MB Rækker returneret: 100
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM zoo4_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_extensions NULL ref extension extension 82 const 141 0.60 Using index condition; Using where; Anvender filesort Status Duration starting 0.12 ms checking permissions 0.02 ms Opening tables 0.04 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.05 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.46 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Kalder Fil og linjenummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Samme som kald i linjen nedenunder. 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:356 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.33 ms Efter sidste forespørgsel: 29.55 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 2.543 MB Rækker returneret: 1
SELECT id,template
FROM zoo4_template_styles
WHERE client_id=0
AND home=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_template_styles NULL ref idx_client_id,idx_client_id_home idx_client_id 1 const 3 20.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/administrator/components/com_widgetkit/widgetkit.php:23 16 plgSystemWidgetkit_zl->{closure}() JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240 15 YOOtheme\Framework\Container->offsetGet() JROOT/administrator/components/com_widgetkit/src/Application.php:50 14 YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}() Samme som kald i linjen nedenunder. 13 call_user_func_array() JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113 12 YOOtheme\Framework\Event\EventDispatcher->trigger() JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149 11 YOOtheme\Framework\Application->boot() JROOT/administrator/components/com_widgetkit/widgetkit.php:103 10 include JROOT/administrator/components/com_widgetkit/widgetkit.php JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6 9 include JROOT/administrator/components/com_widgetkit/widgetkit-app.php JROOT/plugins/system/widgetkit_zl/widgetkit_zl.php:26 8 plgSystemWidgetkit_zl->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:696 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.26 ms Efter sidste forespørgsel: 4.79 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 2.997 MB Rækker returneret: 26
SELECT *
FROM zoo4_rsform_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_rsform_config NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL 26 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php:50 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php:17 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php:102 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28 8 plgSystemRsformdeletesubmissions->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:696 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 3.38 ms Efter sidste forespørgsel: 1.79 ms Forespørgsels hukommelse: 0.501 MB hukommelse før forespørgsel: 3.165 MB Rækker returneret: 576
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 zoo4_menu AS m
LEFT JOIN zoo4_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL 666 9.38 Using where; Anvender filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 benefit_jos1.m.component_id 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 3.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Samme som kald i linjen nedenunder. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:445 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:561 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1169 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.32 ms Efter sidste forespørgsel: 6.42 ms Forespørgsels hukommelse: 0.077 MB hukommelse før forespørgsel: 5.343 MB Rækker returneret: 3
SELECT id, home, template, s.params
FROM zoo4_template_styles as s
LEFT JOIN zoo4_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 3 100.00 NULL 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 benefit_jos1.s.template,const 1 4.67 Using index condition; Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 14 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeLoader.php:88 13 YOOtheme\Theme\Joomla\ThemeLoader::getTemplate() JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeLoader.php:38 12 YOOtheme\Theme\Joomla\ThemeLoader::initTheme() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 11 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 10 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 9 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 8 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 7 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.20 ms Efter sidste forespørgsel: 1.86 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.545 MB Rækker returneret: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `zoo4_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 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.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 19 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 18 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Samme som kald i linjen nedenunder. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 15 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 14 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 13 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/zooseo/zooseo.php:540 9 plgSystemZooSeo->addOpenGraphTags() JROOT/plugins/system/zooseo/zooseo.php:91 8 plgSystemZooSeo->onAfterRoute() 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:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 5.40 ms Efter sidste forespørgsel: 0.08 ms Forespørgsels hukommelse: 0.006 MB hukommelse før forespørgsel: 5.538 MB
UPDATE `zoo4_extensions`
SET `params` = '{\"mediaversion\":\"8db516d671265e58d2bc69d9e0967673\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE zoo4_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.04 ms updating 0.03 ms end 0.01 ms query end 5.21 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/zooseo/zooseo.php:540 9 plgSystemZooSeo->addOpenGraphTags() JROOT/plugins/system/zooseo/zooseo.php:91 8 plgSystemZooSeo->onAfterRoute() 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:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.14 ms Efter sidste forespørgsel: 1.24 ms Forespørgsels hukommelse: 0.019 MB hukommelse før forespørgsel: 5.750 MB Rækker returneret: 1
SELECT *
FROM zoo4_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_languages NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL 1 100.00 Using where; Anvender filesort Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.15 ms Efter sidste forespørgsel: 1.38 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 5.902 MB Rækker returneret: 1
SELECT *
FROM zoo4_zoo_application
WHERE id = 6id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_zoo_application NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 13 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 12 DatabaseHelper->query() JROOT/administrator/components/com_zoo/framework/classes/table.php:399 11 AppTable->_queryObject() JROOT/administrator/components/com_zoo/framework/classes/table.php:189 10 AppTable->find() JROOT/administrator/components/com_zoo/tables/application.php:131 9 ApplicationTable->find() JROOT/administrator/components/com_zoo/framework/classes/table.php:136 8 AppTable->get() JROOT/administrator/components/com_zoo/helpers/zoo.php:83 7 ZooHelper->getApplication() JROOT/components/com_zoo/zoo.php:32 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.46 ms Efter sidste forespørgsel: 0.77 ms Forespørgsels hukommelse: 0.028 MB hukommelse før forespørgsel: 5.967 MB Rækker returneret: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `zoo4_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','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_rsform','com_schuweb_sitemap','com_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper','com_zoo')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_assets NULL range idx_asset_name idx_asset_name 202 NULL 40 100.00 Using index condition Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.00 ms Sending data 0.22 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_zoo/framework/helpers/user.php:222 14 UserAppHelper->isJoomlaSuperAdmin() JROOT/administrator/components/com_zoo/framework/helpers/user.php:54 13 UserAppHelper->get() JROOT/components/com_zoo/controllers/default.php:222 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.07 ms Efter sidste forespørgsel: 0.25 ms Forespørgsels hukommelse: 0.009 MB hukommelse før forespørgsel: 6.095 MB
SET SESSION group_concat_max_len = 1048576FORKLAR ikke mulig på forespørgsel: SET SESSION group_concat_max_len = 1048576Status Duration starting 0.02 ms Opening tables 0.01 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 17 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 16 DatabaseHelper->query() JROOT/administrator/components/com_zoo/tables/category.php:191 15 CategoryTable->getAll() JROOT/administrator/components/com_zoo/classes/application.php:446 14 Application->getCategories() JROOT/administrator/components/com_zoo/classes/application.php:470 13 Application->getCategoryTree() JROOT/components/com_zoo/controllers/default.php:222 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 1.13 ms Efter sidste forespørgsel: 0.09 ms Forespørgsels hukommelse: 0.049 MB hukommelse før forespørgsel: 6.107 MB Rækker returneret: 34
SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids
FROM zoo4_zoo_category as c USE INDEX (APPLICATIONID_ID_INDEX)
LEFT JOIN zoo4_zoo_category_item as ci
ON ci.category_id = c.id
LEFT JOIN zoo4_zoo_item AS i USE INDEX (MULTI_INDEX2)
ON ci.item_id = i.id
AND i.access IN (1,5)
AND i.state = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-01-18 01:31:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-01-18 01:31:19')
WHERE c.application_id = 6
AND c.published = 1
GROUP BY c.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref PRIMARY,ALIAS_INDEX,PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2 APPLICATIONID_ID_INDEX 5 const,const 34 100.00 Using index condition 1 SIMPLE ci NULL ref PRIMARY,CATEGORYID_INDEX CATEGORYID_INDEX 4 benefit_jos1.c.id 12 100.00 Using index 1 SIMPLE i NULL ref MULTI_INDEX2 MULTI_INDEX2 4 benefit_jos1.ci.item_id 1 100.00 Using where; Using index 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 init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.82 ms end 0.01 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 20 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 19 DatabaseHelper->query() JROOT/administrator/components/com_zoo/framework/classes/table.php:425 18 AppTable->_queryObjectList() JROOT/administrator/components/com_zoo/framework/classes/table.php:192 17 AppTable->find() JROOT/administrator/components/com_zoo/framework/classes/table.php:165 16 AppTable->all() JROOT/administrator/components/com_zoo/tables/category.php:217 15 CategoryTable->getAll() JROOT/administrator/components/com_zoo/classes/application.php:446 14 Application->getCategories() JROOT/administrator/components/com_zoo/classes/application.php:470 13 Application->getCategoryTree() JROOT/components/com_zoo/controllers/default.php:222 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.55 ms Efter sidste forespørgsel: 0.47 ms Forespørgsels hukommelse: 0.041 MB hukommelse før forespørgsel: 6.217 MB Rækker returneret: 8
SELECT a.*
FROM zoo4_zoo_item AS a
LEFT JOIN zoo4_zoo_category_item AS b
ON a.id = b.item_id
WHERE a.application_id = 6
AND a.access IN (1,5)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-01-18 01:31:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-01-18 01:31:19')
AND b.category_id IN (538)
GROUP BY a.id
ORDER BY a.priority DESC, a.name ASC
LIMIT 0,15id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX CATEGORYID_INDEX 4 const 10 100.00 Using where; Using index; Using temporary; Anvender filesort 1 SIMPLE a NULL eq_ref PRIMARY,ALIAS_INDEX,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,CREATED_BY_INDEX,NAME_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX,SEARCH_FULLTEXT PRIMARY 4 benefit_jos1.b.item_id 1 27.01 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.24 ms Creating sort index 0.06 ms end 0.00 ms query end 0.00 ms removing tmp table 0.02 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 16 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 15 DatabaseHelper->query() JROOT/administrator/components/com_zoo/framework/classes/table.php:425 14 AppTable->_queryObjectList() JROOT/administrator/components/com_zoo/tables/item.php:469 13 ItemTable->getByCategory() JROOT/components/com_zoo/controllers/default.php:245 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.60 ms Efter sidste forespørgsel: 6.02 ms Forespørgsels hukommelse: 2.376 MB hukommelse før forespørgsel: 6.757 MB Rækker returneret: 1
SELECT custom_data
FROM zoo4_extensions
WHERE element = 'yootheme'
AND folder = 'system'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_extensions NULL ref element_clientid,element_folder_clientid element_folder_clientid 804 const,const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.47 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 36 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 35 JDatabaseDriver->loadAssoc() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Database.php:39 34 YOOtheme\Joomla\Database->fetchAssoc() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Storage.php:23 33 YOOtheme\Joomla\Storage->__construct() Samme som kald i linjen nedenunder. 32 ReflectionClass->newInstanceArgs() JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:181 31 YOOtheme\Container\Service->resolveClass() JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:154 30 YOOtheme\Container\Service->resolveInstance() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:327 29 YOOtheme\Container->resolve() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:92 28 YOOtheme\Container->get() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:408 27 YOOtheme\Container->resolveDependencies() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:358 26 YOOtheme\Container->resolveArguments() JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:179 25 YOOtheme\Container\Service->resolveClass() JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:154 24 YOOtheme\Container\Service->resolveInstance() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:327 23 YOOtheme\Container->resolve() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:92 22 YOOtheme\Container->get() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:408 21 YOOtheme\Container->resolveDependencies() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:358 20 YOOtheme\Container->resolveArguments() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:274 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.70 ms Efter sidste forespørgsel: 41.40 ms Forespørgsels hukommelse: 0.060 MB hukommelse før forespørgsel: 25.506 MB Rækker returneret: 11
SELECT a.*
FROM zoo4_zoo_item AS a JOIN zoo4_zoo_tag AS c
ON a.id = c.item_id
LEFT JOIN zoo4_zoo_search_index AS s
ON a.id = s.item_id
AND s.element_id IN ('66535925-d898-4f8d-96a7-114f8cccddd0')
WHERE a.type = 'medarbejder'
AND a.application_id = 6
AND a.access IN (1,5)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-01-18 01:31:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-01-18 01:31:19')
AND c.name IN ('søndersø')
GROUP BY a.id
ORDER BY a.priority DESC,
CASE WHEN ISNULL(s.value) THEN a.name ELSE s.value END+0<>0 DESC,
CASE WHEN ISNULL(s.value) THEN a.name ELSE s.value END+0,
CASE WHEN ISNULL(s.value) THEN a.name ELSE s.value END
LIMIT 0, 30id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref PRIMARY,NAME_ITEMID_INDEX NAME_ITEMID_INDEX 767 const 16 100.00 Using index; Using temporary; Anvender filesort 1 SIMPLE a NULL eq_ref PRIMARY,ALIAS_INDEX,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,CREATED_BY_INDEX,NAME_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX,SEARCH_FULLTEXT PRIMARY 4 benefit_jos1.c.item_id 1 16.00 Using where 1 SIMPLE s NULL eq_ref PRIMARY PRIMARY 771 benefit_jos1.c.item_id,const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.28 ms Creating sort index 0.07 ms end 0.00 ms query end 0.00 ms removing tmp table 0.02 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 59 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 58 DatabaseHelper->query() JROOT/administrator/components/com_zoo/framework/classes/table.php:425 57 AppTable->_queryObjectList() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:250 56 ItemTable->YOOtheme\Builder\Joomla\Zoo\Type\{closure}() Samme som kald i linjen nedenunder. 55 call_user_func() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:263 54 YOOtheme\Builder\Joomla\Zoo\Type\CustomItemsQueryType::thru() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:251 53 YOOtheme\Builder\Joomla\Zoo\Type\CustomItemsQueryType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 52 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Directive/CallDirective.php:62 51 YOOtheme\GraphQL\Directive\CallDirective->YOOtheme\GraphQL\Directive\{closure}() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 50 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 49 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 48 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.21 ms Efter sidste forespørgsel: 19.56 ms Forespørgsels hukommelse: 0.050 MB hukommelse før forespørgsel: 26.476 MB Rækker returneret: 1
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=1969
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=1969
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.17 ms Efter sidste forespørgsel: 6.44 ms Forespørgsels hukommelse: 0.050 MB hukommelse før forespørgsel: 26.546 MB Rækker returneret: 1
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=1979
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=1979
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.19 ms Efter sidste forespørgsel: 5.84 ms Forespørgsels hukommelse: 0.050 MB hukommelse før forespørgsel: 26.595 MB Rækker returneret: 1
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=1973
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=1973
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.22 ms Efter sidste forespørgsel: 5.38 ms Forespørgsels hukommelse: 0.050 MB hukommelse før forespørgsel: 26.643 MB Rækker returneret: 1
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2124
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2124
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.18 ms Efter sidste forespørgsel: 4.42 ms Forespørgsels hukommelse: 0.049 MB hukommelse før forespørgsel: 26.691 MB Rækker returneret: 0Dublet forespørgsler: #34
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2054
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2054
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.00 ms executing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.16 ms Efter sidste forespørgsel: 5.63 ms Forespørgsels hukommelse: 0.050 MB hukommelse før forespørgsel: 26.738 MB Rækker returneret: 1
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2043
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2043
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.18 ms Efter sidste forespørgsel: 5.70 ms Forespørgsels hukommelse: 0.050 MB hukommelse før forespørgsel: 26.787 MB Rækker returneret: 1
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2129
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2129
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.25 ms Efter sidste forespørgsel: 5.31 ms Forespørgsels hukommelse: 0.049 MB hukommelse før forespørgsel: 26.835 MB Rækker returneret: 0Dublet forespørgsler: #35
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2025
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2025
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.19 ms Efter sidste forespørgsel: 6.52 ms Forespørgsels hukommelse: 0.049 MB hukommelse før forespørgsel: 26.883 MB Rækker returneret: 0Dublet forespørgsler: #36
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2922
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2922
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.24 ms Efter sidste forespørgsel: 7.84 ms Forespørgsels hukommelse: 0.050 MB hukommelse før forespørgsel: 26.931 MB Rækker returneret: 1
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2181
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2181
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.34 ms Efter sidste forespørgsel: 12.73 ms Forespørgsels hukommelse: 0.050 MB hukommelse før forespørgsel: 26.979 MB Rækker returneret: 1
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2012
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2012
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.02 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms executing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 1.59 ms Efter sidste forespørgsel: 8.46 ms Forespørgsels hukommelse: 0.061 MB hukommelse før forespørgsel: 27.014 MB Rækker returneret: 11
SELECT a.*
FROM zoo4_zoo_item AS a JOIN zoo4_zoo_tag AS c
ON a.id = c.item_id
LEFT JOIN zoo4_zoo_search_index AS s
ON a.id = s.item_id
AND s.element_id IN ('66535925-d898-4f8d-96a7-114f8cccddd0')
WHERE a.type = 'medarbejder'
AND a.application_id = 6
AND a.access IN (1,5)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-01-18 01:31:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-01-18 01:31:19')
AND c.name IN ('søndersø')
GROUP BY a.id
ORDER BY a.priority DESC,
CASE WHEN ISNULL(s.value) THEN a.name ELSE s.value END ASC
LIMIT 0, 30id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref PRIMARY,NAME_ITEMID_INDEX NAME_ITEMID_INDEX 767 const 16 100.00 Using index; Using temporary; Anvender filesort 1 SIMPLE a NULL eq_ref PRIMARY,ALIAS_INDEX,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,CREATED_BY_INDEX,NAME_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX,SEARCH_FULLTEXT PRIMARY 4 benefit_jos1.c.item_id 1 16.00 Using where 1 SIMPLE s NULL eq_ref PRIMARY PRIMARY 771 benefit_jos1.c.item_id,const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.28 ms preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.57 ms Creating sort index 0.22 ms end 0.01 ms query end 0.01 ms removing tmp table 0.04 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 59 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 58 DatabaseHelper->query() JROOT/administrator/components/com_zoo/framework/classes/table.php:425 57 AppTable->_queryObjectList() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:250 56 ItemTable->YOOtheme\Builder\Joomla\Zoo\Type\{closure}() Samme som kald i linjen nedenunder. 55 call_user_func() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:263 54 YOOtheme\Builder\Joomla\Zoo\Type\CustomItemsQueryType::thru() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:251 53 YOOtheme\Builder\Joomla\Zoo\Type\CustomItemsQueryType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 52 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Directive/CallDirective.php:62 51 YOOtheme\GraphQL\Directive\CallDirective->YOOtheme\GraphQL\Directive\{closure}() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 50 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 49 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 48 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.40 ms Efter sidste forespørgsel: 21.17 ms Forespørgsels hukommelse: 0.049 MB hukommelse før forespørgsel: 27.311 MB Rækker returneret: 0Dublet forespørgsler: #26
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2054
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2054
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.02 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.28 ms Efter sidste forespørgsel: 13.16 ms Forespørgsels hukommelse: 0.049 MB hukommelse før forespørgsel: 27.383 MB Rækker returneret: 0Dublet forespørgsler: #29
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2025
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2025
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary 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 init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.02 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.30 ms Efter sidste forespørgsel: 7.01 ms Forespørgsels hukommelse: 0.049 MB hukommelse før forespørgsel: 27.430 MB Rækker returneret: 0Dublet forespørgsler: #30
SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2922
AND b.published = 1 UNION SELECT 0
FROM zoo4_zoo_category_item AS a
WHERE a.item_id=2922
AND a.category_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX ITEMID_INDEX 4 const 1 100.00 Using index 1 PRIMARY b NULL eq_ref PRIMARY,PUBLISHED_INDEX PRIMARY 4 benefit_jos1.a.category_id 1 72.58 Using where 2 UNION NULL NULL NULL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL no matching row in const table NULL UNION RESULT <union1,2> NULL ALL NULL INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL NULL NULL Using temporary 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 init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.02 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 70 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 69 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 68 DatabaseHelper->queryResultArray() JROOT/administrator/components/com_zoo/helpers/category.php:63 67 CategoryHelper->getItemsRelatedCategoryIds() JROOT/administrator/components/com_zoo/classes/item.php:565 66 Item->getRelatedCategoryIds() JROOT/administrator/components/com_zoo/helpers/route.php:296 65 RouteHelper->item() JROOT/media/zoo/elements/itemlink/itemlink.php:42 64 ElementItemLink->getValue() JROOT/plugins/system/zoopro/src/Type/ItemType.php:315 63 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolveElement() JROOT/plugins/system/zoopro/src/Type/ItemType.php:310 62 YOOtheme\Builder\Joomla\Zoo\Type\ItemType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 61 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 60 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 59 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 58 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 57 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 56 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 55 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 54 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 53 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 52 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1199 51 GraphQL\Executor\Executor->completeListValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:968 50 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 49 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 48 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.18 ms Efter sidste forespørgsel: 6.33 ms Forespørgsels hukommelse: 0.039 MB hukommelse før forespørgsel: 27.513 MB Rækker returneret: 1
SELECT *
FROM zoo4_zoo_item
WHERE id = 1847id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_zoo_item NULL const PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 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.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 54 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 53 DatabaseHelper->query() JROOT/administrator/components/com_zoo/framework/classes/table.php:399 52 AppTable->_queryObject() JROOT/administrator/components/com_zoo/framework/classes/table.php:189 51 AppTable->find() JROOT/administrator/components/com_zoo/framework/classes/table.php:136 50 AppTable->get() JROOT/plugins/system/zoopro/src/Type/CustomItemQueryType.php:212 49 YOOtheme\Builder\Joomla\Zoo\Type\CustomItemQueryType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 48 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Directive/CallDirective.php:62 47 YOOtheme\GraphQL\Directive\CallDirective->YOOtheme\GraphQL\Directive\{closure}() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 46 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 45 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 44 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 43 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 42 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 41 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 40 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 39 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 38 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 37 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 36 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 35 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 34 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 33 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 32 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 31 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 30 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 29 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 28 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 27 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 26 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 25 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.20 ms Efter sidste forespørgsel: 8.75 ms Forespørgsels hukommelse: 0.040 MB hukommelse før forespørgsel: 27.526 MB Rækker returneret: 1
SELECT *
FROM zoo4_zoo_item
WHERE id = 1876id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_zoo_item NULL const PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Kalder Fil og linjenummer 58 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 57 DatabaseHelper->query() JROOT/administrator/components/com_zoo/framework/classes/table.php:399 56 AppTable->_queryObject() JROOT/administrator/components/com_zoo/framework/classes/table.php:189 55 AppTable->find() JROOT/administrator/components/com_zoo/framework/classes/table.php:136 54 AppTable->get() JROOT/plugins/system/zoopro/src/Type/CustomItemQueryType.php:212 53 YOOtheme\Builder\Joomla\Zoo\Type\CustomItemQueryType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 52 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Directive/CallDirective.php:62 51 YOOtheme\GraphQL\Directive\CallDirective->YOOtheme\GraphQL\Directive\{closure}() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 50 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 49 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 48 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 47 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 46 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 45 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 44 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 43 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 42 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 41 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 40 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 39 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 38 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 37 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 36 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 35 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 34 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 33 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 32 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 31 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 30 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 29 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 28 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 27 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 26 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 25 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 24 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 23 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 22 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 21 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/TemplateListener.php:53 20 YOOtheme\Builder\Joomla\Source\TemplateListener::loadTemplate() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 19 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71 18 YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115 17 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45 16 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48 15 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 14 JEventDispatcher->trigger() JROOT/administrator/components/com_zoo/framework/classes/view.php:58 13 AppView->display() JROOT/components/com_zoo/controllers/default.php:342 12 DefaultController->category() JROOT/libraries/src/MVC/Controller/BaseController.php:702 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_zoo/controllers/default.php:60 10 DefaultController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_zoo/framework/classes/app.php:257 8 App->dispatch() JROOT/administrator/components/com_zoo/classes/application.php:294 7 Application->dispatch() JROOT/components/com_zoo/zoo.php:33 6 require_once JROOT/components/com_zoo/zoo.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.99 ms Efter sidste forespørgsel: 32.38 ms Forespørgsels hukommelse: 0.048 MB hukommelse før forespørgsel: 28.570 MB Rækker returneret: 21
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zoo4_modules AS m
LEFT JOIN zoo4_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN zoo4_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 <= '2022-01-18 01:31:19')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-18 01:31:19')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 247 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 90 1.60 Using index condition; Using where; Anvender filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 benefit_jos1.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 benefit_jos1.m.id 5 40.00 Using where; Using index 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 init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.79 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() Samme som kald i linjen nedenunder. 27 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 26 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 25 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 24 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 23 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:589 22 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277 21 YOOtheme\Container->call() JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:292 20 YOOtheme\Container->YOOtheme\{closure}() Samme som kald i linjen nedenunder. 19 call_user_func_array() JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:86 18 YOOtheme\View->__call() JROOT/templates/yootheme_benefit/templates/header.php:103 17 require JROOT/templates/yootheme_benefit/templates/header.php JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:274 16 YOOtheme\View->evaluate() JROOT/templates/yootheme/vendor/yootheme/view/src/View/FileLoader.php:16 15 YOOtheme\View\FileLoader->__invoke() JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162 14 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme/ViewHelper.php:63 13 YOOtheme\Theme\ViewHelper->YOOtheme\Theme\{closure}() JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162 12 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:23 11 YOOtheme\Theme\Joomla\UrlListener::resolveRelativeUrl() JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162 10 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:237 9 YOOtheme\View->render() JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:69 8 YOOtheme\View->__invoke() JROOT/templates/yootheme/index.php:129 7 require JROOT/templates/yootheme/index.php JROOT/libraries/src/Document/HtmlDocument.php:666 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:728 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:543 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.61 ms Efter sidste forespørgsel: 1.16 ms Forespørgsels hukommelse: 0.170 MB hukommelse før forespørgsel: 28.773 MB Rækker returneret: 25Dublet forespørgsler: #41
SELECT a.*
FROM zoo4_zoo_item AS a
WHERE a.type = 'klinik'
AND a.application_id = 6
AND a.access IN (1,5)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-01-18 01:31:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-01-18 01:31:19')
GROUP BY a.id
ORDER BY a.priority DESC, a.publish_up DESC
LIMIT 0, 30id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index_merge PRIMARY,ALIAS_INDEX,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,CREATED_BY_INDEX,NAME_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX,SEARCH_FULLTEXT TYPE_INDEX,STATE_INDEX,APPLICATIONID_INDEX 767,1,4 NULL 17 40.00 Using intersect(TYPE_INDEX,STATE_INDEX,APPLICATIONID_INDEX); Using where; Anvender filesort Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.40 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 49 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 48 DatabaseHelper->query() JROOT/administrator/components/com_zoo/framework/classes/table.php:425 47 AppTable->_queryObjectList() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:250 46 ItemTable->YOOtheme\Builder\Joomla\Zoo\Type\{closure}() Samme som kald i linjen nedenunder. 45 call_user_func() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:263 44 YOOtheme\Builder\Joomla\Zoo\Type\CustomItemsQueryType::thru() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:251 43 YOOtheme\Builder\Joomla\Zoo\Type\CustomItemsQueryType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 42 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Directive/CallDirective.php:62 41 YOOtheme\GraphQL\Directive\CallDirective->YOOtheme\GraphQL\Directive\{closure}() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 40 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 39 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 38 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 37 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 36 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 35 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 34 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 33 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 32 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 31 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 30 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 29 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 28 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 27 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 26 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 25 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 24 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 23 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 22 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 21 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 20 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 19 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 18 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 17 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 16 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 15 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 14 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 13 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 12 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 11 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder/bootstrap.php:44 10 YOOtheme\Application::YOOtheme\Builder\{closure}() Samme som kald i linjen nedenunder. 9 call_user_func_array() JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:86 8 YOOtheme\View->__call() JROOT/templates/yootheme/index.php:175 7 require JROOT/templates/yootheme/index.php JROOT/libraries/src/Document/HtmlDocument.php:666 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:728 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:543 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.59 ms Efter sidste forespørgsel: 9.84 ms Forespørgsels hukommelse: 0.170 MB hukommelse før forespørgsel: 29.614 MB Rækker returneret: 25Dublet forespørgsler: #40
SELECT a.*
FROM zoo4_zoo_item AS a
WHERE a.type = 'klinik'
AND a.application_id = 6
AND a.access IN (1,5)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-01-18 01:31:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-01-18 01:31:19')
GROUP BY a.id
ORDER BY a.priority DESC, a.publish_up DESC
LIMIT 0, 30id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index_merge PRIMARY,ALIAS_INDEX,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,CREATED_BY_INDEX,NAME_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX,SEARCH_FULLTEXT TYPE_INDEX,STATE_INDEX,APPLICATIONID_INDEX 767,1,4 NULL 17 40.00 Using intersect(TYPE_INDEX,STATE_INDEX,APPLICATIONID_INDEX); Using where; Anvender filesort Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.39 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 49 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 48 DatabaseHelper->query() JROOT/administrator/components/com_zoo/framework/classes/table.php:425 47 AppTable->_queryObjectList() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:250 46 ItemTable->YOOtheme\Builder\Joomla\Zoo\Type\{closure}() Samme som kald i linjen nedenunder. 45 call_user_func() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:263 44 YOOtheme\Builder\Joomla\Zoo\Type\CustomItemsQueryType::thru() JROOT/plugins/system/zoopro/src/Type/CustomItemsQueryType.php:251 43 YOOtheme\Builder\Joomla\Zoo\Type\CustomItemsQueryType::resolve() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 42 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Directive/CallDirective.php:62 41 YOOtheme\GraphQL\Directive\CallDirective->YOOtheme\GraphQL\Directive\{closure}() JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42 40 YOOtheme\GraphQL\Utils\Middleware->__invoke() JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:261 39 YOOtheme\GraphQL\SchemaBuilder->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:781 38 GraphQL\Executor\Executor->resolveOrError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:739 37 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 36 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1321 35 GraphQL\Executor\Executor->collectAndExecuteSubfields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:1276 34 GraphQL\Executor\Executor->completeObjectValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:997 33 GraphQL\Executor\Executor->completeValue() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:872 32 GraphQL\Executor\Executor->completeValueWithLocatedError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:826 31 GraphQL\Executor\Executor->completeValueCatchingError() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:748 30 GraphQL\Executor\Executor->resolveField() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:473 29 GraphQL\Executor\Executor->executeFields() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:349 28 GraphQL\Executor\Executor->executeOperation() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:309 27 GraphQL\Executor\Executor->GraphQL\Executor\{closure}() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Promise/Adapter/SyncPromiseAdapter.php:59 26 GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:310 25 GraphQL\Executor\Executor->doExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/Executor/Executor.php:166 24 GraphQL\Executor\Executor::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:148 23 GraphQL\GraphQL::promiseToExecute() JROOT/templates/yootheme/vendor/webonyx/graphql-php/src/GraphQL.php:85 22 GraphQL\GraphQL::executeQuery() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:60 21 YOOtheme\Builder\Source->query() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:104 20 YOOtheme\Builder\Source\SourceTransform->querySource() JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:57 19 YOOtheme\Builder\Source\SourceTransform->__invoke() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:254 18 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 17 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 16 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 15 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 14 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274 13 YOOtheme\Builder->applyTransforms() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95 12 YOOtheme\Builder->load() JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112 11 YOOtheme\Builder->render() JROOT/templates/yootheme/vendor/yootheme/builder/bootstrap.php:44 10 YOOtheme\Application::YOOtheme\Builder\{closure}() Samme som kald i linjen nedenunder. 9 call_user_func_array() JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:86 8 YOOtheme\View->__call() JROOT/templates/yootheme/index.php:175 7 require JROOT/templates/yootheme/index.php JROOT/libraries/src/Document/HtmlDocument.php:666 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:728 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:543 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.23 ms Efter sidste forespørgsel: 14.95 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 30.373 MB Rækker returneret: 3
SELECT `name`,`element`
FROM `zoo4_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'finder'
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_extensions NULL ref extension extension 82 const 141 1.00 Using index condition; Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_finder/helpers/language.php:126 11 FinderHelperLanguage::loadPluginLanguage() JROOT/modules/mod_finder/mod_finder.php:51 10 include JROOT/modules/mod_finder/mod_finder.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/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:27 7 YOOtheme\Theme\Joomla\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:499 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:791 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:565 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.19 ms Efter sidste forespørgsel: 3.41 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 30.455 MB Rækker returneret: 14Dublet forespørgsler: #44
SELECT `title`
FROM `zoo4_finder_taxonomy`
WHERE `parent_id` = 1
AND `state` = 1
AND `access` IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_finder_taxonomy NULL ref parent_id,state,access,idx_parent_published parent_id 4 const 14 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.03 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.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258 14 FinderIndexerTaxonomy::getBranchTitles() JROOT/administrator/components/com_finder/helpers/indexer/query.php:750 13 FinderIndexerQuery->processString() JROOT/administrator/components/com_finder/helpers/indexer/query.php:236 12 FinderIndexerQuery->__construct() JROOT/modules/mod_finder/helper.php:84 11 ModFinderHelper::getQuery() JROOT/modules/mod_finder/mod_finder.php:54 10 include JROOT/modules/mod_finder/mod_finder.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/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:27 7 YOOtheme\Theme\Joomla\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:499 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:791 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:565 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.17 ms Efter sidste forespørgsel: 6.46 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 30.717 MB Rækker returneret: 14Dublet forespørgsler: #43
SELECT `title`
FROM `zoo4_finder_taxonomy`
WHERE `parent_id` = 1
AND `state` = 1
AND `access` IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_finder_taxonomy NULL ref parent_id,state,access,idx_parent_published parent_id 4 const 14 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 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.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258 14 FinderIndexerTaxonomy::getBranchTitles() JROOT/administrator/components/com_finder/helpers/indexer/query.php:750 13 FinderIndexerQuery->processString() JROOT/administrator/components/com_finder/helpers/indexer/query.php:236 12 FinderIndexerQuery->__construct() JROOT/modules/mod_finder/helper.php:84 11 ModFinderHelper::getQuery() JROOT/modules/mod_finder/mod_finder.php:54 10 include JROOT/modules/mod_finder/mod_finder.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/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:27 7 YOOtheme\Theme\Joomla\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:499 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:791 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:565 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.12 ms Efter sidste forespørgsel: 1.55 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 30.819 MB Rækker returneret: 1
SELECT `alias`
FROM `zoo4_content`
WHERE id = '213'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() Samme som kald i linjen nedenunder. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.28 ms Efter sidste forespørgsel: 0.16 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 30.854 MB Rækker returneret: 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 `zoo4_categories` AS `s`
INNER JOIN `zoo4_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_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 33
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Anvender filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right INGEN INDEX NØGLE KUNNE ANVENDES NULL NULL 33 94.03 Using where Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 17 ContentRouter->getCategorySegment() Samme som kald i linjen nedenunder. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.11 ms Efter sidste forespørgsel: 0.15 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 30.941 MB Rækker returneret: 1
SELECT `alias`
FROM `zoo4_content`
WHERE id = '214'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() Samme som kald i linjen nedenunder. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.10 ms Efter sidste forespørgsel: 0.09 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 30.950 MB Rækker returneret: 1
SELECT `alias`
FROM `zoo4_content`
WHERE id = '215'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() Samme som kald i linjen nedenunder. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.14 ms Efter sidste forespørgsel: 0.07 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 30.959 MB Rækker returneret: 1
SELECT `alias`
FROM `zoo4_content`
WHERE id = '272'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE zoo4_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() Samme som kald i linjen nedenunder. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Forespørgsels tid: 0.31 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 30.971 MB Rækker returneret: 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 `zoo4_categories` AS `s`
INNER JOIN `zoo4_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_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 2
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 2 96.97 Using index condition; Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Kalder Fil og linjenummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 17 ContentRouter->getCategorySegment() Samme som kald i linjen nedenunder. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
28 forespørgselstyper logget, sorteret efter forekomster FALDENDE
SELECT tabeller:
14 × SELECT b.id
FROM zoo4_zoo_category_item AS a JOIN zoo4_zoo_category AS b
ON a.category_id = b.id4 × SELECT `alias`
FROM `zoo4_content`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 `zoo4_categories` AS `s`
INNER JOIN `zoo4_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `zoo4_extensions`2 × SELECT `title`
FROM `zoo4_finder_taxonomy`2 × SELECT a.*
FROM zoo4_zoo_item AS a2 × SELECT *
FROM zoo4_zoo_item2 × SELECT a.*
FROM zoo4_zoo_item AS a JOIN zoo4_zoo_tag AS c
ON a.id = c.item_id
LEFT JOIN zoo4_zoo_search_index AS s
ON a.id = s.item_id
AND s.element_id IN ('66535925-d898-4f8d-96a7-114f8cccddd0')1 × SELECT a.*
FROM zoo4_zoo_item AS a
LEFT JOIN zoo4_zoo_category_item AS b
ON a.id = b.item_id1 × SELECT `name`,`element`
FROM `zoo4_extensions`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zoo4_modules AS m
LEFT JOIN zoo4_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN zoo4_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT custom_data
FROM zoo4_extensions1 × SELECT `data`
FROM `zoo4_session`1 × SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids
FROM zoo4_zoo_category as c USE INDEX (APPLICATIONID_ID_INDEX)
LEFT JOIN zoo4_zoo_category_item as ci
ON ci.category_id = c.id
LEFT JOIN zoo4_zoo_item AS i USE INDEX (MULTI_INDEX2)
ON ci.item_id = i.id
AND i.access IN (1,5)
AND i.state = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-01-18 01:31:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-01-18 01:31:19')1 × SELECT `session_id`
FROM `zoo4_session`1 × SELECT *
FROM zoo4_zoo_application1 × SELECT *
FROM zoo4_languages1 × SELECT id, home, template, s.params
FROM zoo4_template_styles as s
LEFT JOIN zoo4_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 zoo4_menu AS m
LEFT JOIN zoo4_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM zoo4_rsform_confi1 × SELECT id,template
FROM zoo4_template_styles1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM zoo4_extensions1 × SELECT b.id
FROM zoo4_usergroups AS a
LEFT JOIN zoo4_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `zoo4_viewlevels1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `zoo4_assets`
OTHER tabeller:
1 × INSERT INTO `zoo4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3033623962316634313631633638333937393761313338613836303536376430', 1, 1642469479, 0, '', 01 × UPDATE `zoo4_extensions`
SET `params` = '{\"mediaversion\":\"8db516d671265e58d2bc69d9e0967673\"}'1 ×
SET SESSION group_concat_max_len = 104857