СОЮЗ ПОХОРОННЫХ ОРГАНИЗАЦИЙ И КРЕМАТОРИЕВ (СПОК)
+7 (921) 962 48 99
СОЮЗ ПОХОРОННЫХ ОРГАНИЗАЦИЙ И КРЕМАТОРИЕВ (СПОК)
+7 (921) 962 48 99
Навести порядок в одной из самых проблемных сфер бизнеса — сфере похоронных услуг, с которой несколько лет подряд мучились чиновники ФАС, обещает теперь Минстрой. Ведомство собирается положить конец вопиющему «обману на слезах» и «погоне за покойниками», которые устраивают похоронные агенты. Уже к ноябрю Минстрой планирует закончить работу над масштабным законопроектом.
Как перекрыть доступ на рынок нечистым на руку агентам? В состоянии ли честные компании и СРО самостоятельно вылечить этот бизнес? Или все же без государственного кулака и лицензий не обойтись? Не обернется ли лицензирование обычной торговлей индульгенциями? Кто будет решать, сколько должны стоить гроб, венок и работа людей с лопатами? Станут ли фамильные склепы и похороны у подножия храмов легальными? О нынешних проблемах похоронной отрасли и путях их решения корреспонденту «МК» рассказал замминистра строительства и ЖКХ Андрей ЧИБИС.
— Андрей Владимирович, говорят, что никто не знает, сколько в нашей огромной стране могил. Может, хотя бы вы знаете?
— На самом деле этого доподлинно никто не знает. По одним данным, тридцать тысяч кладбищ, по другим — семьдесят. Единого реестра кладбищ и тем более захоронений нет. Это при том, что каждый год из жизни уходит около двух миллионов человек. Скажу больше: на официально закрытое кладбище за определенные деньги пускают. И очень часто люди, которые по воле судьбы какое-то время не могли ухаживать за могилой своих близких, могут прийти и обнаружить, что на этом месте уже похоронен кто-то другой.
— Если честно, похоронные агенты уж очень похожи на стервятников. Только умер человек — сразу началась охота...
— Это конкуренция за покойника. Полбеды, если человек уже умер. Вот самый вопиющий сценарий: пациент долго болеет, но еще жив. Врачам понятно: высока вероятность смерти. И они «сливают» эту информацию похоронным агентам, которые при живом еще человеке начинают предлагать свои услуги родственникам. Это этическая, моральная катастрофа.
— Вообще, какой он, рынок похоронных услуг?
— Совершенно дикий рынок. Похоронить близкого человека — это не за хлебушком сходить. Родственники готовы отдать все, лишь бы церемонию провели качественно. Но нет никаких гарантий, что все будет сделано как положено. У родственников не должна болеть голова о том, что посреди церемонии что-то уронят или машина сломается. Они ведь за все это платят немалые деньги. А по факту, когда машина ломается, работники агентства говорят, что это была вообще единственная машина, и они ничего сделать не могут. Представляете, что чувствуют люди, когда им говорят: «Что хотите, то и делайте»?
— А как цены на этом рынке формируются? С потолка?
— Это вообще отдельная проблема. По закону земельный участок под могилу должен быть предоставлен бесплатно. А все остальные услуги: раскопка могилы, захоронение, памятники, цветы, венки, доставка — на коммерческой основе. Но я пока не встретил ни одного человека, который бы понимал, почему это столько стоит.
— Ну а квитанции-то агенты дают в обмен на деньги?
— Люди практически никогда не требуют договор, чек или квитанцию. А стоит потребовать, сразу: «Подождите, какая квитанция? Вы что?» А к кому же мы предъявим претензии, если возникнет какая-то проблема? Но агент, естественно, уверяет, что все будет хорошо. Но вот вам пример из практики. Нанятая похоронная компания заезжает на кладбище, а тамошние работники не пропускают на территорию и копать запрещают. Мол, мы сами тут копаем. И это происходит в тот момент, когда для людей самое главное — это достойно проводить своего близкого.
— Так как же размотать этот змеиный клубок? Созданы уже механизмы?
— Сегодня необходимо детально регламентировать похоронную деятельность. Там же целая цепочка действий: от содержания и управления кладбищами до «сервисного» цикла. Одно только составление бумаг о погребении для родственников — это уже отдельный вид очень важной работы похоронных агентств. И, конечно же, вся эта деятельность должна работать по единому стандарту. Добросовестный агент должен составить все документы, выбрать гроб, венки, памятник, решить вопросы, связанные с погребальной церемонией: от выбора машины до договоренностей о том, кто и как будет копать могилу. Минимальный гарантированный перечень услуг, которые должен оказать участник рынка, должен быть четко прописан, причем на федеральном уровне. Как правильно хоронить и что должны делать агенты — все это нужно будет подвести под жесткий стандарт. Сегодня мы обсуждаем эту идею и с бизнесом, и с региональными властями, и с представителями конфессий.
— Нужно ли как-то ограничить доступ на рынок для агентов?
— Здесь может быть только два варианта: либо лицензирование, либо вступление в СРО. Причем мы считаем именно первый путь правильным. Ведь лицензию за нарушения стандартов и правил поведения на рынке можно отобрать.
— А как люди смогут узнать, кто из агентов их обведет вокруг пальца, а кто играет по всем правилам? Ведь далеко не каждому придет в голову в состоянии шока изучать лицензии...
— У людей появится возможность через справочные услуги муниципалитетов, специальные порталы в Интернете и печатные издания получить информацию о том, где находятся ближайшие лицензированные похоронные компании. Только так можно до людей донести информацию о тех, кто способен оказывать качественные услуги и проверен государством.
— Не получится в итоге, что на город останется одна-две компании, и похоронные услуги станут дефицитными?
— Так быть не должно. Но совершенно точно это не могут быть сотни фирм, которые только и делают, что ведут между собой бои за покойника. По цене пусть конкурируют. Но эта борьба будет уже в рамках дополнительных сервисов, за рамками минимальных стандартов, прописанных государством.
— Андрей Владимирович, а ставки на тот самый минимальный перечень услуг будут как-то фиксироваться властями?
— Мы считаем, что это нужно сделать — прописать потолок цен. Делать это будут власти субъектов исходя из экономики и уровня доходов по региону.
— Сегодня на воротах большинства публичных кладбищ висят таблички «закрыто для новых захоронений». Через пару десятков лет вообще хоронить будет негде?
— Дело в том, что сегодня за размещение кладбищ отвечают муниципалитеты. Однако мы считаем, что это совершенно не их дело, а дело региональных властей. Ресурсов для размещения кладбищ внутри муниципальных образований чаще всего не существует. Получается глупая ситуация, когда в городе кладбище разместить уже нельзя, а хоронить людей где-то надо. Разрешить оборудовать кладбище в пригороде может уже соседний муниципалитет. В результате постоянно возникают конфликты.
— А за состоянием кладбищ кто должен следить? Местные чиновники или тоже власти региона?
— Это тоже должно стать заботой регионов. Более того, именно они должны определять внешний вид кладбища: дорожки, ограды, вид и габариты памятников. Управлять же кладбищем должно не то унитарное предприятие, которое приглянулось руководителю муниципалитета, а независимые государственные или частные компании, которые будут выбираться специально на конкурсе. Причем в зоне ответственности этих компаний должно быть все: обеспечение безопасности на кладбище, содержание его в достойном состоянии. Чтобы на дорожках не хоронили, чтобы не было одной ограды двухметровой высоты, а другой — в 20 сантиметров от земли. Для людей, приходящих на кладбище, должна быть создана атмосфера размышления о вечности. Это не значит, что все кладбища станут одинаковыми. Но они должны иметь вид исторического памятника.
— Получается, что люди с низкими и средними доходами смогут рассчитывать на достойные, пусть и скромные похороны на публичном кладбище. А что делать тем, кто хочет усопшего похоронить чуть ли не в мавзолее или памятник отгрохать в два человеческих роста? Ну, или принципиально хочет, чтобы его близкий покоился у подножия храма?
— Если говорить о храмах, то для этого мы планируем создать систему вероисповедальных кладбищ. Хотя по факту погосты при церквях и так существуют, правда, нелегально. Так что наша задача — их легализовать. А вот для тех, кто хочет получить какие-то дополнительные услуги, мы рассматриваем возможность создания в стране частных или, правильнее сказать, коммерческих кладбищ. Мы не исключаем, что в России действительно появятся частные кладбища. Лично я не вижу в этом ничего плохого. Это широко развитая международная практика. Так что если люди хотят, чтобы их близкие были захоронены на частном кладбище, эту опцию можно предоставить. Естественно, стандарты на таких кладбищах могут отличаться от стандартов публичных мест захоронения.
— Андрей Владимирович, как открытие частного кладбища может выглядеть на практике? Вот, допустим, есть у меня стартовый капитал. Я смогу купить любой кусок земли и сказать, что здесь будет кладбище?..
— Если в рамках документов территориального планирования предусмотрено, что на этом месте может быть кладбище, то такой вариант вполне возможен. Главное, чтобы статус земельного участка был соблюден. Иначе частные погосты начнут вырастать в Подмосковье на землях сельхозназначения.
— Частные некрополи станут чем-то вроде Рублевки для усопших? Ведь вы сказали, что стандарты услуг там будут отличаться от обычных кладбищ.
— Не совсем так. Те общие минимальные стандарты услуг, о которых я говорил раньше, должны строго соблюдать и владельцы частных кладбищ. И регулирование цен в этом плане будет таким же, как и на публичных. А вот сверх минимума уже можно будет предлагать другие, более дорогие услуги. Например, памятник сделать большой и необычный или участок выделить побольше. Здесь цена будет формироваться уже по правилам свободного рынка. Хотя надо понимать, что и сейчас на публичном кладбище можно взять большой участок земли, но в «черную». А на частных кладбищах за нестандартные запросы будут брать легальную плату.
— К вопросу о повторных захоронениях. Эта проблема не первый год обсуждается, а результата нет. Какие мысли по этому поводу?
— Мы сейчас обсуждаем, возможно ли использование брошенных могил и при каких условиях. На мой взгляд, разрешить такую меру можно при условии обязательного розыска родственников или близких. Кроме того, нужно установить предельный срок, спустя который можно прикасаться к заброшенной могиле.
— Когда Минстрой планирует завершить подготовку поправок в законодательство и внести их в Госдуму?
— По нашим расчетам и указанию Правительства РФ мы должны завершить работу над законопроектом к первому ноября. Надеемся, что Госдума рассмотрит его уже в ходе осенней сессии.
СПРАВКА "МК"
А КАК У НИХ:
Первые коммерческие некрополи в Европе и Америке стали появляться в начале XIX века. Самые знаменитые из них — кладбища «Магической семерки» в Лондоне: семь частных погостов, организованных в позапрошлом столетии в связи с переполнением публичных кладбищ. Среди них наибольшей популярностью у туристов пользуется «Кладбище всех душ», привлекающее любителей старины замысловатой архитектурой памятников. Родственникам усопших разрешалось выбирать способ захоронения. Это могли быть катакомбы, мавзолей, склеп или традиционная земляная могила в обрамлении зеленых насаждений и традиционного английского газона. Кстати, выбор деревьев тоже был огромен: около 800 видов. А чтобы не разориться на газонокосильщиках, по кладбищу пускали коров, которые мирно жевали травку.
Повторные захоронения разрешены в Испании, Франции и Австрии. Для того чтобы использовать заброшенную могилу заново, прах из нее кремируют и помещают на хранение «до востребования». При этом нужно, чтобы за могилой не ухаживали минимум 25 лет.
ДРУГОЕ МНЕНИЕ
Павел УЛАНОВ, руководитель программ подготовки кадров Союза похоронных организаций и крематориев:
— В целом предложения Минстроя способны навести порядок в похоронной сфере, которая сегодня является полукриминальной. Однако сомнения вызывает эффективность введения одних только лицензий. Само по себе лицензирование может превратиться в торговлю бумажками. Мы уже видим подобное и в образовании, и в медицине. Чтобы был реальный контроль за рынком, нужен механизм «двойного фильтра»: симбиоза лицензий и корпоративной сертификации. Необходимо создать Союз ритуальных организаций (СРО), причем их должно быть несколько по стране, иначе вместо независимого корпоративного контролера мы получим что-то вроде негосударственного министерства. Полномочия СРО позволят им создать свои профстандарты для всех работников отрасли: от агентов и менеджеров на телефоне до тех, кто копает могилы и бальзамирует умерших. На базе профстандартов будут создаваться программы образования и этические кодексы. Любая компания, желающая легально работать в «похоронке», должна будет сначала вступить в СРО, которая прогонит претендента через свои фильтры, проверит репутацию и попросту научит, как надо работать. Если фирма адекватная, СРО даст лицензирующему органу рекомендацию на выдачу лицензии. И только после этого компания сможет получить государственное разрешение. Такой механизм будет выгоден всем. СРО будут знать, что их члены добросовестны и отвечают внутренним корпоративным стандартам. Государство будет знать, что лицензию они выдают тем, кто в состоянии нормально работать. А потребитель будет получать услуги только от агентств, прошедших такую «тонкую» фильтрацию. К тому же СРО — это своего рода арбитр и третейский суд на случай споров между агентом и клиентом. СРО будет возмещать вред, причиненный ее членом, из компенсационного фонда. В результате недовольным потребителям не придется обивать пороги судов.
Татьяна Антонова
Источник: mk.ru
©2013-2018 СОЮЗ ПОХОРОННЫХ ОРГАНИЗАЦИЙ И КРЕМАТОРИЕВ (СПОК)
Union of Funeral Organizations and Crematoriums
На нашем сайте мы стараемся максимально полно собрать новости похоронного бизнеса из разных интернет-изданий. Редакция не несет ответственности за сведения, содержащиеся в перепечатанных материалах.
Политика в отношении обработки персональных данных (Политика конфиденциальности)
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1660357394,
"last": 1660357394,
"now": 1660357394
},
"token": "s9TTidpskuLIVnCQIoh7TC94X2LRrBgh"
},
"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_rsfirewall": {
"geoip": "US"
}
}
}
SELECT `session_id`
FROM `l52fb_session`
WHERE `session_id` = '15fd7dae8bdf21d1fe853d119bb4f4aa'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `l52fb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('15fd7dae8bdf21d1fe853d119bb4f4aa', 1, 1660357394, 0, '', 0)
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| update | 0.13 ms |
| Waiting for query cache lock | 0.01 ms |
| update | 0.01 ms |
| end | 0.00 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT id, rules
FROM `l52fb_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.05 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php: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:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM l52fb_usergroups AS a
LEFT JOIN l52fb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.05 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php: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:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `path`
FROM l52fb_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_rsfirewall_ignored | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:53 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `file`
FROM l52fb_rsfirewall_hashes
WHERE `type`='protect'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_rsfirewall_hashes | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:60 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM l52fb_rsfirewall_configuration
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_rsfirewall_configuration | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 52 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.10 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:68 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `l52fb_rsfirewall_logs`
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.23 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.05 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 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/administrator/components/com_rsfirewall/tables/logs.php:36 |
| 11 | RsfirewallTableLogs->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:23 |
| 9 | RSFirewallLogger->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:57 |
| 8 | RSFirewallLogger::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:50 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `l52fb_extensions`
SET `params` = '{\"mediaversion\":\"a646cc382fec60f5abafdb3677e68b10\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UPDATE | l52fb_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.11 ms |
| updating | 0.11 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| end | 0.01 ms |
| query end | 0.04 ms |
| closing tables | 0.03 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 15 | JDatabaseDriverMysqli->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/jxtcxmenu/jxtcxmenu.php:46 |
| 9 | plgSystemjxtcxmenu->onAfterInitialise() | 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:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 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 `l52fb_categories` AS `s`
INNER JOIN `l52fb_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)
AND c.published = 1
AND s.id = 517
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.13 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| executing | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 12 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 11 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 |
| 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
| 9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `alias`,`catid`
FROM `l52fb_content`
WHERE `id` = 517
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.03 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 11 | JDatabaseDriver->loadObject() | JROOT/components/com_content/helpers/legacyrouter.php:366 |
| 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
| 9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM l52fb_rsfirewall_hashes
WHERE (`type`='3.9.9' OR `type`='protect')
AND `flag`!='C'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_rsfirewall_hashes | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1026 |
| 9 | plgSystemRSFirewall->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM l52fb_rsfirewall_snapshots
WHERE `type`='protect'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_rsfirewall_snapshots | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 |
| 10 | RSFirewallSnapshot::get() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1049 |
| 9 | plgSystemRSFirewall->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `ip`,`reason`
FROM l52fb_rsfirewall_lists
WHERE (`ip`='3.239.4.127' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_rsfirewall_lists | NULL | ref | published,type,ip | type | 1 | const | 6 | 36.79 | Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:169 |
| 11 | plgSystemRSFirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:148 |
| 10 | plgSystemRSFirewall->isWhitelisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1085 |
| 9 | plgSystemRSFirewall->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `ip`,`reason`
FROM l52fb_rsfirewall_lists
WHERE (`ip`='3.239.4.127' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_rsfirewall_lists | NULL | ALL | published,type,ip | NO INDEX KEY COULD BE USED | NULL | NULL | 326 | 36.79 | Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.48 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:169 |
| 11 | plgSystemRSFirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:138 |
| 10 | plgSystemRSFirewall->isBlacklisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1089 |
| 9 | plgSystemRSFirewall->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM l52fb_rsfirewall_exceptions
WHERE `published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_rsfirewall_exceptions | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:682 |
| 10 | plgSystemRSFirewall->isException() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1142 |
| 9 | plgSystemRSFirewall->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM l52fb_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.07 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.04 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `l52fb_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_foxcontact','com_installer','com_joomlaupdate','com_jxtc','com_jxtceasyimage','com_jxtcreadinglist','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mijopolls','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_rspagebuilder','com_search','com_sigpro','com_sppagebuilder','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 46 | 100.00 | Using index condition |
| Status | Duration |
|---|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.21 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.68 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `l52fb_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_assets | NULL | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 9802 | 21.63 | Using where |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 8.89 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `l52fb_content`
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.31 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| Opening tables | 0.03 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.16 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.08 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 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:253 |
| 9 | ContentModelArticle->hit() | 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:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM l52fb_content
WHERE `id` = '517'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 10 | Joomla\CMS\Table\Table->load() | JROOT/components/com_content/models/article.php:254 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE l52fb_content
SET `hits` = (`hits` + 1)
WHERE `id` = '517'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UPDATE | l52fb_content | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.05 ms |
| updating | 0.13 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| end | 0.01 ms |
| query end | 0.04 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1245 |
| 10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:255 |
| 9 | ContentModelArticle->hit() | 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:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 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 l52fb_content AS a
INNER JOIN l52fb_categories AS c
on c.id = a.catid
LEFT JOIN l52fb_users AS u
on u.id = a.created_by
LEFT JOIN l52fb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN l52fb_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 517
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-13 02:23:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-13 02:23:14')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
| Status | Duration |
|---|---|
| starting | 0.19 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| init | 0.13 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.30 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.15 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.08 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
| 13 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 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:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 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 `l52fb_categories` AS `s`
INNER JOIN `l52fb_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)
AND c.published = 1
AND s.id = 20
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 4 | 27.72 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.15 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.16 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.12 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 21 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:672 |
| 16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:131 |
| 13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:80 |
| 12 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 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:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `l52fb_contentitem_tag_map` AS m
INNER JOIN `l52fb_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 517
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 6766 | 1.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | u0397366_spok17.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 4.18 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.05 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 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:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM l52fb_fields AS a
LEFT JOIN `l52fb_languages` AS l
ON l.lang_code = a.language
LEFT JOIN l52fb_users AS uc
ON uc.id=a.checked_out
LEFT JOIN l52fb_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN l52fb_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN l52fb_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `l52fb_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 (20,0,19))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | u0397366_spok17.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|---|
| starting | 0.13 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| init | 0.09 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.17 ms |
| preparing | 0.04 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.23 ms |
| Creating sort index | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.06 ms |
| query end | 0.01 ms |
| closing tables | 0.04 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|---|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 19 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 18 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 17 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 16 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:488 |
| 15 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 14 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 12 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 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:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM l52fb_content AS a
LEFT JOIN l52fb_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 20
AND a.state = 1
AND a.access IN (1,1)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2022-08-13 02:23:14')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2022-08-13 02:23:14')
ORDER BY a.created DESC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | index_merge | idx_access,idx_state,idx_catid | idx_catid,idx_state | 4,1 | NULL | 76 | 16.00 | Using intersect(idx_catid,idx_state); Using where; Using filesort |
| 1 | SIMPLE | cc | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.11 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 2.52 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/pagenavigation/pagenavigation.php:161 |
| 15 | PlgContentPagenavigation->onContentBeforeDisplay() | Same as call in the line below. |
| 14 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 12 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:199 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:663 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 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:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM l52fb_modules AS m
LEFT JOIN l52fb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN l52fb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-08-13 02:23:14')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-13 02:23:14')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 58 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | e | NULL | ALL | element_clientid,element_folder_clientid | NO INDEX KEY COULD BE USED | NULL | NULL | 275 | 1.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | m | NULL | ref | PRIMARY,published,newsfeeds | newsfeeds | 204 | u0397366_spok17.e.element,const | 3 | 1.41 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.m.id | 8 | 40.00 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 2.26 ms |
| Creating sort index | 0.24 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.04 ms |
| query end | 0.00 ms |
| closing tables | 0.03 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | 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/libraries/src/Helper/ModuleHelper.php:432 |
| 12 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
| 11 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 10 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
| 9 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/versant/layouts/default/layout.php:94 |
| 8 | require JROOT/templates/versant/layouts/default/layout.php | JROOT/templates/versant/index.php:26 |
| 7 | require JROOT/templates/versant/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id,filename
FROM l52fb_jxtc_ezimg_images
WHERE folder='slideshow5'
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_jxtc_ezimg_images | NULL | ref | folder | folder | 386 | const | 2 | 100.00 | Using index condition; Using filesort |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.08 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_jxtceasyimage/support/helper.php:82 |
| 19 | EzimgHelper::refreshImages() | JROOT/administrator/components/com_jxtceasyimage/support/helper.php:306 |
| 18 | EzimgHelper::getImages() | JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php:39 |
| 17 | require JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php | JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php:34 |
| 16 | include JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 13 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 12 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/templates/versant/XTC/XTC_library.php:626 |
| 11 | _xtcJdocCount() | JROOT/templates/versant/XTC/XTC_library.php:561 |
| 10 | xtcBootstrapGrid() | JROOT/templates/versant/layouts/default/layout_includes/region2.php:65 |
| 9 | require JROOT/templates/versant/layouts/default/layout_includes/region2.php | JROOT/templates/versant/layouts/default/layout.php:124 |
| 8 | require JROOT/templates/versant/layouts/default/layout.php | JROOT/templates/versant/index.php:26 |
| 7 | require JROOT/templates/versant/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `l52fb_jxtc_ezimg_images`
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.13 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 23 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 22 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_jxtceasyimage/tables/images.php:54 |
| 21 | TableImages->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 20 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_jxtceasyimage/support/helper.php:88 |
| 19 | EzimgHelper::refreshImages() | JROOT/administrator/components/com_jxtceasyimage/support/helper.php:306 |
| 18 | EzimgHelper::getImages() | JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php:39 |
| 17 | require JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php | JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php:34 |
| 16 | include JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 13 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 12 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/templates/versant/XTC/XTC_library.php:626 |
| 11 | _xtcJdocCount() | JROOT/templates/versant/XTC/XTC_library.php:561 |
| 10 | xtcBootstrapGrid() | JROOT/templates/versant/layouts/default/layout_includes/region2.php:65 |
| 9 | require JROOT/templates/versant/layouts/default/layout_includes/region2.php | JROOT/templates/versant/layouts/default/layout.php:124 |
| 8 | require JROOT/templates/versant/layouts/default/layout.php | JROOT/templates/versant/index.php:26 |
| 7 | require JROOT/templates/versant/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM l52fb_jxtc_ezimg_images
WHERE published=1
AND folder='slideshow5'
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_jxtc_ezimg_images | NULL | ref | folder | folder | 386 | const | 2 | 10.00 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.08 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_jxtceasyimage/support/helper.php:310 |
| 18 | EzimgHelper::getImages() | JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php:39 |
| 17 | require JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php | JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php:34 |
| 16 | include JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 13 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 12 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/templates/versant/XTC/XTC_library.php:626 |
| 11 | _xtcJdocCount() | JROOT/templates/versant/XTC/XTC_library.php:561 |
| 10 | xtcBootstrapGrid() | JROOT/templates/versant/layouts/default/layout_includes/region2.php:65 |
| 9 | require JROOT/templates/versant/layouts/default/layout_includes/region2.php | JROOT/templates/versant/layouts/default/layout.php:124 |
| 8 | require JROOT/templates/versant/layouts/default/layout.php | JROOT/templates/versant/index.php:26 |
| 7 | require JROOT/templates/versant/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `value`
FROM `l52fb_foxcontact_settings`
WHERE `name` = 'captchadrawer'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l52fb_foxcontact_settings | NULL | const | PRIMARY | PRIMARY | 98 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.06 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|---|---|
| 46 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 45 | JDatabaseDriver->loadResult() | JROOT/libraries/foxcontact/design/item_captcha.php:29 |
| 44 | FoxDesignItemCaptcha->canRenderCaptchaImage() | JROOT/libraries/foxcontact/design/item_captcha.php:36 |
| 43 | FoxDesignItemCaptcha->getState() | JROOT/components/com_foxcontact/layouts/foxcontact/item_captcha.php:9 |
| 42 | include JROOT/components/com_foxcontact/layouts/foxcontact/item_captcha.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
| 41 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
| 40 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/libraries/foxcontact/form/render.php:59 |
| 39 | FoxFormRender::render() | JROOT/components/com_foxcontact/layouts/foxcontact/item.php:9 |
| 38 | include JROOT/components/com_foxcontact/layouts/foxcontact/item.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
| 37 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
| 36 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/libraries/foxcontact/form/render.php:59 |
| 35 | FoxFormRender::render() | JROOT/libraries/foxcontact/form/render.php:44 |
| 34 | FoxFormRender::renders() | JROOT/components/com_foxcontact/layouts/foxcontact/column.php:9 |
| 33 | include JROOT/components/com_foxcontact/layouts/foxcontact/column.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
| 32 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
| 31 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/libraries/foxcontact/form/render.php:59 |
| 30 | FoxFormRender::render() | JROOT/libraries/foxcontact/form/render.php:44 |
| 29 | FoxFormRender::renders() | JROOT/components/com_foxcontact/layouts/foxcontact/row.php:9 |
| 28 | include JROOT/components/com_foxcontact/layouts/foxcontact/row.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
| 27 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
| 26 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/libraries/foxcontact/form/render.php:59 |
| 25 | FoxFormRender::render() | JROOT/libraries/foxcontact/form/render.php:44 |
| 24 | FoxFormRender::renders() | JROOT/components/com_foxcontact/layouts/foxcontact/form.php:17 |
| 23 | Joomla\CMS\Layout\FileLayout->{closure}() | JROOT/libraries/foxcontact/html/elem.php:48 |
| 22 | FoxHtmlElem->conditional() | JROOT/components/com_foxcontact/layouts/foxcontact/form.php:18 |
| 21 | include JROOT/components/com_foxcontact/layouts/foxcontact/form.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
| 20 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
| 19 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/libraries/foxcontact/form/render.php:59 |
| 18 | FoxFormRender::render() | JROOT/libraries/foxcontact/form/render.php:33 |
| 17 | FoxFormRender::start() | JROOT/modules/mod_foxcontact/mod_foxcontact.php:38 |
| 16 | include JROOT/modules/mod_foxcontact/mod_foxcontact.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 13 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 12 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/templates/versant/XTC/XTC_library.php:626 |
| 11 | _xtcJdocCount() | JROOT/templates/versant/XTC/XTC_library.php:561 |
| 10 | xtcBootstrapGrid() | JROOT/templates/versant/layouts/default/layout_includes/region9.php:37 |
| 9 | require JROOT/templates/versant/layouts/default/layout_includes/region9.php | JROOT/templates/versant/layouts/default/layout.php:124 |
| 8 | require JROOT/templates/versant/layouts/default/layout.php | JROOT/templates/versant/index.php:26 |
| 7 | require JROOT/templates/versant/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM l52fb_fields AS a
LEFT JOIN `l52fb_languages` AS l
ON l.lang_code = a.language
LEFT JOIN l52fb_users AS uc
ON uc.id=a.checked_out
LEFT JOIN l52fb_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN l52fb_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN l52fb_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `l52fb_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_custom.content'
AND (fc.category_id IS NULL OR fc.category_id IN (20,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | u0397366_spok17.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | u0397366_spok17.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|---|
| starting | 0.21 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| init | 0.13 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.26 ms |
| preparing | 0.06 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.36 ms |
| Creating sort index | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.07 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|---|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 25 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 24 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 23 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 22 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:488 |
| 21 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 20 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 18 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 17 | JHtmlContent::prepare() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 13 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Same as call in the line below. |
| 11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:599 |
| 9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 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 l52fb_content AS a
INNER JOIN l52fb_categories AS c
on c.id = a.catid
LEFT JOIN l52fb_users AS u
on u.id = a.created_by
LEFT JOIN l52fb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN l52fb_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 517
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-13 02:23:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-13 02:23:14')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
| Status | Duration |
|---|---|
| starting | 0.15 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.11 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.22 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.16 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.07 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 12 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
| 11 | ContentModelArticle->getItem() | JROOT/plugins/system/noextlinks/noextlinks.php:624 |
| 10 | PlgSystemNoExtLinks->getCurrentArticle() | JROOT/plugins/system/noextlinks/noextlinks.php:598 |
| 9 | PlgSystemNoExtLinks->checkArticle() | JROOT/plugins/system/noextlinks/noextlinks.php:234 |
| 8 | PlgSystemNoExtLinks->onAfterRender() | Same as call in the line below. |
| 7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 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 l52fb_content AS a
INNER JOIN l52fb_categories AS c
on c.id = a.catid
LEFT JOIN l52fb_users AS u
on u.id = a.created_by
LEFT JOIN l52fb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN l52fb_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 517
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-13 02:23:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-13 02:23:14')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
| Status | Duration |
|---|---|
| starting | 0.19 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.08 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.15 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.13 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 12 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
| 11 | ContentModelArticle->getItem() | JROOT/plugins/system/noextlinks/noextlinks.php:624 |
| 10 | PlgSystemNoExtLinks->getCurrentArticle() | JROOT/plugins/system/noextlinks/noextlinks.php:535 |
| 9 | PlgSystemNoExtLinks->checkCategory() | JROOT/plugins/system/noextlinks/noextlinks.php:234 |
| 8 | PlgSystemNoExtLinks->onAfterRender() | Same as call in the line below. |
| 7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
3 × 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 l52fb_content AS a
INNER JOIN l52fb_categories AS c
on c.id = a.catid
LEFT JOIN l52fb_users AS u
on u.id = a.created_by
LEFT JOIN l52fb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN l52fb_content_rating AS v
ON a.id = v.content_id
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 `l52fb_categories` AS `s`
INNER JOIN `l52fb_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `l52fb_assets`
2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM l52fb_fields AS a
LEFT JOIN `l52fb_languages` AS l
ON l.lang_code = a.language
LEFT JOIN l52fb_users AS uc
ON uc.id=a.checked_out
LEFT JOIN l52fb_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN l52fb_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN l52fb_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `l52fb_fields_categories` AS fc
ON fc.field_id = a.id
2 × SELECT `ip`,`reason`
FROM l52fb_rsfirewall_lists
1 × SELECT *
FROM l52fb_content
1 × SELECT `m`.`tag_id`,`t`.*
FROM `l52fb_contentitem_tag_map` AS m
INNER JOIN `l52fb_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM l52fb_content AS a
LEFT JOIN l52fb_categories AS cc
ON cc.id = a.catid
1 × SELECT `value`
FROM `l52fb_foxcontact_settings`
1 × SELECT *
FROM l52fb_jxtc_ezimg_images
1 × SELECT id,filename
FROM l52fb_jxtc_ezimg_images
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM l52fb_modules AS m
LEFT JOIN l52fb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN l52fb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM l52fb_rsfirewall_exceptions
1 × SELECT `file`
FROM l52fb_rsfirewall_hashes
1 × SELECT `path`
FROM l52fb_rsfirewall_ignored
1 × SELECT b.id
FROM l52fb_usergroups AS a
LEFT JOIN l52fb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `l52fb_viewlevels
1 × SELECT *
FROM l52fb_rsfirewall_configuratio
1 × SELECT `alias`,`catid`
FROM `l52fb_content`
1 × SELECT `session_id`
FROM `l52fb_session`
1 × SELECT *
FROM l52fb_rsfirewall_snapshots
1 × SELECT *
FROM l52fb_rsfirewall_hashes
1 × SELECT *
FROM l52fb_languages
1 × UPDATE l52fb_content
SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
FROM `l52fb_jxtc_ezimg_images
1 × SHOW FULL COLUMNS
FROM `l52fb_content
1 × UPDATE `l52fb_extensions`
SET `params` = '{\"mediaversion\":\"a646cc382fec60f5abafdb3677e68b10\"}'
1 × SHOW FULL COLUMNS
FROM `l52fb_rsfirewall_logs
1 × INSERT INTO `l52fb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('15fd7dae8bdf21d1fe853d119bb4f4aa', 1, 1660357394, 0, '', 0