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
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 |
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 |
# | 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 |
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 non possibile sulla query: INSERT INTO `i15_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'633472723930643162616c353973323933623633726368626730', 1, 1674959193, 0, '', 0)
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 |
# | 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 |
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`
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 | |
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 |
# | 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 |
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
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 |
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 |
# | 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 |
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 non possibile sulla query: UPDATE `i15_extensions`
SET `params` = '{\"mediaversion\":\"2b920f5486adbdcbe2bcbd456714686d\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
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 |
# | 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 |
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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 |
# | 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 |
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
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 |
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 |
# | 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 |
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
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 |
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 |
# | 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 |
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
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 |
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 |
# | 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 |
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
SELECT *
FROM `apl_employers` AS `a`
WHERE a.id_employer = 11042
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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 |
# | 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 |
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
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 |
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 |
# | 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 |
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
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)
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 |
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 |
# | 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 |
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
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 |
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 |
# | 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 |
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
SELECT `sala`
FROM `apl_emp_sale`
WHERE `id_employer` = 11042
AND `id_manifestazione` = 1
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 |
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 |
# | 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 |
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
SELECT `sala`
FROM `apl_emp_sale`
WHERE `id_employer` = 11042
AND `id_manifestazione` = 1
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 |
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 |
# | 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 |
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
SELECT `url`
FROM `i24_employer_url`
WHERE `id_employer` = 11042
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | i24_employer_url | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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 |
# | 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 |
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
SELECT `url`
FROM `i24_employer_url`
WHERE `id_employer` = 11042
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | i24_employer_url | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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 |
# | 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 |
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
SELECT *
FROM `apl_employers` AS `a`
WHERE a.id_employer = 11042
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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 |
# | 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 |
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)
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 |
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 |
# | 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 |
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)
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 |
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 |
# | 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 |
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
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)
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 |
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 |
# | 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 |
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'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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 |
# | 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 |
2 × SELECT *
FROM `apl_employers` AS `a`
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`)
2 × SELECT `sala`
FROM `apl_emp_sale`
2 × SELECT `url`
FROM `i24_employer_url`
1 × SELECT `session_id`
FROM `i15_session`
1 × SELECT id, rules
FROM `i15_viewlevels
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
1 × SELECT *
FROM `apl_manifestazione` AS `a`
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)
1 × SELECT IF((SELECT DISTINCT id_ads
FROM apl_ads_catprotette cat
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)
1 × SELECT `id`
FROM `apl_manifestazione`
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)
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`)
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`)
1 × SELECT m.`is_digital`
FROM apl_manifestazione m