0
×
L'annuncio è stato disattivato. È possibile ritrovarlo nella tab annunci scaduti e riattivarlo in qualunque momento.
IOLAVORO Virtual
In questo momento le offerte di lavoro sono
34291 - APPRENDISTA ADDETTO ALL'APPLICAZIONE DI PANNELLI IN CARTONGESSO
34291 - Apprendista addetto all'applicazione di pannelli in cartongesso
addetto all'applicazione di pannelli in cartongesso
APPRENDISTA ADDETTO A LAVORI DI CARTONGESSO E CONTROSOFFITTATURA. L'AZIENDA VALUTA EVENTUALMENTE ANCHE PERSONALE QUALIFICATO NELLA MANSIONE
ETA' MASSIMA 29 ANNI E BUONA CAPACITA' DI APPRENDIMENTO
- Italia: Cuneo (CN)
APPRENDISTATO
FULL TIME
- B (Requisito Obbligatorio)
Clicca sul pulsante INVIA LA CANDIDATURA e compila il tuo profilo con tutte le informazioni. È necessaria l'autenticazione con Spid o CIE (Carta di identità elettronica). Se non hai ancora Spid puoi richiedere un supporto utilizzando la chat di assistenza
Se non in possesso di SPID o di altra modalità di accesso al portale, inviare una mail a [email protected] allegando il proprio curriculum e specificando a quale offerta si fa riferimento.
CONDIVIDI QUESTO ANNUNCIO
Console Debug Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1674961041,
"last": 1674961041,
"now": 1674961041
},
"token": "J1Z2FupJI8FiV63m3RELs9T2dtqrGJSs"
},
"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
Tempo: 3.81 ms / 3.81 ms Memoria: 0.594 MB / 0.96 MB Application: afterLoad
Tempo: 111.41 ms / 115.22 ms Memoria: 0.956 MB / 1.92 MB Application: afterInitialise
Tempo: 18.81 ms / 134.03 ms Memoria: 2.193 MB / 4.11 MB Application: afterRoute
Tempo: 41.37 ms / 175.40 ms Memoria: 0.109 MB / 4.22 MB Application: beforeRenderComponent com_iolavoro
Tempo: 43.68 ms / 219.08 ms Memoria: 0.567 MB / 4.79 MB Application: afterRenderComponent com_iolavoro
Tempo: 1.39 ms / 220.47 ms Memoria: 0.072 MB / 4.86 MB Application: afterDispatch
Tempo: 15.38 ms / 235.85 ms Memoria: 0.480 MB / 5.34 MB Application: beforeRenderModule mod_login (Login)
Tempo: 3.17 ms / 239.02 ms Memoria: 0.034 MB / 5.37 MB Application: afterRenderModule mod_login (Login)
Tempo: 15.28 ms / 254.30 ms Memoria: 0.151 MB / 5.52 MB Application: afterRender
Query totali del database: 146.13 ms
6,14 MB (6.438.760 Bytes)
38 query eseguite 146.13 ms
Trovati 15 duplicati!
- Tempo della query: 0.68 ms Memoria query: 0.022 MB memoria prima della query: 1.303 MB Righe restituite: 0Query duplicate: #10
SELECT `session_id`
FROM `i15_session`
WHERE `session_id` = X'6a7136666f303672737232616c376c666f6a757630706f377667'
LIMIT 1id 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.06 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.07 ms Preparing 0.01 ms Executing 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 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: 74.73 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'6a7136666f303672737232616c376c666f6a757630706f377667', 1, 1674961041, 0, '', 0)EXPLAIN non possibile sulla query: INSERT INTO `i15_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6a7136666f303672737232616c376c666f6a757630706f377667', 1, 1674961041, 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.16 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 74.00 ms Closing tables 0.04 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.77 ms Dopo l'ultima query: 3.90 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.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 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.04 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.89 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 = 11id 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.02 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.02 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: 37.75 ms Dopo l'ultima query: 40.01 ms Memoria query: 0.005 MB memoria prima della query: 4.115 MB
UPDATE `i15_extensions`
SET `params` = '{\"mediaversion\":\"50c951d3951e80f41441b2201a898fda\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN non possibile sulla query: UPDATE `i15_extensions` SET `params` = '{\"mediaversion\":\"50c951d3951e80f41441b2201a898fda\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.10 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.12 ms End of update loop 0.01 ms Waiting for query cache lock 0.01 ms End of update loop 0.02 ms Query end 0.01 ms Commit 36.88 ms Closing tables 0.04 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 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: 1.05 ms Dopo l'ultima query: 6.41 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 = 1id 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.09 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init 0.07 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 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.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 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: 0.67 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.022 MB memoria prima della query: 4.501 MB Righe restituite: 1
SELECT id_employer
FROM apl_ads
WHERE id = 34291id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE apl_ads const PRIMARY,id 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.11 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 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/components/com_iolavoro/controllers/public.php:205 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.81 ms Dopo l'ultima query: 1.50 ms Memoria query: 0.046 MB memoria prima della query: 4.515 MB Righe restituite: 1Query duplicate: #16
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:57" >= 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 = 34291
AND e.id_employer = 11067id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 const PRIMARY,id_employer,id_manifestazione,id_employer_2,id PRIMARY 4 const 1 1 SIMPLE e const PRIMARY PRIMARY 4 const 1 1 SIMPLE CP2011 const PRIMARY PRIMARY 4 const 1 1 SIMPLE sez ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE contratto eq_ref PRIMARY PRIMARY 4 const 1 1 SIMPLE es ref PRIMARY,id_subgroup PRIMARY 4 const 4 Using index 1 SIMPLE s eq_ref PRIMARY PRIMARY 4 iolavoro_prod.es.id_subgroup 1 Using where Status Duration Starting 0.28 ms Checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.17 ms Optimizing 0.09 ms Statistics 0.31 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.09 ms Executing 0.01 ms Sending data 0.25 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.03 ms Updating status 0.04 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:39 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.26 ms Memoria query: 0.035 MB memoria prima della query: 4.551 MB Righe restituite: 1
SELECT *
FROM `apl_employers` AS `a`
WHERE a.id_employer = 11067id 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.02 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.04 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/APLObject.php:72 10 APLObject->__construct() JROOT/components/com_iolavoro/views/public/view.html.php:40 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.62 ms Dopo l'ultima query: 1.48 ms Memoria query: 0.026 MB memoria prima della query: 4.589 MB Righe restituite: 1Query duplicate: #1
SELECT `session_id`
FROM `i15_session`
WHERE `session_id` = X'6a7136666f303672737232616c376c666f6a757630706f377667'
LIMIT 1id 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.07 ms Checking permissions 0.02 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 16 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 15 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 14 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/WebApplication.php:321 13 Joomla\CMS\Application\WebApplication->initialise() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:10 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.24 ms Memoria query: 0.036 MB memoria prima della query: 4.598 MB Righe restituite: 1
SELECT *
FROM `apl_employers` AS `a`
WHERE a.id_employer = 11067id 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/ads.php:18 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.10 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.030 MB memoria prima della query: 4.607 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 = 11067
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 4 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.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.08 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.04 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/ads.php:26 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.88 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.029 MB memoria prima della query: 4.616 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 = 11067
AND s.id_manifestazione = 1
ORDER BY s.
order ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE es ref PRIMARY,id_subgroup PRIMARY 4 const 4 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.02 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.07 ms Sorting result 0.04 ms Executing 0.01 ms Sending data 0.66 ms Creating sort index 0.07 ms Removing tmp table 0.21 ms Creating sort index 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.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:1506 14 JDatabaseDriver->loadAssocList() JROOT/components/com_iolavoro/classes/APLSubgroup.php:144 13 APLSubgroup::getEmployerSubgroups() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:27 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.97 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.029 MB memoria prima della query: 4.627 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 (26)) 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 = 11067
AND emj.id_manifestazione IN (26)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.14 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.08 ms Optimizing 0.06 ms Statistics 0.16 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.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 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/ads.php:35 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.13 ms Memoria query: 0.030 MB memoria prima della query: 4.634 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 = 11067
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 4 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.05 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.19 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.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 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/ads.php:36 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.72 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.046 MB memoria prima della query: 4.647 MB Righe restituite: 1Query duplicate: #8
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:57" >= 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 = 34291
AND e.id_employer = 11067id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 const PRIMARY,id_employer,id_manifestazione,id_employer_2,id PRIMARY 4 const 1 1 SIMPLE e const PRIMARY PRIMARY 4 const 1 1 SIMPLE CP2011 const PRIMARY PRIMARY 4 const 1 1 SIMPLE sez ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE contratto eq_ref PRIMARY PRIMARY 4 const 1 1 SIMPLE es ref PRIMARY,id_subgroup PRIMARY 4 const 4 Using index 1 SIMPLE s eq_ref PRIMARY PRIMARY 4 iolavoro_prod.es.id_subgroup 1 Using where Status Duration Starting 0.28 ms Checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.16 ms Optimizing 0.09 ms Statistics 0.29 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.07 ms Executing 0.01 ms Sending data 0.27 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.03 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:1465 14 JDatabaseDriver->loadAssoc() JROOT/components/com_iolavoro/classes/IoLavoro/IoLavoroTools.php:440 13 IoLavoroTools::getAnnuncioById() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:40 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.90 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.025 MB memoria prima della query: 4.671 MB Righe restituite: 0Query duplicate: #18
SELECT `sala`
FROM `apl_emp_sale`
WHERE `id_employer` = 11067
AND `id_manifestazione` = 1id 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.05 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.30 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/ads.php:49 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.90 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.024 MB memoria prima della query: 4.679 MB Righe restituite: 0Query duplicate: #17
SELECT `sala`
FROM `apl_emp_sale`
WHERE `id_employer` = 11067
AND `id_manifestazione` = 1id 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.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.03 ms Preparing 0.04 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.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/ads.php:50 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.62 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.024 MB memoria prima della query: 4.686 MB Righe restituite: 0Query duplicate: #20
SELECT `url`
FROM `i24_employer_url`
WHERE `id_employer` = 11067id 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.07 ms Checking permissions 0.03 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.05 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 13 JDatabase->query() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:53 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.60 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.024 MB memoria prima della query: 4.693 MB Righe restituite: 0Query duplicate: #19
SELECT `url`
FROM `i24_employer_url`
WHERE `id_employer` = 11067id 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.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.05 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.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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:54 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.53 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.028 MB memoria prima della query: 4.703 MB Righe restituite: 4
SELECT ads.titolo AS "nome_annuncio", ads.id as "id_ads", ads.validato ,ads.active, e.id_employer, e.titolo as "employer_name", profiles.name as "name_profile", candidature.date_insert, candidature.interest, candidature.source, candidature.read, EXISTS(SELECT *
FROM i15_apl_customers_dossier ds
WHERE ds.id_customer = 0
AND ds.id_ads = ads.id) as "in_dossier"
FROM i15_apl_customers_candidature candidature JOIN `apl_ads` ads
ON ads.id = candidature.id_ads JOIN `apl_employers` e
ON e.id_employer = ads.id_employer JOIN `CP2011` profiles
ON profiles.id_profile = ads.id_profile
WHERE 1
AND ads.id = 34291
AND candidature.source <> 3
AND ads.id_manifestazione = 1
ORDER BY candidature.date_insert DESCid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY ads const PRIMARY,id_profile,id_employer,id_manifestazione,id_employer_2,id PRIMARY 4 const 1 1 PRIMARY e const PRIMARY PRIMARY 4 const 1 1 PRIMARY profiles const PRIMARY PRIMARY 4 const 1 1 PRIMARY candidature ref id_ads id_ads 4 const 4 Using where; Using filesort 2 SUBQUERY ds ref ads_dossier,customer_dossier ads_dossier 5 const 1 Using where Status Duration Starting 0.19 ms Checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.12 ms Optimizing 0.06 ms Statistics 0.20 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.11 ms Executing 0.01 ms Sending data 0.06 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.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/IoLavoro/IoLavoroTools.php:534 13 IoLavoroTools::getCustomerCandidature() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:69 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.92 ms Dopo l'ultima query: 0.34 ms Memoria query: 0.029 MB memoria prima della query: 4.718 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 = 11067
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.14 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.02 ms Init 0.08 ms Optimizing 0.06 ms Statistics 0.15 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/ads.php:724 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.93 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.029 MB memoria prima della query: 4.726 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 = 11067
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.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.02 ms Init 0.08 ms Optimizing 0.06 ms Statistics 0.15 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/ads.php:735 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.70 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.047 MB memoria prima della query: 4.735 MB Righe restituite: 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:57" >= 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 = 34291id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 const PRIMARY,id_employer,id_manifestazione,id_employer_2,id PRIMARY 4 const 1 1 SIMPLE e const PRIMARY PRIMARY 4 const 1 1 SIMPLE CP2011 const PRIMARY PRIMARY 4 const 1 1 SIMPLE sez ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE contratto eq_ref PRIMARY PRIMARY 4 const 1 1 SIMPLE es ref PRIMARY,id_subgroup PRIMARY 4 const 4 Using index 1 SIMPLE s eq_ref PRIMARY PRIMARY 4 iolavoro_prod.es.id_subgroup 1 Using where 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.03 ms Table lock 0.01 ms Init 0.16 ms Optimizing 0.08 ms Statistics 0.29 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.07 ms Executing 0.01 ms Sending data 0.24 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.05 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/components/com_iolavoro/classes/IoLavoro/IoLavoroTools.php:440 14 IoLavoroTools::getAnnuncioById() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1615 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.67 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.026 MB memoria prima della query: 4.759 MB Righe restituite: 1
SELECT *
FROM apl_comuni
WHERE id = '4078'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE apl_comuni 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.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.03 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/components/com_iolavoro/classes/LavIntTools.php:518 14 LavIntTools::getComuneById() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1727 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.63 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.026 MB memoria prima della query: 4.767 MB Righe restituite: 1
SELECT *
FROM apl_province
WHERE id = '4'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE apl_province 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.04 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.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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/components/com_iolavoro/classes/LavIntTools.php:603 14 LavIntTools::getProvinciaById() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1729 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.64 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.025 MB memoria prima della query: 4.775 MB Righe restituite: 1
SELECT `id`, UPPER(nome) as `nome`
FROM `apl_contratto`
WHERE id = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE apl_contratto const PRIMARY PRIMARY 4 const 1 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 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/components/com_iolavoro/classes/LavIntTools.php:198 14 LavIntTools::getContratti() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1760 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.64 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.026 MB memoria prima della query: 4.784 MB Righe restituite: 6
SELECT id, nome
FROM apl_esperienze_richiesteid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE apl_esperienze_richieste 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.03 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.02 ms Preparing 0.02 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.03 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/components/com_iolavoro/classes/LavIntTools.php:216 14 LavIntTools::getEsperienze() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1766 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.66 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.025 MB memoria prima della query: 4.794 MB Righe restituite: 1
SELECT id, UPPER(nome) as nome
FROM apl_mod_lavoro
WHERE id = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE apl_mod_lavoro const PRIMARY PRIMARY 4 const 1 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 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/components/com_iolavoro/classes/LavIntTools.php:251 14 LavIntTools::getModalitaLavoro() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1784 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.72 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.027 MB memoria prima della query: 4.803 MB Righe restituite: 0
SELECT *
FROM apl_ads_language
WHERE id_ads = '34291'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE apl_ads_language ref ads_nome,id_ads ads_nome 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.04 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.03 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/components/com_iolavoro/classes/LavIntTools.php:231 14 LavIntTools::getLingueByIdAnnuncio() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1826 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.14 ms Memoria query: 0.027 MB memoria prima della query: 4.810 MB Righe restituite: 1
SELECT *
FROM apl_ads_competenze
WHERE id_annuncio = '34291'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE apl_ads_competenze const id_annuncio id_annuncio 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.04 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.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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/components/com_iolavoro/classes/LavIntTools.php:507 14 LavIntTools::getCompInfoByIdAnnuncio() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1877 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.72 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.026 MB memoria prima della query: 4.819 MB Righe restituite: 1
SELECT *
FROM apl_ads_patente
WHERE id_ad = '34291'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE apl_ads_patente ref id_annuncio,annuncio_fk_idx id_annuncio 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.10 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/components/com_iolavoro/classes/LavIntTools.php:543 14 LavIntTools::getPatentiByIdAnnuncio() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1949 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.77 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.027 MB memoria prima della query: 4.834 MB Righe restituite: 0
SELECT t2.id, t2.nome as nome, t2.norm as norm, t1.obbl
FROM apl_ads_patentini t1 JOIN apl_patentini t2
ON t1.id_patentino = t2.id
WHERE t1.id_ads = '34291'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref id_ads,id_patentino id_ads 4 const 1 1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 iolavoro_prod.t1.id_patentino 1 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.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 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.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/components/com_iolavoro/classes/LavIntTools.php:566 14 LavIntTools::getPatentiniByIdAnnuncio() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1979 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.14 ms Memoria query: 0.026 MB memoria prima della query: 4.843 MB Righe restituite: 0
SELECT t2.id, t2.nome as nome, t2.ddl as ddl, t1.obbl
FROM apl_ads_statuslavorativi t1 JOIN `apl_status_lavorativo` t2
ON t1.id_status_lav = t2.id
WHERE t1.id_ads = '34291'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref id_ads_index,fk1_ads_statuslav_idx id_ads_index 4 const 1 1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 iolavoro_prod.t1.id_status_lav 1 Using where 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.03 ms Statistics 0.11 ms Preparing 0.05 ms Executing 0.01 ms Sending data 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.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/components/com_iolavoro/classes/LavIntTools.php:579 14 LavIntTools::getStatusLavorativiByIdAnnuncio() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1998 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.81 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.026 MB memoria prima della query: 4.851 MB Righe restituite: 0
SELECT t2.id, t2.nome as nome, t2.ddl as ddl, t1.obbl
FROM apl_ads_catprotette t1 JOIN apl_cat_protette t2
ON t1.id_categoria = t2.id
WHERE t1.id_ads = '34291'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref id_ads,id_categoria id_ads 4 const 1 Using index condition 1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 iolavoro_prod.t1.id_categoria 1 Status Duration Starting 0.11 ms Checking permissions 0.02 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.09 ms Preparing 0.06 ms Executing 0.01 ms Sending data 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/components/com_iolavoro/classes/LavIntTools.php:592 14 LavIntTools::getCategorieProtetteByIdAnnuncio() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:1999 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.81 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.036 MB memoria prima della query: 4.861 MB Righe restituite: 1
SELECT *
FROM `apl_employers` AS `a`
WHERE a.id_employer = 11067id 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.09 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/components/com_iolavoro/classes/APLObject.php:72 14 APLObject->__construct() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:2045 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.17 ms Memoria query: 0.030 MB memoria prima della query: 4.870 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 = 11067
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 4 1 SIMPLE s eq_ref PRIMARY PRIMARY 4 iolavoro_prod.es.id_subgroup 1 Using where Status Duration Starting 0.16 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.02 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/components/com_iolavoro/classes/employer/APLEmployer.php:163 14 APLEmployer->getSimpleParticipationDetails() JROOT/components/com_iolavoro/classes/IoLavoro15Tools.php:2046 13 Iolavoro15Tools::getHTMLAds() JROOT/components/com_iolavoro/views/public/tmpl/ads.php:759 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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.23 ms Memoria query: 0.030 MB memoria prima della query: 4.849 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 = 11067
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 4 1 SIMPLE s eq_ref PRIMARY PRIMARY 4 iolavoro_prod.es.id_subgroup 1 Using where Status Duration Starting 0.12 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.07 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.05 ms Executing 0.01 ms Sending data 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 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/ads.php:845 12 include JROOT/components/com_iolavoro/views/public/tmpl/ads.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
28 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
4 × 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 × SELECT *
FROM `apl_employers` AS `a`3 × 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:57" >= 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)2 × SELECT `session_id`
FROM `i15_session`2 × SELECT `sala`
FROM `apl_emp_sale`2 × SELECT `url`
FROM `i24_employer_url`1 × SELECT *
FROM apl_province1 × SELECT t2.id, t2.nome as nome, t2.ddl as ddl, t1.obbl
FROM apl_ads_statuslavorativi t1 JOIN `apl_status_lavorativo` t2
ON t1.id_status_lav = t2.id1 × SELECT t2.id, t2.nome as nome, t2.norm as norm, t1.obbl
FROM apl_ads_patentini t1 JOIN apl_patentini t2
ON t1.id_patentino = t2.id1 × SELECT *
FROM apl_ads_patente1 × SELECT *
FROM apl_ads_competenze1 × SELECT *
FROM apl_ads_language1 × SELECT id, UPPER(nome) as nome
FROM apl_mod_lavoro1 × SELECT id, nome
FROM apl_esperienze_richiest1 × SELECT `id`, UPPER(nome) as `nome`
FROM `apl_contratto`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 *
FROM apl_comuni1 × 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 id, rules
FROM `i15_viewlevels1 × SELECT ads.titolo AS "nome_annuncio", ads.id as "id_ads", ads.validato ,ads.active, e.id_employer, e.titolo as "employer_name", profiles.name as "name_profile", candidature.date_insert, candidature.interest, candidature.source, candidature.read, EXISTS(SELECT *
FROM i15_apl_customers_dossier ds1 × 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 (26)) 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 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 id_employer
FROM apl_ads1 × SELECT *
FROM `apl_manifestazione` AS `a`1 × SELECT b.id
FROM i15_usergroups AS a
LEFT JOIN i15_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT t2.id, t2.nome as nome, t2.ddl as ddl, t1.obbl
FROM apl_ads_catprotette t1 JOIN apl_cat_protette t2
ON t1.id_categoria = t2.id
ALTRE tabelle:
1 × INSERT INTO `i15_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6a7136666f303672737232616c376c666f6a757630706f377667', 1, 1674961041, 0, '', 01 × UPDATE `i15_extensions`
SET `params` = '{\"mediaversion\":\"50c951d3951e80f41441b2201a898fda\"}'