-
21 Septembris 2012 07:41:58
Tēvu zemes mīlestību
Mēs ar darbiem rādīsim
Tie ir mūsu tehnikuma karogā rakstītie vārdi –
Tautas dziesmas “Karavīri bēdājās” viena rindkopa…
Šodien no sevis man gribas piebilst:
Mums ir vēl
Cilvēki, kuriem bija jāiet
Karā.
Uz kuriem
Šāva un kuri
Šāva. Un arī
Mums ir jāiet
Karā – pret meliem, ļaunumu
un vienaldzību.
Mēs visi esam iesaukti šai
Karā. /Livars/
Neliela saruna ar grāmatas “Rīgas Valsts tehnikums – 95” autori,
vēsturnieci Rasmu Cinovsku.
Livars – Laikā, varbūt Laikmetā, kad šķiet, modernie saziņas līdzekļi un tehnoloģijas cenšas izkonkurēt drukāto vārdu, tapusi 1124 gramus smaga, 270 mm x 210 mm liela un 23 mm bieza grāmata ar aptuveni 100 krāsu un tikpat melnbaltiem foto uzņēmumiem, reprodukcijām – arī laika zoba skartiem. Deviņdesmit piecu gadu ritums … Divsimt divdesmit piecās lapaspusēs “dzīva organisma”– Skolas – laiks …
Tikai pārlapojot šo grāmatu, šķiet, Jums ir izdevies aptvert – neaptveramo…
Rasma Cinovska – Paldies, Livar...
Livars – Savādi, mūsu ir tik daudz, bet es neredzu citu, kas būtu varējis paveikt šo neizmērojamo darbu un izdarīt to tik īsā laikā, kāds Jums bija atvēlēts.
Rasma Cinovska – Es uzskatu, ka tas bija mans pienākums un mans veltījums mūsu kolēģiem – priekšgājējiem un daudzajiem audzēkņiem, kas tehnikumu atceras un vienmēr uzskata to par savu. Protams, uzsākot nopietni iedziļināties visos notikumos un visdažādākajās peripetijās 95 pastāvēšanas gados, nebiju domājusi, ka tas mani tik dziļi piesaistīs. Ar katru nākamo mirkli sapratu, ka tas, ko daru, ir ļoti atbildīgi pagātnes un nākotnes priekšā. Tie bija visdažādākie arhīva materiāli – biogrāfijas, rīkojumi, pavēles, pateicības, paskaidrojumi, foto materiāli, filmas, albumi, apbalvojumi, kam, kur, par ko, visdažnedažādākās liecības …
Livars – Rīgas Valsts tehnikuma direktore Dagnija Vanaga grāmatas priekšvārdā saka lieliskus vārdus: „Gadalaiki maina krāsas ap mums, gadskārtu ritums maina mūs pašus un to vidi, kurā dzīvojam, strādājam un mācāmies. Nemainīgas paliek vērtības – tās, kurām uzticamies, tās,
kuras paši radām un vēlamies nodot citiem.”
Rasma Cinovska – Un ļoti nozīmīgi ir tas, ka visā mūsu tehnikuma pastāvēšanas laikā daudzi jo daudzi mūsu bijušie audzēkņi pēc augstskolas absolvēšanas ir atkal atgriezušies, lai mācītu nākamo paaudzi.
Livars – Grāmatā lasu arī Rīgas Tehniskās universitātes rektora Ivara Knēta sacīto: „Ir fantastiski emocionāli iepazīties ar slavenā Rīgas Valsts tehnikuma attīstības vēsturi, it sevišķi, ja šo lielisko mācību iestādi 1925. gadā ir beidzis mans tēvs Valters Knēts, bet es pats savulaik mācījos Rīgas Būvniecības tehnikumā, kas ir viena no RVT nodaļām. Paldies par
Plašo vēsturisko materiālu saglabāšanu! Šodienu var labāk saprast un novērtēt, ja apzināmies savu vēsturi.”
Rasma Cinovska – Jā, tā nu ir sanācis, ka arī es no 1962. gada pēc pašas kvēlas vēlēšanās līdz pat šai dienai joprojām esmu tehnikumā un esmu ne tikai vēstures pasniedzēja ...
Livars – ...bet arī daļa no mūsu vēstures. Jūs bijāt Mehānikas nodaļas vadītāja, direktora vietniece audzināšanas darbā … vēl un vēl, un vēl … darīts ir ļoti daudz… bet ir arī viens bet …
Rasma Cinovska – Tas būtu?
Livars – Bet 1993. gadā arī mani iesaistījāt šajā mūsu Dzīves veidā būt par daļu no mūsu lielās vēstures, par ko es tikai priecājos.
Rasma Cinovska – Mēs te daudzi jau esam kā tehnikuma inventārs, tikai bez numuriem. Nemaz nerunājot par tehnikuma bijušajiem absolventiem un tagadējiem pasniedzējiem – Ojāru Žīguru, kas tehnikumu beidza 1949. gadā un nesen pelnītā atpūtā devušos Daini Līdi, kam tehnikums bija pirmā un vienīgā darba vieta.
Cerams, mūsu dienu vēsturi rakstīs jaunie kolēģi, bijušie RVT audzēkņi, un tie nav uz vienas rokas pirkstiem skaitāmi, viņu ir daudz – jauni, labi izglītoti, interesanti, tehnikuma dzīvi un tradīcijas zinoši.
Livars – Atvainojiet, bet, ja mēs tā turpināsim, tad mums sanāks vēl viena grāmata par grāmatu!
Es saprotu, ka vienam cilvēkam to visu aptvert un apkopot tik īsā laikā bija praktiski neiespējami. Kas bija jūsu labajā komandā,
kas noveda pie tik izcila rezultāta?
Rasma Cinovska – Tad vispirms man jāpateicas mūsu kolēģei, arī kādreizējai tehnikuma absolventei, vēlāk Ķīmijas nodaļas pasniedzējai, nodaļas vadītājai, direktora vietniecei un savu laiku arī RVT direktorei Intai Bombizai. Inta vispār ir mūsu saimes dvēsele un patiesa savas lietas
Cīnītāja … Nevaru nepieminēt mūsu bijušo kolēģi, ķīmijas zinātņu doktoru Ilgvaru Grosvaldu, kas no 1964.g. līdz 1970. gadam strādāja RVT /tolaik – Ar Darba Sarkanā Karoga ordeni apbalvotajā Rīgas Industriālajā politehnikumā/. Protams, paldies arī visam kolektīvam par atsaucību un patiesu ieinteresētību grāmatas tapšanā.
Tātad grāmata – vērtīga, skaisti noformēta, liela, bieza, smaga un vēl pēc poligrāfijas krāsas patīkami smaržojoša…
Es gribētu Jūs kā kultūras un arī skatuves mākslu pārzinošu lūgt –
padot galavārdu, ir tāds termins teātrī. Galavārdu, aiz kura varētu sekot patiesi pateicības aplausi Jūsu lieliskajam veikumam.
Rasma Cinovska – Es esmu tikai mūsu Laika pierakstītāja un citēšu jau kāda sacīto: Dod man paļaušanos pieņemt to, ko es nevaru mainīt, dod man drosmi mainīt to, ko varu mainīt, un dod man gudrību šo vienu no otra atšķirt!
Livars – Paldies Jums!
Vēl jau visi
vārdi nav
pierakstīti.
Vēl jau visas
zvaigznes nav
saskaitītas.
Vēl jau visas
dzintara lāses nav
uzlasītas.
/Rīgā, 2016.25.02. Livars Jankovskis/
Joomla! kļūdu konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1744940066,
"last": 1744940066,
"now": 1744940066
}
},
"registry": {
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly9vbGQucnZ0Lmx2L3Bhci1tdW1zLWFyaGl2cy8xNzQxLXJhc21hLWNpbm92c2thP2xheW91dD1kZWZhdWx0JnByaW50PTEmdG1wbD1jb21wb25lbnQ%3D"
}
},
"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.95 MB (5,191,440 Bytes)
Veikti 30 vaicājumi 16.15 ms
Query Time: 0.22 ms Query memory: 0.026 MB Memory before query: 0.663 MB Rows returned: 0
SELECT `data`
FROM `rvt_session`
WHERE `session_id` = 'gmroes7m4jq0jb7nh5v4u1nvu5'
| 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.03 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.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 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 | | 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.14 ms After last query: 0.34 ms Query memory: 0.023 MB Memory before query: 0.751 MB Rows returned: 0
SELECT `session_id`
FROM `rvt_session`
WHERE `session_id` = 'gmroes7m4jq0jb7nh5v4u1nvu5'
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rvt_session | const | PRIMARY | PRIMARY | 766 | 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.02 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 | | 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:774 |
| 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.55 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 0.756 MB
INSERT INTO `rvt_session`
(`session_id`, `client_id`, `time`)
VALUES
('gmroes7m4jq0jb7nh5v4u1nvu5', 0, '1744940066')
EXPLAIN not possible on query: INSERT INTO `rvt_session`
(`session_id`, `client_id`, `time`) VALUES
('gmroes7m4jq0jb7nh5v4u1nvu5', 0, '1744940066')
| 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 for update | 0.01 ms |
| Update | 0.05 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.38 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/cms/application/cms.php:208 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:774 |
| 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.34 ms After last query: 0.41 ms Query memory: 0.041 MB Memory before query: 0.790 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.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.13 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.22 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 0.839 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.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.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 | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:354 |
| 8 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:423 |
| 7 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 6 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 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.14 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 0.846 MB Rows returned: 4
SELECT id, rules
FROM `rvt_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | rvt_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | |
| 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.00 ms |
| Statistics | 0.01 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 | | 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 8 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:440 |
| 7 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 6 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 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.68 ms After last query: 0.09 ms Query memory: 0.035 MB Memory before query: 0.857 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.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.34 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.23 ms After last query: 0.38 ms Query memory: 0.028 MB Memory before query: 0.941 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.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.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/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.20 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 0.954 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.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.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: 1.43 ms After last query: 2.69 ms Query memory: 0.342 MB Memory before query: 1.353 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.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.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 1.18 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 | | 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.70 ms After last query: 18.19 ms Query memory: 0.036 MB Memory before query: 3.448 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=1741
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.17 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.12 ms |
| Optimizing | 0.04 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Preparing | 0.00 ms |
| Executing | 0.02 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.19 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 3.454 MB Rows returned: 1
SELECT `alias`,`catid`
FROM `rvt_content`
WHERE `id` = 1741
| 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.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.02 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.22 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 3.461 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.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.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.69 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 3.455 MB
UPDATE `rvt_extensions`
SET `params` = '{\"mediaversion\":\"5a969014d4dd4d36e303d45f442d82e9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `rvt_extensions`
SET `params` = '{\"mediaversion\":\"5a969014d4dd4d36e303d45f442d82e9\"}'
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.05 ms |
| Updating | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.50 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.27 ms After last query: 0.34 ms Query memory: 0.023 MB Memory before query: 3.554 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.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.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 | | 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.17 ms After last query: 0.95 ms Query memory: 0.027 MB Memory before query: 3.614 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.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 | | 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: 0.72 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 3.628 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.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.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.31 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.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: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.56 ms After last query: 0.17 ms Query memory: 0.039 MB Memory before query: 3.645 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.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.00 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.11 ms |
| closing tables | 0.01 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 |
| Removing tmp table | 0.08 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.26 ms After last query: 0.49 ms Query memory: 0.049 MB Memory before query: 3.729 MB Rows returned: 1
SELECT *
FROM rvt_content
WHERE `id` = '1741'
| 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.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 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 | | 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: 0.47 ms After last query: 0.11 ms Query memory: 0.007 MB Memory before query: 3.765 MB
UPDATE rvt_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1741'
EXPLAIN not possible on query: UPDATE rvt_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1741'
| 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.03 ms |
| Updating | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.31 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/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.69 ms After last query: 0.40 ms Query memory: 0.039 MB Memory before query: 3.868 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 = 1741
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-18 01:34:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-18 01:34:27')
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.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.01 ms |
| init | 0.07 ms |
| Optimizing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.10 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.02 ms |
| Reset for next command | 0.00 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: 1.78 ms After last query: 0.40 ms Query memory: 0.038 MB Memory before query: 3.925 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.11 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.08 ms |
| Optimizing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Statistics | 0.11 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.03 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.38 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.00 ms |
| Creating sort index | 0.59 ms |
| Creating sort index | 0.05 ms |
| Removing tmp table | 0.08 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 | | 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.28 ms After last query: 0.68 ms Query memory: 0.037 MB Memory before query: 3.972 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` = 1741
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.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.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.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.15 ms After last query: 3.62 ms Query memory: 0.028 MB Memory before query: 4.169 MB Rows returned: 1
SELECT created_by, catid
FROM rvt_content
WHERE id = 1741
| 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.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: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: 1.73 ms After last query: 0.14 ms Query memory: 0.031 MB Memory before query: 4.182 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.1741')
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.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.37 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: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: 1.70 ms After last query: 0.35 ms Query memory: 0.032 MB Memory before query: 4.218 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.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.02 ms |
| Executing | 0.00 ms |
| Sending data | 1.34 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: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.46 ms After last query: 0.23 ms Query memory: 0.037 MB Memory before query: 4.255 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.16 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.04 ms |
| closing tables | 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 |
| Removing tmp table | 0.08 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.17 ms After last query: 0.10 ms Query memory: 0.031 MB Memory before query: 4.286 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.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: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.50 ms After last query: 0.07 ms Query memory: 0.031 MB Memory before query: 4.303 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.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 |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.16 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: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.30 ms After last query: 0.10 ms Query memory: 0.036 MB Memory before query: 4.318 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=1741
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.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.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: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 |
25 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 extension_id AS id, element AS "option", params, enabled
FROM rvt_extensions
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
1 × SELECT `data`
FROM `rvt_session`
1 × SELECT a.rules
FROM rvt_assets AS a
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 `alias`,`catid`
FROM `rvt_content`
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 `session_id`
FROM `rvt_session`
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 id, rules
FROM `rvt_viewlevels
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.*, 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 × INSERT INTO `rvt_session` (`session_id`, `client_id`, `time`)
VALUES ('gmroes7m4jq0jb7nh5v4u1nvu5', 0, '1744940066'
1 × UPDATE `rvt_extensions`
SET `params` = '{\"mediaversion\":\"5a969014d4dd4d36e303d45f442d82e9\"}'
1 × SHOW FULL COLUMNS
FROM `rvt_content
1 × UPDATE rvt_content
SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
FROM `rvt_assets