Planinsko društvo Črna vsako leto na 1.1. organizira Novoletni pohod na Peco: od Matjaža do Matjaža.
V mesecu decembru pa pod okriljem MDO Koroških PD poteka tradicionalni pohod "Čez goro k očetu".
Zimski nočni pohodi
- Podrobnosti
DONACIJE POPLAVE 2023
Denarno pomoč za prizadete v občini Črna na Koroškem lahko nakažete na:
TRR: SI56 0110 0010 0007 227
SKLIC: 00 2393
NAMEN NAKAZILA: POPLAVE 2023
BIC BANKE: BSLJSI2X
KODA NAMENA: CHAR.
Hvala vam za vašo pomoč.
- Nahajate se:
-
Domov
-
Športne prireditve
- Zimski nočni pohodi
Turistična pisarna
TIC OBČINA ČRNA NA KOROŠKEM
Center 101, 2393 Črna na Koroškem
Telefon: 02 870 48 20
Mobilni telefon: 041 743 442
Email: tic@crna.si
info@parkkm.si
Delovni čas TIC
Od ponedeljka do petka: 9.00 - 16.00 ure
V soboto: 9.00 - 12.00 ure
Črna na Koroškem (575 m n. v.) je slikovito, prijetno naselje v trikraki dolini ob reki Meži na desno in Javorskim potokom na levo, na križišču dveh cest – na levo proti Šoštanju in desno proti Koprivni. Ko prideš v Črno po dolini Meže, ti nekje v notranjosti nekaj reče:
"TU BI PA RAD BIL DOMA."
Naša spletna stran uporablja piškotke.
Za boljšo uporabniško izkušnjo in spremljanje statistike obiska uporabljamo piškotke. Če se z namestitvijo piškotkov strinjate, kliknite »Shrani« in nemoteno nadaljujte z uporabo spletne rešitve, lahko pa si ogledate nastavitve piškotkov.
Za boljšo uporabniško izkušnjo in spremljanje statistike obiska uporabljamo piškotke. Če se z namestitvijo piškotkov strinjate, kliknite »Shrani« in nemoteno nadaljujte z uporabo spletne rešitve, lahko pa si ogledate nastavitve piškotkov.
Nastavitve piškotkov
Piškotki za delovanje strani
Analitični piškotki
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1695960066,
"last": 1695960066,
"now": 1695960066
},
"token": "3yhCoaLAbf78Aq4Z8mtmmDXl01NJCZoI"
},
"registry": {
"plg_system_eprivacy_non_eu": false
},
"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
}
}
}
Time
Memory
Time: 8.69 ms / 8.69 ms Memory: 0.891 MB / 1.12 MB Application: afterLoad
Time: 36.87 ms / 45.56 ms Memory: 1.885 MB / 3.00 MB Application: afterInitialise
Time: 20.41 ms / 65.97 ms Memory: 1.522 MB / 4.52 MB Application: afterRoute
Time: 1.72 ms / 67.69 ms Memory: 0.054 MB / 4.58 MB Application: beforeRenderComponent com_content
Time: 2.29 ms / 69.99 ms Memory: 0.172 MB / 4.75 MB Application: Before Access::preloadComponents (all components)
Time: 2.46 ms / 72.45 ms Memory: 0.099 MB / 4.85 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 72.49 ms Memory: -0.005 MB / 4.84 MB Application: Before Access::preloadPermissions (com_content)
Time: 18.40 ms / 90.88 ms Memory: 7.171 MB / 12.01 MB Application: After Access::preloadPermissions (com_content)
Time: 1.62 ms / 92.50 ms Memory: -0.436 MB / 11.58 MB Application: Before Access::getAssetRules (id:1955 name:com_content.article.1628)
Time: 0.43 ms / 92.93 ms Memory: 0.020 MB / 11.60 MB Application: After Access::getAssetRules (id:1955 name:com_content.article.1628)
Time: 22.33 ms / 115.26 ms Memory: 0.878 MB / 12.48 MB Application: afterRenderComponent com_content
Time: 0.68 ms / 115.93 ms Memory: 0.023 MB / 12.50 MB Application: afterDispatch
Time: 16.85 ms / 132.78 ms Memory: 0.452 MB / 12.95 MB Application: beforeRenderModule mod_menu (Navigacija)
Time: 5.48 ms / 138.27 ms Memory: 0.466 MB / 13.42 MB Application: afterRenderModule mod_menu (Navigacija)
Time: 0.92 ms / 139.19 ms Memory: -0.005 MB / 13.41 MB Application: beforeRenderModule mod_custom (Turistična pisarna)
Time: 1.04 ms / 140.23 ms Memory: 0.012 MB / 13.42 MB Application: afterRenderModule mod_custom (Turistična pisarna)
Time: 0.12 ms / 140.35 ms Memory: -0.004 MB / 13.42 MB Application: beforeRenderModule mod_custom (Delovni čas TIC)
Time: 0.19 ms / 140.54 ms Memory: 0.007 MB / 13.43 MB Application: afterRenderModule mod_custom (Delovni čas TIC)
Time: 0.19 ms / 140.73 ms Memory: -0.002 MB / 13.42 MB Application: beforeRenderModule mod_menu (Footer Menu)
Time: 1.66 ms / 142.39 ms Memory: 0.013 MB / 13.44 MB Application: afterRenderModule mod_menu (Footer Menu)
Time: 0.19 ms / 142.58 ms Memory: -0.010 MB / 13.43 MB Application: beforeRenderModule mod_custom (Footer Text)
Time: 2.82 ms / 145.40 ms Memory: 0.042 MB / 13.47 MB Application: afterRenderModule mod_custom (Footer Text)
Time: 0.18 ms / 145.58 ms Memory: -0.003 MB / 13.47 MB Application: beforeRenderModule mod_custom (Social)
Time: 0.19 ms / 145.77 ms Memory: 0.007 MB / 13.47 MB Application: afterRenderModule mod_custom (Social)
Time: 4.98 ms / 150.74 ms Memory: 0.741 MB / 14.21 MB Application: beforeRenderModule mod_custom (Copyrights)
Time: 0.46 ms / 151.21 ms Memory: 0.007 MB / 14.22 MB Application: afterRenderModule mod_custom (Copyrights)
Time: 0.08 ms / 151.28 ms Memory: -0.002 MB / 14.22 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.60 ms / 152.88 ms Memory: 0.023 MB / 14.24 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.07 ms / 152.96 ms Memory: -0.009 MB / 14.23 MB Application: beforeRenderModule mod_custom (POPLAVE 2023)
Time: 0.22 ms / 153.18 ms Memory: 0.007 MB / 14.24 MB Application: afterRenderModule mod_custom (POPLAVE 2023)
Time: 0.03 ms / 153.21 ms Memory: -0.003 MB / 14.24 MB Application: beforeRenderModule mod_custom (HeaderBgSpacer)
Time: 0.36 ms / 153.56 ms Memory: 0.007 MB / 14.25 MB Application: afterRenderModule mod_custom (HeaderBgSpacer)
Time: 0.08 ms / 153.64 ms Memory: 0.003 MB / 14.25 MB Application: beforeRenderModule mod_djmegamenu (DJ-MegaMenu)
Time: 7.58 ms / 161.22 ms Memory: 0.428 MB / 14.68 MB Application: beforeRenderModule mod_menu (Dokumenti in obrazci)
Time: 2.49 ms / 163.71 ms Memory: 0.046 MB / 14.72 MB Application: afterRenderModule mod_menu (Dokumenti in obrazci)
Time: 0.16 ms / 163.87 ms Memory: -0.006 MB / 14.72 MB Application: beforeRenderModule mod_menu (Spletne kamere)
Time: 0.98 ms / 164.85 ms Memory: 0.015 MB / 14.73 MB Application: afterRenderModule mod_menu (Spletne kamere)
Time: 0.37 ms / 165.22 ms Memory: -0.004 MB / 14.73 MB Application: beforeRenderModule mod_custom (Gradovi Kralja Matjaža)
Time: 0.30 ms / 165.52 ms Memory: 0.007 MB / 14.73 MB Application: afterRenderModule mod_custom (Gradovi Kralja Matjaža)
Time: 0.15 ms / 165.67 ms Memory: -0.001 MB / 14.73 MB Application: beforeRenderModule mod_menu (Turistične znamenitosti)
Time: 2.61 ms / 168.28 ms Memory: 0.044 MB / 14.78 MB Application: afterRenderModule mod_menu (Turistične znamenitosti)
Time: 0.18 ms / 168.46 ms Memory: -0.006 MB / 14.77 MB Application: beforeRenderModule mod_menu (Turistična ponudba)
Time: 5.30 ms / 173.76 ms Memory: 0.088 MB / 14.86 MB Application: afterRenderModule mod_menu (Turistična ponudba)
Time: 20.45 ms / 194.21 ms Memory: 0.067 MB / 14.93 MB Application: afterRenderModule mod_djmegamenu (DJ-MegaMenu)
Time: 0.19 ms / 194.41 ms Memory: -0.002 MB / 14.92 MB Application: beforeRenderModule mod_custom (Language)
Time: 0.36 ms / 194.76 ms Memory: 0.007 MB / 14.93 MB Application: afterRenderModule mod_custom (Language)
Time: 0.16 ms / 194.92 ms Memory: -0.004 MB / 14.93 MB Application: beforeRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button)
Time: 0.27 ms / 195.19 ms Memory: 0.011 MB / 14.94 MB Application: afterRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button)
Time: 0.14 ms / 195.33 ms Memory: -0.004 MB / 14.94 MB Application: beforeRenderModule mod_custom (TopBar Holder)
Time: 0.45 ms / 195.78 ms Memory: 0.053 MB / 14.99 MB Application: beforeRenderModule mod_search (Iskalnik)
Time: 2.69 ms / 198.46 ms Memory: 0.029 MB / 15.02 MB Application: afterRenderModule mod_search (Iskalnik)
Time: 0.12 ms / 198.58 ms Memory: -0.008 MB / 15.01 MB Application: beforeRenderModule mod_custom (Socialna omrežja top (copy))
Time: 0.29 ms / 198.87 ms Memory: 0.007 MB / 15.02 MB Application: afterRenderModule mod_custom (Socialna omrežja top (copy))
Time: 0.09 ms / 198.96 ms Memory: -0.002 MB / 15.01 MB Application: beforeRenderModule mod_custom (Vizitka)
Time: 0.31 ms / 199.27 ms Memory: 0.007 MB / 15.02 MB Application: afterRenderModule mod_custom (Vizitka)
Time: 2.64 ms / 201.92 ms Memory: 0.688 MB / 15.71 MB Application: afterRenderModule mod_custom (TopBar Holder)
Time: 142.85 ms / 344.77 ms Memory: 0.191 MB / 15.90 MB Application: afterRender
Database queries total: 40.73 ms
16.52 MB (17,321,648 Bytes)
28 poizvedb zabeleženo 40.73 ms
- Query Time: 1.02 ms Query memory: 0.021 MB Memory before query: 1.683 MB Rows returned: 0
SELECT `data`
FROM `v76cn_session`
WHERE `session_id` = X'747633383063346c676f6575333169363832327039676b736b35'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_session const PRIMARY PRIMARY 575 const 1 Status Duration Starting 0.20 ms Checking permissions 0.05 ms Opening tables 0.29 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.50 ms After last query: 0.66 ms Query memory: 0.013 MB Memory before query: 1.741 MB Rows returned: 0
SELECT `session_id`
FROM `v76cn_session`
WHERE `session_id` = X'747633383063346c676f6575333169363832327039676b736b35'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_session const PRIMARY PRIMARY 575 const 1 Using index Status Duration Starting 0.06 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.04 ms Updating status 0.02 ms Reset for next command 0.02 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:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.55 ms After last query: 0.13 ms Query memory: 0.010 MB Memory before query: 1.758 MB
INSERT INTO `v76cn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'747633383063346c676f6575333169363832327039676b736b35', 1, 1695960066, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `v76cn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'747633383063346c676f6575333169363832327039676b736b35', 1, 1695960066, 0, '', 0)Status Duration Starting 0.07 ms Checking permissions 0.03 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init for update 0.02 ms Update 0.09 ms Waiting for query cache lock 0.02 ms Update 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.03 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.02 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:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 1.22 ms After last query: 0.91 ms Query memory: 0.027 MB Memory before query: 1.832 MB Rows returned: 46
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `v76cn_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_extensions ref extension extension 62 const 37 Using index condition; Using where Status Duration Starting 0.07 ms Checking permissions 0.02 ms Opening tables 0.31 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.18 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.19 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.81 ms After last query: 1.19 ms Query memory: 0.015 MB Memory before query: 1.947 MB Rows returned: 5
SELECT id, rules
FROM `v76cn_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Status Duration Starting 0.06 ms Checking permissions 0.02 ms Opening tables 0.27 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.02 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:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.88 ms After last query: 0.16 ms Query memory: 0.015 MB Memory before query: 1.972 MB Rows returned: 2
SELECT b.id
FROM v76cn_usergroups AS a
LEFT JOIN v76cn_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.07 ms Checking permissions 0.02 ms Opening tables 0.26 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.02 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:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.39 ms After last query: 0.31 ms Query memory: 0.020 MB Memory before query: 2.011 MB Rows returned: 114
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM v76cn_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_extensions ref extension extension 62 const 164 Using index condition; Using where; Using filesort Status Duration Starting 0.10 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.67 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.05 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.74 ms After last query: 4.54 ms Query memory: 0.024 MB Memory before query: 2.541 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `v76cn_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using index condition Status Duration Starting 0.14 ms Checking permissions 0.04 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.11 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 16 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 13 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 12 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 11 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 10 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 9 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 8 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/eprivacy/eprivacy.php:60 7 plgSystemePrivacy->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.68 ms After last query: 0.21 ms Query memory: 0.016 MB Memory before query: 2.547 MB
UPDATE `v76cn_extensions`
SET `params` = '{\"mediaversion\":\"bc0ef5bbde126af3043c093d34efd5e7\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `v76cn_extensions` SET `params` = '{\"mediaversion\":\"bc0ef5bbde126af3043c093d34efd5e7\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.07 ms Checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.03 ms Init for update 0.09 ms Updating 0.08 ms End of update loop 0.02 ms Waiting for query cache lock 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Waiting for query cache lock 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 12 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 11 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 10 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 9 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 8 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/eprivacy/eprivacy.php:60 7 plgSystemePrivacy->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.37 ms After last query: 14.91 ms Query memory: 0.046 MB Memory before query: 3.081 MB Rows returned: 117
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM v76cn_menu AS m
LEFT JOIN v76cn_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 2 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 eojhg01_crna2v15.m.component_id 1 Using where Status Duration Starting 0.17 ms Checking permissions 0.03 ms Opening tables 0.40 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.16 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 1.06 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.28 ms After last query: 4.88 ms Query memory: 0.030 MB Memory before query: 4.072 MB Rows returned: 7
SELECT id, home, template, s.params
FROM v76cn_template_styles as s
LEFT JOIN v76cn_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 7 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 eojhg01_crna2v15.s.template,const 1 Using index condition; Using where Status Duration Starting 0.11 ms Checking permissions 0.02 ms Opening tables 0.49 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.10 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 21 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 20 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 19 Joomla\CMS\HTML\HTMLHelper::script() Same as call in the line below. 18 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 17 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 16 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/behavior.php:63 15 JHtmlBehavior::framework() JROOT/libraries/cms/html/behavior.php:60 14 JHtmlBehavior::framework() JROOT/libraries/cms/html/behavior.php:369 13 JHtmlBehavior::modal() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 11 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 10 Joomla\CMS\HTML\HTMLHelper::_() JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:29 9 require_once JROOT/administrator/components/com_djclassifieds/lib/djcategory.php JROOT/administrator/components/com_djclassifieds/lib/djseo.php:31 8 require_once JROOT/administrator/components/com_djclassifieds/lib/djseo.php JROOT/components/com_djclassifieds/router.php:31 7 require_once JROOT/components/com_djclassifieds/router.php JROOT/libraries/src/Router/SiteRouter.php:779 6 Joomla\CMS\Router\SiteRouter->getComponentRouter() JROOT/libraries/src/Router/SiteRouter.php:131 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.22 ms After last query: 4.79 ms Query memory: 0.025 MB Memory before query: 4.275 MB Rows returned: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `v76cn_categories` AS `s`
INNER JOIN `v76cn_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 1628
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.15 ms Checking permissions 0.03 ms Opening tables 0.54 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 12 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 11 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:350 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.91 ms After last query: 0.12 ms Query memory: 0.017 MB Memory before query: 4.291 MB Rows returned: 1
SELECT `alias`,`catid`
FROM `v76cn_content`
WHERE `id` = 1628id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 ms Checking permissions 0.02 ms Opening tables 0.27 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/components/com_content/helpers/legacyrouter.php:366 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.11 ms After last query: 4.21 ms Query memory: 0.014 MB Memory before query: 4.544 MB Rows returned: 1
SELECT *
FROM v76cn_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_languages system NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.14 ms Checking permissions 0.03 ms Opening tables 0.39 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.07 ms After last query: 2.89 ms Query memory: 0.026 MB Memory before query: 4.757 MB Rows returned: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `v76cn_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djclassifieds','com_djmediatools','com_djtabs','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_jmwascanner','com_joomlaupdate','com_juform','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mijopolls','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshow','com_slideshowfx','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_assets range idx_asset_name idx_asset_name 152 NULL 47 Using index condition Status Duration Starting 0.12 ms Checking permissions 0.03 ms Opening tables 0.34 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.07 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.97 ms End of update loop 0.05 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.95 ms After last query: 0.27 ms Query memory: 0.195 MB Memory before query: 4.844 MB Rows returned: 4466
SELECT `id`,`name`,`rules`,`parent_id`
FROM `v76cn_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 4678 Using where Status Duration Starting 0.09 ms Checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.17 ms Preparing 0.03 ms Executing 0.02 ms Sending data 3.00 ms End of update loop 0.06 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.41 ms After last query: 16.89 ms Query memory: 0.026 MB Memory before query: 11.620 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `v76cn_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `v76cn_content`Status Duration Starting 0.19 ms Checking permissions 0.05 ms Closing tables 0.02 ms Opening tables 0.23 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms Checking permissions 0.14 ms Closing tables 0.02 ms Executing 0.02 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Removing tmp table 0.09 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.80 ms After last query: 1.91 ms Query memory: 0.014 MB Memory before query: 11.763 MB
UPDATE v76cn_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1628'EXPLAIN not possible on query: UPDATE v76cn_content SET `hits` = (`hits` + 1) WHERE `id` = '1628'Status Duration Starting 0.12 ms Checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init for update 0.06 ms Updating 0.10 ms End of update loop 0.02 ms Waiting for query cache lock 0.03 ms End of update loop 0.06 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Waiting for query cache lock 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.75 ms After last query: 0.94 ms Query memory: 0.029 MB Memory before query: 11.833 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM v76cn_content AS a
INNER JOIN v76cn_categories AS c
on c.id = a.catid
LEFT JOIN v76cn_users AS u
on u.id = a.created_by
LEFT JOIN v76cn_categories as parent
ON parent.id = c.parent_id
LEFT JOIN v76cn_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 1628
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-29 04:01:06')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-29 04:01:06')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.20 ms Checking permissions 0.03 ms Opening tables 0.60 ms After opening tables 0.05 ms System lock 0.02 ms Table lock 0.02 ms Init 0.07 ms Optimizing 0.05 ms Statistics 0.25 ms Preparing 0.04 ms Unlocking tables 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.03 ms Closing tables 0.02 ms Starting cleanup 0.03 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.09 ms After last query: 1.39 ms Query memory: 0.038 MB Memory before query: 11.925 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `v76cn_categories` AS `s`
INNER JOIN `v76cn_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 98
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 58 Using where; Using filesort Status Duration Starting 0.18 ms Checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.06 ms Optimizing 0.05 ms Statistics 0.16 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.10 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.23 ms After last query: 0.89 ms Query memory: 0.025 MB Memory before query: 11.998 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `v76cn_contentitem_tag_map` AS m
INNER JOIN `v76cn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1628
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 2 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 eojhg01_crna2v15.m.tag_id 1 Using where Status Duration Starting 0.11 ms Checking permissions 0.03 ms Opening tables 0.49 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.22 ms After last query: 3.89 ms Query memory: 0.032 MB Memory before query: 12.299 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM v76cn_fields AS a
LEFT JOIN `v76cn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN v76cn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN v76cn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN v76cn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN v76cn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `v76cn_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (98,0,91))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using join buffer (flat, BNL join) 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 eojhg01_crna2v15.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 eojhg01_crna2v15.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 eojhg01_crna2v15.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 eojhg01_crna2v15.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 eojhg01_crna2v15.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.25 ms Checking permissions 0.06 ms Opening tables 0.58 ms After opening tables 0.05 ms System lock 0.02 ms Table lock 0.02 ms Init 0.07 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.05 ms Creating tmp table 0.09 ms Sorting result 0.13 ms Executing 0.03 ms Sending data 0.26 ms Creating sort index 0.05 ms Removing tmp table 0.06 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.80 ms After last query: 6.95 ms Query memory: 0.016 MB Memory before query: 12.613 MB Rows returned: 9
SELECT id
FROM v76cn_template_styles
ORDER BY idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_template_styles index NULL PRIMARY 4 NULL 9 Using index Status Duration Starting 0.20 ms Checking permissions 0.05 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:275 9 JMFTemplate->setup() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:121 8 JMFTemplate->__construct() JROOT/templates/jm-job-listings/index.php:18 7 require JROOT/templates/jm-job-listings/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.95 ms After last query: 4.08 ms Query memory: 0.028 MB Memory before query: 12.871 MB Rows returned: 33
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM v76cn_modules AS m
LEFT JOIN v76cn_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN v76cn_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-09-29 04:01:06')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-29 04:01:06')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 810 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 54 Using index condition; Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 eojhg01_crna2v15.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 eojhg01_crna2v15.m.id 5 Using where; Using index Status Duration Starting 0.28 ms Checking permissions 0.05 ms Opening tables 0.56 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.05 ms Optimizing 0.05 ms Statistics 0.08 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 1.27 ms End of update loop 0.05 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.08 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:422 11 JMFTemplate->countModules() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:415 10 JMFTemplate->checkModules() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1594 9 JMFTemplate->getAllColumnsClasses() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:174 8 JMFTemplate->__construct() JROOT/templates/jm-job-listings/index.php:18 7 require JROOT/templates/jm-job-listings/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.85 ms After last query: 17.41 ms Query memory: 0.045 MB Memory before query: 13.454 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM v76cn_fields AS a
LEFT JOIN `v76cn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN v76cn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN v76cn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN v76cn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN v76cn_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using join buffer (flat, BNL join) 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 eojhg01_crna2v15.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 eojhg01_crna2v15.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 eojhg01_crna2v15.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 eojhg01_crna2v15.a.group_id 1 Using where Status Duration Starting 0.30 ms Checking permissions 0.06 ms Opening tables 0.09 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.08 ms Optimizing 0.05 ms Statistics 0.11 ms Preparing 0.04 ms Creating tmp table 0.07 ms Sorting result 0.05 ms Executing 0.02 ms Sending data 0.25 ms Creating sort index 0.05 ms Removing tmp table 0.06 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.26 ms Updating status 0.06 ms Reset for next command 0.02 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 29 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 28 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 27 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 26 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 25 PlgSystemFields->onContentPrepare() Same as call in the line below. 24 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 23 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 22 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 21 JHtmlContent::prepare() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 19 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 18 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 17 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:682 14 JMFTemplate->renderModules() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:835 13 JMFTemplate->renderFlexiblock() JROOT/templates/jm-job-listings/tpl/blocks/footer-mod.php:15 12 include JROOT/templates/jm-job-listings/tpl/blocks/footer-mod.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:614 11 JMFTemplate->renderBlock() JROOT/templates/jm-job-listings/tpl/default.php:76 10 include JROOT/templates/jm-job-listings/tpl/default.php JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:614 9 JMFTemplate->renderBlock() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:625 8 JMFTemplate->renderScheme() JROOT/templates/jm-job-listings/index.php:19 7 require JROOT/templates/jm-job-listings/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.88 ms After last query: 29.27 ms Query memory: 0.018 MB Memory before query: 14.843 MB Rows returned: 1
SELECT manifest_cache
FROM v76cn_extensions
WHERE element='mod_djmegamenu'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_extensions ref element_clientid,element_folder_clientid element_clientid 302 const 1 Using index condition Status Duration Starting 0.20 ms Checking permissions 0.06 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/modules/mod_djmegamenu/helpers/helper.php:398 11 modDJMMHelper::getVersion() JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:84 10 include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.76 ms After last query: 29.83 ms Query memory: 0.018 MB Memory before query: 15.857 MB Rows returned: 147
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLESStatus Duration Starting 0.22 ms Checking permissions 0.05 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Filling schema table 0.02 ms Checking permissions 0.73 ms Executing 0.05 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Removing tmp table 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 10 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jmwascannerplugin/jmwascannerplugin.php:65 9 plgSystemjmwascannerplugin->isEnabled() JROOT/plugins/system/jmwascannerplugin/jmwascannerplugin.php:35 8 plgSystemjmwascannerplugin->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.31 ms After last query: 0.38 ms Query memory: 0.015 MB Memory before query: 15.902 MB Rows returned: 1
SELECT *
FROM v76cn_plgwap2_config
WHERE var_name = 'show_protectedby'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v76cn_plgwap2_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 7 Using where Status Duration Starting 0.09 ms Checking permissions 0.02 ms Opening tables 0.34 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 2.31 ms End of update loop 0.06 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jmwascannerplugin/jmwascannerplugin.php:74 9 plgSystemjmwascannerplugin->isEnabled() JROOT/plugins/system/jmwascannerplugin/jmwascannerplugin.php:35 8 plgSystemjmwascannerplugin->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
25 vrst poizvedb zabeleženo, razvrščeno po dogodkih DESC
IZBERI tabele:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `v76cn_assets`2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `v76cn_categories` AS `s`
INNER JOIN `v76cn_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `v76cn_extensions`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM v76cn_content AS a
INNER JOIN v76cn_categories AS c
on c.id = a.catid
LEFT JOIN v76cn_users AS u
on u.id = a.created_by
LEFT JOIN v76cn_categories as parent
ON parent.id = c.parent_id
LEFT JOIN v76cn_content_rating AS v
ON a.id = v.content_id1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM v76cn_fields AS a
LEFT JOIN `v76cn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN v76cn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN v76cn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN v76cn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN v76cn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `v76cn_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `m`.`tag_id`,`t`.*
FROM `v76cn_contentitem_tag_map` AS m
INNER JOIN `v76cn_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM v76cn_modules AS m
LEFT JOIN v76cn_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN v76cn_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM v76cn_plgwap2_config1 × SELECT manifest_cache
FROM v76cn_extensions1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM v76cn_fields AS a
LEFT JOIN `v76cn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN v76cn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN v76cn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN v76cn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN v76cn_fields_groups AS g
ON g.id = a.group_id1 × SELECT id
FROM v76cn_template_styles1 × SELECT `alias`,`catid`
FROM `v76cn_content`1 × SELECT b.id
FROM v76cn_usergroups AS a
LEFT JOIN v76cn_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `v76cn_viewlevels1 × SELECT `session_id`
FROM `v76cn_session`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM v76cn_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM v76cn_menu AS m
LEFT JOIN v76cn_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `data`
FROM `v76cn_session`1 × SELECT id, home, template, s.params
FROM v76cn_template_styles as s
LEFT JOIN v76cn_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM v76cn_languages
OSTALE tabele:
1 × SHOW TABLE
1 × UPDATE v76cn_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `v76cn_content1 × UPDATE `v76cn_extensions`
SET `params` = '{\"mediaversion\":\"bc0ef5bbde126af3043c093d34efd5e7\"}'1 × INSERT INTO `v76cn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'747633383063346c676f6575333169363832327039676b736b35', 1, 1695960066, 0, '', 0