nanoscience and nanotechnology: small is different

Series

Extending, distorting and stacking nanographenes into 1D, 2D and 3D structures

Tuesday, 18 March 2025 12:00

Prof. Aurelio Mateo Alonso (University of the Basque Country UPV/EHU)

Superconducting lumped-element resonators: enabling technologies for radiation detection and quantum computing interfacing

Tuesday, 11 March 2025 12:00

Víctor Rollano (Centro de Astrobiología CSIC - INTA)

Inaugural lecture of the Systems Chemistry laboratory

Tuesday, 18 February 2025 12:00

Thomas Hermans (IMDEA Nanociencia)

Empowering polysaccharide-based nanoformulations for cardiac RNA-based therapies

Tuesday, 11 February 2025 12:00

Synthesis, optical and supramolecular properties of curved nanographenes

Tuesday, 04 February 2025 12:00

Prof. Araceli González Campaña (Universidad de Granada)

Coupling optical tweezers with tip-enhanced Raman spectroscopy for the investigation of individual supramolecular systems

Tuesday, 14 January 2025 12:00

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1744127595,
                "last": 1744127595,
                "now": 1744127595
            },
            "token": "LgNKWTXuALICxvqEfHRqOdbScetylNC6"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Profile Information

Time

Memory

Time: 17.95 ms / 17.95 ms Memory: 0.432 MB / 0.78 MB Application: afterLoad

Time: 78.18 ms / 96.13 ms Memory: 7.294 MB / 8.07 MB Application: afterInitialise

Time: 25.89 ms / 122.02 ms Memory: 0.492 MB / 8.56 MB Application: afterRoute

Time: 2.65 ms / 124.67 ms Memory: 0.033 MB / 8.60 MB Application: beforeRenderComponent com_zoo

Time: 18.90 ms / 143.56 ms Memory: 0.323 MB / 8.92 MB Application: Before Access::preloadComponents (all components)

Time: 0.94 ms / 144.51 ms Memory: 0.055 MB / 8.97 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 144.53 ms Memory: -0.004 MB / 8.97 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.52 ms / 145.05 ms Memory: 0.008 MB / 8.98 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 34.52 ms / 179.56 ms Memory: 1.970 MB / 10.95 MB Application: Before Access::preloadPermissions (com_zoo)

Time: 1.74 ms / 181.30 ms Memory: -0.061 MB / 10.89 MB Application: After Access::preloadPermissions (com_zoo)

Time: 3.46 ms / 184.76 ms Memory: 0.122 MB / 11.01 MB Application: Before Access::getAssetRules (id:144 name:com_zoo)

Time: 0.01 ms / 184.78 ms Memory: 0.002 MB / 11.01 MB Application: After Access::getAssetRules (id:144 name:com_zoo)

Time: 53.69 ms / 238.47 ms Memory: 0.789 MB / 11.80 MB Application: afterRenderComponent com_zoo

Time: 6.45 ms / 244.92 ms Memory: 0.180 MB / 11.98 MB Application: afterDispatch

Time: 11.25 ms / 256.17 ms Memory: 0.646 MB / 12.63 MB Application: beforeRenderModule mod_widgetkit (Cabecera - Resto secciones con texto encima imagen)

Time: 7.86 ms / 264.03 ms Memory: 0.134 MB / 12.76 MB Application: afterRenderModule mod_widgetkit (Cabecera - Resto secciones con texto encima imagen)

Time: 9.31 ms / 273.33 ms Memory: 0.076 MB / 12.84 MB Application: beforeRenderModule mod_menu (Menú principal superior - inglés)

Time: 11.90 ms / 285.23 ms Memory: 0.589 MB / 13.43 MB Application: afterRenderModule mod_menu (Menú principal superior - inglés)

Time: 8.00 ms / 293.24 ms Memory: 0.017 MB / 13.44 MB Application: beforeRenderModule mod_search (Buscar)

Time: 1.84 ms / 295.08 ms Memory: 0.063 MB / 13.51 MB Application: afterRenderModule mod_search (Buscar)

Time: 1.06 ms / 296.14 ms Memory: -0.020 MB / 13.49 MB Application: beforeRenderModule mod_languages (Idioma)

Time: 3.16 ms / 299.30 ms Memory: 0.044 MB / 13.53 MB Application: afterRenderModule mod_languages (Idioma)

Time: 2.09 ms / 301.38 ms Memory: 0.011 MB / 13.54 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.04 ms / 303.42 ms Memory: 0.071 MB / 13.61 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.91 ms / 305.33 ms Memory: 0.016 MB / 13.63 MB Application: beforeRenderModule mod_custom (Calendar (sidebar))

Time: 1.31 ms / 306.63 ms Memory: 0.006 MB / 13.64 MB Application: afterRenderModule mod_custom (Calendar (sidebar))

Time: 2.96 ms / 309.59 ms Memory: 0.017 MB / 13.65 MB Application: beforeRenderModule mod_menu (Footer menu - inglés)

Time: 3.29 ms / 312.88 ms Memory: 0.016 MB / 13.67 MB Application: afterRenderModule mod_menu (Footer menu - inglés)

Time: 5.45 ms / 318.33 ms Memory: -0.006 MB / 13.66 MB Application: beforeRenderModule mod_menu (Menú inglés móviles)

Time: 7.79 ms / 326.11 ms Memory: 0.173 MB / 13.84 MB Application: afterRenderModule mod_menu (Menú inglés móviles)

Time: 7.64 ms / 333.76 ms Memory: 0.044 MB / 13.88 MB Application: afterRender

Database queries total: 18.77 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tainan_session	const	PRIMARY	PRIMARY	194	const	1

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tainan_session	const	PRIMARY	PRIMARY	194	const	1	Using index

#	Caller	File and line number
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:828
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN not possible on query: INSERT INTO `tainan_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3239686239383537756c30616f666e6d6a6e6f76333867767330', 1, 1744127595, 0, '', 0)

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.01 ms
Update	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.31 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.30 ms After last query: 4.48 ms Query memory: 0.021 MB Memory before query: 1.151 MB Rows returned: 5

SELECT id, rules

  FROM `tainan_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tainan_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.31 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 1.163 MB Rows returned: 2

SELECT b.id

  FROM tainan_usergroups AS a

  LEFT JOIN tainan_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.50 ms After last query: 44.87 ms Query memory: 0.025 MB Memory before query: 3.812 MB Rows returned: 1

SELECT id,template 
  FROM tainan_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tainan_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	Using where

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
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:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
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:91
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:15
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:668
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.48 ms After last query: 39.00 ms Query memory: 0.005 MB Memory before query: 8.574 MB

UPDATE `tainan_extensions`

  SET `params` = '{\"mediaversion\":\"2521ef81f503e09168545889260eb59e\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN not possible on query: UPDATE `tainan_extensions` SET `params` = '{\"mediaversion\":\"2521ef81f503e09168545889260eb59e\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.10 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.44 ms After last query: 10.16 ms Query memory: 0.022 MB Memory before query: 8.766 MB Rows returned: 1

SELECT * 
  FROM tainan_zoo_application 
  WHERE id = 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tainan_zoo_application	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.77 ms After last query: 9.72 ms Query memory: 0.029 MB Memory before query: 8.919 MB Rows returned: 41

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `tainan_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_chronoforms5','com_chronoforms6','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','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_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper','com_zoo','com_zoolanders')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tainan_assets	range	idx_asset_name	idx_asset_name	202	NULL	42	Using index condition

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
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:217
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.15 ms After last query: 0.96 ms Query memory: 0.008 MB Memory before query: 8.990 MB


  SET SESSION group_concat_max_len = 1048576

Explain

EXPLAIN not possible on query: SET SESSION group_concat_max_len = 1048576

Profile

Status	Duration
Starting	0.03 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/category.php:183
15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:217
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.12 ms After last query: 0.43 ms Query memory: 0.042 MB Memory before query: 9.015 MB Rows returned: 9

SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM tainan_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN tainan_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN tainan_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 <= '2025-04-08 15:53:15') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-08 15:53:15') 
  WHERE c.application_id = 5 
  AND c.published = 1 
  GROUP BY c.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	APPLICATIONID_ID_INDEX	APPLICATIONID_ID_INDEX	5	const,const	8	Using where
1	SIMPLE	ci	ref	PRIMARY,CATEGORYID_INDEX	PRIMARY	4	nanociencia_web_2019.c.id	71	Using index
1	SIMPLE	i	ref	MULTI_INDEX2	MULTI_INDEX2	4	nanociencia_web_2019.ci.item_id	1	Using where; Using index

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.07 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	1.63 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
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:209
15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:217
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.28 ms After last query: 1.38 ms Query memory: 0.087 MB Memory before query: 9.278 MB Rows returned: 6

SELECT a.* 
  FROM tainan_zoo_item AS a 
  LEFT JOIN tainan_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 5 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-08 15:53:15') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-08 15:53:15') 
  AND b.category_id  = 1639 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.created DESC 
  LIMIT 0,6

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	18	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	nanociencia_web_2019.b.item_id	1	Using where

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting for group	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.65 ms
Creating sort index	0.12 ms
Removing tmp table	0.10 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
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:467
13	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:238
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.53 ms After last query: 28.89 ms Query memory: 0.038 MB Memory before query: 10.829 MB Rows returned: 49

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `tainan_assets`

  WHERE `name` LIKE 'com_zoo.%' OR `name` = 'com_zoo' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tainan_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	1885	Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	1.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
35	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
34	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
33	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:37
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.68 ms After last query: 1.60 ms Query memory: 0.036 MB Memory before query: 10.936 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `tainan_assets`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `tainan_assets`

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.00 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.08 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
37	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
36	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
35	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
34	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
33	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:37
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.28 ms After last query: 0.95 ms Query memory: 0.033 MB Memory before query: 10.987 MB Rows returned: 0

Duplicate queries: #16 #17 #18 #20 #21 #23 #24 #26 #27 #29 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
35	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
34	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
33	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:37
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.23 ms After last query: 0.17 ms Query memory: 0.033 MB Memory before query: 11.041 MB Rows returned: 0

Duplicate queries: #15 #17 #18 #20 #21 #23 #24 #26 #27 #29 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
34	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
33	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
32	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
31	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
30	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
29	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
28	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:37
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.44 ms After last query: 9.99 ms Query memory: 0.034 MB Memory before query: 11.121 MB Rows returned: 0

Duplicate queries: #15 #16 #18 #20 #21 #23 #24 #26 #27 #29 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
35	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
34	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
33	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:37
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 0.27 ms Query memory: 0.033 MB Memory before query: 11.174 MB Rows returned: 0

Duplicate queries: #15 #16 #17 #20 #21 #23 #24 #26 #27 #29 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
34	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
33	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
32	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
31	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
30	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
29	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
28	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:37
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.50 ms After last query: 4.56 ms Query memory: 0.031 MB Memory before query: 11.233 MB Rows returned: 2

SELECT b.id 
  FROM tainan_zoo_category_item AS a JOIN tainan_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=16645 
  AND b.published = 1 UNION SELECT 0 
  FROM tainan_zoo_category_item AS a 
  WHERE a.item_id=16645 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	3
1	PRIMARY	b	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	nanociencia_web_2019.a.category_id	1	Using where
2	UNION	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.05 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:26
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.27 ms After last query: 6.34 ms Query memory: 0.033 MB Memory before query: 11.285 MB Rows returned: 0

Duplicate queries: #15 #16 #17 #18 #21 #23 #24 #26 #27 #29 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
35	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
34	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
33	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:37
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 0.14 ms Query memory: 0.033 MB Memory before query: 11.338 MB Rows returned: 0

Duplicate queries: #15 #16 #17 #18 #20 #23 #24 #26 #27 #29 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
34	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
33	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
32	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
31	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
30	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
29	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
28	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:37
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.45 ms After last query: 4.21 ms Query memory: 0.031 MB Memory before query: 11.396 MB Rows returned: 2

SELECT b.id 
  FROM tainan_zoo_category_item AS a JOIN tainan_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=16640 
  AND b.published = 1 UNION SELECT 0 
  FROM tainan_zoo_category_item AS a 
  WHERE a.item_id=16640 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	3
1	PRIMARY	b	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	nanociencia_web_2019.a.category_id	1	Using where
2	UNION	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:26
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.27 ms After last query: 4.02 ms Query memory: 0.033 MB Memory before query: 11.448 MB Rows returned: 0

Duplicate queries: #15 #16 #17 #18 #20 #21 #24 #26 #27 #29 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
35	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
34	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
33	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
23	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:36
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 0.13 ms Query memory: 0.033 MB Memory before query: 11.500 MB Rows returned: 0

Duplicate queries: #15 #16 #17 #18 #20 #21 #23 #26 #27 #29 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
34	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
33	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
32	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
31	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
30	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
29	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
28	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
23	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:36
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.48 ms After last query: 3.83 ms Query memory: 0.031 MB Memory before query: 11.563 MB Rows returned: 2

SELECT b.id 
  FROM tainan_zoo_category_item AS a JOIN tainan_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=16612 
  AND b.published = 1 UNION SELECT 0 
  FROM tainan_zoo_category_item AS a 
  WHERE a.item_id=16612 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	3
1	PRIMARY	b	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	nanociencia_web_2019.a.category_id	1	Using where
2	UNION	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:26
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.28 ms After last query: 6.11 ms Query memory: 0.033 MB Memory before query: 11.615 MB Rows returned: 0

Duplicate queries: #15 #16 #17 #18 #20 #21 #23 #24 #27 #29 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
35	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
34	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
33	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:37
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.29 ms After last query: 0.16 ms Query memory: 0.033 MB Memory before query: 11.668 MB Rows returned: 0

Duplicate queries: #15 #16 #17 #18 #20 #21 #23 #24 #26 #29 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
34	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
33	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
32	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
31	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
30	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
29	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
28	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:37
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.39 ms After last query: 4.16 ms Query memory: 0.031 MB Memory before query: 11.725 MB Rows returned: 2

SELECT b.id 
  FROM tainan_zoo_category_item AS a JOIN tainan_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=16603 
  AND b.published = 1 UNION SELECT 0 
  FROM tainan_zoo_category_item AS a 
  WHERE a.item_id=16603 
  AND a.category_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	3
1	PRIMARY	b	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	nanociencia_web_2019.a.category_id	1	Using where
2	UNION	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
NULL	UNION RESULT	<union1,2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:26
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.26 ms After last query: 4.00 ms Query memory: 0.033 MB Memory before query: 11.777 MB Rows returned: 0

Duplicate queries: #15 #16 #17 #18 #20 #21 #23 #24 #26 #27 #30

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
35	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
34	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
33	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
29	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
28	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
23	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:36
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 0.15 ms Query memory: 0.033 MB Memory before query: 11.829 MB Rows returned: 0

Duplicate queries: #15 #16 #17 #18 #20 #21 #23 #24 #26 #27 #29

SELECT *

  FROM tainan_assets

  WHERE `name` = 'com_zoo.application.5.events'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
34	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
33	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
32	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
31	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
30	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
29	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
28	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:304
27	UserAppHelper->canEditState()	JROOT/administrator/components/com_zoo/classes/type.php:115
26	Type->canEditState()	JROOT/administrator/components/com_zoo/classes/item.php:263
25	Item->canEditState()	JROOT/media/zoo/elements/itemstate/itemstate.php:26
24	ElementItemState->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
23	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php:36
22	include JROOT/media/zoo/applications/blog/templates/events/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/events/_item.php:16
19	include JROOT/media/zoo/applications/blog/templates/events/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/_items.php:40
17	include JROOT/media/zoo/applications/blog/templates/events/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/events/category.php:52
15	include JROOT/media/zoo/applications/blog/templates/events/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
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:57
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:253
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.77 ms After last query: 1.94 ms Query memory: 0.021 MB Memory before query: 11.923 MB Rows returned: 3

SELECT language,id

  FROM `tainan_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tainan_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	1009	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.49 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	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/SiteApplication.php:199
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.33 ms After last query: 0.80 ms Query memory: 0.021 MB Memory before query: 11.958 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `tainan_menu` AS `c`

  INNER JOIN `tainan_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `tainan_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `tainan_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 1300

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
7	PlgSystemLanguageFilter->onAfterDispatch()	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/SiteApplication.php:199
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.48 ms After last query: 11.81 ms Query memory: 0.028 MB Memory before query: 12.609 MB Rows returned: 14

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM tainan_modules AS m

  LEFT JOIN tainan_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN tainan_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-04-08 15:53:15') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-08 15:53:15') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 1300 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	179	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	nanociencia_web_2019.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	nanociencia_web_2019.m.id	4	Using where; Using index

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.89 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_master2/layouts/theme.config.php:26
10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.29 ms After last query: 1.91 ms Query memory: 0.027 MB Memory before query: 12.663 MB Rows returned: 1

SELECT * 
  FROM tainan_widgetkit 
  WHERE id = "152"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tainan_widgetkit	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/Database.php:35
20	YOOtheme\Framework\Joomla\Database->fetchAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Database/Database.php:88
19	YOOtheme\Framework\Database\Database->fetchObject()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:44
18	YOOtheme\Widgetkit\Content\ContentProvider->find()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:30
17	YOOtheme\Widgetkit\Content\ContentProvider->get()	JROOT/administrator/components/com_widgetkit/src/Application.php:151
16	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
15	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
14	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_master2/layouts/theme.config.php:72
10	include JROOT/templates/yoo_master2/layouts/theme.config.php	JROOT/templates/yoo_master2/layouts/theme.php:10
9	include JROOT/templates/yoo_master2/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

19 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
12 × SELECT * 
  FROM tainan_assets
```

4 × SELECT b.id 
  FROM tainan_zoo_category_item AS a JOIN tainan_zoo_category AS b 
  ON a.category_id = b.id

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `tainan_assets`

1 × SELECT `data` 
  FROM `tainan_session`

1 × SELECT `session_id` 
  FROM `tainan_session`

1 × SELECT id, rules 
  FROM `tainan_viewlevels

1 × SELECT b.id 
  FROM tainan_usergroups AS a 
  LEFT JOIN tainan_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id,template 
  FROM tainan_template_styles

1 × SELECT * 
  FROM tainan_zoo_application

1 × SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM tainan_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN tainan_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN tainan_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 <= '2025-04-08 15:53:15') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-08 15:53:15')

1 × SELECT a.* 
  FROM tainan_zoo_item AS a 
  LEFT JOIN tainan_zoo_category_item AS b 
  ON a.id = b.item_id

1 × SELECT language,id 
  FROM `tainan_menu`

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `tainan_menu` AS `c` 
  INNER JOIN `tainan_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `tainan_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `tainan_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM tainan_modules AS m 
  LEFT JOIN tainan_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN tainan_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

```
1 × SELECT * 
  FROM tainan_widgetkit
```

OTHER Tables:

1 × INSERT INTO `tainan_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3239686239383537756c30616f666e6d6a6e6f76333867767330', 1, 1744127595, 0, '', 0

1 × UPDATE `tainan_extensions` 
  SET `params` = '{\"mediaversion\":\"2521ef81f503e09168545889260eb59e\"}'

1 × 
  SET SESSION group_concat_max_len = 104857

1 × SHOW FULL COLUMNS 
  FROM `tainan_assets

Series

Extending, distorting and stacking nanographenes into 1D, 2D and 3D structures

Superconducting lumped-element resonators: enabling technologies for radiation detection and quantum computing interfacing

Inaugural lecture of the Systems Chemistry laboratory

Empowering polysaccharide-based nanoformulations for cardiac RNA-based therapies

Synthesis, optical and supramolecular properties of curved nanographenes

Coupling optical tweezers with tip-enhanced Raman spectroscopy for the investigation of individual supramolecular systems

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

34 Queries Logged 18.77 ms

12 duplicate found!

19 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Log Messages

12 messages logged