{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1726670032,
                "last": 1726670032,
                "now": 1726670032
            },
            "token": "vkz20wrIdg6XMzHH5Ii9IRm8GQobka9c"
        },
        "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
        }
    }
}

Tempo

Memoria

130 query eseguite 200.49 ms

1. Tempo della query: 6.12 ms Memoria query: 0.025 MB memoria prima della query: 0.970 MB Righe restituite: 0

   SELECT `data`
   
     FROM `ecw3r_session`
   
     WHERE `session_id` = '63f3f3jm7jj61pssrnjv7o3djf'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_session	const	PRIMARY	PRIMARY	575	const	1	100.00	NULL

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   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:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:832
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

2. Tempo della query: 0.63 ms Dopo l'ultima query: 5.10 ms Memoria query: 0.021 MB memoria prima della query: 0.985 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `ecw3r_session`
   
     WHERE `session_id` = '63f3f3jm7jj61pssrnjv7o3djf' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_session	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:834
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

3. Tempo della query: 0.95 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.003 MB memoria prima della query: 0.989 MB

   INSERT INTO `ecw3r_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('63f3f3jm7jj61pssrnjv7o3djf', 1, '1726670032', 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('63f3f3jm7jj61pssrnjv7o3djf', 1, '1726670032', 0, '', 0)

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:217
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:834
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

4. Tempo della query: 2.69 ms Dopo l'ultima query: 31.66 ms Memoria query: 0.022 MB memoria prima della query: 1.205 MB Righe restituite: 2

   SELECT b.id
   
     FROM ecw3r_usergroups AS a
   
     LEFT JOIN ecw3r_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	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

5. Tempo della query: 2.58 ms Dopo l'ultima query: 3.59 ms Memoria query: 0.023 MB memoria prima della query: 1.211 MB Righe restituite: 5

   SELECT id, rules
   
     FROM `ecw3r_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	100.00	NULL

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

6. Tempo della query: 4.01 ms Dopo l'ultima query: 239.71 ms Memoria query: 0.006 MB memoria prima della query: 2.693 MB

   UPDATE `ecw3r_extensions`
   
     SET `params` = '{\"mediaversion\":\"23f43ec40298c8b8d055cdddeb0a35d0\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
   13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
   12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
   11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
   10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   9	JFactory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
   8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1158
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

7. Tempo della query: 5.67 ms Dopo l'ultima query: 94.45 ms Memoria query: 0.032 MB memoria prima della query: 4.120 MB Righe restituite: 39

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `ecw3r_assets`
   
     WHERE `name` IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_foxcontact','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_tz_multipurpose','com_tz_portfolio','com_uniterevolution2','com_users','com_weblinks','com_wrapper','com_xmap') OR `parent_id` = 0

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ecw3r_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	152,4	NULL	40	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File and line number
   22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
   20	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
   19	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
   18	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
   17	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
   16	JUser->authorise()	JROOT/components/com_tz_portfolio/models/article.php:76
   15	TZ_PortfolioModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:434
   14	JModelLegacy->getState()	JROOT/components/com_tz_portfolio/models/article.php:199
   13	TZ_PortfolioModelArticle->getItem()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:143
   12	TZ_PortfolioTemplate::getTemplateId()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:28
   11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
   10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
   9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
   8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
   7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
   6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
   5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
   4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

8. Tempo della query: 6.47 ms Dopo l'ultima query: 4.22 ms Memoria query: 0.044 MB memoria prima della query: 4.220 MB Righe restituite: 1
   Query duplicate: #16  #30  #44  #50  #72

   SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
     CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 1) AS rating, v.rating_count as rating_count
   
     FROM ecw3r_content AS a
   
     LEFT JOIN ecw3r_categories AS c 
     on c.id = a.catid
   
     LEFT JOIN ecw3r_users AS u 
     on u.id = a.created_by
   
     LEFT JOIN (
   SELECT contact.user_id, MAX(contact.id) AS id, contact.language
   
     FROM ecw3r_contact_details AS contact
   
     WHERE contact.published = 1
   
     GROUP BY contact.user_id, contact.language) AS contact 
     ON contact.user_id = a.created_by
   
     LEFT JOIN ecw3r_categories as parent 
     ON parent.id = c.parent_id
   
     LEFT JOIN ecw3r_content_rating AS v 
     ON a.id = v.content_id
   
     LEFT 
     OUTER JOIN  (SELECT cat.id as id 
     FROM ecw3r_categories AS cat JOIN ecw3r_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt 
     WHERE parent.extension = 'com_content' 
     AND parent.published <= 0 
     GROUP BY cat.id) AS badcats 
     ON badcats.id = c.id
   
     WHERE a.id = 75 
     AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-18 14:33:52') 
     AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-18 14:33:52') 
     AND (a.state = 1 OR a.state =2)

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
   1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	PRIMARY	<derived2>	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL
   1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
   1	PRIMARY	<derived3>	ref	<auto_key0>	<auto_key0>	4	const	3	100.00	Using index
   3	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	100.00	Using index condition; Using temporary; Using filesort
   3	DERIVED	cat	ALL	idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	100.00	Range checked for each record (index map: 0x10)
   2	DERIVED	contact	system	idx_state	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
   14	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/article.php:264
   13	TZ_PortfolioModelArticle->getItem()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:143
   12	TZ_PortfolioTemplate::getTemplateId()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:28
   11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
   10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
   9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
   8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
   7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
   6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
   5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
   4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

9. Tempo della query: 1.69 ms Dopo l'ultima query: 4.97 ms Memoria query: 0.037 MB memoria prima della query: 4.331 MB Righe restituite: 2
   Query duplicate: #33

   SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
   			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
   			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
   			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
   
     FROM ecw3r_categories as c
   
     LEFT JOIN ecw3r_categories AS s 
     ON (s.lft <= c.lft 
     AND s.rgt >= c.rgt) OR (s.lft > c.lft 
     AND s.rgt < c.rgt)
   
     WHERE (c.extension='com_content' OR c.extension='system') 
     AND c.access IN (1,1,5) 
     AND c.published = 1 
     AND s.id=9
   
     GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
   			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
   			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
   			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
   
     ORDER BY c.lft

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
   1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File and line number
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
   15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
   14	JCategories->get()	JROOT/components/com_tz_portfolio/models/article.php:284
   13	TZ_PortfolioModelArticle->getItem()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:143
   12	TZ_PortfolioTemplate::getTemplateId()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:28
   11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
   10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
   9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
   8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
   7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
   6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
   5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
   4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

10. Tempo della query: 10.78 ms Dopo l'ultima query: 0.97 ms Memoria query: 0.024 MB memoria prima della query: 4.373 MB Righe restituite: 1
    Query duplicate: #17  #45  #51  #73

    SELECT `template_id`
    
      FROM `ecw3r_tz_portfolio_categories`
    
      WHERE `catid`=9

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_tz_portfolio_categories	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	10	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:162
    12	TZ_PortfolioTemplate::getTemplateId()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:28
    11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

11. Tempo della query: 3.51 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.024 MB memoria prima della query: 4.380 MB Righe restituite: 1
    Query duplicate: #18  #46  #52  #74

    SELECT `template_id`
    
      FROM `ecw3r_tz_portfolio_xref_content`
    
      WHERE `contentid`=75

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_tz_portfolio_xref_content	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:174
    12	TZ_PortfolioTemplate::getTemplateId()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:28
    11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

12. Tempo della query: 8.09 ms Dopo l'ultima query: 2.01 ms Memoria query: 0.029 MB memoria prima della query: 4.350 MB Righe restituite: 7

    SHOW FULL COLUMNS 
      FROM `ecw3r_tz_portfolio_templates`

    Explain

    EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `ecw3r_tz_portfolio_templates`

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    14	JTable->__construct()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:41
    13	TZ_PortfolioTableTemplates->__construct()	JROOT/libraries/joomla/table/table.php:311
    12	JTable::getInstance()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:32
    11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

13. Tempo della query: 0.54 ms Dopo l'ultima query: 4.58 ms Memoria query: 0.025 MB memoria prima della query: 4.386 MB Righe restituite: 1
    Query duplicate: #19  #47  #53  #75

    SELECT COUNT(*)
    
      FROM ecw3r_tz_portfolio_templates

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Select tables optimized away

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:49
    14	TZ_PortfolioTableTemplates->hasData()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:61
    13	TZ_PortfolioTableTemplates->_hasHome()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:75
    12	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
    11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

14. Tempo della query: 0.83 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.024 MB memoria prima della query: 4.394 MB Righe restituite: 1
    Query duplicate: #20  #48  #54  #76

    SELECT COUNT(*)
    
      FROM ecw3r_tz_portfolio_templates
    
      WHERE `home`= 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_tz_portfolio_templates	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:67
    13	TZ_PortfolioTableTemplates->_hasHome()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:75
    12	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
    11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

15. Tempo della query: 0.86 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.030 MB memoria prima della query: 4.401 MB Righe restituite: 1
    Query duplicate: #21  #49  #55  #77

    SELECT *
    
      FROM ecw3r_tz_portfolio_templates
    
      WHERE `home`= 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_tz_portfolio_templates	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:81
    12	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
    11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

16. Tempo della query: 0.76 ms Dopo l'ultima query: 5.61 ms Memoria query: 0.037 MB memoria prima della query: 4.555 MB Righe restituite: 1
    Query duplicate: #8  #30  #44  #50  #72

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 1) AS rating, v.rating_count as rating_count
    
      FROM ecw3r_content AS a
    
      LEFT JOIN ecw3r_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN ecw3r_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN (
    SELECT contact.user_id, MAX(contact.id) AS id, contact.language
    
      FROM ecw3r_contact_details AS contact
    
      WHERE contact.published = 1
    
      GROUP BY contact.user_id, contact.language) AS contact 
      ON contact.user_id = a.created_by
    
      LEFT JOIN ecw3r_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ecw3r_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM ecw3r_categories AS cat JOIN ecw3r_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 75 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-18 14:33:52') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-18 14:33:52') 
      AND (a.state = 1 OR a.state =2)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	<derived2>	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
    1	PRIMARY	<derived3>	ref	<auto_key0>	<auto_key0>	4	const	3	100.00	Using index
    3	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	100.00	Using index condition; Using temporary; Using filesort
    3	DERIVED	cat	ALL	idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	100.00	Range checked for each record (index map: 0x10)
    2	DERIVED	contact	system	idx_state	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    15	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/article.php:264
    14	TZ_PortfolioModelArticle->getItem()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:143
    13	TZ_PortfolioTemplate::getTemplateId()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:28
    12	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    11	TZ_PortfolioControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

17. Tempo della query: 0.37 ms Dopo l'ultima query: 0.52 ms Memoria query: 0.025 MB memoria prima della query: 4.608 MB Righe restituite: 1
    Query duplicate: #10  #45  #51  #73

    SELECT `template_id`
    
      FROM `ecw3r_tz_portfolio_categories`
    
      WHERE `catid`=9

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_tz_portfolio_categories	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	10	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:162
    13	TZ_PortfolioTemplate::getTemplateId()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:28
    12	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    11	TZ_PortfolioControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

18. Tempo della query: 0.37 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.024 MB memoria prima della query: 4.616 MB Righe restituite: 1
    Query duplicate: #11  #46  #52  #74

    SELECT `template_id`
    
      FROM `ecw3r_tz_portfolio_xref_content`
    
      WHERE `contentid`=75

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_tz_portfolio_xref_content	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:174
    13	TZ_PortfolioTemplate::getTemplateId()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:28
    12	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    11	TZ_PortfolioControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

19. Tempo della query: 0.34 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.026 MB memoria prima della query: 4.572 MB Righe restituite: 1
    Query duplicate: #13  #47  #53  #75

    SELECT COUNT(*)
    
      FROM ecw3r_tz_portfolio_templates

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Select tables optimized away

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:49
    15	TZ_PortfolioTableTemplates->hasData()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:61
    14	TZ_PortfolioTableTemplates->_hasHome()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:75
    13	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
    12	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    11	TZ_PortfolioControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

20. Tempo della query: 0.31 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.025 MB memoria prima della query: 4.580 MB Righe restituite: 1
    Query duplicate: #14  #48  #54  #76

    SELECT COUNT(*)
    
      FROM ecw3r_tz_portfolio_templates
    
      WHERE `home`= 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_tz_portfolio_templates	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:67
    14	TZ_PortfolioTableTemplates->_hasHome()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:75
    13	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
    12	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    11	TZ_PortfolioControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

21. Tempo della query: 0.43 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.026 MB memoria prima della query: 4.588 MB Righe restituite: 1
    Query duplicate: #15  #49  #55  #77

    SELECT *
    
      FROM ecw3r_tz_portfolio_templates
    
      WHERE `home`= 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ecw3r_tz_portfolio_templates	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:81
    13	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
    12	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
    11	TZ_PortfolioControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

22. Tempo della query: 3.32 ms Dopo l'ultima query: 5.78 ms Memoria query: 0.036 MB memoria prima della query: 4.745 MB Righe restituite: 1
    Query duplicate: #23

    SELECT c.featured,xc.*,c.catid,c.attribs AS param,c.title AS c_title
    
      FROM ecw3r_tz_portfolio_xref_content AS xc
    
      LEFT JOIN ecw3r_content AS c 
      ON c.id=xc.contentid
    
      WHERE c.state = 1 
      AND xc.contentid=75

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	xc	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    14	JDatabase->query()	JROOT/components/com_tz_portfolio/models/media.php:102
    13	TZ_PortfolioModelMedia->getMedia()	JROOT/components/com_tz_portfolio/views/article/view.html.php:52
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

23. Tempo della query: 0.80 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.036 MB memoria prima della query: 4.752 MB Righe restituite: 1
    Query duplicate: #22

    SELECT c.featured,xc.*,c.catid,c.attribs AS param,c.title AS c_title
    
      FROM ecw3r_tz_portfolio_xref_content AS xc
    
      LEFT JOIN ecw3r_content AS c 
      ON c.id=xc.contentid
    
      WHERE c.state = 1 
      AND xc.contentid=75

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	xc	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/media.php:107
    13	TZ_PortfolioModelMedia->getMedia()	JROOT/components/com_tz_portfolio/views/article/view.html.php:52
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

24. Tempo della query: 1.22 ms Dopo l'ultima query: 4.21 ms Memoria query: 0.031 MB memoria prima della query: 4.799 MB Righe restituite: 1
    Query duplicate: #25

    SELECT xc.*,c.attribs AS param 
      FROM ecw3r_tz_portfolio_xref_content AS xc 
      LEFT JOIN ecw3r_content AS c 
      ON c.id=xc.contentid 
      WHERE c.state=1 
      AND xc.contentid=75

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	xc	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    14	JDatabase->query()	JROOT/components/com_tz_portfolio/models/attachments.php:40
    13	TZ_PortfolioModelAttachments->getAttachments()	JROOT/components/com_tz_portfolio/views/article/view.html.php:59
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

25. Tempo della query: 0.63 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.031 MB memoria prima della query: 4.806 MB Righe restituite: 1
    Query duplicate: #24

    SELECT xc.*,c.attribs AS param 
      FROM ecw3r_tz_portfolio_xref_content AS xc 
      LEFT JOIN ecw3r_content AS c 
      ON c.id=xc.contentid 
      WHERE c.state=1 
      AND xc.contentid=75

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	xc	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/attachments.php:44
    13	TZ_PortfolioModelAttachments->getAttachments()	JROOT/components/com_tz_portfolio/views/article/view.html.php:59
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

26. Tempo della query: 13.39 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.027 MB memoria prima della query: 4.814 MB Righe restituite: 1
    Query duplicate: #27

    SELECT u.id,u.name,u.email,tu.images,tu.url,tu.gender,tu.description,tu.twitter,tu.facebook,tu.google_one 
      FROM ecw3r_users AS u 
      LEFT JOIN ecw3r_tz_portfolio_users AS tu 
      ON tu.usersid=u.id 
      LEFT JOIN ecw3r_content AS c 
      ON c.created_by=u.id 
      WHERE c.id=75

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_createdby	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	tu	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	10	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    14	JDatabase->query()	JROOT/components/com_tz_portfolio/models/user.php:40
    13	TZ_PortfolioModelUser->getUser()	JROOT/components/com_tz_portfolio/views/article/view.html.php:60
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

27. Tempo della query: 0.45 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.027 MB memoria prima della query: 4.821 MB Righe restituite: 1
    Query duplicate: #26

    SELECT u.id,u.name,u.email,tu.images,tu.url,tu.gender,tu.description,tu.twitter,tu.facebook,tu.google_one 
      FROM ecw3r_users AS u 
      LEFT JOIN ecw3r_tz_portfolio_users AS tu 
      ON tu.usersid=u.id 
      LEFT JOIN ecw3r_content AS c 
      ON c.created_by=u.id 
      WHERE c.id=75

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_createdby	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	tu	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	10	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/user.php:45
    13	TZ_PortfolioModelUser->getUser()	JROOT/components/com_tz_portfolio/views/article/view.html.php:60
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

28. Tempo della query: 8.57 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.025 MB memoria prima della query: 4.832 MB Righe restituite: 0
    Query duplicate: #29

    SELECT t.*,x.contentid
    
      FROM `ecw3r_tz_portfolio_tags` AS t
    
      INNER JOIN `ecw3r_tz_portfolio_tags_xref` AS x 
      ON t.id=x.tagsid
    
      WHERE t.published = 1 
      AND x.contentid = 75

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    14	JDatabase->query()	JROOT/components/com_tz_portfolio/models/tag.php:60
    13	TZ_PortfolioModelTag->getTag()	JROOT/components/com_tz_portfolio/views/article/view.html.php:61
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

29. Tempo della query: 0.40 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.025 MB memoria prima della query: 4.839 MB Righe restituite: 0
    Query duplicate: #28

    SELECT t.*,x.contentid
    
      FROM `ecw3r_tz_portfolio_tags` AS t
    
      INNER JOIN `ecw3r_tz_portfolio_tags_xref` AS x 
      ON t.id=x.tagsid
    
      WHERE t.published = 1 
      AND x.contentid = 75

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	100.00	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/tag.php:65
    13	TZ_PortfolioModelTag->getTag()	JROOT/components/com_tz_portfolio/views/article/view.html.php:61
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

30. Tempo della query: 0.62 ms Dopo l'ultima query: 2.06 ms Memoria query: 0.037 MB memoria prima della query: 4.857 MB Righe restituite: 1
    Query duplicate: #8  #16  #44  #50  #72

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 1) AS rating, v.rating_count as rating_count
    
      FROM ecw3r_content AS a
    
      LEFT JOIN ecw3r_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN ecw3r_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN (
    SELECT contact.user_id, MAX(contact.id) AS id, contact.language
    
      FROM ecw3r_contact_details AS contact
    
      WHERE contact.published = 1
    
      GROUP BY contact.user_id, contact.language) AS contact 
      ON contact.user_id = a.created_by
    
      LEFT JOIN ecw3r_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ecw3r_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM ecw3r_categories AS cat JOIN ecw3r_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 75 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-18 14:33:52') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-18 14:33:52') 
      AND (a.state = 1 OR a.state =2)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	<derived2>	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
    1	PRIMARY	<derived3>	ref	<auto_key0>	<auto_key0>	4	const	3	100.00	Using index
    3	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	100.00	Using index condition; Using temporary; Using filesort
    3	DERIVED	cat	ALL	idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	100.00	Range checked for each record (index map: 0x10)
    2	DERIVED	contact	system	idx_state	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    15	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/article.php:264
    14	TZ_PortfolioModelArticle->getItem()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/article/view.html.php:67
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

31. Tempo della query: 5.28 ms Dopo l'ultima query: 0.88 ms Memoria query: 0.069 MB memoria prima della query: 4.908 MB Righe restituite: 4
    Query duplicate: #32

    SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug
    
      FROM `ecw3r_content` AS c
    
      LEFT JOIN `ecw3r_categories` AS cc 
      ON cc.id=c.catid
    
      LEFT JOIN `ecw3r_tz_portfolio_xref_content` AS x 
      ON x.contentid = c.id
    
      WHERE c.state = 1 
      AND NOT c.id=75 
      AND NOT x.type='quote' 
      AND NOT x.type='link' 
      AND c.catid=9
    
      ORDER BY c.created DESC 
      LIMIT 4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	c	eq_ref	PRIMARY,idx_state,idx_catid	PRIMARY	4	Sql1009297_1.x.contentid	1	100.00	Using index condition; Using where
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    15	JDatabase->query()	JROOT/components/com_tz_portfolio/models/article.php:158
    14	TZ_PortfolioModelArticle->getItemRelated()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/article/view.html.php:68
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

32. Tempo della query: 0.82 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.053 MB memoria prima della query: 4.931 MB Righe restituite: 4
    Query duplicate: #31

    SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug
    
      FROM `ecw3r_content` AS c
    
      LEFT JOIN `ecw3r_categories` AS cc 
      ON cc.id=c.catid
    
      LEFT JOIN `ecw3r_tz_portfolio_xref_content` AS x 
      ON x.contentid = c.id
    
      WHERE c.state = 1 
      AND NOT c.id=75 
      AND NOT x.type='quote' 
      AND NOT x.type='link' 
      AND c.catid=9
    
      ORDER BY c.created DESC 
      LIMIT 4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	c	eq_ref	PRIMARY,idx_state,idx_catid	PRIMARY	4	Sql1009297_1.x.contentid	1	100.00	Using index condition; Using where
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.05 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/article.php:163
    14	TZ_PortfolioModelArticle->getItemRelated()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/article/view.html.php:68
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

33. Tempo della query: 0.55 ms Dopo l'ultima query: 2.67 ms Memoria query: 0.038 MB memoria prima della query: 5.004 MB Righe restituite: 2
    Query duplicate: #9

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM ecw3r_categories as c
    
      LEFT JOIN ecw3r_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=9
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.02 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
    15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
    14	JCategories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:45
    13	TZ_PortfolioHelperRoute::getArticleRoute()	JROOT/components/com_tz_portfolio/views/article/view.html.php:158
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

34. Tempo della query: 2.18 ms Dopo l'ultima query: 1.47 ms Memoria query: 0.044 MB memoria prima della query: 5.065 MB Righe restituite: 11

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM ecw3r_categories as c
    
      LEFT JOIN ecw3r_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=1
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

    Profilo

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.02 ms
    checking query cache for query	0.24 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.21 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.05 ms
    optimizing	0.03 ms
    statistics	0.29 ms
    preparing	0.05 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    Creating sort index	0.35 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.23 ms
    Waiting for query cache lock	0.02 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
    15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
    14	JCategories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:135
    13	TZ_PortfolioHelperRoute::getCategoryRoute()	JROOT/components/com_tz_portfolio/views/article/view.html.php:161
    12	TZ_PortfolioViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
    9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

35. Tempo della query: 1.32 ms Dopo l'ultima query: 158.01 ms Memoria query: 0.030 MB memoria prima della query: 5.872 MB Righe restituite: 0