Картечные патроны.
В целом процесс снаряжения картечных патронов похож на снаряжение дробовых. Однако есть некоторые отличия. Например, может потребоваться увеличить навеску пороха, а на пороховой пыж часто досылается картонная прокладка.
Важно отметить, что все компоненты — гильзы, порох и капсюли — должны быть новыми. Порох необходимо отвешивать с точностью до 0,01 грамма.
Для обеспечения высокой кучности при стрельбе картечью используются различные приспособления. Наиболее часто применяются следующие методы:
1. Стрельба согласованной картечью. Этот метод даёт лучший бой, чем стрельба несогласованной картечью. Определить диаметр согласованной картечи для конкретного ружья можно эмпирическим путём или с помощью калькулятора.
2. Использование различных контейнеров.
3. Пересыпание картечи крахмалом.
Эти методы можно комбинировать.
Укладка картечи столбиками помогает предотвратить перестраивание снаряда в канале ствола. Существует несколько способов укладки:
1. После укладки одного слоя картечи между отдельными картечинами вставляют палочки (например, спички), по длине соответствующие высоте снаряда. Эти палочки удерживают картечины в положении строго друг над другом.
2. Снаряд лучше обернуть бумагой или полиэтиленом, чтобы уменьшить деформацию картечи от соприкосновения с поверхностью канала ствола. Также можно использовать контейнеры.
3. Некоторые охотники изготавливают отдельные трубочки для каждого столбика дроби, а затем склеивают их.
4. Можно использовать обычные дробовые стаканчики, разделив их внутри крест-накрест.
5. Также можно самостоятельно изготовить контейнеры нужной формы из полиэтилена. Контейнеры обычно разрезают на несколько частей, чтобы они распадались при выстреле.
Пересыпание картечи крахмалом обычно применяется в сочетании с предыдущими приёмами. При этом нужно учитывать увеличение массы снаряда за счёт крахмала.
Картечные патроны (если гильзы пластмассовые или бумажные) обычно запрессовываются «звёздочкой».
Картечный снаряд, как правило, имеет большую массу, чем обычный дробовой. Поэтому его приходится облегчать, так как ружья обычно пристреляны на массу дробового снаряда. Для этого удаляют одну или несколько картечин.
Существуют и другие способы улучшения кучности, например, связывание картечи. При этом методе согласовывать картечь не нужно. Капроновая нить нарезается на отрезки по количеству картечин в снаряде. С одной стороны весь пучок нитей связывают общим узлом, а с другой — на каждую нитку насаживают картечину. Затем снаряд упаковывают в цилиндр из фотоплёнки или другого твёрдого материала.
Для охоты на крупного зверя некоторые охотники применяют снаряды из трёх очень крупных (около 12 мм) картечин, упакованных в специальный контейнер или соединённых стальным стержнем, чтобы избежать расклинивающего эффекта.
Важно помнить, что при попытке добиться лучшей кучности при выстреле картечью необходимо проверить максимальные давления, возникающие в стволе при выстреле. В противном случае это может привести к деформации стволов. Также не следует увлекаться усилением заряда пороха, так как это может привести к повреждению стволов.
Снаряжение пулевых патронов.
Пуля братьев Соколовых.
Снаряжение пулевых патронов требует еще большей тщательности, ведь от выстрела пулей зависит порой жизнь охотника, так как объекты охоты зачастую опасны для человека. Крайне желательно при этом, чтобы ружье было пристреляно пулей. При снаряжении пулевых патронов прежде всего следует тщательно подобрать компоненты. Гильза должна быть новой, капсюли и порох принадлежать одной партии. Внутренний диаметр гильзы должен строго соответствовать диаметру канала ствола, а масса пыжей, равно как и пуль, не должна сильно различаться в разных патронах.
Пулям, естественно, уделяется особое внимание. Корпус пули по диаметру должен быть на 0,4— 0,5 мм меньше диаметра самого сильного дульного сужения, а диаметр ведущих ребер не должен отклоняться от фактического диаметра канала ствола более чем на 0,05 мм. Пуля не должна иметь заусенцев, выбоин, вмятин, так как это все влияет на смещение ее центра тяжести от оси симметрии и величину сопротивления головной части пули встречному потоку воздуха. Если пуля имеет полиэтиленовый пыж, то его обтюрирующая часть должна быть на 0,05 мм больше диаметра канала ствола. При наличии войлочного пыжа его высота у всех снаряжаемых пуль должна быть одинаковой. Снаряжение пулевых патронов производится в общих чертах следующим образом: в новую гильзу запрессовывается капсюль "Жевело" (в малых калибрах применяется и "Центробой").
Затем насыпается заряд пороха, отвешенный с точностью до 0,01 г. Пороха нужно брать на 8—10% больше, чем рекомендуется для снаряжения дробового патрона с той же массой снаряда и в тех же условиях. Если в инструкции к пороху указана максимально допустимая масса порохового заряда, то нужно брать несколько меньшее количество пороха и увеличивать его только в случае неудовлетворительного боя, обусловленного его малой навеской (хорошая кучность ниже точки прицеливания). Если же пули ложатся выше точки прицеливания либо разброс их слишком велик, то навеску пороха следует уменьшить. . На порох досылаются картонные прокладки толщиной 2,5—3 мм или полиэтиленовый (реже картонный) обтюратор. Следует помнить, что применение полиэтиленового обтюратора требует уменьшения навески пороха примерно на 0,2 г по сравнению с аналогичным патроном, в котором использованы картонные пыжи-прокладки. На картонную прокладку или обтюратор досылается осаленный основной войлочный пыж, а на него по необходимости дополнительный неосаленный пыж. На войлочном пыже, с верхней его стороны, рекомендуется сделать крестообразный надрез почти на полную глубину, чтобы после вылета из ствола он меньше влиял бы на полет пули. Высота пыжей определяется конструкцией пули; у пуль с хвостовиком-стабилизатором она меньше, чем у пуль, такого хвостовика не имеющих. На пыж досылается пуля, и гильза завальцовывается ручной или настольной закруткой, имеющей в матрице специальное углубление, которое исключает возможность деформации выступающей головной части пули (у Бреннеке, БС, Ильина) при завальцовке.
Пуля Бреннеке
В ружьях с чоковым дульным сужением нередко применяют подкалиберные пули, т.е. пули меньшего калибра (в ружье 12-го калибра — пулю 16-го и т.д.). При использовании подкалиберных пуль их следует каким-либо образом отцентрировать и закрепить в гильзе. Для этого применяют части трубки гильзы меньшего калибра, полиэтиленовый контейнер, полоску бумаги и т.д. Целесообразнее всего в качестве подкалиберной использовать пулю Бреннеке, имеющую довольно большую массу и хвостовик-стабилизатор, облегчающий ее закрепление в гильзе большего калибра
Легкие подкалиберные пули могут служить причиной худшего сгорания бездымного пороха и неполноценных выстрелов. При их снаряжении лучше использовать обтюраторы. Снаряжение патронов нередко применяемой у нас в стране (особенно на периферии) круглой пулей несколько отличается от приведенной схемы. Большинство авторов рекомендует поверх нее устанавливать войлочный пыж высотой не менее 1/2 калибра и уже после этого завальцовывать гильзу.
С нижнего края пыжа нужно срезать фаску в 4—5 мм под углом 45°, чтобы при прохождении канала ствола кромку пыжа не затянуло бы под пулю, т.к. это приведет к разрыву или вздутию ствола. Некоторые авторы, впрочем, считают, что и это не гарантирует безопасности при выстреле, и отрицают возможность установки пыжей поверх круглой пули.
При стрельбе подкалиберной круглой пулей, наиболее часто применяемой охотниками, ее центрируют, используя для этого полоску бумаги с приклеенными к ней ребрышками из спичек или картона, полиэтиленовый контейнер, кусочек промасленной ткани или замши, в который оборачивают пулю, и тд.
Круглые подкалиберные пули, снаряженные в латунные гильзы, центрируют, а затем заливают смесью вазелина и парафина либо воском. Большое разнообразие конструкций пуль определяет и значительные "индивидуальные" отклонения при снаряжении ими патронов. Например, пули, имеющие пыж-стабилизатор большой высоты (Витта, Полева, Ширинского-Шихматова), обычно устанавливают прямо на порох или на картонную прокладку.
Примером пули, требующей особого способа снаряжения патрона, служит пуля Майера.
Пуля Майера
В бумажную гильзу с капсюлем "Жевело" насыпают 2 г пороха "Сокол" (при массе пули 33 г и температуре не ниже —4°С); порох сжимают с усилием 4—5 кг. На порох досылают картонные прокладки общей толщиной 2,5—3 мм, а затем войлочный пыж высотой в полкалибра ствола, разрезанный по высоте на 4 части. На пыж насыпают мелкие опилки, а на них досылают картонную прокладку толщиной 0,6—0,7 мм.
На нее устанавливают еще одну прокладку толщиной 3 мм с диаметром, равным диаметру тела пули без направляющих ребер. Эта прокладка должна стоять строго по центру трубки гильзы. Затем вставляют пулю так, чтобы вышеупомянутая картонная прокладка уменьшенного диаметра не сместилась в сторону, и гильзу завальцовывают. Слой опилок подбирают такой высоты, чтобы на завальцовку осталось 5—6 мм дульца гильзы .
При стрельбе из легких (2,9—3,1 кг для 12-го калибра) ружей патронами, снаряженными таким способом (что было предложено автором пули), достигаются отличные результаты, однако, если пулю Майе-ра снарядить обычным способом, показатели заметно ухудшаются. Некоторые пули (Мак-Элвина, Фостера) хорошо "работают" лишь при использовании их со специально под них изготовленными пыжами.
Охотники нередко самостоятельно не только модифицируют конструкции пуль, но и меняют способ снаряжения пулевых патронов. Как правило, они не достигают показателей лучших, чем при способах, предложенных разработчиками пуль, однако из всякого правила бывают исключения, и эксперименты могут привести к отличным результатам. Но следует помнить, что экспериментировать можно лишь имея достаточный опыт обращения с оружием и боеприпасами.
При этом следует соблюдать большую осторожность. Различные пули можно приобрести в охотничьих магазинах, но выбор и качество их изготовления не всегда отвечают требованиям охотников, а некоторые отличные по своим характеристикам пули отечественной промышленностью не производятся. В связи с этим часть охотников изготавливают пули самостоятельно.
Наиболее проста в изготовлении круглая пуля, и в отдаленных районах Сибири и Дальнего Востока охотники нередко льют или катают круглые пули самостоятельно. Изготовление же пуль других конструкций намного сложнее и требует навыков работы с чертежами и умения пользоваться различными станками, т.к. пулелейки и некоторые пули вытачиваются на токарном станке.
Картечь. Картечь отличается от дроби только размерами. Диаметр картечи более 5 мм. Содержание примесей к свинцу в картечи не превышает 1,5%, т.е. она бывает только мягкой. По последнему ГОСТу (7837-76) диаметр картечи, выпускаемой в нашей стране, должен быть следующий: 5,25; 5,60; 5,70; 5,80; 6,20; 6,50; 6,80; 6,95; 7,15; 7,55; 7,70; 8,00; 8,50; 9,65; 10,00.
Это довольно сильно отличается от использовавшейся в прошлом картечи 6 номеров (I — 10 мм, II — 9 мм, III - 8 мм, IV — 7 мм, V — 6,5 мм, VI — 6 мм), но позволяет лучше согласовывать картечь в патронах разных калибров. Согласованной называется картечь, диаметр которой подобран так, что при укладке одного слоя в дульной части ствола не имеется зазоров между картечинами и каналом ствола.
При использовании диаметр картечи не должен превышать половины диаметра канала ствола, т.е. 10-миллиметровую картечь можно применять лишь в ружьях 10-го калибра и т.п. Это условие может быть нарушено лишь при применении дополнительных приспособлений, исключающих расклинивающий эффект при выстреле (например, использование специальных контейнеров).
Пули.
Для стрельбы по крупному зверю используют пули различной конструкции. Существует большое число типов пуль для охотничьих гладкоствольных ружей, часть которых выпускает отечественная промышленность. Пули нередко изготавливаются и самими охотниками, для чего используют специальные пулелейки различных видов. Ряд охотников-изобретателей и у нас в стране, и за рубежом разрабатывают новые конструкции пуль или усовершенствуют уже имеющиеся.
Описание пуль неизвестной конструкции встречается в литературе довольно часто. Как показывает практика, большинство из них уступает по своим показателям пулям, уже имеющимся в распоряжении охотников. Поэтому из примерно 200 типов пуль, запатентованных в этом столетии, и еще большего числа выпускаемых кустарями, лишь около двух десятков нашли широкое применение в разных странах, в т.ч. и в России.
Для выяснения качества пули для того или иного ружья нужно экспериментировать. Стрельба производится с расстояния 50 м не менее чем по 6 выстрелов из каждого ствола. Качество боя каждого ствола оценивается отдельно. Кроме кучности боя большое значение для характеристики пули имеют ее начальная скорость, падение скорости в полете, энергия удара.
Эти показатели можно выяснить лишь при работе на специальном стенде. Энергия удара пули, называемая также живой силой снаряда, зависит от массы пули и ее скорости в момент поражения цели. Чем выше она, тем выше убойность пули. Однако немаловажное значение имеет и площадь поперечного сечения пули. При равных массах и скоростях пуля с большим поперечным сечением наносит, как правило, большие разрушения, т.е. является более убойной. Повышение убойности часто достигается также особой конструкцией пули — ее способностью легко деформироваться или разворачиваться в теле зверя.
Для характеристики пуль иногда используют один показатель — поперечную нагрузку. Она определяется отношением массы пули к ее поперечному сечению. От поперечной нагрузки зависит падение скорости, а соответственно энергия удара в момент попадания в цель. Материал, из которого изготовлена пуля, сильно влияет на степень ее деформации в момент выстрела, а следовательно, и на ее баллистику. Большинство пуль изготавливают из сплавов на основе свинца с добавками, повышающими его твердость (сурьма, мышьяковистый ангидрид и др.), но не редки и пули из других металлов и сплавов (латунь, сталь, медь).
Лучше всего пулями стрелять из стволов цилиндрической сверловки. Стрельба из чока несколько ухудшает качество выстрела, особенно круглой пулей. Все многообразие выпускаемых пуль можно классифицировать по различным признакам. Обычно их подразделяют на обыкновенные пули, а также на пули стрелочного, турбинного и стрелочно-турбинного типов. Более дробная классификация предложена Д.Поляковым, она основана на принципе стабилизации пули в полете и включает пять групп.
Ниже приведена данная классификация и ее соотношение с четырьмя основными типами:
1.Пули, не имеющие стабилизации в полете (обыкновенные пули).
2. Пули, стабилизирующиеся в полете вращением за счет гироскопического аэродинамического эффекта, создаваемого наружными аэродинамическими наклонными ребрами, с пыжами, жестко прикрепленными к хвостовой части пули, а также смещением центра тяжести к ее головной части (стре-лочно-турбишшй тип).
3. Пули, стабилизирующиеся в полете в основном за счет смещения центра тяжести к головной части, а также иногда и за счет гироскопического аэродинамического эффекта, создаваемого наружными аэродинамическими ребрами (стрелочный, реже (стрел очно-турбинный тип).
4. Пули, стабилизирующиеся в полете вращением за счет ударного аэродинамического эффекта, создаваемого формой пули. В этой группе можно выделить в качестве отдельной подгруппы подкалиберные пули этого же типа (стрелочный тип).
5. Пули, стабилизирующиеся в полете вращением за счет гироскопического аэродинамического эффекта, создаваемого аэродинамическими ребрами, расположенными во внутренних полостях пули (турбинный тип).
Блондо Фостера
Идеал Ильина
"Кировчанка" Майера
Плёва Шаровая
"Спутник" "Вятка"
Следует оговориться, что приведенное выше разделение пуль на различные группы и типы весьма условно. Оно опирается на внешние конструктивные признаки пуль и довольно-таки умозрительные заключения о том, как они должны вести себя во время полета.
Практически же можно считать доказанным, что внешние наклонные ребра не придают пулям вращательного движения, тем более что они, как правило, сминаются при прохождении дульного сужения.
Внутренние ребра в пулях турбинного типа, по некоторым исследованиям, также не обеспечивают вращения, т.к. во внутреннем канале образуется препятствующая ему воздушная пробка. Так что, вероятнее всего, пули любой конструкции, выпущенные из гладкоствольного ружья, не вращаются, и их баллистика зависит от расположения центра тяжести, формы пули и наличия стабилизирующих пыжей.
Designed by www.diablodesign.eu.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1736035736, "last": 1736035736, "now": 1736035736 }, "token": "T4EVVESmpkyIh311QfCHRO3vEBNp8ICj" }, "registry": {}, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "com_mailto": { "links": { "11a1fef1e08e9521476475532e2f7942a53c0864": { "link": "https://zhevelo.com/index.php/2024-04-07-15-48-27/13-2024-04-07-11-42-11/125-snaryazhenie-patronov-kartechyu-i-pulej.html", "expiry": 1736035736 } } } } }
SELECT `data`
FROM `n12lb_session`
WHERE `session_id` = X'6262626536646437613764343939336131346562373766656532333939386139'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_session | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.09 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
executing | 0.00 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Такой же, как вызов в строке ниже |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
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:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `n12lb_session`
WHERE `session_id` = X'6262626536646437613764343939336131346562373766656532333939386139'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_session | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
executing | 0.00 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
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:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
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:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `n12lb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6262626536646437613764343939336131346562373766656532333939386139', 1, 1736035736, 0, '', 0)
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
update | 0.05 ms |
end | 0.00 ms |
query end | 0.03 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
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:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `n12lb_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_extensions | ref | extension | extension | 82 | const | 37 | 100.00 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.12 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.12 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Такой же, как вызов в строке ниже |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `n12lb_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_viewlevels | ALL | NULL | INDEX KEY не используется | NULL | NULL | 5 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.09 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.00 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.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
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:318 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM n12lb_usergroups AS a
LEFT JOIN n12lb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.14 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
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:318 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM n12lb_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_extensions | ref | extension | extension | 82 | const | 137 | 100.00 | Using index condition; Using where; Используется сортировка файлов |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.50 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Такой же, как вызов в строке ниже |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM n12lb_j2store_configurations
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_j2store_configurations | ALL | NULL | INDEX KEY не используется | NULL | NULL | 100 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.01 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.00 ms |
Sending data | 0.68 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_j2store/helpers/config.php:20 |
13 | J2Config->__construct() | JROOT/administrator/components/com_j2store/helpers/config.php:28 |
12 | J2Config::getInstance() | JROOT/administrator/components/com_j2store/helpers/j2store.php:72 |
11 | J2Store::config() | JROOT/plugins/system/j2store/j2store.php:187 |
10 | plgSystemJ2Store->onJ2StoreCronTask() | JROOT/plugins/system/j2store/j2store.php:167 |
9 | plgSystemJ2Store->onAfterInitialise() | Такой же, как вызов в строке ниже |
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:668 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM n12lb_menu AS m
LEFT JOIN n12lb_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 23 | 100.00 | Using index condition; Using where; Используется сортировка файлов |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.12 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.29 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Такой же, как вызов в строке ниже |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `n12lb_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using index condition |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.06 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.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
19 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
18 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Такой же, как вызов в строке ниже |
17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
15 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
14 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
13 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
9 | plgSystemJComments->onAfterRoute() | Такой же, как вызов в строке ниже |
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:1190 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `n12lb_extensions`
SET `params` = '{\"mediaversion\":\"37d41b96153d61dc1d15a1964321b49d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_extensions | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.04 ms |
updating | 0.04 ms |
end | 0.00 ms |
query end | 0.06 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
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/jcomments/jcomments.php:111 |
9 | plgSystemJComments->onAfterRoute() | Такой же, как вызов в строке ниже |
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:1190 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `n12lb_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_jcomments_settings | ref | PRIMARY | PRIMARY | 214 | const,const | 91 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.53 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.14 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/config.php:140 |
15 | JCommentsCfg::_load() | Такой же, как вызов в строке ниже |
14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/classes/config.php:159 |
12 | JCommentsCfg->load() | JROOT/components/com_jcomments/classes/config.php:47 |
11 | JCommentsCfg::getInstance() | JROOT/components/com_jcomments/helpers/system.php:39 |
10 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
9 | plgSystemJComments->onAfterRoute() | Такой же, как вызов в строке ниже |
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:1190 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM n12lb_template_styles as s
LEFT JOIN n12lb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | INDEX KEY не используется | NULL | NULL | 5 | 60.00 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | zarad01_teshagro.s.template,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.15 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.05 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.03 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
11 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/components/com_jcomments/helpers/system.php:46 |
10 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
9 | plgSystemJComments->onAfterRoute() | Такой же, как вызов в строке ниже |
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:1190 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM n12lb_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_languages | ALL | NULL | INDEX KEY не используется | NULL | NULL | 2 | 100.00 | Using where; Используется сортировка файлов |
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.09 ms |
init | 0.01 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.05 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `n12lb_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2store','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper','com_xmap')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 38 | 100.00 | Using index condition |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.13 ms |
init | 0.04 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.13 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.33 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
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:457 |
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:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `n12lb_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_assets | ALL | idx_asset_name,idx_parent_id | INDEX KEY не используется | NULL | NULL | 526 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.38 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
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:457 |
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:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `n12lb_content`
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.33 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.15 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.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.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Sending data | 0.05 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
removing tmp table | 0.11 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
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:328 |
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:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE n12lb_content
SET `hits` = (`hits` + 1)
WHERE `id` = '125'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_content | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.03 ms |
updating | 0.07 ms |
end | 0.00 ms |
query end | 0.04 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1264 |
10 | Joomla\CMS\Table\Table->hit() | 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:702 |
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:225 |
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 n12lb_content AS a
INNER JOIN n12lb_categories AS c
on c.id = a.catid
LEFT JOIN n12lb_users AS u
on u.id = a.created_by
LEFT JOIN n12lb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN n12lb_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 125
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-05 00:08:56')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-05 00:08:56')
AND (a.state = 1 OR a.state =2)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | v | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
Status | Duration |
---|---|
starting | 0.10 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.81 ms |
init | 0.06 ms |
System lock | 0.00 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.07 ms |
end | 0.00 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
12 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
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 `n12lb_categories` AS `s`
INNER JOIN `n12lb_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 13
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Используется сортировка файлов |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX KEY не используется | NULL | NULL | 35 | 40.00 | Using where |
Status | Duration |
---|---|
starting | 0.08 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.11 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
22 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
21 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
20 | ContentRouter->getCategorySegment() | Такой же, как вызов в строке ниже |
19 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
18 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
17 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
16 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
15 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
14 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
13 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
12 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
11 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `n12lb_contentitem_tag_map` AS m
INNER JOIN `n12lb_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 125
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | INDEX KEY не используется | NULL | NULL | 320 | 75.00 | Using where |
1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | zarad01_teshagro.t.id | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.16 ms |
init | 0.04 ms |
System lock | 0.00 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 1.17 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `n12lb_users`
Status | Duration |
---|---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.31 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.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Sending data | 0.07 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
removing tmp table | 0.16 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
23 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
22 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:41 |
21 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:328 |
20 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 |
19 | Joomla\CMS\User\User::getTable() | JROOT/plugins/system/sourcerer/src/Security.php:60 |
18 | RegularLabs\Plugin\System\Sourcerer\Security::set() | JROOT/plugins/system/sourcerer/src/Helper.php:35 |
17 | RegularLabs\Plugin\System\Sourcerer\Helper->onContentPrepare() | Такой же, как вызов в строке ниже |
16 | call_user_func_array() | JROOT/plugins/system/sourcerer/src/Plugin.php:97 |
15 | RegularLabs\Plugin\System\Sourcerer\Plugin->run() | JROOT/plugins/system/sourcerer/sourcerer.php:52 |
14 | PlgSystemSourcerer->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `n12lb_users`
WHERE `id` = 555
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_users | 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.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.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
20 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:87 |
19 | Joomla\CMS\Table\User->load() | JROOT/plugins/system/sourcerer/src/Security.php:62 |
18 | RegularLabs\Plugin\System\Sourcerer\Security::set() | JROOT/plugins/system/sourcerer/src/Helper.php:35 |
17 | RegularLabs\Plugin\System\Sourcerer\Helper->onContentPrepare() | Такой же, как вызов в строке ниже |
16 | call_user_func_array() | JROOT/plugins/system/sourcerer/src/Plugin.php:97 |
15 | RegularLabs\Plugin\System\Sourcerer\Plugin->run() | JROOT/plugins/system/sourcerer/sourcerer.php:52 |
14 | PlgSystemSourcerer->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `g`.`id`,`g`.`title`
FROM `n12lb_usergroups` AS g
INNER JOIN `n12lb_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 555
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | PRIMARY | PRIMARY | 4 | const | 3 | 100.00 | Using index |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.m.group_id | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.07 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 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.02 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
20 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:112 |
19 | Joomla\CMS\Table\User->load() | JROOT/plugins/system/sourcerer/src/Security.php:62 |
18 | RegularLabs\Plugin\System\Sourcerer\Security::set() | JROOT/plugins/system/sourcerer/src/Helper.php:35 |
17 | RegularLabs\Plugin\System\Sourcerer\Helper->onContentPrepare() | Такой же, как вызов в строке ниже |
16 | call_user_func_array() | JROOT/plugins/system/sourcerer/src/Plugin.php:97 |
15 | RegularLabs\Plugin\System\Sourcerer\Plugin->run() | JROOT/plugins/system/sourcerer/sourcerer.php:52 |
14 | PlgSystemSourcerer->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `n12lb_users`
WHERE `id` = 555
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_users | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
24 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:87 |
23 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 |
22 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
21 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
20 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
19 | Joomla\CMS\Factory::getUser() | JROOT/plugins/system/sourcerer/src/Security.php:64 |
18 | RegularLabs\Plugin\System\Sourcerer\Security::set() | JROOT/plugins/system/sourcerer/src/Helper.php:35 |
17 | RegularLabs\Plugin\System\Sourcerer\Helper->onContentPrepare() | Такой же, как вызов в строке ниже |
16 | call_user_func_array() | JROOT/plugins/system/sourcerer/src/Plugin.php:97 |
15 | RegularLabs\Plugin\System\Sourcerer\Plugin->run() | JROOT/plugins/system/sourcerer/sourcerer.php:52 |
14 | PlgSystemSourcerer->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `g`.`id`,`g`.`title`
FROM `n12lb_usergroups` AS g
INNER JOIN `n12lb_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 555
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | PRIMARY | PRIMARY | 4 | const | 3 | 100.00 | Using index |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.m.group_id | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 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.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
24 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:112 |
23 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 |
22 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
21 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
20 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
19 | Joomla\CMS\Factory::getUser() | JROOT/plugins/system/sourcerer/src/Security.php:64 |
18 | RegularLabs\Plugin\System\Sourcerer\Security::set() | JROOT/plugins/system/sourcerer/src/Helper.php:35 |
17 | RegularLabs\Plugin\System\Sourcerer\Helper->onContentPrepare() | Такой же, как вызов в строке ниже |
16 | call_user_func_array() | JROOT/plugins/system/sourcerer/src/Plugin.php:97 |
15 | RegularLabs\Plugin\System\Sourcerer\Plugin->run() | JROOT/plugins/system/sourcerer/sourcerer.php:52 |
14 | PlgSystemSourcerer->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM n12lb_user_usergroup_map AS map
LEFT JOIN n12lb_usergroups AS a
ON a.id = map.group_id
LEFT JOIN n12lb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 555
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | map | ref | PRIMARY | PRIMARY | 4 | const | 3 | 100.00 | Using index |
1 | SIMPLE | a | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.map.group_id | 1 | 100.00 | NULL |
1 | SIMPLE | b | ALL | idx_usergroup_nested_set_lookup | INDEX KEY не используется | NULL | NULL | 9 | 100.00 | Range checked for each record (index map: 0x10) |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
21 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
20 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/User/User.php:480 |
19 | Joomla\CMS\User\User->getAuthorisedGroups() | JROOT/plugins/system/sourcerer/src/Security.php:67 |
18 | RegularLabs\Plugin\System\Sourcerer\Security::set() | JROOT/plugins/system/sourcerer/src/Helper.php:35 |
17 | RegularLabs\Plugin\System\Sourcerer\Helper->onContentPrepare() | Такой же, как вызов в строке ниже |
16 | call_user_func_array() | JROOT/plugins/system/sourcerer/src/Plugin.php:97 |
15 | RegularLabs\Plugin\System\Sourcerer\Plugin->run() | JROOT/plugins/system/sourcerer/sourcerer.php:52 |
14 | PlgSystemSourcerer->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
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 n12lb_fields AS a
LEFT JOIN `n12lb_languages` AS l
ON l.lang_code = a.language
LEFT JOIN n12lb_users AS uc
ON uc.id=a.checked_out
LEFT JOIN n12lb_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN n12lb_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN n12lb_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `n12lb_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 (13,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Используется сортировка файлов |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | zarad01_teshagro.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.a.id | 1 | 100.00 | Using where; Using index; Distinct |
Status | Duration |
---|---|
starting | 0.10 ms |
checking permissions | 0.02 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.21 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.36 ms |
Creating sort index | 0.02 ms |
end | 0.00 ms |
removing tmp table | 0.09 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 |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
14 | PlgSystemFields->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW TABLES
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 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 |
checking permissions | 0.32 ms |
Sending data | 0.06 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.01 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
22 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 |
21 | JDatabaseDriverMysqli->getTableList() | JROOT/libraries/f0f/database/driver/joomla.php:251 |
20 | F0FDatabaseDriverJoomla->getTableList() | JROOT/libraries/f0f/table/table.php:2082 |
19 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:536 |
18 | F0FTable->__construct() | JROOT/administrator/components/com_j2store/tables/product.php:66 |
17 | J2StoreTableProduct->__construct() | JROOT/libraries/f0f/table/table.php:433 |
16 | F0FTable::getAnInstance() | JROOT/plugins/content/j2store/j2store.php:92 |
15 | plgContentJ2Store->defaultPosition() | JROOT/plugins/content/j2store/j2store.php:70 |
14 | plgContentJ2Store->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `n12lb_j2store_products`
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.23 ms |
init | 0.00 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.06 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.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 |
Sending data | 0.04 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.08 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
21 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/f0f/database/driver/joomla.php:229 |
20 | F0FDatabaseDriverJoomla->getTableColumns() | JROOT/libraries/f0f/table/table.php:2162 |
19 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:536 |
18 | F0FTable->__construct() | JROOT/administrator/components/com_j2store/tables/product.php:66 |
17 | J2StoreTableProduct->__construct() | JROOT/libraries/f0f/table/table.php:433 |
16 | F0FTable::getAnInstance() | JROOT/plugins/content/j2store/j2store.php:92 |
15 | plgContentJ2Store->defaultPosition() | JROOT/plugins/content/j2store/j2store.php:70 |
14 | plgContentJ2Store->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `n12lb_j2store_productimages`
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.20 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Opening tables | 0.05 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 |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
removing tmp table | 0.07 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/f0f/database/driver/joomla.php:229 |
21 | F0FDatabaseDriverJoomla->getTableColumns() | JROOT/libraries/f0f/table/table.php:2162 |
20 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:2360 |
19 | F0FTable->getQueryJoinFields() | JROOT/libraries/f0f/table/table.php:539 |
18 | F0FTable->__construct() | JROOT/administrator/components/com_j2store/tables/product.php:66 |
17 | J2StoreTableProduct->__construct() | JROOT/libraries/f0f/table/table.php:433 |
16 | F0FTable::getAnInstance() | JROOT/plugins/content/j2store/j2store.php:92 |
15 | plgContentJ2Store->defaultPosition() | JROOT/plugins/content/j2store/j2store.php:70 |
14 | plgContentJ2Store->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `n12lb_j2store_manufacturers`
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.20 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.00 ms |
executing | 0.00 ms |
Opening tables | 0.05 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 |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.07 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/f0f/database/driver/joomla.php:229 |
21 | F0FDatabaseDriverJoomla->getTableColumns() | JROOT/libraries/f0f/table/table.php:2162 |
20 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:2360 |
19 | F0FTable->getQueryJoinFields() | JROOT/libraries/f0f/table/table.php:539 |
18 | F0FTable->__construct() | JROOT/administrator/components/com_j2store/tables/product.php:66 |
17 | J2StoreTableProduct->__construct() | JROOT/libraries/f0f/table/table.php:433 |
16 | F0FTable::getAnInstance() | JROOT/plugins/content/j2store/j2store.php:92 |
15 | plgContentJ2Store->defaultPosition() | JROOT/plugins/content/j2store/j2store.php:70 |
14 | plgContentJ2Store->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `n12lb_j2store_vendors`
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.21 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.00 ms |
preparing | 0.00 ms |
executing | 0.00 ms |
Opening tables | 0.05 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 |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.07 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/f0f/database/driver/joomla.php:229 |
21 | F0FDatabaseDriverJoomla->getTableColumns() | JROOT/libraries/f0f/table/table.php:2162 |
20 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:2360 |
19 | F0FTable->getQueryJoinFields() | JROOT/libraries/f0f/table/table.php:539 |
18 | F0FTable->__construct() | JROOT/administrator/components/com_j2store/tables/product.php:66 |
17 | J2StoreTableProduct->__construct() | JROOT/libraries/f0f/table/table.php:433 |
16 | F0FTable::getAnInstance() | JROOT/plugins/content/j2store/j2store.php:92 |
15 | plgContentJ2Store->defaultPosition() | JROOT/plugins/content/j2store/j2store.php:70 |
14 | plgContentJ2Store->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `n12lb_j2store_addresses`
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.21 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.00 ms |
preparing | 0.00 ms |
executing | 0.00 ms |
Opening tables | 0.05 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.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 |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.08 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/f0f/database/driver/joomla.php:229 |
21 | F0FDatabaseDriverJoomla->getTableColumns() | JROOT/libraries/f0f/table/table.php:2162 |
20 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:2360 |
19 | F0FTable->getQueryJoinFields() | JROOT/libraries/f0f/table/table.php:539 |
18 | F0FTable->__construct() | JROOT/administrator/components/com_j2store/tables/product.php:66 |
17 | J2StoreTableProduct->__construct() | JROOT/libraries/f0f/table/table.php:433 |
16 | F0FTable::getAnInstance() | JROOT/plugins/content/j2store/j2store.php:92 |
15 | plgContentJ2Store->defaultPosition() | JROOT/plugins/content/j2store/j2store.php:70 |
14 | plgContentJ2Store->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT n12lb_j2store_products.*,`n12lb_j2store_productimages`.`j2store_productimage_id`,`n12lb_j2store_productimages`.`main_image`,`n12lb_j2store_productimages`.`main_image_alt`,`n12lb_j2store_productimages`.`thumb_image`,`n12lb_j2store_productimages`.`thumb_image_alt`,`n12lb_j2store_productimages`.`additional_images`,`n12lb_j2store_productimages`.`additional_images_alt`,`n12lb_j2store_manufacturers`.`brand_desc_id`,`n12lb_j2store_addresses`.`first_name` AS manufacturer_first_name,`n12lb_j2store_addresses`.`last_name` AS manufacturer_last_name,`n12lb_j2store_addresses`.`company` AS manufacturer
FROM n12lb_j2store_products
LEFT JOIN `n12lb_j2store_productimages`
ON `n12lb_j2store_products`.`j2store_product_id` = `n12lb_j2store_productimages`.`product_id`
LEFT JOIN `n12lb_j2store_manufacturers`
ON `n12lb_j2store_products`.`manufacturer_id` = `n12lb_j2store_manufacturers`.`j2store_manufacturer_id`
LEFT JOIN `n12lb_j2store_vendors`
ON `n12lb_j2store_products`.`vendor_id` = `n12lb_j2store_vendors`.`j2store_vendor_id`
LEFT JOIN `n12lb_j2store_addresses`
ON `n12lb_j2store_manufacturers`.`address_id` = `n12lb_j2store_addresses`.`j2store_address_id`
WHERE `n12lb_j2store_products`.`product_source` = 'com_content'
AND `n12lb_j2store_products`.`product_source_id` = '125'
AND `n12lb_j2store_products`.`enabled` = '1'
AND `n12lb_j2store_products`.`visibility` = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | INDEX KEY не используется | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
starting | 0.05 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.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
executing | 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.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
20 | JDatabaseDriver->loadAssoc() | JROOT/libraries/f0f/database/driver/joomla.php:291 |
19 | F0FDatabaseDriverJoomla->loadAssoc() | JROOT/libraries/f0f/table/table.php:949 |
18 | F0FTable->load() | JROOT/administrator/components/com_j2store/tables/product.php:94 |
17 | J2StoreTableProduct->load() | JROOT/administrator/components/com_j2store/tables/product.php:197 |
16 | J2StoreTableProduct->get_product_by_source() | JROOT/plugins/content/j2store/j2store.php:94 |
15 | plgContentJ2Store->defaultPosition() | JROOT/plugins/content/j2store/j2store.php:70 |
14 | plgContentJ2Store->onContentPrepare() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
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 n12lb_content AS a
LEFT JOIN n12lb_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 13
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-01-05 00:08:56')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-05 00:08:56')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 43 | 100.00 | Using where; Используется сортировка файлов |
1 | SIMPLE | cc | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.00 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.40 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/pagenavigation/pagenavigation.php:161 |
14 | PlgContentPagenavigation->onContentBeforeDisplay() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:199 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM `n12lb_jcomments_blacklist`
WHERE `ip` = '3.135.209.66' OR `ip` = '3.135.209.*' OR `ip` = '3.135.*.*' OR `ip` = '3.*.*.*'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_jcomments_blacklist | index | idx_ip | idx_ip | 119 | NULL | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.07 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
20 | JDatabaseDriver->loadResult() | JROOT/components/com_jcomments/classes/security.php:154 |
19 | JCommentsSecurity::checkBlacklist() | JROOT/components/com_jcomments/classes/acl.php:76 |
18 | JCommentsACL->JCommentsACL() | JROOT/components/com_jcomments/classes/factory.php:274 |
17 | JCommentsFactory::getACL() | JROOT/components/com_jcomments/jcomments.php:190 |
16 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
15 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
14 | plgContentJComments->onContentAfterDisplay() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `n12lb_jcomments_objects`
WHERE `object_id` = '125'
AND `object_group` = 'com_content'
AND `lang` = 'ru-RU'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_jcomments_objects | ref | idx_object | idx_object | 833 | const,const,const | 1 | 100.00 | Using index condition |
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.06 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
24 | JDatabaseDriver->loadObject() | JROOT/components/com_jcomments/models/object.php:28 |
23 | JCommentsModelObject::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:117 |
22 | JCommentsObjectHelper::fetchObjectInfo() | Такой же, как вызов в строке ниже |
21 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
20 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/helpers/object.php:159 |
19 | JCommentsObjectHelper::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:46 |
18 | JCommentsObjectHelper::getLink() | JROOT/components/com_jcomments/classes/factory.php:255 |
17 | JCommentsFactory::getTemplate() | JROOT/components/com_jcomments/jcomments.php:194 |
16 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
15 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
14 | plgContentJComments->onContentAfterDisplay() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT count(*)
FROM n12lb_jcomments AS c
WHERE c.object_id = 125
AND c.object_group = 'com_content'
AND c.published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ref | idx_object | idx_object | 772 | const,const,const | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.05 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 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.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/components/com_jcomments/models/jcomments.php:35 |
18 | JCommentsModel::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:1306 |
17 | JComments::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:224 |
16 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
15 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
14 | plgContentJComments->onContentAfterDisplay() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted ,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM n12lb_jcomments AS c
LEFT JOIN n12lb_jcomments_votes AS v
ON c.id = v.commentid
AND v.userid = 0
AND v.ip = '3.135.209.66'
WHERE c.object_id = 125
AND c.object_group = 'com_content'
AND c.published = 1
ORDER BY c.parent, c.date ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ref | idx_object | idx_object | 772 | const,const,const | 1 | 100.00 | Using index condition; Using where; Используется сортировка файлов |
1 | SIMPLE | v | ref | idx_comment,idx_user | idx_comment | 8 | zarad01_teshagro.c.id,const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.06 ms |
init | 0.03 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 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.02 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/models/jcomments.php:80 |
18 | JCommentsModel::getCommentsList() | JROOT/components/com_jcomments/jcomments.php:792 |
17 | JComments::getCommentsTree() | JROOT/components/com_jcomments/jcomments.php:269 |
16 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
15 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
14 | plgContentJComments->onContentAfterDisplay() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`
FROM `n12lb_jcomments_mailq`
ORDER BY `priority` desc
LIMIT 10
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_jcomments_mailq | index | NULL | idx_priority | 1 | NULL | 1 | 100.00 | Using index |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.07 ms |
init | 0.01 ms |
System lock | 0.02 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
Sorting result | 0.00 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.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/helpers/notification.php:78 |
17 | JCommentsNotificationHelper::send() | JROOT/components/com_jcomments/jcomments.php:289 |
16 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
15 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
14 | plgContentJComments->onContentAfterDisplay() | Такой же, как вызов в строке ниже |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
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 n12lb_modules AS m
LEFT JOIN n12lb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN n12lb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-01-05 00:08:56')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-05 00:08:56')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 107 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 12 | 100.00 | Using index condition; Using where; Используется сортировка файлов |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.m.id | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | zarad01_teshagro.m.module,const | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.13 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.17 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | Такой же, как вызов в строке ниже |
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:441 |
12 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
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:601 |
9 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/dd_wildnature_63/library/Artx/Page.php:46 |
8 | ArtxPage->containsModules() | JROOT/templates/dd_wildnature_63/index.php:126 |
7 | require JROOT/templates/dd_wildnature_63/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
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:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM n12lb_banners
WHERE '2025-01-05 00:08:56' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | INDEX KEY не используется | NULL | NULL | NULL | NULL | Impossible WHERE |
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.09 ms |
init | 0.03 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
executing | 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.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_banners/helpers/banners.php:79 |
11 | BannersHelper::updateReset() | JROOT/modules/mod_banners/mod_banners.php:19 |
10 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM n12lb_banners as a
LEFT JOIN n12lb_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-05 00:08:56')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-05 00:08:56')
AND (a.imptotal = 0 OR a.impmade < a.imptotal)
AND a.catid IN (36)
ORDER BY a.sticky DESC,a.ordering
LIMIT 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_state,idx_banner_catid | idx_banner_catid | 4 | const | 1 | 100.00 | Using where; Используется сортировка файлов |
1 | SIMPLE | cl | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.a.cid | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.29 ms |
init | 0.03 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.05 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_banners/models/banners.php:222 |
12 | BannersModelBanners->getItems() | JROOT/modules/mod_banners/helper.php:48 |
11 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
10 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE n12lb_banners
SET impmade = (impmade + 1)
WHERE id IN (7)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_banners | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.02 ms |
updating | 0.03 ms |
end | 0.00 ms |
query end | 0.03 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/components/com_banners/models/banners.php:268 |
12 | BannersModelBanners->impress() | JROOT/modules/mod_banners/helper.php:54 |
11 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
10 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM n12lb_content AS a
LEFT JOIN n12lb_categories AS c
ON c.id = a.catid
LEFT JOIN n12lb_users AS ua
ON ua.id = a.created_by
LEFT JOIN n12lb_users AS uam
ON uam.id = a.modified_by
LEFT JOIN n12lb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN n12lb_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (24,13,30,11,15,16,17,18,19,20,21)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-05 00:08:56')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-05 00:08:56')
ORDER BY a.created desc
LIMIT 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_state | 1 | const | 199 | 100.00 | Using where; Используется сортировка файлов |
1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | zarad01_teshagro.a.catid | 1 | 100.00 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.a.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.a.modified_by | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.c.parent_id | 1 | 100.00 | Using where |
1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | zarad01_teshagro.a.id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.12 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.02 ms |
init | 0.07 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.90 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
14 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
13 | ContentModelArticles->getItems() | JROOT/modules/mod_bt_contentslider/classes/content.php:160 |
12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:69 |
11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
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 `n12lb_categories` AS `s`
INNER JOIN `n12lb_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 20
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Используется сортировка файлов |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX KEY не используется | NULL | NULL | 35 | 48.57 | Using where |
Status | Duration |
---|---|
starting | 0.09 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.10 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.08 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
22 | ContentRouter->getCategorySegment() | Такой же, как вызов в строке ниже |
21 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_bt_contentslider/classes/content.php:208 |
12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:69 |
11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
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 `n12lb_categories` AS `s`
INNER JOIN `n12lb_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 16
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Используется сортировка файлов |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX KEY не используется | NULL | NULL | 35 | 48.57 | Using where |
Status | Duration |
---|---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.09 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.07 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
22 | ContentRouter->getCategorySegment() | Такой же, как вызов в строке ниже |
21 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_bt_contentslider/classes/content.php:208 |
12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:69 |
11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
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 `n12lb_categories` AS `s`
INNER JOIN `n12lb_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 21
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Используется сортировка файлов |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX KEY не используется | NULL | NULL | 35 | 48.57 | Using where |
Status | Duration |
---|---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.07 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
22 | ContentRouter->getCategorySegment() | Такой же, как вызов в строке ниже |
21 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_bt_contentslider/classes/content.php:208 |
12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:69 |
11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
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 `n12lb_categories` AS `s`
INNER JOIN `n12lb_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 11
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Используется сортировка файлов |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX KEY не используется | NULL | NULL | 35 | 48.57 | Using where |
Status | Duration |
---|---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.08 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
22 | ContentRouter->getCategorySegment() | Такой же, как вызов в строке ниже |
21 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_bt_contentslider/classes/content.php:208 |
12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:69 |
11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM n12lb_banners
WHERE '2025-01-05 00:08:56' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | INDEX KEY не используется | NULL | NULL | NULL | NULL | Impossible WHERE |
Status | Duration |
---|---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
executing | 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.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_banners/helpers/banners.php:79 |
11 | BannersHelper::updateReset() | JROOT/modules/mod_banners/mod_banners.php:19 |
10 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM n12lb_banners as a
LEFT JOIN n12lb_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-05 00:08:56')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-05 00:08:56')
AND (a.imptotal = 0 OR a.impmade < a.imptotal)
AND a.catid IN (28)
ORDER BY a.sticky DESC,a.ordering
LIMIT 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_state,idx_banner_catid | idx_state | 1 | const | 3 | 100.00 | Using where; Using temporary; Используется сортировка файлов |
1 | SIMPLE | cl | ALL | PRIMARY | INDEX KEY не используется | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
Status | Duration |
---|---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.09 ms |
preparing | 0.04 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.37 ms |
Creating sort index | 0.04 ms |
end | 0.00 ms |
removing tmp table | 0.27 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 |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_banners/models/banners.php:222 |
12 | BannersModelBanners->getItems() | JROOT/modules/mod_banners/helper.php:48 |
11 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
10 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE n12lb_banners
SET impmade = (impmade + 1)
WHERE id IN (1,2)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_banners | range | PRIMARY | PRIMARY | 4 | const | 2 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.03 ms |
updating | 0.07 ms |
end | 0.00 ms |
query end | 0.04 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/components/com_banners/models/banners.php:268 |
12 | BannersModelBanners->impress() | JROOT/modules/mod_banners/helper.php:54 |
11 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
10 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE n12lb_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=1
AND track_date='2025-01-05 00:00:00'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | n12lb_banner_tracks | range | PRIMARY,idx_track_date,idx_track_type,idx_banner_id | PRIMARY | 13 | const,const,const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.28 ms |
init | 0.01 ms |
System lock | 0.06 ms |
updating | 0.03 ms |
end | 0.00 ms |
query end | 0.03 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/components/com_banners/models/banners.php:306 |
12 | BannersModelBanners->impress() | JROOT/modules/mod_banners/helper.php:54 |
11 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
10 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
5 × 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 `n12lb_categories` AS `s`
INNER JOIN `n12lb_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 `n12lb_assets`
2 × SELECT *
FROM `n12lb_users`
2 × SELECT *
FROM n12lb_banners
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `n12lb_extensions`
2 × SELECT `g`.`id`,`g`.`title`
FROM `n12lb_usergroups` AS g
INNER JOIN `n12lb_user_usergroup_map` AS m
ON m.group_id = g.id
2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM n12lb_banners as a
LEFT JOIN n12lb_banner_clients AS cl
ON cl.id = a.cid
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 n12lb_content AS a
LEFT JOIN n12lb_categories AS cc
ON cc.id = a.catid
1 × SELECT n12lb_j2store_products.*,`n12lb_j2store_productimages`.`j2store_productimage_id`,`n12lb_j2store_productimages`.`main_image`,`n12lb_j2store_productimages`.`main_image_alt`,`n12lb_j2store_productimages`.`thumb_image`,`n12lb_j2store_productimages`.`thumb_image_alt`,`n12lb_j2store_productimages`.`additional_images`,`n12lb_j2store_productimages`.`additional_images_alt`,`n12lb_j2store_manufacturers`.`brand_desc_id`,`n12lb_j2store_addresses`.`first_name` AS manufacturer_first_name,`n12lb_j2store_addresses`.`last_name` AS manufacturer_last_name,`n12lb_j2store_addresses`.`company` AS manufacturer
FROM n12lb_j2store_products
LEFT JOIN `n12lb_j2store_productimages`
ON `n12lb_j2store_products`.`j2store_product_id` = `n12lb_j2store_productimages`.`product_id`
LEFT JOIN `n12lb_j2store_manufacturers`
ON `n12lb_j2store_products`.`manufacturer_id` = `n12lb_j2store_manufacturers`.`j2store_manufacturer_id`
LEFT JOIN `n12lb_j2store_vendors`
ON `n12lb_j2store_products`.`vendor_id` = `n12lb_j2store_vendors`.`j2store_vendor_id`
LEFT JOIN `n12lb_j2store_addresses`
ON `n12lb_j2store_manufacturers`.`address_id` = `n12lb_j2store_addresses`.`j2store_address_id`
1 × SELECT COUNT(*)
FROM `n12lb_jcomments_blacklist`
1 × SELECT count(*)
FROM n12lb_jcomments AS c
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM n12lb_modules AS m
LEFT JOIN n12lb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN n12lb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM n12lb_content AS a
LEFT JOIN n12lb_categories AS c
ON c.id = a.catid
LEFT JOIN n12lb_users AS ua
ON ua.id = a.created_by
LEFT JOIN n12lb_users AS uam
ON uam.id = a.modified_by
LEFT JOIN n12lb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN n12lb_content_rating AS v
ON a.id = v.content_id
1 × SELECT `id`
FROM `n12lb_jcomments_mailq`
1 × SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted ,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM n12lb_jcomments AS c
LEFT JOIN n12lb_jcomments_votes AS v
ON c.id = v.commentid
AND v.userid = 0
AND v.ip = '3.135.209.66'
1 × 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 n12lb_fields AS a
LEFT JOIN `n12lb_languages` AS l
ON l.lang_code = a.language
LEFT JOIN n12lb_users AS uc
ON uc.id=a.checked_out
LEFT JOIN n12lb_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN n12lb_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN n12lb_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `n12lb_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT *
FROM `n12lb_jcomments_objects`
1 × SELECT `m`.`tag_id`,`t`.*
FROM `n12lb_contentitem_tag_map` AS m
INNER JOIN `n12lb_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM n12lb_extensions
1 × SELECT *
FROM n12lb_j2store_configuration
1 × SELECT b.id
FROM n12lb_usergroups AS a
LEFT JOIN n12lb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `n12lb_viewlevels
1 × SELECT `session_id`
FROM `n12lb_session`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM n12lb_menu AS m
LEFT JOIN n12lb_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM `n12lb_jcomments_settings`
1 × SELECT `data`
FROM `n12lb_session`
1 × 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 n12lb_content AS a
INNER JOIN n12lb_categories AS c
on c.id = a.catid
LEFT JOIN n12lb_users AS u
on u.id = a.created_by
LEFT JOIN n12lb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN n12lb_content_rating AS v
ON a.id = v.content_id
1 × SELECT *
FROM n12lb_languages
1 × SELECT id, home, template, s.params
FROM n12lb_template_styles as s
LEFT JOIN n12lb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT b.id
FROM n12lb_user_usergroup_map AS map
LEFT JOIN n12lb_usergroups AS a
ON a.id = map.group_id
LEFT JOIN n12lb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
2 × UPDATE n12lb_banners
SET impmade = (impmade + 1)
1 × SHOW FULL COLUMNS
FROM `n12lb_j2store_manufacturers
1 × SHOW FULL COLUMNS
FROM `n12lb_j2store_vendors
1 × SHOW FULL COLUMNS
FROM `n12lb_j2store_addresses
1 × SHOW FULL COLUMNS
FROM `n12lb_j2store_productimages
1 × UPDATE n12lb_banner_tracks
SET `count` = (`count` + 1)
1 × SHOW FULL COLUMNS
FROM `n12lb_j2store_products
1 × SHOW FULL COLUMNS
FROM `n12lb_content
1 × UPDATE `n12lb_extensions`
SET `params` = '{\"mediaversion\":\"37d41b96153d61dc1d15a1964321b49d\"}'
1 × UPDATE n12lb_content
SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
FROM `n12lb_users
1 × SHOW TABLE
1 × INSERT INTO `n12lb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6262626536646437613764343939336131346562373766656532333939386139', 1, 1736035736, 0, '', 0
Комментарии
RSS лента комментариев этой записи