-
22 Februāris 2014 17:32:51
RĪGAS VALSTS TEHNIKUMS PĒC STUNDĀM
Kādu reizi man nācās palikt tehnikumā pēc stundām, un es ieraudzīju citu tehnikuma dzīvi, kura ļoti atšķiras no ikdienas mācību laikā redzētā! Skola palikusi dīvaini klusa, taču tajā klusumā varēja sadzirdēt neparastas skaņas. „Lai notiek burvība!” izskanēja tieši no direktora kabineta. Vienā mirklī visa ēka kļuva gaiša, skanēja skaista melodija, kuru es vēl tagad atceros. Pēkšņi viss, kas stāvēja, sāka kustēties! Uz grīdas guļošie papīra gabali vienā mirklī pazuda. Kafija, kuru netīšām izlēja uz trepēm, it kā iztvaikojās. Un pēc kādām piecām minūtēm visa ēka bija sakopta, zīmējumi uz sienām nodzēsti un grīdas izmazgātas.
Tomēr, kā vien negribētos, tā notiek tikai pasakās! Patiesībā visu, ko mēs atstājam uz grīdas un sienām kabinetos un gaiteņos, saudzīgi katru darba dienas vakaru tīra apkopējas. Es ar visu cieņu pret viņu darbu, gribu izteikt viņām savu pateicību, kā arī audzēkņus pamudināt novērtēt citu cilvēku centību un darbu.
Anatolijs Ovsjaņņikovs S1
Uz Vecrīgas soliņa
Sēž jaunkundze
Un vecmāmiņa.
Pirmā šķirsta žurnālu,
Otrai rokās avīze.
Abas lasa sadaļu:
SLUDINĀJUMI.
Programmēšanas tehnoloģijas
Pēc augstākajiem standartiem.
Jūsu uzņēmumam finansiālas problēmas –
Mūsu speciālistiem ir risinājumi.
Vīram saplīsa jaunais vāģis?
Bez panikas – palīgā steidzas automehāniķis!
Interesē meža nozares politika?
Tikai pie mums: kvalitatīva un tālredzīga!
Tātad, Jūs sapratāt,
Visi kā viens augstākās klases spečuki,
Ražoti tikai pie mums:
Rīgas Valsts tehnikumā.
Tad nu, draugi, saskandināsim glāzes
Mūsu skolas 95. gadadienā!
Sofija Leonova S-3
*************************************************************************************
Cik skaista un pilna smaidiem šī diena
Mūsu mīļā tehnikuma dzimšanas diena
Tehnikuma gaiteņos visi tik smaida
Un ar lielāko prieku ciemiņus gaida
Tu neesi vecs, tu esi varens
Tu neesi viens, tu esi ar mums
Mūsu mīļais Rīgas Valsts tehnikums.
*************************************************************************************
Tu kļuvi man kā otrās mājas
Kā manas mammas pieskāriens
Kā draugs, kurš vienmēr man ir blakus
Un tu man esi tikai viens
Tu kļuvi man kā otrās mājas
Silts ir katrs tav apskāviens
Es, viņš, viņa...nē, IKVIENS
Tavas sirds sitiens
*********************************************************************************
Kristīna Šimanska B3
Kāds ir mūsu tehnikums?
Tāds kā viņa nosaukums:
Rāms, jo stāv te ilgu laiku;
Īpašs, jo katra diena nes ko jaunu;
Gudrs, jo skolotāji visu zin;
Atbildīgs, jo visus svētkus svin;
Sakārtots, jo visam šeit ir termiņš;
Vecs, jo cilvēks nedzīvo, cik viņš;
Aizpildīts, jo audzēkņi tik nāk un nāk;
Liels, jo katru gadu tas aug;
Sens, jo 95 gadus ar mums;
Tuvs, jo uzcelts priekš mums;
Stingrs, jo te nav joki, te nav pasaka;
Tālredzīgs, jo mācībām ir priekšroka;
Elegants, jo te mācās arī meitenes;
Haotisks, jo diena rit bez apstājas;
Nozīmīgs, jo 4 gadus tu te pavadi;
Ikdienišķs, jo katru dienu tu te atnāci;
Kārtīgs, jo katrs sēž savā solā;
Unikāls, jo nav kā cita skola;
Mīļš, jo tas ir mūsu tehnikums;
Svarīgs, jo tāds bija, ir un būs šis tehnikums.
Izceltie burti ir Tehnikuma nosaukums!
Kristīne Sčastnaja B3
Joomla! kļūdu konsole
{
"__default": {
"session": {
"counter": 5,
"timer": {
"start": 1755969973,
"last": 1755969974,
"now": 1755969974
},
"token": "ICrwhtLQIlOQH1CEzP5W6OwgWvn57uP1"
},
"registry": {
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly9vbGQucnZ0Lmx2L3Bhci1tdW1zLWFyaGl2cy8xMTU1LXBpa2MtcnZ0LWF1ZHpla251LXZlbHRpanVtaT9sYXlvdXQ9ZGVmYXVsdCZwcmludD0xJnRtcGw9Y29tcG9uZW50"
}
},
"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;}"
}
}
}
4.85 MB (5,084,576 Bytes)
Veikti 27 vaicājumi 23.26 ms
Query Time: 0.30 ms Query memory: 0.028 MB Memory before query: 0.665 MB Rows returned: 1
SELECT `data`
FROM `rvt_session`
WHERE `session_id` = '2g9oke1km13gr4076lm67ejg66'
| 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.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.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.01 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.01 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.54 ms After last query: 0.65 ms Query memory: 0.039 MB Memory before query: 0.786 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.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.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.21 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.02 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.90 ms After last query: 0.44 ms Query memory: 0.035 MB Memory before query: 0.837 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 ordering
| id | 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.06 ms |
| checking permissions | 0.01 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.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.55 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 | | 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.30 ms After last query: 0.57 ms Query memory: 0.028 MB Memory before query: 0.920 MB Rows returned: 2
SELECT *
FROM rvt_languages
WHERE published=1
ORDER BY ordering ASC
| id | 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.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.02 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.04 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/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.29 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 0.933 MB Rows returned: 3
SELECT element
FROM rvt_extensions
WHERE type = 'language'
AND client_id = 0
AND enabled = 1
| id | 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.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.04 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/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: 2.36 ms After last query: 4.30 ms Query memory: 0.342 MB Memory before query: 1.283 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.lft
| id | 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.07 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.05 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 1.97 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 | | 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.82 ms After last query: 11.94 ms Query memory: 0.036 MB Memory before query: 3.441 MB Rows returned: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM 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=1155
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.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 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.22 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.14 ms |
| Optimizing | 0.04 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Statistics | 0.09 ms |
| Preparing | 0.04 ms |
| Preparing | 0.00 ms |
| Executing | 0.03 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 | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 11 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 10 | JCategories->get() | JROOT/components/com_content/router.php:351 |
| 9 | ContentRouter->parse() | JROOT/libraries/cms/router/site.php:395 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:479 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:234 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:118 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:763 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:50 |
Query Time: 0.23 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 3.446 MB Rows returned: 1
SELECT `alias`,`catid`
FROM `rvt_content`
WHERE `id` = 1155
| id | 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.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.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 | | 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 10 | JDatabaseDriver->loadObject() | JROOT/components/com_content/router.php:367 |
| 9 | ContentRouter->parse() | JROOT/libraries/cms/router/site.php:395 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:479 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:234 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:118 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:763 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:50 |
Query Time: 0.28 ms After last query: 0.29 ms Query memory: 0.027 MB Memory before query: 3.455 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.02 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.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/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.24 ms After last query: 0.21 ms Query memory: 0.007 MB Memory before query: 3.448 MB
UPDATE `rvt_extensions`
SET `params` = '{\"mediaversion\":\"fc75a4983f6b90b354b92642806acee3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `rvt_extensions`
SET `params` = '{\"mediaversion\":\"fc75a4983f6b90b354b92642806acee3\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init for update | 0.06 ms |
| Updating | 0.04 ms |
| End of update loop | 0.01 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.37 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 3.485 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 = 1
| id | 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.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.03 ms |
| Executing | 0.00 ms |
| Sending data | 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.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 | | 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: 0.30 ms After last query: 1.32 ms Query memory: 0.028 MB Memory before query: 3.609 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 = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
| 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.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.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:1541 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:354 |
| 14 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/user/user.php:475 |
| 13 | JUser->getAuthorisedGroups() | JROOT/libraries/joomla/user/user.php:381 |
| 12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:439 |
| 10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 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.24 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 3.621 MB Rows returned: 1
SELECT a.rules
FROM rvt_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.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.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 | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:246 |
| 13 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:384 |
| 12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:439 |
| 10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 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.02 ms After last query: 0.24 ms Query memory: 0.028 MB Memory before query: 3.633 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.lft
| id | 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.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.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.44 ms |
| Creating sort index | 0.08 ms |
| Removing tmp table | 0.14 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 |
| 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:1541 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:246 |
| 14 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:107 |
| 13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:439 |
| 10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 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.83 ms After last query: 0.22 ms Query memory: 0.039 MB Memory before query: 3.649 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `rvt_content`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `rvt_content`
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| closing tables | 0.00 ms |
| Opening tables | 0.24 ms |
| After opening tables | 0.01 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.01 ms |
| checking permissions | 0.16 ms |
| closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.07 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.13 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/libraries/joomla/database/driver/mysqli.php:440 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 13 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 12 | JTable->__construct() | JROOT/libraries/legacy/table/content.php:31 |
| 11 | JTableContent->__construct() | JROOT/libraries/joomla/table/table.php:305 |
| 10 | JTable::getInstance() | JROOT/components/com_content/models/article.php:264 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 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.28 ms After last query: 0.57 ms Query memory: 0.037 MB Memory before query: 3.733 MB Rows returned: 1
SELECT *
FROM rvt_content
WHERE `id` = '1155'
| id | 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.03 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.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 | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1456 |
| 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:728 |
| 10 | JTable->load() | JROOT/components/com_content/models/article.php:265 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 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.12 ms After last query: 0.17 ms Query memory: 0.008 MB Memory before query: 3.752 MB
UPDATE rvt_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1155'
EXPLAIN not possible on query: UPDATE rvt_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1155'
| 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.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.89 ms |
| closing tables | 0.01 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 | | 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/table/table.php:1249 |
| 10 | JTable->hit() | JROOT/components/com_content/models/article.php:266 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 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.94 ms After last query: 0.47 ms Query memory: 0.039 MB Memory before query: 3.778 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM rvt_content AS a
LEFT JOIN rvt_categories AS c
on c.id = a.catid
LEFT JOIN rvt_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.language in ('lv-LV','*')
AND a.id = 1155
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-08-23 17:26:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-08-23 17:26:14')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | a | const | PRIMARY,idx_state,idx_language | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | v | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | const | 0 | |
| 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 | 10 | Using index condition; Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.11 ms |
| Optimizing | 0.04 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Statistics | 0.12 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.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.12 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.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:159 |
| 12 | ContentModelArticle->getItem() | JROOT/libraries/legacy/view/legacy.php:401 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 10 | ContentViewArticle->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.99 ms After last query: 0.58 ms Query memory: 0.038 MB Memory before query: 3.890 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=229
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.lft
| id | 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.17 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.12 ms |
| Optimizing | 0.05 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Statistics | 0.16 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.07 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 ms |
| Executing | 0.00 ms |
| Sending data | 0.77 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 1.02 ms |
| Creating sort index | 0.08 ms |
| Removing tmp table | 0.11 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.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 13 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 12 | JCategories->get() | JROOT/components/com_content/helpers/route.php:44 |
| 11 | ContentHelperRoute::getArticleRoute() | JROOT/components/com_content/views/article/view.html.php:71 |
| 10 | ContentViewArticle->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.36 ms After last query: 0.97 ms Query memory: 0.037 MB Memory before query: 3.929 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.article'
AND `m`.`content_item_id` = 1155
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.05 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.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 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.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/helper/tags.php:426 |
| 11 | JHelperTags->getItemTags() | JROOT/components/com_content/views/article/view.html.php:156 |
| 10 | ContentViewArticle->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: 4.90 ms Query memory: 0.028 MB Memory before query: 4.127 MB Rows returned: 1
SELECT created_by, catid
FROM rvt_content
WHERE id = 1155
| id | 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.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.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 | | 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:296 |
| 13 | plgContentAttachments->onContentBeforeDisplay() | 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/article/view.html.php:167 |
| 10 | ContentViewArticle->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: 3.32 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 4.140 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.1155')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
| id | 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.03 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.06 ms |
| Preparing | 0.01 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 | 2.77 ms |
| Creating sort index | 0.08 ms |
| Removing tmp table | 0.11 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:302 |
| 13 | plgContentAttachments->onContentBeforeDisplay() | 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/article/view.html.php:167 |
| 10 | ContentViewArticle->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: 3.02 ms After last query: 0.45 ms Query memory: 0.032 MB Memory before query: 4.176 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.lft
| id | 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.06 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 | 2.55 ms |
| Creating sort index | 0.05 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.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 | | 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:302 |
| 13 | plgContentAttachments->onContentBeforeDisplay() | 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/article/view.html.php:167 |
| 10 | ContentViewArticle->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.64 ms After last query: 0.30 ms Query memory: 0.037 MB Memory before query: 4.213 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.03 ms |
| checking permissions | 0.00 ms |
| closing tables | 0.00 ms |
| Opening tables | 0.23 ms |
| After opening tables | 0.01 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.07 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.10 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:302 |
| 13 | plgContentAttachments->onContentBeforeDisplay() | 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/article/view.html.php:167 |
| 10 | ContentViewArticle->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.24 ms After last query: 0.14 ms Query memory: 0.031 MB Memory before query: 4.244 MB Rows returned: 1
SELECT id
FROM rvt_assets
WHERE parent_id = 0
| id | 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.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.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:302 |
| 13 | plgContentAttachments->onContentBeforeDisplay() | 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/article/view.html.php:167 |
| 10 | ContentViewArticle->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.66 ms After last query: 0.11 ms Query memory: 0.031 MB Memory before query: 4.260 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.lft
| id | 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.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.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.22 ms |
| Creating sort index | 0.05 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.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 | | 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:302 |
| 13 | plgContentAttachments->onContentBeforeDisplay() | 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/article/view.html.php:167 |
| 10 | ContentViewArticle->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.43 ms After last query: 0.15 ms Query memory: 0.036 MB Memory before query: 4.276 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=1155
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY created DESC
| id | 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.06 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.04 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.02 ms |
| Creating sort index | 0.10 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 | | 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:302 |
| 13 | plgContentAttachments->onContentBeforeDisplay() | 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/article/view.html.php:167 |
| 10 | ContentViewArticle->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 |
22 dažādie vaicājumi, sakārtoti pēc skaita.
SELECT vaicājumi:
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
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
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM rvt_extensions
1 × SELECT `data`
FROM `rvt_session`
1 × SELECT id
FROM rvt_assets
1 × SELECT created_by, catid
FROM rvt_content
1 × 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.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM rvt_content AS a
LEFT JOIN rvt_categories AS c
on c.id = a.catid
LEFT JOIN rvt_users AS u
on u.id = a.created_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
1 × SELECT *
FROM rvt_content
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
1 × SELECT a.rules
FROM rvt_assets AS a
1 × 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
1 × SELECT `alias`,`catid`
FROM `rvt_content`
1 × 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
1 × SELECT element
FROM rvt_extensions
1 × SELECT *
FROM rvt_languages
1 × SELECT folder AS type, element AS name, params
FROM rvt_extensions
1 × SELECT a.*, u.name as creator_name
FROM rvt_attachments AS a
LEFT JOIN rvt_users AS u
ON u.id = a.created_by
Citi vaicājumi:
1 × UPDATE `rvt_extensions`
SET `params` = '{\"mediaversion\":\"fc75a4983f6b90b354b92642806acee3\"}'
1 × SHOW FULL COLUMNS
FROM `rvt_content
1 × UPDATE rvt_content
SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
FROM `rvt_assets