Iepirkuma priekšmets: PIKC „Rīgas Valsts tehnikums” telpu remonts Ūnijas ielā 31A, Rīgā
Iepirkuma identifikācija Nr.: RVT 2018/20
Iesniegšanas termiņš: 10/01/2019 Laiks: 10:00
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit.
Nolikums: skatīt šeit.
Pielikums: skatīt šeit Nr. 1. un skatīt šeit Nr. 2.
Jautājumi un atbildes:skatīt šeit.
Informatīvais paziņojums par noslēgto līgumu IUB:skatīt šet.
Iepirkuma priekšmets: PIKC „Rīgas Valsts tehnikums” telpu remonts Ūnijas ielā 31A, Rīgā
Iepirkuma identifikācija Nr.: RVT 2018/19
Iesniegšanas termiņš: 02/01/2019 Laiks: 10:00
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit
Nolikums: skatīt šeit Nr.1. un skatīt šeit Nr. 2.
Iepirkums pārtraukts: skatīt šeit
Iepirkuma priekšmets: PIKC „Rīgas Valsts tehnikums” mācību korpusa ēkas Kr.Valdemāra ielā 1C, Rīgā, atjaunošanas tehniskās dokumentācijas izstrāde un autoruzraudzība
Iepirkuma identifikācija Nr.: RVT 2018/18
Iesniegšanas termiņš: 02/01/2019 Laiks: 10:00
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit
Nolikums: skatīt šeit.
Informatīvais paziņojums par noslēgto līgumu IUB:
Identifikācijas Nr.: RVT 2018/17
Iepirkuma priekšmets: Energoefektivitātes paaugstināšanas pasākumu īstenošana dienesta viesnīcas ēkai Zeļļu ielā 8, Limbažos un mācību korpusa ēkai Zeļļu ielā 9, Limbažos, Limbažu novadā
Nolikums: skatīt šeit.
Iesniegšanas termiņš: 07/11/2018 Laiks: 11:00
Informatīvais paziņojums IUB:skatīt šeit.
Finanšu piedāvājuma forma (darbu apjomi):skatīt šet.
Būvprojekts: skatīt šeit.
Atbildes uz jautājumiem/Skaidrojošā informācija: skatīt šeit Nr. 1. un skatīt šeit Nr. 2., un skatīt šeit Nr. 3. un skatīt šeit Nr. 4.
Precizēts nolikums un precizēta finanšu piedāvājuma forma: skatīt šeit Nr.1. un skatīt šeit Nr. 2.
Noslēgtais paziņojums:skatīt šeit.
Informatīvais paziņojums par noslēgto līgumu IUB: skatīt šet.
Līgums: skatīt šeit.
Iepirkuma priekšmets:Lietota mikroautobusa iegāde
Iepirkuma identifikācija Nr.:RVT 2018/16
Iepirkuma identifikācija Nr.:RVT 2018/16
Iesniegšanas termiņš: 08/10/2018 Laiks: 10:00
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit
Nolikums: skatīt šeit.
Informatīvais paziņojums par noslēgto līgumu IUB: skatīt šeit.
Līgums:skatīt šeit.
Iepirkuma priekšmets: PIKC „Rīgas Valsts tehnikums” mācību korpusa ēkas, Noliktavas ielā 2, Rīgā, atjaunošanas tehniskās dokumentācijas izstrāde un autoruzraudzība
Iepirkuma identifikācija Nr.: RVT 2018/14
Iepirkuma identifikācija Nr.: RVT 2018/14
Iesniegšanas termiņš: 11/09/2018 Laiks: 11:00
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit
Nolikums: skatīt šeit.
Informatīvais paziņojums par noslēgto līgumu IUB: skatīt šeit.
Informatīvais paziņojums par noslēgto līgumu IUB: skatīt šeit.
Līgums: skatīt šeit.
Iepirkuma priekšmets:Kokskaidu granulu piegāde 2018/2019.gada apkures sezonai
Iepirkuma identifikācija Nr.:RVT 2018/15
Iepirkuma identifikācija Nr.:RVT 2018/15
Iesniegšanas termiņš:10/09/2018 Laiks: 11:00
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit
Nolikums:skatīt šeit.
Informatīvais paziņojums par noslēgto līgumu IUB: skatīt šeit.
Līgums: skatīt šeit.
Iepirkuma priekšmets: Zāģmateriālu piegāde PIKC “Rīgas Valsts tehnikums” mācību procesa nodrošināšanai
Iepirkuma identifikācija Nr.: RVT 2018/13
Iepirkuma identifikācija Nr.: RVT 2018/13
Iesniegšanas termiņš: 27/08/2018 Laiks: 10:00
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit
Paziņojums par plānoto līgumu 9.panta kārtībā IUB: skatīt šeit
Nolikums: skatīt šeit
Informatīvais paziņojums par noslēgto līgumu IUB: skatīt šeit.
Līgums: skatīt šeit.
Informatīvais paziņojums par noslēgto līgumu IUB: skatīt šeit.
Līgums: skatīt šeit.
Seko mums
![]()
![]()
![]()
![]()
Joomla! kļūdu konsole
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1743726094,
"last": 1743726094,
"now": 1743726094
}
},
"registry": {
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly9vbGQucnZ0Lmx2LzIwMTgtZ2FkYS1pbmZvcm1hdGl2aWUtcGF6aW5vanVtaS1wYXItaWVwaXJrdW1pZW0%2F"
}
},
"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": [
"1"
],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"autoreadmoreDefaultParams": {
"limittype": "0",
"leadingMax": "750",
"introMax": "500",
"Ignore_Existing_Read_More": "0",
"Strip_Formatting": "0",
"Enabled_Front_Page": "1",
"add_trimming_dots": "0",
"trimming_dots": "...",
"categories_switch": "0",
"categories": "",
"articles_switch": "0",
"debug": "0",
"Thumbnails": "0",
"Thumbnails_Class": "",
"Strip_Image_Formatting": "0",
"Force_Image_Handle": "0",
"csscode": ".margin-h-8 {margin:8px;}"
}
}
}
Time
Memory
Time: 0.76 ms / 0.76 ms Memory: 0.072 MB / 0.40 MB Application: afterLoad
Time: 14.87 ms / 15.62 ms Memory: 2.931 MB / 3.34 MB Application: afterInitialise
Time: 0.45 ms / 16.07 ms Memory: 0.064 MB / 3.40 MB Application: afterRoute
Time: 1.50 ms / 17.58 ms Memory: 0.067 MB / 3.47 MB Application: beforeRenderComponent com_content
Time: 57.47 ms / 75.05 ms Memory: 1.522 MB / 4.99 MB Application: afterRenderComponent com_content
Time: 0.50 ms / 75.54 ms Memory: 0.005 MB / 4.99 MB Application: afterDispatch
Time: 2.41 ms / 77.95 ms Memory: 0.060 MB / 5.05 MB Application: beforeRenderModule mod_menu (Footer menu)
Time: 6.59 ms / 84.54 ms Memory: 0.146 MB / 5.20 MB Application: afterRenderModule mod_menu (Footer menu)
Time: 0.08 ms / 84.63 ms Memory: 0.000 MB / 5.19 MB Application: beforeRenderModule mod_banners (Pieaugušo izglītības centrs)
Time: 2.45 ms / 87.08 ms Memory: 0.060 MB / 5.25 MB Application: afterRenderModule mod_banners (Pieaugušo izglītības centrs)
Time: 0.04 ms / 87.12 ms Memory: 0.000 MB / 5.25 MB Application: beforeRenderModule mod_banners (Programma "Latvijas skolas soma")
Time: 1.18 ms / 88.29 ms Memory: 0.040 MB / 5.29 MB Application: afterRenderModule mod_banners (Programma "Latvijas skolas soma")
Time: 0.04 ms / 88.33 ms Memory: 0.000 MB / 5.28 MB Application: beforeRenderModule mod_banners (RVT 100 gadi)
Time: 1.13 ms / 89.45 ms Memory: 0.037 MB / 5.32 MB Application: afterRenderModule mod_banners (RVT 100 gadi)
Time: 0.03 ms / 89.49 ms Memory: 0.000 MB / 5.32 MB Application: beforeRenderModule mod_banners (Sociālie tīkli)
Time: 1.83 ms / 91.32 ms Memory: 0.046 MB / 5.36 MB Application: afterRenderModule mod_banners (Sociālie tīkli)
Time: 0.05 ms / 91.37 ms Memory: 0.000 MB / 5.36 MB Application: beforeRenderModule mod_menu (Izvēlne)
Time: 0.21 ms / 91.58 ms Memory: 0.017 MB / 5.38 MB Application: afterRenderModule mod_menu (Izvēlne)
Time: 0.03 ms / 91.61 ms Memory: 0.000 MB / 5.36 MB Application: beforeRenderModule mod_menu (Informatīvie paziņojumi par iepirkumiem)
Time: 0.94 ms / 92.56 ms Memory: 0.019 MB / 5.38 MB Application: afterRenderModule mod_menu (Informatīvie paziņojumi par iepirkumiem)
Time: 0.03 ms / 92.59 ms Memory: 0.000 MB / 5.38 MB Application: beforeRenderModule mod_menu (Sludinājumi)
Time: 1.21 ms / 93.80 ms Memory: 0.022 MB / 5.40 MB Application: afterRenderModule mod_menu (Sludinājumi)
Time: 0.03 ms / 93.83 ms Memory: 0.000 MB / 5.40 MB Application: beforeRenderModule mod_menu (Nodaļas )
Time: 0.21 ms / 94.04 ms Memory: 0.016 MB / 5.41 MB Application: afterRenderModule mod_menu (Nodaļas )
Time: 0.04 ms / 94.08 ms Memory: 0.000 MB / 5.40 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.38 ms / 94.46 ms Memory: 0.009 MB / 5.41 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.05 ms / 94.50 ms Memory: 0.000 MB / 5.41 MB Application: beforeRenderModule mod_menu (Latvian menu)
Time: 0.80 ms / 95.31 ms Memory: 0.017 MB / 5.42 MB Application: afterRenderModule mod_menu (Latvian menu)
Time: 0.03 ms / 95.34 ms Memory: 0.000 MB / 5.41 MB Application: beforeRenderModule mod_menu (Russian menu modulis)
Time: 0.13 ms / 95.46 ms Memory: 0.004 MB / 5.41 MB Application: afterRenderModule mod_menu (Russian menu modulis)
Time: 0.04 ms / 95.51 ms Memory: 0.000 MB / 5.41 MB Application: beforeRenderModule mod_search (Main search)
Time: 0.50 ms / 96.00 ms Memory: 0.015 MB / 5.43 MB Application: afterRenderModule mod_search (Main search)
Time: 0.05 ms / 96.05 ms Memory: 0.000 MB / 5.43 MB Application: beforeRenderModule mod_languages (Choose your language)
Time: 1.45 ms / 97.50 ms Memory: 0.042 MB / 5.47 MB Application: afterRenderModule mod_languages (Choose your language)
Time: 0.05 ms / 97.55 ms Memory: 0.000 MB / 5.47 MB Application: beforeRenderModule mod_menu (Link menu right top modulis)
Time: 0.43 ms / 97.98 ms Memory: 0.009 MB / 5.47 MB Application: afterRenderModule mod_menu (Link menu right top modulis)
Time: 2.90 ms / 100.88 ms Memory: 0.156 MB / 5.63 MB Application: afterRender
Database queries total: 42.49 ms
6.77 MB (7,098,864 Bytes)
Veikti 62 vaicājumi 42.49 ms
- Query Time: 0.18 ms Query memory: 0.029 MB Memory before query: 0.662 MB Rows returned: 1
SELECT `data`
FROM `rvt_session`
WHERE `session_id` = 't616qfiqn526fddpcjpm1ivs15'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_session const PRIMARY PRIMARY 766 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:44 12 JSessionStorageDatabase->read() Same as call in the line below. 11 session_start() JROOT/libraries/joomla/session/handler/native.php:258 10 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:49 9 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:81 8 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:636 7 JSession->_start() JROOT/libraries/joomla/session/session.php:596 6 JSession->start() JROOT/libraries/cms/application/cms.php:748 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:47 - Query Time: 0.33 ms After last query: 0.44 ms Query memory: 0.038 MB Memory before query: 0.791 MB Rows returned: 42
SELECT extension_id AS id, element AS "option", params, enabled
FROM rvt_extensions
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_extensions ref extension extension 82 const 42 Using index condition Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.12 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 8 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/cache/controller/callback.php:157 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:448 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:120 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:584 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.56 ms After last query: 0.28 ms Query memory: 0.035 MB Memory before query: 0.839 MB Rows returned: 92
SELECT folder AS type, element AS name, params
FROM rvt_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 254 Using where; Using filesort Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.33 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 6 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:310 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.21 ms After last query: 0.36 ms Query memory: 0.028 MB Memory before query: 0.923 MB Rows returned: 2
SELECT *
FROM rvt_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Using filesort Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 8 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:164 7 JLanguageHelper::getLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:61 6 PlgSystemLanguageFilter->__construct() JROOT/libraries/cms/plugin/helper.php:255 5 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 4 JPluginHelper::importPlugin() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.22 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 0.936 MB Rows returned: 3
SELECT element
FROM rvt_extensions
WHERE type = 'language'
AND client_id = 0
AND enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_extensions ref extension extension 82 const 6 Using index condition; Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 8 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/language/multilang.php:90 7 JLanguageMultilang::getSiteLangs() JROOT/plugins/system/languagefilter/languagefilter.php:72 6 PlgSystemLanguageFilter->__construct() JROOT/libraries/cms/plugin/helper.php:255 5 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 4 JPluginHelper::importPlugin() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.42 ms After last query: 2.76 ms Query memory: 0.342 MB Memory before query: 1.286 MB Rows returned: 240
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 rvt_menu AS m
LEFT JOIN rvt_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 ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 332 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 old_rvt_lv.m.component_id 1 Using where Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 1.16 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 19 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:86 18 JMenuSite->load() JROOT/libraries/cms/menu/menu.php:74 17 JMenu->__construct() JROOT/libraries/cms/menu/site.php:57 16 JMenuSite->__construct() JROOT/libraries/cms/menu/menu.php:133 15 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:435 14 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 13 JApplicationSite->getMenu() JROOT/libraries/cms/router/site.php:57 12 JRouterSite->__construct() JROOT/libraries/cms/router/router.php:196 11 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:531 10 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:407 9 JApplicationSite::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:99 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.24 ms After last query: 6.54 ms Query memory: 0.026 MB Memory before query: 3.417 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM rvt_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1653 12 JDatabaseDriver->loadObject() JROOT/libraries/joomla/cache/controller/callback.php:157 11 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156 10 JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47 9 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:90 8 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:991 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.18 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 3.410 MB
UPDATE `rvt_extensions`
SET `params` = '{\"mediaversion\":\"efbbc1eb9ff89bb355675bfe74af6267\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `rvt_extensions` SET `params` = '{\"mediaversion\":\"efbbc1eb9ff89bb355675bfe74af6267\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.04 ms Updating 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:119 9 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 8 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:991 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.29 ms After last query: 0.36 ms Query memory: 0.023 MB Memory before query: 3.460 MB Rows returned: 4
SELECT id, home, template, s.params
FROM rvt_template_styles as s
LEFT JOIN rvt_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 ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 old_rvt_lv.s.template,const 1 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 5 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:484 4 JApplicationSite->getTemplate() JROOT/libraries/cms/application/site.php:165 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.91 ms After last query: 1.09 ms Query memory: 0.030 MB Memory before query: 3.620 MB Rows returned: 4
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.189')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 3649 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 1.46 ms Creating sort index 0.07 ms Removing tmp table 0.10 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 18 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 17 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 16 JAccess::check() JROOT/libraries/joomla/user/user.php:393 15 JUser->authorise() JROOT/components/com_content/models/category.php:137 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:439 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:114 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.22 ms After last query: 0.16 ms Query memory: 0.030 MB Memory before query: 3.639 MB Rows returned: 1
SELECT b.id
FROM rvt_usergroups AS a
LEFT JOIN rvt_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
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 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 18 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:354 17 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:111 16 JAccess::check() JROOT/libraries/joomla/user/user.php:393 15 JUser->authorise() JROOT/components/com_content/models/category.php:137 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:439 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:114 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 2.30 ms After last query: 0.28 ms Query memory: 0.041 MB Memory before query: 3.661 MB Rows returned: 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,COUNT(i.`id`) AS numitems
FROM rvt_categories as c
LEFT JOIN (SELECT cat.id as id
FROM rvt_categories AS cat JOIN rvt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN rvt_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('lv-LV','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN `rvt_content` AS i
ON i.`catid` = c.id
AND i.state = 1
AND (i.language = '*' OR i.language = 'lv-LV')
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND badcats.id is null
AND s.id=189
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 259 Using where 1 PRIMARY i ref idx_state,idx_catid,idx_language idx_catid 4 old_rvt_lv.c.id 7 Using where 1 PRIMARY <derived2> ref key0 key0 5 old_rvt_lv.c.id 11 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 11 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 259 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.13 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.10 ms Optimizing 0.03 ms Optimizing 0.01 ms Statistics 0.05 ms Statistics 0.16 ms Preparing 0.02 ms Creating tmp table 0.01 ms Sorting result 0.01 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms Executing 0.00 ms Sending data 0.38 ms Creating sort index 0.03 ms Removing tmp table 0.00 ms Creating sort index 0.92 ms Creating sort index 0.03 ms Removing tmp table 0.10 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 17 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 16 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 15 JCategories->get() JROOT/components/com_content/models/category.php:346 14 ContentModelCategory->getCategory() JROOT/components/com_content/models/category.php:223 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.60 ms After last query: 0.31 ms Query memory: 0.032 MB Memory before query: 3.704 MB Rows returned: 2
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 26 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.23 ms Creating sort index 0.04 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 21 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 20 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 19 JAccess::check() JROOT/libraries/joomla/user/user.php:393 18 JUser->authorise() JROOT/components/com_content/models/articles.php:449 17 ContentModelArticles->getListQuery() JROOT/libraries/legacy/model/list.php:129 16 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:181 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:537 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.42 ms After last query: 0.14 ms Query memory: 0.100 MB Memory before query: 3.722 MB Rows returned: 8
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM rvt_content AS a
LEFT JOIN rvt_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN rvt_categories AS c
ON c.id = a.catid
LEFT JOIN rvt_users AS ua
ON ua.id = a.created_by
LEFT JOIN rvt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN rvt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rvt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM rvt_categories AS cat JOIN rvt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 189
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-04 00:21:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-04 00:21:34')
AND a.language in ('lv-LV','*')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 0, 8id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 1 PRIMARY a ref idx_access,idx_catid,idx_language idx_catid 4 const 20 Using where; Using filesort 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.created_by 1 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.modified_by 1 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.id 1 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 2 LATERAL DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 11 Using index condition; Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.16 ms checking permissions 0.00 ms Opening tables 0.04 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.09 ms Optimizing 0.04 ms Optimizing 0.01 ms Statistics 0.04 ms Statistics 0.12 ms Preparing 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.11 ms Executing 0.00 ms Sending data 0.11 ms Executing 0.00 ms Sending data 0.08 ms Executing 0.00 ms Sending data 0.06 ms Executing 0.00 ms Sending data 0.07 ms Executing 0.00 ms Sending data 0.06 ms Executing 0.00 ms Sending data 0.08 ms Executing 0.00 ms Sending data 0.06 ms Executing 0.00 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 17 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 16 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:537 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.53 ms After last query: 0.63 ms Query memory: 0.029 MB Memory before query: 3.999 MB Rows returned: 1
SELECT COUNT(*)
FROM rvt_content AS a
LEFT JOIN rvt_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN rvt_categories AS c
ON c.id = a.catid
LEFT JOIN rvt_users AS ua
ON ua.id = a.created_by
LEFT JOIN rvt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN rvt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rvt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM rvt_categories AS cat JOIN rvt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 189
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-04 00:21:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-04 00:21:34')
AND a.language in ('lv-LV','*')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 1 PRIMARY a ref idx_access,idx_catid,idx_language idx_catid 4 const 20 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 2 LATERAL DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 11 Using index condition; Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.09 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.06 ms Optimizing 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Statistics 0.11 ms Preparing 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.06 ms Executing 0.00 ms Sending data 0.05 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.06 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.05 ms Executing 0.00 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:235 14 JModelList->getPagination() JROOT/components/com_content/models/category.php:257 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.30 ms After last query: 0.23 ms Query memory: 0.037 MB Memory before query: 4.009 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `rvt_contentitem_tag_map` AS m
INNER JOIN `rvt_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 189
AND `t`.`published` = 1
AND t.access IN (1,1)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 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 old_rvt_lv.m.tag_id 1 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 13 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:426 12 JHelperTags->getItemTags() JROOT/libraries/legacy/view/category.php:217 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.19 ms After last query: 2.45 ms Query memory: 0.028 MB Memory before query: 4.261 MB Rows returned: 1
SELECT created_by, catid
FROM rvt_content
WHERE id = 2927id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:811 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:180 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.77 ms After last query: 0.15 ms Query memory: 0.031 MB Memory before query: 4.275 MB Rows returned: 5
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.2927')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 3649 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 1.35 ms Creating sort index 0.06 ms Removing tmp table 0.08 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 20 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 19 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 18 JAccess::check() JROOT/libraries/joomla/user/user.php:393 17 JUser->authorise() JROOT/administrator/components/com_attachments/permissions.php:125 16 AttachmentsPermissions::userMayEditArticle() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:886 15 AttachmentsPlugin_Com_Content->userMayAddAttachment() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.70 ms After last query: 0.32 ms Query memory: 0.032 MB Memory before query: 4.310 MB Rows returned: 2
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_attachments')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 3649 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 1.33 ms Creating sort index 0.04 ms Removing tmp table 0.08 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 21 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 20 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 19 JAccess::check() JROOT/libraries/joomla/user/user.php:393 18 JUser->authorise() JROOT/components/com_attachments/models/attachments.php:405 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.52 ms After last query: 0.19 ms Query memory: 0.037 MB Memory before query: 4.346 MB Rows returned: 8
SHOW FULL COLUMNS
FROM `rvt_assets`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `rvt_assets`Status Duration Starting 0.02 ms checking permissions 0.00 ms closing tables 0.00 ms Opening tables 0.17 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.05 ms closing tables 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.11 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 25 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 24 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 23 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 22 JTable->__construct() JROOT/libraries/joomla/table/asset.php:61 21 JTableAsset->__construct() JROOT/libraries/joomla/table/table.php:305 20 JTable::getInstance() JROOT/libraries/joomla/access/access.php:100 19 JAccess::check() JROOT/libraries/joomla/user/user.php:393 18 JUser->authorise() JROOT/components/com_attachments/models/attachments.php:429 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.20 ms After last query: 0.17 ms Query memory: 0.031 MB Memory before query: 4.379 MB Rows returned: 1
SELECT id
FROM rvt_assets
WHERE parent_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_assets ref idx_parent_id idx_parent_id 4 const 1 Using index Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 21 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/table/nested.php:1216 20 JTableNested->getRootId() JROOT/libraries/joomla/access/access.php:101 19 JAccess::check() JROOT/libraries/joomla/user/user.php:393 18 JUser->authorise() JROOT/components/com_attachments/models/attachments.php:429 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.55 ms After last query: 0.09 ms Query memory: 0.031 MB Memory before query: 4.396 MB Rows returned: 1
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 1 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.18 ms Creating sort index 0.04 ms Removing tmp table 0.08 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 21 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 20 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 19 JAccess::check() JROOT/libraries/joomla/user/user.php:393 18 JUser->authorise() JROOT/components/com_attachments/models/attachments.php:429 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.35 ms After last query: 0.10 ms Query memory: 0.036 MB Memory before query: 4.411 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM rvt_attachments AS a
LEFT JOIN rvt_users AS u
ON u.id = a.created_by
WHERE a.parent_id=2927
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY created DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.created_by 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.07 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 18 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.17 ms After last query: 0.80 ms Query memory: 0.028 MB Memory before query: 4.426 MB Rows returned: 1
SELECT created_by, catid
FROM rvt_content
WHERE id = 2911id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:811 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:180 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.74 ms After last query: 0.12 ms Query memory: 0.031 MB Memory before query: 4.439 MB Rows returned: 5
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.2911')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 3649 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 1.35 ms Creating sort index 0.05 ms Removing tmp table 0.08 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 20 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 19 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 18 JAccess::check() JROOT/libraries/joomla/user/user.php:393 17 JUser->authorise() JROOT/administrator/components/com_attachments/permissions.php:125 16 AttachmentsPermissions::userMayEditArticle() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:886 15 AttachmentsPlugin_Com_Content->userMayAddAttachment() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.32 ms After last query: 0.31 ms Query memory: 0.036 MB Memory before query: 4.462 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM rvt_attachments AS a
LEFT JOIN rvt_users AS u
ON u.id = a.created_by
WHERE a.parent_id=2911
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY created DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.created_by 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.69 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 18 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.20 ms After last query: 0.63 ms Query memory: 0.028 MB Memory before query: 4.469 MB Rows returned: 1
SELECT created_by, catid
FROM rvt_content
WHERE id = 2910id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:811 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:180 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.76 ms After last query: 0.13 ms Query memory: 0.031 MB Memory before query: 4.482 MB Rows returned: 5
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.2910')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 3649 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 1.35 ms Creating sort index 0.05 ms Removing tmp table 0.08 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 20 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 19 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 18 JAccess::check() JROOT/libraries/joomla/user/user.php:393 17 JUser->authorise() JROOT/administrator/components/com_attachments/permissions.php:125 16 AttachmentsPermissions::userMayEditArticle() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:886 15 AttachmentsPlugin_Com_Content->userMayAddAttachment() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.32 ms After last query: 0.29 ms Query memory: 0.036 MB Memory before query: 4.504 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM rvt_attachments AS a
LEFT JOIN rvt_users AS u
ON u.id = a.created_by
WHERE a.parent_id=2910
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY created DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.created_by 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 1.04 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 18 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.21 ms After last query: 1.58 ms Query memory: 0.028 MB Memory before query: 4.516 MB Rows returned: 1
SELECT created_by, catid
FROM rvt_content
WHERE id = 2825id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:811 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:180 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.77 ms After last query: 0.12 ms Query memory: 0.031 MB Memory before query: 4.528 MB Rows returned: 5
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.2825')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 3649 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 1.35 ms Creating sort index 0.05 ms Removing tmp table 0.08 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 20 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 19 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 18 JAccess::check() JROOT/libraries/joomla/user/user.php:393 17 JUser->authorise() JROOT/administrator/components/com_attachments/permissions.php:125 16 AttachmentsPermissions::userMayEditArticle() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:886 15 AttachmentsPlugin_Com_Content->userMayAddAttachment() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.33 ms After last query: 0.28 ms Query memory: 0.036 MB Memory before query: 4.550 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM rvt_attachments AS a
LEFT JOIN rvt_users AS u
ON u.id = a.created_by
WHERE a.parent_id=2825
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY created DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.created_by 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.07 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 18 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.17 ms After last query: 0.59 ms Query memory: 0.029 MB Memory before query: 4.565 MB Rows returned: 1
SELECT created_by, catid
FROM rvt_content
WHERE id = 2813id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:811 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:180 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.92 ms After last query: 0.13 ms Query memory: 0.031 MB Memory before query: 4.578 MB Rows returned: 5
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.2813')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 3649 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 1.53 ms Creating sort index 0.05 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 20 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 19 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 18 JAccess::check() JROOT/libraries/joomla/user/user.php:393 17 JUser->authorise() JROOT/administrator/components/com_attachments/permissions.php:125 16 AttachmentsPermissions::userMayEditArticle() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:886 15 AttachmentsPlugin_Com_Content->userMayAddAttachment() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.30 ms After last query: 0.27 ms Query memory: 0.036 MB Memory before query: 4.601 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM rvt_attachments AS a
LEFT JOIN rvt_users AS u
ON u.id = a.created_by
WHERE a.parent_id=2813
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY created DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.created_by 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.07 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 18 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.17 ms After last query: 0.56 ms Query memory: 0.028 MB Memory before query: 4.609 MB Rows returned: 1
SELECT created_by, catid
FROM rvt_content
WHERE id = 2769id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:811 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:180 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.78 ms After last query: 0.12 ms Query memory: 0.031 MB Memory before query: 4.621 MB Rows returned: 5
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.2769')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 3649 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 1.37 ms Creating sort index 0.05 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 20 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 19 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 18 JAccess::check() JROOT/libraries/joomla/user/user.php:393 17 JUser->authorise() JROOT/administrator/components/com_attachments/permissions.php:125 16 AttachmentsPermissions::userMayEditArticle() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:886 15 AttachmentsPlugin_Com_Content->userMayAddAttachment() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.32 ms After last query: 0.30 ms Query memory: 0.036 MB Memory before query: 4.644 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM rvt_attachments AS a
LEFT JOIN rvt_users AS u
ON u.id = a.created_by
WHERE a.parent_id=2769
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY created DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.created_by 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 18 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.18 ms After last query: 0.60 ms Query memory: 0.028 MB Memory before query: 4.652 MB Rows returned: 1
SELECT created_by, catid
FROM rvt_content
WHERE id = 2765id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:811 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:180 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 2.17 ms After last query: 0.14 ms Query memory: 0.031 MB Memory before query: 4.664 MB Rows returned: 5
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.2765')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 3649 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 1.59 ms Creating sort index 0.22 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 20 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 19 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 18 JAccess::check() JROOT/libraries/joomla/user/user.php:393 17 JUser->authorise() JROOT/administrator/components/com_attachments/permissions.php:125 16 AttachmentsPermissions::userMayEditArticle() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:886 15 AttachmentsPlugin_Com_Content->userMayAddAttachment() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.37 ms After last query: 0.32 ms Query memory: 0.036 MB Memory before query: 4.686 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM rvt_attachments AS a
LEFT JOIN rvt_users AS u
ON u.id = a.created_by
WHERE a.parent_id=2765
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY created DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.created_by 1 Status Duration Starting 0.09 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.07 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 18 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.16 ms After last query: 0.56 ms Query memory: 0.028 MB Memory before query: 4.694 MB Rows returned: 1
SELECT created_by, catid
FROM rvt_content
WHERE id = 2760id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rvt_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:811 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:180 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.96 ms After last query: 0.12 ms Query memory: 0.031 MB Memory before query: 4.706 MB Rows returned: 5
SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.2760')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 3649 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 1.58 ms Creating sort index 0.05 ms Removing tmp table 0.08 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 20 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 19 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 18 JAccess::check() JROOT/libraries/joomla/user/user.php:393 17 JUser->authorise() JROOT/administrator/components/com_attachments/permissions.php:125 16 AttachmentsPermissions::userMayEditArticle() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:886 15 AttachmentsPlugin_Com_Content->userMayAddAttachment() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.31 ms After last query: 0.29 ms Query memory: 0.036 MB Memory before query: 4.729 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM rvt_attachments AS a
LEFT JOIN rvt_users AS u
ON u.id = a.created_by
WHERE a.parent_id=2760
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY created DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.created_by 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 18 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:196 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:106 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 2.10 ms After last query: 1.35 ms Query memory: 0.045 MB Memory before query: 4.877 MB Rows returned: 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 rvt_categories as c
LEFT JOIN (SELECT cat.id as id
FROM rvt_categories AS cat JOIN rvt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN rvt_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('lv-LV','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND badcats.id is null
AND s.id=189
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 259 Using where 1 PRIMARY <derived2> ref key0 key0 5 old_rvt_lv.c.id 11 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 11 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 259 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.12 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.09 ms Optimizing 0.03 ms Optimizing 0.01 ms Statistics 0.05 ms Statistics 0.12 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Executing 0.00 ms Sending data 0.40 ms Creating sort index 0.14 ms Removing tmp table 0.01 ms Creating sort index 0.67 ms Creating sort index 0.06 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 23 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 22 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 21 JCategories->get() JROOT/components/com_content/helpers/route.php:44 20 ContentHelperRoute::getArticleRoute() JROOT/layouts/joomla/content/blog_style_default_item_title.php:24 19 include JROOT/layouts/joomla/content/blog_style_default_item_title.php JROOT/libraries/cms/layout/file.php:121 18 JLayoutFile->render() JROOT/libraries/cms/layout/helper.php:72 17 JLayoutHelper::render() JROOT/components/com_content/views/category/tmpl/blog_item.php:23 16 include JROOT/components/com_content/views/category/tmpl/blog_item.php JROOT/libraries/legacy/view/legacy.php:670 15 JViewLegacy->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:86 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/legacy/view/legacy.php:670 13 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209 12 JViewLegacy->display() JROOT/libraries/legacy/view/category.php:233 11 JViewCategory->display() JROOT/components/com_content/views/category/view.html.php:258 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 1.66 ms After last query: 10.14 ms Query memory: 0.148 MB Memory before query: 5.017 MB Rows returned: 228
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM rvt_modules AS m
LEFT JOIN rvt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN rvt_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 <= '2025-04-04 00:21:34')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-04 00:21:34')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 377 OR mm.menuid <= 0)
AND m.language IN ('lv-LV','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds,idx_language NO INDEX KEY COULD BE USED NULL NULL 136 Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 old_rvt_lv.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 old_rvt_lv.m.id 13 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 1.25 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/module/helper.php:409 11 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:352 10 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 9 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:501 8 JDocumentHtml->countModules() JROOT/templates/rvt6/index.php:60 7 require JROOT/templates/rvt6/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.19 ms After last query: 7.56 ms Query memory: 0.037 MB Memory before query: 5.217 MB Rows returned: 0
SELECT *
FROM rvt_banners
WHERE '2025-04-04 00:21:34' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id 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 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Executing 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.31 ms After last query: 0.26 ms Query memory: 0.029 MB Memory before query: 5.242 MB Rows returned: 1
SELECT COUNT(*)
FROM rvt_banners as a
LEFT JOIN rvt_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (186)
AND a.language in ('lv-LV','*')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_banner_catid,idx_language idx_banner_catid 4 const 1 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:324 14 JModelList->getStart() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.35 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 5.249 MB Rows returned: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rvt_banners as a
LEFT JOIN rvt_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (186)
AND a.language in ('lv-LV','*')
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_banner_catid,idx_language idx_banner_catid 4 const 1 Using where; Using filesort 1 SIMPLE cl eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.cid 1 Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.70 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 5.265 MB
UPDATE rvt_banners
SET impmade = (impmade + 1)
WHERE id = 14EXPLAIN not possible on query: UPDATE rvt_banners SET impmade = (impmade + 1) WHERE id = 14Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.03 ms Updating 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.52 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.19 ms After last query: 0.30 ms Query memory: 0.037 MB Memory before query: 5.267 MB Rows returned: 0
SELECT *
FROM rvt_banners
WHERE '2025-04-04 00:21:34' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id 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 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Executing 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.28 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 5.287 MB Rows returned: 1
SELECT COUNT(*)
FROM rvt_banners as a
LEFT JOIN rvt_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (3)
AND a.language in ('lv-LV','*')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_banner_catid,idx_language idx_banner_catid 4 const 1 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:324 14 JModelList->getStart() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.32 ms After last query: 0.05 ms Query memory: 0.030 MB Memory before query: 5.294 MB Rows returned: 0
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rvt_banners as a
LEFT JOIN rvt_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (3)
AND a.language in ('lv-LV','*')
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_banner_catid,idx_language idx_banner_catid 4 const 1 Using where; Using filesort 1 SIMPLE cl eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.cid 1 Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.17 ms After last query: 0.21 ms Query memory: 0.037 MB Memory before query: 5.302 MB Rows returned: 0
SELECT *
FROM rvt_banners
WHERE '2025-04-04 00:21:34' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id 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 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Executing 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.27 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 5.322 MB Rows returned: 1
SELECT COUNT(*)
FROM rvt_banners as a
LEFT JOIN rvt_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (245)
AND a.language in ('lv-LV','*')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_banner_catid,idx_language idx_banner_catid 4 const 1 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:324 14 JModelList->getStart() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.32 ms After last query: 0.05 ms Query memory: 0.030 MB Memory before query: 5.328 MB Rows returned: 0
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rvt_banners as a
LEFT JOIN rvt_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (245)
AND a.language in ('lv-LV','*')
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_banner_catid,idx_language idx_banner_catid 4 const 1 Using where; Using filesort 1 SIMPLE cl eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.cid 1 Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.17 ms After last query: 0.19 ms Query memory: 0.037 MB Memory before query: 5.335 MB Rows returned: 0
SELECT *
FROM rvt_banners
WHERE '2025-04-04 00:21:34' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id 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 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Executing 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.27 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 5.355 MB Rows returned: 1
SELECT COUNT(*)
FROM rvt_banners as a
LEFT JOIN rvt_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (160)
AND a.language in ('lv-LV','*')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_banner_catid,idx_language idx_banner_catid 4 const 1 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:324 14 JModelList->getStart() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.35 ms After last query: 0.05 ms Query memory: 0.030 MB Memory before query: 5.362 MB Rows returned: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rvt_banners as a
LEFT JOIN rvt_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (160)
AND a.language in ('lv-LV','*')
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_banner_catid,idx_language idx_banner_catid 4 const 1 Using where; Using filesort 1 SIMPLE cl eq_ref PRIMARY PRIMARY 4 old_rvt_lv.a.cid 1 Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.55 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 5.378 MB
UPDATE rvt_banners
SET impmade = (impmade + 1)
WHERE id = 9EXPLAIN not possible on query: UPDATE rvt_banners SET impmade = (impmade + 1) WHERE id = 9Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.03 ms Updating 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.36 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.25 ms After last query: 5.24 ms Query memory: 0.027 MB Memory before query: 5.458 MB Rows returned: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `rvt_menu` AS `c`
INNER JOIN `rvt_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `rvt_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `rvt_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 377id 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.04 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 14 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/language/associations.php:101 13 JLanguageAssociations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:319 12 MenusHelper::getAssociations() JROOT/modules/mod_languages/helper.php:62 11 ModLanguagesHelper::getList() JROOT/modules/mod_languages/mod_languages.php:18 10 include JROOT/modules/mod_languages/mod_languages.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50 - Query Time: 0.24 ms After last query: 0.20 ms Query memory: 0.029 MB Memory before query: 5.471 MB Rows returned: 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `rvt_categories` AS `c`
INNER JOIN `rvt_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_categories.item'
INNER JOIN `rvt_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `rvt_categories` AS `c2`
ON a2.id = c2.`id`
AND c2.extension = 'com_content'
WHERE c.id = 189
AND c.extension = 'com_content'id 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.04 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/language/associations.php:101 15 JLanguageAssociations::getAssociations() JROOT/administrator/components/com_categories/helpers/categories.php:102 14 CategoriesHelper::getAssociations() JROOT/administrator/components/com_categories/helpers/association.php:43 13 CategoryHelperAssociation::getCategoryAssociations() JROOT/components/com_content/helpers/association.php:61 12 ContentHelperAssociation::getAssociations() JROOT/modules/mod_languages/helper.php:71 11 ModLanguagesHelper::getList() JROOT/modules/mod_languages/mod_languages.php:18 10 include JROOT/modules/mod_languages/mod_languages.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:50
26 dažādie vaicājumi, sakārtoti pēc skaita.
SELECT vaicājumi:
12 × SELECT b.rules
FROM rvt_assets AS a
LEFT JOIN rvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt8 × SELECT created_by, catid
FROM rvt_content8 × SELECT a.*, u.name as creator_name
FROM rvt_attachments AS a
LEFT JOIN rvt_users AS u
ON u.id = a.created_by4 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rvt_banners as a
LEFT JOIN rvt_banner_clients AS cl
ON cl.id = a.cid4 × SELECT COUNT(*)
FROM rvt_banners as a
LEFT JOIN rvt_banner_clients AS cl
ON cl.id = a.cid4 × SELECT *
FROM rvt_banners2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM rvt_extensions1 × SELECT `data`
FROM `rvt_session`1 × SELECT `c2`.`language`,`c2`.`id`
FROM `rvt_menu` AS `c`
INNER JOIN `rvt_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `rvt_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `rvt_menu` AS `c2`
ON a2.id = c2.`id`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM rvt_modules AS m
LEFT JOIN rvt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN rvt_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × 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 rvt_categories as c
LEFT JOIN (SELECT cat.id as id
FROM rvt_categories AS cat JOIN rvt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT id
FROM rvt_assets1 × SELECT COUNT(*)
FROM rvt_content AS a
LEFT JOIN rvt_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN rvt_categories AS c
ON c.id = a.catid
LEFT JOIN rvt_users AS ua
ON ua.id = a.created_by
LEFT JOIN rvt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN rvt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rvt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM rvt_categories AS cat JOIN rvt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT `m`.`tag_id`,`t`.*
FROM `rvt_contentitem_tag_map` AS m
INNER JOIN `rvt_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM rvt_content AS a
LEFT JOIN rvt_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN rvt_categories AS c
ON c.id = a.catid
LEFT JOIN rvt_users AS ua
ON ua.id = a.created_by
LEFT JOIN rvt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN rvt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rvt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM rvt_categories AS cat JOIN rvt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × 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,COUNT(i.`id`) AS numitems
FROM rvt_categories as c
LEFT JOIN (SELECT cat.id as id
FROM rvt_categories AS cat JOIN rvt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT b.id
FROM rvt_usergroups AS a
LEFT JOIN rvt_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, home, template, s.params
FROM rvt_template_styles as s
LEFT JOIN rvt_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 rvt_menu AS m
LEFT JOIN rvt_extensions AS e
ON m.component_id = e.extension_id1 × SELECT element
FROM rvt_extensions1 × SELECT *
FROM rvt_languages1 × SELECT folder AS type, element AS name, params
FROM rvt_extensions1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `rvt_categories` AS `c`
INNER JOIN `rvt_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_categories.item'
INNER JOIN `rvt_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `rvt_categories` AS `c2`
ON a2.id = c2.`id`
AND c2.extension = 'com_content'
Citi vaicājumi:
2 × UPDATE rvt_banners
SET impmade = (impmade + 1)1 × UPDATE `rvt_extensions`
SET `params` = '{\"mediaversion\":\"efbbc1eb9ff89bb355675bfe74af6267\"}'1 × SHOW FULL COLUMNS
FROM `rvt_assets