Gubernur Jawa Tengah meninjau stand Pemkab Grobogan pada GPA Soropadan ke-8
Gubernur Gubernur Jawa Tengah Ganjar Pranowo berkesempatan meninjau stand stand Pemkab Grobogan Gelar pada Promosi Agribisnis (GPA) Soropadan ke-8 tahun 2018
Budidaya Jagung Manis Petani Desa Temon Kec Brati Cukup Menguntungkan
Kasmuri, petani Desa Temon Kecamatan Brati saat panen jagung manis. Harga jual yang tinggi dan waktu tanam yang singkat membuat budidaya jagung manis sangat menjanjikan
Halal Bihalal Keluarga Besar Dinas Pertanian Kabupaten Grobogan
Keluarga Besar Dinas Pertanian Kabupaten Grobogan melaksanakan Halal Bihalal Hari Raya Idul Fitri 1439 H, pada hari Kamis 28 Juni 2018 di Rumah Kedelai Grobogan
Safari Tanam Kedelai Bersama Petani Grobogan di 3 wilayah kecamatan
Ditjen Tanaman Pangan Kementerian Pertanian melaksanakan “Safari Tanam Kedelai Bersama Petani Grobogan” di 3 wilayah kecamatan, yaitu Gubug, Karangrayung dan Klambu
Petani Tembakau di Kabupaten Grobogan Jalin Kemitraan Dengan Sejumlah Pabrik Rokok
Dinas Pertanian Grobogan melalui Bidang Perkebunan berperan aktif dalam memfasilitasi terjalinnya kemitraan antara petani tembakau dengan sejumlah pabrik rokok
Bupati Grobogan menganugerahkan penghargaan "RUMAH KEDELAI AWARD"
Bupati Grobogan menganugerahkan penghargaan kepada Ganjar Pranowo, Sumardjo Gatot Irianto, Tjandra Mukti, Munif Ghulamahdi, Atis Adisarwanto dan Andi Amran Sulaiman
Tempe Terbesar Kedelai Lokal Dari Grobogan Pecahkan Rekor Dunia
Pengakuan resmi kedelai lokal Grobogan berhasil memecahkan Rekor Dunia, diserahkan oleh Eksekutif Manajer Muda MURI, Sri Widayati kepada Bupati Grobogan, Sri Sumarni
Panen Raya Padi Bersama Mentri Pertanian Di Desa Menduran Kec. Brati Kab. Grobogan
Menteri Pertanian Republik Indonesia Andi Amran Sulaiman melakukan Kunjungan Kerja dalam rangka Panen Padi di Desa Menduran Kecamatan Brati Kabupaten Grobogan
KaBalitbang Kementan Saat Panen Raya Padi di Desa Ngeluk Kec. Penawangan Kab. Grobogan
Ka Balitbang Kementrian Pertanian Dr.Ir.Muhammad Syakir, M.S., melakukan kunjungan kerja dalam rangka panen raya padi seluas lebih 250 ha di Desa Ngeluk Kec. Penawangan
Kementan melakukan Safari Serapan Gabah Petani (SERGAP) di Desa Wanutunggal Kec. Godong.
Dalam Rangka penyerapan gabah petani oleh Perum BULOG, Badan Ketahanan Pangan Kementan melakukan Safari Serapan Gabah Petani di Desa Wanutunggal Kec. Godong
list-1
Gubernur Jawa Tengah meninjau stand Pemkab Grobogan pada GPA Soropadan ke-8
Gubernur Gubernur Jawa Tengah Ganjar Pranowo berkesempatan meninjau stand stand Pemkab Grobogan Gelar pada Promosi Agribisnis (GPA) Soropadan ke-8 tahun 2018
index.php/30-berita/196-buka-gpa-soropadan-gubernur-jateng-ingatkan-pentingnya-basis-data-pertanian
Budidaya Jagung Manis Petani Desa Temon Kec Brati Cukup Menguntungkan
Kasmuri, petani Desa Temon Kecamatan Brati saat panen jagung manis. Harga jual yang tinggi dan waktu tanam yang singkat membuat budidaya jagung manis sangat menjanjikan
Halal Bihalal Keluarga Besar Dinas Pertanian Kabupaten Grobogan
Keluarga Besar Dinas Pertanian Kabupaten Grobogan melaksanakan Halal Bihalal Hari Raya Idul Fitri 1439 H, pada hari Kamis 28 Juni 2018 di Rumah Kedelai Grobogan
Safari Tanam Kedelai Bersama Petani Grobogan di 3 wilayah kecamatan
Ditjen Tanaman Pangan Kementerian Pertanian melaksanakan “Safari Tanam Kedelai Bersama Petani Grobogan” di 3 wilayah kecamatan, yaitu Gubug, Karangrayung dan Klambu
Petani Tembakau di Kabupaten Grobogan Jalin Kemitraan Dengan Sejumlah Pabrik Rokok
Dinas Pertanian Grobogan melalui Bidang Perkebunan berperan aktif dalam memfasilitasi terjalinnya kemitraan antara petani tembakau dengan sejumlah pabrik rokok
Bupati Grobogan menganugerahkan penghargaan "RUMAH KEDELAI AWARD"
Bupati Grobogan menganugerahkan penghargaan kepada Ganjar Pranowo, Sumardjo Gatot Irianto, Tjandra Mukti, Munif Ghulamahdi, Atis Adisarwanto dan Andi Amran Sulaiman
Tempe Terbesar Kedelai Lokal Dari Grobogan Pecahkan Rekor Dunia
Pengakuan resmi kedelai lokal Grobogan berhasil memecahkan Rekor Dunia, diserahkan oleh Eksekutif Manajer Muda MURI, Sri Widayati kepada Bupati Grobogan, Sri Sumarni
Panen Raya Padi Bersama Mentri Pertanian Di Desa Menduran Kec. Brati Kab. Grobogan
Menteri Pertanian Republik Indonesia Andi Amran Sulaiman melakukan Kunjungan Kerja dalam rangka Panen Padi di Desa Menduran Kecamatan Brati Kabupaten Grobogan
KaBalitbang Kementan Saat Panen Raya Padi di Desa Ngeluk Kec. Penawangan Kab. Grobogan
Ka Balitbang Kementrian Pertanian Dr.Ir.Muhammad Syakir, M.S., melakukan kunjungan kerja dalam rangka panen raya padi seluas lebih 250 ha di Desa Ngeluk Kec. Penawangan
Kementan melakukan Safari Serapan Gabah Petani (SERGAP) di Desa Wanutunggal Kec. Godong.
Dalam Rangka penyerapan gabah petani oleh Perum BULOG, Badan Ketahanan Pangan Kementan melakukan Safari Serapan Gabah Petani di Desa Wanutunggal Kec. Godong
Pemilihan Petani Muda
Pendaftaran :
5 mei 2018 – 17 Agustus 2018
Info Lengkap kunjungi http://www.dutapetanimuda.id/
Sektor pertanian merupakan salah satu sektor yang mempunyai peranan cukup penting dalam perekonomian Indonesia. Salah satu subsektor pertanian yang mempunyai peranan yang sangat strategis adalah subsektor tanaman pangan, yang meliputi tanaman padi dan palawija. Peranan penting subsektor tanaman pangan adalah dalam hal pemenuhan kebutuhan pangan masyarakat Indonesia. Mengingat pentingnya peran subsektor tanaman pangan, dibutuhkan informasi mengenai produksi tanaman pangan yang akurat dan menggambarkan kondisi terkini. Salah satu informasi penting yang dibutuhkan dalam penghitungn produksi tanaman pangan adalah hasil per hektar (produktivitas) yang dikumpulkan secara rutin setiap subround melalui Survei Ubinan.
Informasi pokok yang dikumpulkan melalui Survei Ubinan adalah data produktivitas (hasil per hektar) tanaman padi sawah, jagung, kedelai, kacang tanah, ubi kayu, dan ubi jalar. Informasi pendukung lainnya yang juga dikumpulkan antara lain koordinat lokasi ubinan, jenis lahan, cara penanaman, sistem penanaman, jenis kegiatan peningkatan produksi, banyaknya benih dan pupuk yang digunakan, jenis/varietas benih yang digunakan (khusus padi dan jagung), intensitas serangan hama serta cara pengendaliannya, informasi bantuan benih, pupuk, alsintan, dan informasi kualitatif yang berkaitan dengan produktivitas. Mengingat begitu pentingnya data yang dihasilkan melalui Survei Ubinan ini, maka diperlukan pelatihan petugas yang intensif agar data yang dihasilkan benar-benar akurat.
Pelatihan ubinan dilaksanakan mulai tanggal 3-4 Juli 2018 di Hotel Kyriad Grand Master, Purwodadi Kab. Grobogan. Pelatihan ini diikuti oleh 40 orang peserta terdiri dari Koordinator Statistik Kecamatan (KSK) dan Petugas Penyuluh Pertanian yang menangani ubinan Stastistik Pertanian.
Pelatihan dibuka oleh Agung Wagito, S. Si, M.Si, mewakili Kepala BPS Kabupaten Grobogan.
Pelatihan pada hari pertama diisi dengan paparan materi oleh instruktur daerah mengenai tata cara pemutakhiran, konsep dan definisi, pencacahan, dan sedikit materi mengenai pengolahan. Dalam pelatihan ini juga dilakukan diskusi mengenai kasus-kasus yang mungkin terjadi di lapangan atau pengalaman-pengalaman di lapangan dalam melaksanakan survei ubinan. Pada hari kedua dilakukan tryout ubinan dengan turun langsung ke lapangan. Pada pelatihan kali ini tanaman pangan yang diubin adalah tanaman padi dan Jagung.
Survey ubinan rutin di lakukan setiap tahun dalam 3 periode, yaitu subround/SR I (periode Januari-april), SR II (periode Mei – Agustus), SR III (Periode September-Desember).
Praktek Lapangan Ubinan Padi berlokasi di Desa Kuripan Kec. Purwodadi Pelatihan Jagung berlokasi di Desa Karanganyar Kec. Purwodadi.
Diharapkan dengan adanya Pelatihan ini diperoleh informasi data yang akurat.
Dinas Pertanian Grobogan @dispertan
#KakMin melaporkan acara "Kenal Pamit Kapolres Grobogan", dari AKBP M.Choiron El Atiq, SH, SIK, MH kepada AKBP Ronn… https://t.co/ZcUwSHDEPB
Dinas Pertanian Grobogan @dispertan
Dilokasi Poktan Margo Marem saat ini total luas tanaman melon ada sekitar 30 ha dengan umur tanaman berfariasi anta… https://t.co/8nJ48yLK2w
Dinas Pertanian Grobogan @dispertan
Tanaman melon masih menjadi favorit bagi para petani, seperti #PetaniKita Marjan anggota Poktan Margo Marem Ds Tung… https://t.co/WHX1sG7goY
Copyright © 2014. Dinas Pertanian Kab.Grobogan Prov.Jawa Tengah
Jl.P.Diponegoro No.20 Telp (0292) 421478, Fax (0292) 426322 webmail : dipertan@grobogan.go.id
http://dispertan.grobogan.go.id/
Dinas Pertanian Kabupaten Grobogan
{ "__default": { "session": { "counter": 1, "timer": { "start": 1575586643, "last": 1575586643, "now": 1575586643 }, "client": { "forwarded": "3.95.131.208" }, "token": "sgBoqsGVSRKwA8jjF9y1vi8OBXJAW0bC" }, "registry": {}, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "com_mailto": { "links": { "21768dc923a93c19d97960be5e430b1252e83792": { "link": "http:\/\/dinpertan.grobogan.go.id\/index.php\/30-berita\/181-pelatihan-petugas-survey-ubinan-tanaman-pangan-2018", "expiry": 1575586644 } } } } }
SELECT `data`
FROM `ni2ek_session`
WHERE `session_id` = 'ko9lq8plt656mus4vknafa1d60'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_session | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | NULL |
# | **Caller** | **File and line number** |
---|---|---|
16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | **Same as call in the line below.** |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:755 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:343 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `ni2ek_session`
WHERE `session_id` = 'ko9lq8plt656mus4vknafa1d60'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_session | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
# | **Caller** | **File and line number** |
---|---|---|
9 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:343 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `ni2ek_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('ko9lq8plt656mus4vknafa1d60', 1, '1575586643', 0, '', 0)
# | **Caller** | **File and line number** |
---|---|---|
8 | JDatabaseDriverMysql->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:343 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ni2ek_extensions`
WHERE `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_extensions | ref | extension | extension | 82 | const | 39 | 100.00 | Using index condition |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:423 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | **Same as call in the line below.** |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:431 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:497 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:596 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `ni2ek_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_viewlevels | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 5 | 100.00 | NULL |
# | **Caller** | **File and line number** |
---|---|---|
10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM ni2ek_usergroups AS a
LEFT JOIN ni2ek_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | 100.00 | Using where; Using index |
# | **Caller** | **File and line number** |
---|---|---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ni2ek_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_extensions | ref | extension | extension | 82 | const | 108 | 100.00 | Using index condition; Using where; **Using filesort** |
# | **Caller** | **File and line number** |
---|---|---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:359 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 ni2ek_menu AS m
LEFT JOIN ni2ek_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 | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 42 | 100.00 | Using index condition; Using where; **Using filesort** |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | dinperta_hortik.m.component_id | 1 | 100.00 | Using where |
# | **Caller** | **File and line number** |
---|---|---|
19 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | **Same as call in the line below.** |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:374 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:488 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1070 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ni2ek_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using index condition |
# | **Caller** | **File and line number** |
---|---|---|
20 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
19 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
18 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | **Same as call in the line below.** |
17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
15 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
14 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
13 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
9 | plgSystemJComments->onAfterRoute() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `ni2ek_extensions`
SET `params` = '{\"mediaversion\":\"7378c4c8249c7a9f733b436322b7ae45\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_extensions | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
14 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
13 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
9 | plgSystemJComments->onAfterRoute() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `ni2ek_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_jcomments_settings | ref | PRIMARY | PRIMARY | 214 | const,const | 91 | 100.00 | Using where |
# | **Caller** | **File and line number** |
---|---|---|
17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/config.php:140 |
15 | JCommentsCfg::_load() | **Same as call in the line below.** |
14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/classes/config.php:159 |
12 | JCommentsCfg->load() | JROOT/components/com_jcomments/classes/config.php:47 |
11 | JCommentsCfg::getInstance() | JROOT/components/com_jcomments/helpers/system.php:39 |
10 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
9 | plgSystemJComments->onAfterRoute() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM ni2ek_template_styles as s
LEFT JOIN ni2ek_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 | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_template | **NO INDEX KEY COULD BE USED** | NULL | NULL | 5 | 100.00 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | dinperta_hortik.s.template,const | 1 | 100.00 | Using index condition; Using where |
# | **Caller** | **File and line number** |
---|---|---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
11 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/components/com_jcomments/helpers/system.php:46 |
10 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
9 | plgSystemJComments->onAfterRoute() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT manifest_cache
FROM ni2ek_extensions
WHERE element LIKE 'jsn_epic_pro'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_extensions | range | element_clientid,element_folder_clientid | element_clientid | 402 | NULL | 3 | 100.00 | Using index condition |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
14 | JDatabaseDriver->loadResult() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122 |
13 | JSNTplHelper::getManifestCache() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217 |
12 | JSNTplHelper::getTemplateVersion() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35 |
11 | jsn_template_framework_class_loader() | **Same as call in the line below.** |
10 | spl_autoload_call() | JROOT/plugins/system/jsntplframework/jsntplframework.php:187 |
9 | PlgSystemJSNTPLFramework->onAfterRoute() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM ni2ek_extensions
WHERE type = 'component'
AND element = 'com_sh404sef'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 100.00 | Using index condition; Using where |
# | **Caller** | **File and line number** |
---|---|---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
12 | JDatabaseDriver->loadResult() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1166 |
11 | JSNTplUtils->checkSH404SEF() | JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36 |
10 | JSNTPLFramework::initial() | JROOT/plugins/system/jsntplframework/jsntplframework.php:191 |
9 | PlgSystemJSNTPLFramework->onAfterRoute() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM ni2ek_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_languages | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 1 | 100.00 | Using where; **Using filesort** |
# | **Caller** | **File and line number** |
---|---|---|
7 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ni2ek_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easybookreloaded','com_fields','com_finder','com_imageshow','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_phocaguestbook','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_assets | ALL | idx_asset_name | **NO INDEX KEY COULD BE USED** | NULL | NULL | 340 | 11.76 | Using where |
# | **Caller** | **File and line number** |
---|---|---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:55 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:248 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `ni2ek_content`
# | **Caller** | **File and line number** |
---|---|---|
16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
11 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:312 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:250 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM ni2ek_content
WHERE `id` = '181'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_content | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
10 | Joomla\CMS\Table\Table->load() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE ni2ek_content
SET `hits` = (`hits` + 1)
WHERE `id` = '181'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_content | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
# | **Caller** | **File and line number** |
---|---|---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/src/Table/Table.php:1242 |
10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:252 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM ni2ek_content AS a
INNER JOIN ni2ek_categories AS c
on c.id = a.catid
LEFT JOIN ni2ek_users AS u
on u.id = a.created_by
LEFT JOIN ni2ek_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ni2ek_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 181
AND c.published > 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | v | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
# | **Caller** | **File and line number** |
---|---|---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:148 |
12 | ContentModelArticle->getItem() | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398 |
11 | JViewLegacy->get() | JROOT/components/com_content/views/article/view.html.php:42 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 `ni2ek_categories` AS `s`
INNER JOIN `ni2ek_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 30
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | **Using filesort** |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | **NO INDEX KEY COULD BE USED** | NULL | NULL | 44 | 65.91 | Using where |
# | **Caller** | **File and line number** |
---|---|---|
23 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:312 |
21 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
20 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
19 | ContentRouter->getCategorySegment() | **Same as call in the line below.** |
18 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
17 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
16 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
15 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:672 |
14 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
13 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
12 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
11 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `ni2ek_contentitem_tag_map` AS m
INNER JOIN `ni2ek_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 181
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type | **NO INDEX KEY COULD BE USED** | NULL | NULL | 1 | 100.00 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | dinperta_hortik.m.tag_id | 1 | 100.00 | Using where |
# | **Caller** | **File and line number** |
---|---|---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ni2ek_fields AS a
LEFT JOIN `ni2ek_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ni2ek_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ni2ek_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ni2ek_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ni2ek_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ni2ek_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (30,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; **Using filesort** |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | dinperta_hortik.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | dinperta_hortik.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | dinperta_hortik.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | dinperta_hortik.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | dinperta_hortik.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | dinperta_hortik.a.id | 1 | 100.00 | Using where; Using index |
# | **Caller** | **File and line number** |
---|---|---|
20 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
14 | PlgSystemFields->onContentPrepare() | **Same as call in the line below.** |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `name`, `value`
FROM `ni2ek_jsn_imageshow_config`
WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_jsn_imageshow_config | ALL | name | **NO INDEX KEY COULD BE USED** | NULL | NULL | 1 | 100.00 | Using where |
# | **Caller** | **File and line number** |
---|---|---|
19 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81 |
17 | JSNISParameter->getParameters() | JROOT/administrator/components/com_imageshow/imageshow.defines.php:27 |
16 | require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php | JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16 |
15 | include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php | JROOT/plugins/content/imageshow/imageshow.php:28 |
14 | plgContentImageShow->onContentPrepare() | **Same as call in the line below.** |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM ni2ek_extensions
WHERE element='com_imageshow'
AND type='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ni2ek_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 100.00 | Using index condition; Using where |
# | **Caller** | **File and line number** |
---|---|---|
17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310 |
15 | JSNISUtils->getComponentInfo() | JROOT/plugins/content/imageshow/imageshow.php:45 |
14 | plgContentImageShow->onContentPrepare() | **Same as call in the line below.** |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |