{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1674959193,
                "last": 1674959193,
                "now": 1674959193
            },
            "token": "lZMPpP3W362Bp3GbWDuEinHRy1kiPpg5"
        },
        "registry": {
            "current_theme": "red",
            "current_direction": "ltr",
            "current_key_sufix": "_red_ltr"
        },
        "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

22 query eseguite 72.41 ms

1. Tempo della query: 0.62 ms Memoria query: 0.022 MB memoria prima della query: 1.303 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `i15_session`
   
     WHERE `session_id` = X'633472723930643162616c353973323933623633726368626730' 
     LIMIT 1

   Explain

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

   Profilo

   Status	Duration
   Starting	0.08 ms
   Checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.07 ms
   Preparing	0.01 ms
   Executing	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   Call Stack

   #	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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:48

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

   ---

2. Tempo della query: 46.93 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.004 MB memoria prima della query: 1.309 MB

   INSERT INTO `i15_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'633472723930643162616c353973323933623633726368626730', 1, 1674959193, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `i15_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'633472723930643162616c353973323933623633726368626730', 1, 1674959193, 0, '', 0)

   Profilo

   Status	Duration
   Starting	0.08 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.03 ms
   Update	0.15 ms
   Waiting for query cache lock	0.01 ms
   Update	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	46.21 ms
   Closing tables	0.03 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.05 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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:48

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

   ---

3. Tempo della query: 0.75 ms Dopo l'ultima query: 3.92 ms Memoria query: 0.023 MB memoria prima della query: 1.455 MB Righe restituite: 6

   SELECT id, rules
   
     FROM `i15_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	i15_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6

   Profilo

   Status	Duration
   Starting	0.08 ms
   Checking permissions	0.01 ms
   Opening tables	0.04 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.03 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.10 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.03 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 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:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

   ---

4. Tempo della query: 0.88 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.022 MB memoria prima della query: 1.468 MB Righe restituite: 2

   SELECT b.id
   
     FROM i15_usergroups AS a
   
     LEFT JOIN i15_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 11

   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	41	Using where; Using index

   Profilo

   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	0.04 ms
   Optimizing	0.04 ms
   Statistics	0.12 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.05 ms
   Executing	0.01 ms
   Sending data	0.13 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 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:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

   ---

5. Tempo della query: 0.76 ms Dopo l'ultima query: 39.74 ms Memoria query: 0.005 MB memoria prima della query: 4.115 MB

   UPDATE `i15_extensions`
   
     SET `params` = '{\"mediaversion\":\"2b920f5486adbdcbe2bcbd456714686d\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN non possibile sulla query: UPDATE `i15_extensions` SET `params` = '{\"mediaversion\":\"2b920f5486adbdcbe2bcbd456714686d\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profilo

   Status	Duration
   Starting	0.09 ms
   Checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init for update	0.15 ms
   Updating	0.09 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.04 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.04 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:1130
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

   ---

6. Tempo della query: 0.93 ms Dopo l'ultima query: 5.92 ms Memoria query: 0.037 MB memoria prima della query: 4.494 MB Righe restituite: 1

   SELECT *
   
     FROM `apl_manifestazione` AS `a`
   
     WHERE a.id = 1

   Explain

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

   Profilo

   Status	Duration
   Starting	0.07 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.03 ms
   Init	0.07 ms
   Optimizing	0.03 ms
   Statistics	0.09 ms
   Preparing	0.01 ms
   Unlocking tables	0.02 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.08 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.04 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
   10	JDatabaseDriver->loadAssoc()	JROOT/components/com_iolavoro/classes/APLObject.php:72
   9	APLObject->__construct()	JROOT/components/com_iolavoro/controllers/public.php:47
   8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
   6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

   ---

7. Tempo della query: 1.34 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.035 MB memoria prima della query: 4.503 MB Righe restituite: 1

   SELECT e.*, es.id_subgroup, fd.descrizione_contratto, ag.ad
                   
     FROM apl_employers e
                   JOIN apl_emp_man_jusers emj 
     ON (e.id_employer = emj.id_employer)
                   
     LEFT JOIN apl_employers_subgroups es 
     ON es.id_employer = e.id_employer
                   
     LEFT JOIN i15_apl_franchisor_details fd 
     ON fd.id_employer = e.id_employer
                   
     LEFT JOIN i15_apl_agenzialavoro_ads ag 
     ON ag.id_employer = e.id_employer JOIN apl_subgroups s 
     ON (s.id_subgroup = es.`id_subgroup` 
     AND s.id_manifestazione = 1)  
     WHERE e.id_employer = 11042 
     AND emj.id_manifestazione=1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	e	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	emj	const	PRIMARY,indice_aziende_manif_jusers,_idx,id_manifestazione	PRIMARY	8	const,const	1	Using index
   1	SIMPLE	fd	ref	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	ag	ref	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	es	ref	PRIMARY,id_subgroup	PRIMARY	4	const	5	Using index
   1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	iolavoro_prod.es.id_subgroup	1	Using where

   Profilo

   Status	Duration
   Starting	0.15 ms
   Checking permissions	0.02 ms
   Opening tables	0.07 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.08 ms
   Optimizing	0.06 ms
   Statistics	0.24 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.08 ms
   Executing	0.01 ms
   Sending data	0.19 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.03 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
   10	JDatabaseDriver->loadAssoc()	JROOT/components/com_iolavoro/models/public.php:357
   9	IoLavoroModelPublic->getEmployer()	JROOT/components/com_iolavoro/controllers/public.php:186
   8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
   6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

   ---

8. Tempo della query: 6.96 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.034 MB memoria prima della query: 4.516 MB Righe restituite: 22

   SELECT 
            IF((SELECT DISTINCT id_ads 
     FROM apl_ads_catprotette cat 
     WHERE cat.id_ads = t1.id 
     AND cat.id_categoria IN (1,2,3,4,5)), "true", "false") AS "isH1",
    IF((SELECT DISTINCT id_ads 
     FROM apl_ads_catprotette cat 
     WHERE cat.id_ads = t1.id 
     AND cat.id_categoria IN (8,9)), "true", "false") AS "isH18",
           t1.id_stato_lavoro, t1.nascondi_zona_lavoro, t1.in_italia , IFNULL(r.`nome`,"") AS "regione", IFNULL(prov.`nome`,"") AS "provincia", IFNULL(com.`nome`,"") AS "comune", t1.id,  t1.titolo as nome_profilo , emp.ragione_sociale, emp.titolo,
                       IF((SELECT DISTINCT id_ads 
     FROM apl_ads_catprotette cat 
     WHERE cat.id_ads = t1.id 
     AND cat.id_categoria IN (1,5)), "true", "false") AS "isH" 
     FROM `apl_ads` t1  JOIN CP2011 t2 
     ON t1.id_profile = t2.id_profile JOIN apl_employers emp 
     on emp.id_employer = t1.id_employer
                     JOIN apl_emp_man_jusers emj 
     ON (emj.id_employer = t1.id_employer 
     AND emj.id_manifestazione=1)
                     
     LEFT JOIN `apl_regioni` r 
     ON (r.`id` = t1.`id_regione_lavoro`)
                     
     LEFT JOIN `apl_province` prov 
     ON (prov.`id` = t1.`id_prov_lavoro`)
                     
     LEFT JOIN `apl_comuni` com 
     ON (com.`id` = t1.`id_comune_lavoro`)
                     
     WHERE 1 = 1 
                     
     AND t1.id_manifestazione IN (1, 1)
     AND t1.id_employer = 11042 
     AND t1.validato = 1  
     AND t1.active = 1  
     AND (t1.datetime_scadenza > "2023-01-29 02:26:33" OR t1.datetime_scadenza = "0000-00-00 00:00:00" )  
     ORDER BY t1.`id` DESC

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	PRIMARY	emp	const	PRIMARY	PRIMARY	4	const	1
   1	PRIMARY	emj	const	PRIMARY,indice_aziende_manif_jusers,_idx,id_manifestazione	PRIMARY	8	const,const	1	Using index
   1	PRIMARY	t1	ref	id_profile,id_employer,id_manifestazione,id_employer_2	id_employer_2	4	const	363	Using index condition; Using where; Using filesort
   1	PRIMARY	r	eq_ref	PRIMARY	PRIMARY	4	iolavoro_prod.t1.id_regione_lavoro	1	Using where
   1	PRIMARY	prov	eq_ref	PRIMARY	PRIMARY	4	iolavoro_prod.t1.id_prov_lavoro	1	Using where
   1	PRIMARY	t2	eq_ref	PRIMARY	PRIMARY	4	iolavoro_prod.t1.id_profile	1	Using index
   1	PRIMARY	com	eq_ref	PRIMARY	PRIMARY	4	iolavoro_prod.t1.id_comune_lavoro	1	Using where
   4	DEPENDENT SUBQUERY	cat	ref	id_ads,id_categoria	id_ads	4	iolavoro_prod.t1.id	1	Using where; Using index
   3	DEPENDENT SUBQUERY	cat	ref	id_ads,id_categoria	id_ads	4	iolavoro_prod.t1.id	1	Using where; Using index
   2	DEPENDENT SUBQUERY	cat	ref	id_ads,id_categoria	id_ads	4	iolavoro_prod.t1.id	1	Using where; Using index

   Profilo

   Status	Duration
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Executing	0.01 ms
   Sending data	0.04 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.03 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Removing tmp table	0.01 ms
   Freeing items	0.01 ms
   Removing tmp table	0.01 ms
   Freeing items	0.01 ms
   Removing tmp table	0.01 ms
   Freeing items	0.03 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   10	JDatabaseDriver->loadAssocList()	JROOT/components/com_iolavoro/models/public.php:618
   9	IoLavoroModelPublic->getAdsByEmployerId()	JROOT/components/com_iolavoro/controllers/public.php:188
   8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
   6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

   ---

9. Tempo della query: 1.42 ms Dopo l'ultima query: 1.63 ms Memoria query: 0.044 MB memoria prima della query: 4.580 MB Righe restituite: 0

   SELECT t1.*, 
               e.titolo as "employer_name", 
               e.presentazione as "employer_description", 
               e.sito as "employer_site",
               contratto.nome as "tipo_contratto",
               IF(t1.titolo = "", "...",t1.titolo) as "nome", IFNULL(CP2011.CODNOMI11," ISTAT ") as "istat", sez.`sezione`, 
               IFNULL(CP2011.name," PROFILO ") as "nome_profilo",
   	    IF(UNIX_TIMESTAMP(t1.datetime_scadenza) > 0 
     AND "2023-01-29 02:26" >= t1.datetime_scadenza, 1, 0) as "scaduto",
   	    s.`reference` as "subgroup_reference",
               s.`name` as "subgroup_name"
               
     FROM `apl_ads` t1
   	    JOIN `apl_employers` e 
     ON (e.id_employer = t1.id_employer)
               JOIN `apl_employers_subgroups` es 
     ON (es.`id_employer` = t1.`id_employer`)
               JOIN `apl_subgroups` s 
     ON (s.`id_subgroup` = es.`id_subgroup` 
     AND s.`id_manifestazione` = t1.`id_manifestazione`)
               
     LEFT JOIN CP2011 
     ON (CP2011.id_profile = t1.id_profile )
               
     LEFT JOIN `apl_ads_sezione` sez 
     ON (t1.`id` = sez.`id_ads`) 
               
     LEFT JOIN `apl_contratto` contratto 
     ON (contratto.id = t1.id_tipo_contratto)
               
     WHERE t1.id = 0

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Profilo

   Status	Duration
   Starting	0.24 ms
   Checking permissions	0.02 ms
   Opening tables	0.07 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.16 ms
   Optimizing	0.08 ms
   Statistics	0.26 ms
   Preparing	0.02 ms
   Executing	0.12 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.03 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
   11	JDatabaseDriver->loadAssoc()	JROOT/components/com_iolavoro/classes/IoLavoro/IoLavoroTools.php:440
   10	IoLavoroTools::getAnnuncioById()	JROOT/components/com_iolavoro/views/public/view.html.php:67
   9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
   8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
   6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

   ---

10. Tempo della query: 0.78 ms Dopo l'ultima query: 1.46 ms Memoria query: 0.036 MB memoria prima della query: 4.609 MB Righe restituite: 1
    Query duplicate: #18

    SELECT *
    
      FROM `apl_employers` AS `a`
    
      WHERE a.id_employer = 11042

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 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	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/components/com_iolavoro/classes/APLObject.php:72
    13	APLObject->__construct()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:14
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

11. Tempo della query: 0.82 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.024 MB memoria prima della query: 4.617 MB Righe restituite: 0

    SELECT `id` 
      FROM `apl_manifestazione` 
      WHERE `active` = 1 
      AND `public` = 1 
      AND `id` != 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	apl_manifestazione	range	PRIMARY	PRIMARY	4	NULL	42	Using where

    Profilo

    Status	Duration
    Starting	0.07 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	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.17 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:17
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

12. Tempo della query: 1.13 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.030 MB memoria prima della query: 4.625 MB Righe restituite: 1
    Query duplicate: #21

    SELECT emj.*, es.*, s.name as "nome", s.reference, s.descrizione
                    
      FROM apl_emp_man_jusers emj
                    JOIN apl_manifestazione m 
      ON (m.id = emj.id_manifestazione 
      AND m.active=1 
      AND m.id IN (1))
                    JOIN apl_employers_subgroups es 
      ON (es.`id_employer` = emj.`id_employer`)
                    JOIN apl_subgroups s 
      ON (s.`id_manifestazione` = m.id 
      AND es.`id_subgroup` = s.`id_subgroup`)
                    
      WHERE emj.id_employer = 11042 
      AND emj.id_manifestazione IN (1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	emj	const	PRIMARY,indice_aziende_manif_jusers,_idx,id_manifestazione	PRIMARY	8	const,const	1
    1	SIMPLE	m	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	es	ref	PRIMARY,id_subgroup	PRIMARY	4	const	5
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	iolavoro_prod.es.id_subgroup	1	Using where

    Profilo

    Status	Duration
    Starting	0.14 ms
    Checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.17 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.13 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/components/com_iolavoro/classes/employer/APLEmployer.php:163
    13	APLEmployer->getSimpleParticipationDetails()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:19
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

13. Tempo della query: 1.85 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.029 MB memoria prima della query: 4.634 MB Righe restituite: 1

    SELECT s.*  , es.id_employer, es.modalita_partecipazione, es.chat, es.webinar   
      FROM apl_subgroups s  JOIN apl_employers_subgroups es 
      ON (s.id_subgroup = es.id_subgroup)  
      WHERE id_group = 9  
      AND es.id_employer = 11042 
      AND s.id_manifestazione = 1 
      ORDER BY s.
      order ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	es	ref	PRIMARY,id_subgroup	PRIMARY	4	const	5	Using temporary; Using filesort
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	iolavoro_prod.es.id_subgroup	1	Using where

    Profilo

    Status	Duration
    Starting	0.11 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	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.05 ms
    Creating tmp table	0.06 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.69 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.21 ms
    Creating sort index	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    14	JDatabaseDriver->loadAssocList()	JROOT/components/com_iolavoro/classes/APLSubgroup.php:144
    13	APLSubgroup::getEmployerSubgroups()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:20
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

14. Tempo della query: 0.80 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.024 MB memoria prima della query: 4.643 MB Righe restituite: 0
    Query duplicate: #15

    SELECT `sala` 
      FROM `apl_emp_sale` 
      WHERE `id_employer` = 11042 
      AND `id_manifestazione` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	apl_emp_sale	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	157	Using where

    Profilo

    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.03 ms
    Statistics	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.29 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    13	JDatabase->query()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:38
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

15. Tempo della query: 0.88 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.024 MB memoria prima della query: 4.650 MB Righe restituite: 0
    Query duplicate: #14

    SELECT `sala` 
      FROM `apl_emp_sale` 
      WHERE `id_employer` = 11042 
      AND `id_manifestazione` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	apl_emp_sale	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	157	Using where

    Profilo

    Status	Duration
    Starting	0.07 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	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.29 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.06 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:39
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

16. Tempo della query: 0.58 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.024 MB memoria prima della query: 4.657 MB Righe restituite: 1
    Query duplicate: #17

    SELECT `url` 
      FROM `i24_employer_url` 
      WHERE `id_employer` = 11042

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 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	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 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
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    13	JDatabase->query()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:43
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

17. Tempo della query: 0.48 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.025 MB memoria prima della query: 4.665 MB Righe restituite: 1
    Query duplicate: #16

    SELECT `url` 
      FROM `i24_employer_url` 
      WHERE `id_employer` = 11042

    Explain

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

    Profilo

    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.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 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
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:44
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

18. Tempo della query: 0.79 ms Dopo l'ultima query: 0.30 ms Memoria query: 0.036 MB memoria prima della query: 4.676 MB Righe restituite: 1
    Query duplicate: #10

    SELECT *
    
      FROM `apl_employers` AS `a`
    
      WHERE a.id_employer = 11042

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 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	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/components/com_iolavoro/classes/APLObject.php:72
    13	APLObject->__construct()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:238
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

19. Tempo della query: 1.00 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.029 MB memoria prima della query: 4.685 MB Righe restituite: 0

    SELECT emj.*, es.*, s.name as "nome", s.reference, s.descrizione
                    
      FROM apl_emp_man_jusers emj
                    JOIN apl_manifestazione m 
      ON (m.id = emj.id_manifestazione 
      AND m.active=1 
      AND m.id IN (27))
                    JOIN apl_employers_subgroups es 
      ON (es.`id_employer` = emj.`id_employer`)
                    JOIN apl_subgroups s 
      ON (s.`id_manifestazione` = m.id 
      AND es.`id_subgroup` = s.`id_subgroup`)
                    
      WHERE emj.id_employer = 11042 
      AND emj.id_manifestazione IN (27)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profilo

    Status	Duration
    Starting	0.15 ms
    Checking permissions	0.01 ms
    Opening tables	0.15 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.13 ms
    Preparing	0.01 ms
    Executing	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/components/com_iolavoro/classes/employer/APLEmployer.php:163
    13	APLEmployer->getSimpleParticipationDetails()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:239
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

20. Tempo della query: 0.91 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.029 MB memoria prima della query: 4.693 MB Righe restituite: 0

    SELECT emj.*, es.*, s.name as "nome", s.reference, s.descrizione
                    
      FROM apl_emp_man_jusers emj
                    JOIN apl_manifestazione m 
      ON (m.id = emj.id_manifestazione 
      AND m.active=1 
      AND m.id IN (1033))
                    JOIN apl_employers_subgroups es 
      ON (es.`id_employer` = emj.`id_employer`)
                    JOIN apl_subgroups s 
      ON (s.`id_manifestazione` = m.id 
      AND es.`id_subgroup` = s.`id_subgroup`)
                    
      WHERE emj.id_employer = 11042 
      AND emj.id_manifestazione IN (1033)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profilo

    Status	Duration
    Starting	0.17 ms
    Checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.13 ms
    Preparing	0.02 ms
    Executing	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/components/com_iolavoro/classes/employer/APLEmployer.php:163
    13	APLEmployer->getSimpleParticipationDetails()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:250
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

21. Tempo della query: 1.14 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.030 MB memoria prima della query: 4.700 MB Righe restituite: 1
    Query duplicate: #12

    SELECT emj.*, es.*, s.name as "nome", s.reference, s.descrizione
                    
      FROM apl_emp_man_jusers emj
                    JOIN apl_manifestazione m 
      ON (m.id = emj.id_manifestazione 
      AND m.active=1 
      AND m.id IN (1))
                    JOIN apl_employers_subgroups es 
      ON (es.`id_employer` = emj.`id_employer`)
                    JOIN apl_subgroups s 
      ON (s.`id_manifestazione` = m.id 
      AND es.`id_subgroup` = s.`id_subgroup`)
                    
      WHERE emj.id_employer = 11042 
      AND emj.id_manifestazione IN (1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	emj	const	PRIMARY,indice_aziende_manif_jusers,_idx,id_manifestazione	PRIMARY	8	const,const	1
    1	SIMPLE	m	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	es	ref	PRIMARY,id_subgroup	PRIMARY	4	const	5
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	iolavoro_prod.es.id_subgroup	1	Using where

    Profilo

    Status	Duration
    Starting	0.14 ms
    Checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.17 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.13 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/components/com_iolavoro/classes/employer/APLEmployer.php:163
    13	APLEmployer->getSimpleParticipationDetails()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:263
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

22. Tempo della query: 0.65 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.025 MB memoria prima della query: 4.707 MB Righe restituite: 1

    SELECT m.`is_digital` 
      FROM apl_manifestazione m 
      WHERE id = '1'

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 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	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 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
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_iolavoro/classes/APLManifestazione.php:597
    13	APLManifestazione::isDigital()	JROOT/components/com_iolavoro/views/public/tmpl/employer.php:425
    12	include JROOT/components/com_iolavoro/views/public/tmpl/employer.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_iolavoro/views/public/view.html.php:134
    9	IoLavoroViewPublic->display()	JROOT/components/com_iolavoro/controllers/public.php:329
    8	IoLavoroControllerPublic->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_iolavoro/iolavoro.php:191
    6	require_once JROOT/components/com_iolavoro/iolavoro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

18 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 2 × SELECT * 
     FROM `apl_employers` AS `a`

2. 2 × SELECT emj.*, es.*, s.name as "nome", s.reference, s.descrizione                 
     FROM apl_emp_man_jusers emj                 JOIN apl_manifestazione m 
     ON (m.id = emj.id_manifestazione 
     AND m.active=1 
     AND m.id IN (1))                 JOIN apl_employers_subgroups es 
     ON (es.`id_employer` = emj.`id_employer`)                 JOIN apl_subgroups s 
     ON (s.`id_manifestazione` = m.id 
     AND es.`id_subgroup` = s.`id_subgroup`)

3. 2 × SELECT `sala` 
     FROM `apl_emp_sale`

4. 2 × SELECT `url` 
     FROM `i24_employer_url`

5. 1 × SELECT `session_id` 
     FROM `i15_session`

6. 1 × SELECT id, rules 
     FROM `i15_viewlevels

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

8. 1 × SELECT * 
     FROM `apl_manifestazione` AS `a`

9. 1 × SELECT e.*, es.id_subgroup, fd.descrizione_contratto, ag.ad                 
     FROM apl_employers e                 JOIN apl_emp_man_jusers emj 
     ON (e.id_employer = emj.id_employer)                 
     LEFT JOIN apl_employers_subgroups es 
     ON es.id_employer = e.id_employer                 
     LEFT JOIN i15_apl_franchisor_details fd 
     ON fd.id_employer = e.id_employer                 
     LEFT JOIN i15_apl_agenzialavoro_ads ag 
     ON ag.id_employer = e.id_employer JOIN apl_subgroups s 
     ON (s.id_subgroup = es.`id_subgroup` 
     AND s.id_manifestazione = 1)

10. 1 × SELECT           IF((SELECT DISTINCT id_ads 
      FROM apl_ads_catprotette cat

11. 1 × SELECT t1.*,              e.titolo as "employer_name",              e.presentazione as "employer_description",              e.sito as "employer_site",             contratto.nome as "tipo_contratto",             IF(t1.titolo = "", "...",t1.titolo) as "nome", IFNULL(CP2011.CODNOMI11," ISTAT ") as "istat", sez.`sezione`,              IFNULL(CP2011.name," PROFILO ") as "nome_profilo",      IF(UNIX_TIMESTAMP(t1.datetime_scadenza) > 0 
      AND "2023-01-29 02:26" >= t1.datetime_scadenza, 1, 0) as "scaduto",      s.`reference` as "subgroup_reference",             s.`name` as "subgroup_name"             
      FROM `apl_ads` t1      JOIN `apl_employers` e 
      ON (e.id_employer = t1.id_employer)             JOIN `apl_employers_subgroups` es 
      ON (es.`id_employer` = t1.`id_employer`)             JOIN `apl_subgroups` s 
      ON (s.`id_subgroup` = es.`id_subgroup` 
      AND s.`id_manifestazione` = t1.`id_manifestazione`)             
      LEFT JOIN CP2011 
      ON (CP2011.id_profile = t1.id_profile )             
      LEFT JOIN `apl_ads_sezione` sez 
      ON (t1.`id` = sez.`id_ads`)              
      LEFT JOIN `apl_contratto` contratto 
      ON (contratto.id = t1.id_tipo_contratto)

12. 1 × SELECT `id` 
      FROM `apl_manifestazione`

13. 1 × SELECT s.*  , es.id_employer, es.modalita_partecipazione, es.chat, es.webinar   
      FROM apl_subgroups s  JOIN apl_employers_subgroups es 
      ON (s.id_subgroup = es.id_subgroup)

14. 1 × SELECT emj.*, es.*, s.name as "nome", s.reference, s.descrizione                 
      FROM apl_emp_man_jusers emj                 JOIN apl_manifestazione m 
      ON (m.id = emj.id_manifestazione 
      AND m.active=1 
      AND m.id IN (27))                 JOIN apl_employers_subgroups es 
      ON (es.`id_employer` = emj.`id_employer`)                 JOIN apl_subgroups s 
      ON (s.`id_manifestazione` = m.id 
      AND es.`id_subgroup` = s.`id_subgroup`)

15. 1 × SELECT emj.*, es.*, s.name as "nome", s.reference, s.descrizione                 
      FROM apl_emp_man_jusers emj                 JOIN apl_manifestazione m 
      ON (m.id = emj.id_manifestazione 
      AND m.active=1 
      AND m.id IN (1033))                 JOIN apl_employers_subgroups es 
      ON (es.`id_employer` = emj.`id_employer`)                 JOIN apl_subgroups s 
      ON (s.`id_manifestazione` = m.id 
      AND es.`id_subgroup` = s.`id_subgroup`)

16. 1 × SELECT m.`is_digital` 
      FROM apl_manifestazione m

ALTRE tabelle:

1. 1 × INSERT INTO `i15_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'633472723930643162616c353973323933623633726368626730', 1, 1674959193, 0, '', 0

2. 1 × UPDATE `i15_extensions` 
     SET `params` = '{\"mediaversion\":\"2b920f5486adbdcbe2bcbd456714686d\"}'