Онлайн курс. Повышение квалификации

Материальная мотивация персонала

Станьте профессионалом в сфере материального стимулирования сотрудников. Вы узнаете, как построить справедливую систему оплаты труда, ставить цели и определять ключевые показатели эффективности (KPI), а также внедрять системы управления результативностью. Эти умения помогут вам обеспечить стабильное развитие компании за счёт повышения производительности и уровня удовлетворённости работников.

Чему вы научитесь?

  • Разрабатывать и внедрять систему грейдирования должностей для повышения эффективности управления персоналом
  • Оптимизировать процесс вознаграждения сотрудников на основе их результативности и ключевых показателей эффективности (KPI)
  • Разрабатывать и внедрять системы премирования, основанные на сбалансированных показателях (BSC)
  • Управлять эффективностью сотрудников с использованием методологии Performance Management
  • Применять современные подходы к анализу и оценке должностей в компании

 

Стоимость курса
45,000 рублей
16 ак. часа
2 дня обучения c 09:00 до 16:00
14.05.2025 - 15.05.2025
14.05.2025 - 15.05.2025
03.09.2025 - 04.09.2025
17.12.2025 - 18.12.2025
Курс прошли: 3458 человек
Зарегистрироваться на курс
Длительность обучения
16 ак. часа
2 дня обучения c 09:00 до 16:00
Лицензия и ФРДО
РШУ имеет государственную лицензию лицензию на оказание образовательного услуг №020945
Гарантия качества
Член российской ассоциации бизнес-образования
Документ об образовании
Документ об образовании
Установленного государством образца
70% практики и 30% теории на курсе
85% клиентов возвращаются к нам вновь
95% слушателей отмечают удобство обучения на курсах
72% выпускников продвинулись по карьерной лестнице
93% слушателей используют полученные знания на практике
87% наших преподавателей являются действующими специалистами ведущих компаний
Кому подойдет?
Для компании
Внедрение системы грейдирования, обеспечивающей справедливость и прозрачность в оплате труда Разработка систем премирования и KPI, ориентированных на достижение целей компании Внедрение систем управления эффективностью (Performance Management) для повышения результативности сотрудников
Для руководителя
Освоение методологии Performance Management для эффективного управления персоналом Разработка систем премирования и компенсаций, основанных на достижении KPI Разработка и внедрение сбалансированных показателей (BSC) для повышения эффективности управления
Для специалиста
Получение знаний о грейдировании должностей и их связи с карьерным ростом Освоение принципов разработки и внедрения систем премирования и KPI Освоение методик Performance Management и их применения на практике
Этапы обучения
1
Начало обучения. Ознакомление с процессом обучения.
2
Самостоятельное изучение теоретического материала в соответствии с учебным планом.
3
Текущий контроль знаний.
4
Промежуточная аттестация.
5
Итоговая аттестация.
Программа курса
Развернуть всю программу
01 Система грейдирования должностей
  • Разработка системы грейдов на предприятии, преимущества и ограничения метода. 
  • Разные подходы к грейдированию. Алгоритм разработки системы грейдов. 
  • Подготовка к грейдированию. Описание должности. Требования к описанию. 
  • Практикум: «Подготовка к грейдированию. Анализ должностей». 
  • Определение ценности должности через балльно-факторную оценку должностей. 
  • Практикум: «Подготовка к грейдированию. Проведение оценки должностей по балльно-факторному методу». 
  • Построение системы грейдов. Оптимизация постоянной части заработной платы на основе результатов грейдирования.
  • Методы грейдирования. Определение количества грейдов для компании. Матрица грейдов. 
  • Выбор компенсационной политики оплаты труда относительно рынка.
  • Определение величины окладов в зависимости от грейда. Анализ рынка. Построение вилок окладов.  
  • Типы грейдов. Преимущества и недостатки. Опыт применения и результаты внедрения системы грейдов в российских и зарубежных компаниях.
  • Изменение зарплатных диапазонов, пересмотр и индексация
  • Внедрение системы грейдов в компании. 
  • Особенности процесса коммуникации
  • Практикум: «Разработка коммуникационной кампании».
02 Разработка системы премирования. Система управления эффективностью Perfomance Management. Система сбалансированных показателей BSC
  • Разработка целей и KPI по методологии BSC.
  • Алгоритм разработки эффективной системы вознаграждения. Разработка карты целей компании и ССП – сбалансированной системы показателей с учетом причинно-следственных связей. 
  • Каких финансовых показателей Вы хотите достичь? Разработка целей и показателей составляющей. 
  • Цели и показатели клиентской составляющей.
  • Какие внутренние бизнес-процессы необходимо улучшить. 
  • Разработка таблицы ССП – сбалансированной системы показателей.
  • Разработка сбалансированных таблиц целей и KPI для топ-менеджеров как основа для оценки результативности и вознаграждения.
  • Примеры сбалансированных таблиц целей и KPI для руководителей. 
  • Внедрение PM – управление эффективностью. Разработка эффективной системы вознаграждения по результатам на основе KPI для основных подразделений (производство, продажи).
  • Основные принципы системы Performance Management – управление эффективностью. 
  • Определение результативности сотрудника. Связь результативности с размером вознаграждения.
  • Пример расчета CSI-индекса удовлетворенности внутренних клиентов. 
  • Таблицы целей и KPI для коммерческих подразделений. Расчет результативности и размера вознаграждения на примере руководителя отдела продаж. 
  • Таблицы целей и KPI для производственных подразделений. Расчет результативности и размера вознаграждения на примере начальника цеха. 
  • 2 подхода к формированию таблиц целей. Какой выбрать. Преимущества и недостатки. 
  • Таблицы вознаграждения в зависимости от результативности.
  • Разработка эффективной системы вознаграждения на основе KPI для поддерживающих подразделений
  • Алгоритм разработки целей и KPI для поддерживающих подразделений. 
  • Формулы расчета % выполнения целей и KPI. Пример расчета СSI-индекса удовлетворенности внутренних клиентов.
  • Пример расчета результативности и размера вознаграждения для директора по персоналу, менеджера по персоналу, менеджера по подбору персонала и др. 
  • Примеры таблиц целей и КPI для поддерживающих подразделений: руководителя отдела закупки, главного бухгалтера, руководителя отдела маркетинга, ИТ и других.
  • Пример расчета размера вознаграждения по результатам (KPI) и компетенциям.
  • Практикум: «Работа в группах. Разработка таблиц целей и KPI и расчет размера вознаграждения».
Запросить коммерческое предложение
Также вы можете запросить адресное коммерческое предложение (конкретно на вашу организацию). Для этого нажмите здесь
Преподаватели
Дьякова Дина Юрьевна
Дьякова Дина Юрьевна

Консультант, эксперт в области: управления численностью персонала, оптимизации организационных структур и бизнес-процессов, разработки политики ...

Старостин Николай Владимирович
Старостин Николай Владимирович

Магистр психологии. Специалист в области систем вознаграждения и в управлении наймом персонала. Имеет успешный разносторонний опыт в организацио...

Выберите подходящий курс
Онлайн-курс

Документ о повышении квалификации

Доступ из любой точки мира

Частичный отрыв от работы

Полный комплект обучающих материалов

Удобная онлайн-платформа (Zoom), видео и звук высокого качества

Без перелетов и гостиниц

Обратная связь от преподавателей

45 000 рублей
Видеокурс

Документ о повышении квалификации

Доступ из любой точки мира

Без отрыва от работы

Индивидуальный график обучения, который вы составляете самостоятельно

Комплект электронных обучающих материалов

Удобная платформа

Прохождение тестов и решение кейсов

Оперативная поддержка

40 000 рублей
Очный

Документ о повышении квалификации

Комфортная аудитория

Полное погружение в процесс обучения

Полный комплект обучающих материалов

Быстрая обратная связь от преподавателя

Эффективный нетворкинг

Место проведения: ВДНХ, в свободное время после завершения обучения доступны более 30 выставок, концертов и многочисленные кафе для отдыха

50 000 рублей
Документы, выдаваемые по итогам обучения
Форма выдаваемого документа
Удостоверение о повышении квалификации / диплом о профессиональной переподготовке установленного образца
Наша лицензия
Запросить коммерческое предложение
Также вы можете запросить адресное коммерческое предложение (конкретно на вашу организацию). Для этого нажмите здесь
Остались вопросы? Спросите нас!
Нажимая кнопку «Отправить», вы даете согласие на обработку персональных данных, в соответствии с Федеральным законом от 27.07.2006 года №152-ФЗ «О персональных данных», на условиях и для целей, определенных в Согласии на обработку персональных данных
Запросить коммерческое предложение
Нажимая кнопку «Отправить», вы даете согласие на обработку персональных данных, в соответствии с Федеральным законом от 27.07.2006 года №152-ФЗ «О персональных данных», на условиях и для целей, определенных в Согласии на обработку персональных данных
Корпоративное обучение
Развивайте сотрудников с учетом стоящих перед ними задач
Нажимая кнопку «Отправить», вы даете согласие на обработку персональных данных, в соответствии с Федеральным законом от 27.07.2006 года №152-ФЗ «О персональных данных», на условиях и для целей, определенных в Согласии на обработку персональных данных
Запросить коммерческое предложение
Нажимая кнопку «Отправить», вы даете согласие на обработку персональных данных, в соответствии с Федеральным законом от 27.07.2006 года №152-ФЗ «О персональных данных», на условиях и для целей, определенных в Согласии на обработку персональных данных
Регистрация на курс
Дата курса: 14.05.2025 - 15.05.2025
Стоимость курса: 45,000 рублей
Примененные скидки: скидки не применялись
Нажимая кнопку «Отправить», вы даете согласие на обработку персональных данных, в соответствии с Федеральным законом от 27.07.2006 года №152-ФЗ «О персональных данных», на условиях и для целей, определенных в Согласии на обработку персональных данных
Регистрация на курс
Выбранные курсы: нет выбранных курсов
Длительность курсов: длительность не выбрана
Нажимая кнопку «Отправить», вы даете согласие на обработку персональных данных, в соответствии с Федеральным законом от 27.07.2006 года №152-ФЗ «О персональных данных», на условиях и для целей, определенных в Согласии на обработку персональных данных

Контакты учебного центра

13.275MBMemory Usage484msRequest Duration
Joomla! Version4.4.7
PHP Version7.3.33
Identityguest
Response200
Templateeffortless
Database
Server
mysql
Version
8.0.31-0ubuntu0.20.04.2
Collation
utf8mb4_0900_ai_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:46 [ "REDIRECT_HTTPS" => "on" "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_STATUS" => "...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743546841 "last" => 1743546841...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (874.63KB) (2.59ms)
  • afterInitialise (2.41MB) (28.59ms)
  • afterRoute (461.02KB) (11.2ms)
  • beforeRenderComponent com_content (166.92KB) (4.61ms)
  • Before Access::preloadComponents (all components) (116.02KB) (1.17ms)
  • After Access::preloadComponents (all components) (112.11KB) (2.97ms)
  • Before Access::preloadPermissions (com_content) (3.65KB) (41μs)
  • After Access::preloadPermissions (com_content) (1.04MB) (4.86ms)
  • Before Access::getAssetRules (id:2193 name:com_content.article.1646) (66.81KB) (159μs)
  • After Access::getAssetRules (id:2193 name:com_content.article.1646) (9.75KB) (120μs)
  • Before Access::getAssetRules (id:2195 name:com_content.article.1648) (2.78MB) (77.87ms)
  • After Access::getAssetRules (id:2195 name:com_content.article.1648) (1.61KB) (19μs)
  • Before Access::getAssetRules (id:2194 name:com_content.article.1647) (358.3KB) (6.99ms)
  • After Access::getAssetRules (id:2194 name:com_content.article.1647) (1.61KB) (19μs)
  • Before Access::getAssetRules (id:1668 name:com_content.article.1158) (407.47KB) (7.69ms)
  • After Access::getAssetRules (id:1668 name:com_content.article.1158) (1.61KB) (18μs)
  • Before Access::getAssetRules (id:1672 name:com_content.article.1162) (161.02KB) (5.49ms)
  • After Access::getAssetRules (id:1672 name:com_content.article.1162) (2.86KB) (23μs)
  • Before Access::getAssetRules (id:2066 name:com_content.article.1524) (36.4KB) (2.43ms)
  • After Access::getAssetRules (id:2066 name:com_content.article.1524) (1.61KB) (18μs)
  • Before Access::getAssetRules (id:2070 name:com_content.article.1528) (1.17MB) (33.66ms)
  • After Access::getAssetRules (id:2070 name:com_content.article.1528) (1.61KB) (23μs)
  • Before Access::getAssetRules (id:2069 name:com_content.article.1527) (362.83KB) (7.38ms)
  • After Access::getAssetRules (id:2069 name:com_content.article.1527) (1.61KB) (15μs)
  • Before Access::getAssetRules (id:2092 name:com_content.article.1550) (100.99KB) (7.81ms)
  • After Access::getAssetRules (id:2092 name:com_content.article.1550) (1.92KB) (13μs)
  • Before Access::getAssetRules (id:2093 name:com_content.article.1551) (1.24MB) (26.68ms)
  • After Access::getAssetRules (id:2093 name:com_content.article.1551) (1.61KB) (20μs)
  • Before Access::getAssetRules (id:2094 name:com_content.article.1552) (433.99KB) (7.2ms)
  • After Access::getAssetRules (id:2094 name:com_content.article.1552) (1.61KB) (18μs)
  • Before Access::getAssetRules (id:2112 name:com_content.article.1570) (129.88KB) (8.33ms)
  • After Access::getAssetRules (id:2112 name:com_content.article.1570) (1.61KB) (24μs)
  • afterRenderComponent com_content (2.75MB) (14.6ms)
  • afterDispatch (22.34KB) (499μs)
  • beforeRenderRawModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (672.37KB) (6.29ms)
  • afterRenderRawModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (11.21KB) (583μs)
  • beforeRenderModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (800B) (7μs)
  • afterRenderModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (3.05KB) (72μs)
  • beforeRenderRawModule mod_menu (Меню) (2.77KB) (97μs)
  • afterRenderRawModule mod_menu (Меню) (87.08KB) (1.31ms)
  • beforeRenderModule mod_menu (Меню) (704B) (6μs)
  • afterRenderModule mod_menu (Меню) (3.15KB) (38μs)
  • beforeRenderRawModule mod_custom (Направления курсов и семинаров) (1.84KB) (20μs)
  • afterRenderRawModule mod_custom (Направления курсов и семинаров) (6.31KB) (650μs)
  • beforeRenderModule mod_custom (Направления курсов и семинаров) (768B) (6μs)
  • afterRenderModule mod_custom (Направления курсов и семинаров) (9.96KB) (40μs)
  • beforeRenderRawModule mod_custom (Контакты учебного центра) (6.84KB) (21μs)
  • afterRenderRawModule mod_custom (Контакты учебного центра) (960B) (130μs)
  • beforeRenderModule mod_custom (Контакты учебного центра) (752B) (3μs)
  • afterRenderModule mod_custom (Контакты учебного центра) (2.57KB) (29μs)
  • beforeRenderRawModule mod_bdthemes_logo (Logo Module) (96.9KB) (1.96ms)
  • afterRenderRawModule mod_bdthemes_logo (Logo Module) (6.1KB) (424μs)
  • beforeRenderModule mod_bdthemes_logo (Logo Module) (720B) (5μs)
  • afterRenderModule mod_bdthemes_logo (Logo Module) (2.29KB) (39μs)
  • beforeRenderRawModule mod_custom (поиск новый) (584B) (262μs)
  • afterRenderRawModule mod_custom (поиск новый) (928B) (135μs)
  • beforeRenderModule mod_custom (поиск новый) (720B) (4μs)
  • afterRenderModule mod_custom (поиск новый) (9.91KB) (33μs)
  • beforeRenderRawModule mod_menu (Main Menu) (3.76KB) (259μs)
  • afterRenderRawModule mod_menu (Main Menu) (200.94KB) (1.47ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (4μs)
  • afterRenderModule mod_menu (Main Menu) (4.4KB) (36μs)
  • beforeRenderRawModule mod_bdthemes_logo (Logo Small) (209.88KB) (3.28ms)
  • afterRenderRawModule mod_bdthemes_logo (Logo Small) (1.37KB) (163μs)
  • beforeRenderModule mod_bdthemes_logo (Logo Small) (720B) (4μs)
  • afterRenderModule mod_bdthemes_logo (Logo Small) (13.35KB) (40μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumb) (16.61KB) (282μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumb) (8.98KB) (552μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumb) (704B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumb) (2.4KB) (40μs)
  • beforeRenderRawModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (11.13KB) (1.33ms)
  • afterRenderRawModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (1.05KB) (153μs)
  • beforeRenderModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (864B) (4μs)
  • afterRenderModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (2.37KB) (37μs)
  • beforeRenderRawModule mod_custom (Footer Logo лого в подвале) (1.24KB) (228μs)
  • afterRenderRawModule mod_custom (Footer Logo лого в подвале) (960B) (123μs)
  • beforeRenderModule mod_custom (Footer Logo лого в подвале) (736B) (3μs)
  • afterRenderModule mod_custom (Footer Logo лого в подвале) (2.09KB) (38μs)
  • beforeRenderRawModule mod_menu (Mobile Menu) (4.59KB) (339μs)
  • afterRenderRawModule mod_menu (Mobile Menu) (3.38KB) (851μs)
  • beforeRenderModule mod_menu (Mobile Menu) (720B) (4μs)
  • afterRenderModule mod_menu (Mobile Menu) (4.41KB) (33μs)
  • afterRender (230.27KB) (197ms)
  • 1 x afterRender (230.27KB) (40.6%)
    196.60ms
    1 x Before Access::getAssetRules (id:2195 name:com_content.article.1648) (2.78MB) (16.08%)
    77.87ms
    1 x Before Access::getAssetRules (id:2070 name:com_content.article.1528) (1.17MB) (6.95%)
    33.66ms
    1 x afterInitialise (2.41MB) (5.9%)
    28.59ms
    1 x Before Access::getAssetRules (id:2093 name:com_content.article.1551) (1.24MB) (5.51%)
    26.68ms
    1 x afterRenderComponent com_content (2.75MB) (3.02%)
    14.60ms
    1 x afterRoute (461.02KB) (2.31%)
    11.20ms
    1 x Before Access::getAssetRules (id:2112 name:com_content.article.1570) (129.88KB) (1.72%)
    8.33ms
    1 x Before Access::getAssetRules (id:2092 name:com_content.article.1550) (100.99KB) (1.61%)
    7.81ms
    1 x Before Access::getAssetRules (id:1668 name:com_content.article.1158) (407.47KB) (1.59%)
    7.69ms
    1 x Before Access::getAssetRules (id:2069 name:com_content.article.1527) (362.83KB) (1.52%)
    7.38ms
    1 x Before Access::getAssetRules (id:2094 name:com_content.article.1552) (433.99KB) (1.49%)
    7.20ms
    1 x Before Access::getAssetRules (id:2194 name:com_content.article.1647) (358.3KB) (1.44%)
    6.99ms
    1 x beforeRenderRawModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (672.37KB) (1.3%)
    6.29ms
    1 x Before Access::getAssetRules (id:1672 name:com_content.article.1162) (161.02KB) (1.13%)
    5.49ms
    1 x After Access::preloadPermissions (com_content) (1.04MB) (1%)
    4.86ms
    1 x beforeRenderComponent com_content (166.92KB) (0.95%)
    4.61ms
    1 x beforeRenderRawModule mod_bdthemes_logo (Logo Small) (209.88KB) (0.68%)
    3.28ms
    1 x After Access::preloadComponents (all components) (112.11KB) (0.61%)
    2.97ms
    1 x afterLoad (874.63KB) (0.53%)
    2.59ms
    1 x Before Access::getAssetRules (id:2066 name:com_content.article.1524) (36.4KB) (0.5%)
    2.43ms
    1 x beforeRenderRawModule mod_bdthemes_logo (Logo Module) (96.9KB) (0.4%)
    1.96ms
    1 x afterRenderRawModule mod_menu (Main Menu) (200.94KB) (0.3%)
    1.47ms
    1 x beforeRenderRawModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (11.13KB) (0.28%)
    1.33ms
    1 x afterRenderRawModule mod_menu (Меню) (87.08KB) (0.27%)
    1.31ms
    1 x Before Access::preloadComponents (all components) (116.02KB) (0.24%)
    1.17ms
    1 x afterRenderRawModule mod_menu (Mobile Menu) (3.38KB) (0.18%)
    851μs
    1 x afterRenderRawModule mod_custom (Направления курсов и семинаров) (6.31KB) (0.13%)
    650μs
    1 x afterRenderRawModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (11.21KB) (0.12%)
    583μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumb) (8.98KB) (0.11%)
    552μs
    1 x afterDispatch (22.34KB) (0.1%)
    499μs
    1 x afterRenderRawModule mod_bdthemes_logo (Logo Module) (6.1KB) (0.09%)
    424μs
    1 x beforeRenderRawModule mod_menu (Mobile Menu) (4.59KB) (0.07%)
    339μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumb) (16.61KB) (0.06%)
    282μs
    1 x beforeRenderRawModule mod_custom (поиск новый) (584B) (0.05%)
    262μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (3.76KB) (0.05%)
    259μs
    1 x beforeRenderRawModule mod_custom (Footer Logo лого в подвале) (1.24KB) (0.05%)
    228μs
    1 x afterRenderRawModule mod_bdthemes_logo (Logo Small) (1.37KB) (0.03%)
    163μs
    1 x Before Access::getAssetRules (id:2193 name:com_content.article.1646) (66.81KB) (0.03%)
    159μs
    1 x afterRenderRawModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (1.05KB) (0.03%)
    153μs
    1 x afterRenderRawModule mod_custom (поиск новый) (928B) (0.03%)
    135μs
    1 x afterRenderRawModule mod_custom (Контакты учебного центра) (960B) (0.03%)
    130μs
    1 x afterRenderRawModule mod_custom (Footer Logo лого в подвале) (960B) (0.03%)
    123μs
    1 x After Access::getAssetRules (id:2193 name:com_content.article.1646) (9.75KB) (0.02%)
    120μs
    1 x beforeRenderRawModule mod_menu (Меню) (2.77KB) (0.02%)
    97μs
    1 x afterRenderModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (3.05KB) (0.01%)
    72μs
    1 x Before Access::preloadPermissions (com_content) (3.65KB) (0.01%)
    41μs
    1 x afterRenderModule mod_custom (Направления курсов и семинаров) (9.96KB) (0.01%)
    40μs
    1 x afterRenderModule mod_bdthemes_logo (Logo Small) (13.35KB) (0.01%)
    40μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumb) (2.4KB) (0.01%)
    40μs
    1 x afterRenderModule mod_bdthemes_logo (Logo Module) (2.29KB) (0.01%)
    39μs
    1 x afterRenderModule mod_menu (Меню) (3.15KB) (0.01%)
    38μs
    1 x afterRenderModule mod_custom (Footer Logo лого в подвале) (2.09KB) (0.01%)
    38μs
    1 x afterRenderModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (2.37KB) (0.01%)
    37μs
    1 x afterRenderModule mod_menu (Main Menu) (4.4KB) (0.01%)
    36μs
    1 x afterRenderModule mod_custom (поиск новый) (9.91KB) (0.01%)
    33μs
    1 x afterRenderModule mod_menu (Mobile Menu) (4.41KB) (0.01%)
    33μs
    1 x afterRenderModule mod_custom (Контакты учебного центра) (2.57KB) (0.01%)
    29μs
    1 x After Access::getAssetRules (id:2112 name:com_content.article.1570) (1.61KB) (0%)
    24μs
    1 x After Access::getAssetRules (id:1672 name:com_content.article.1162) (2.86KB) (0%)
    23μs
    1 x After Access::getAssetRules (id:2070 name:com_content.article.1528) (1.61KB) (0%)
    23μs
    1 x beforeRenderRawModule mod_custom (Контакты учебного центра) (6.84KB) (0%)
    21μs
    1 x After Access::getAssetRules (id:2093 name:com_content.article.1551) (1.61KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_custom (Направления курсов и семинаров) (1.84KB) (0%)
    20μs
    1 x After Access::getAssetRules (id:2195 name:com_content.article.1648) (1.61KB) (0%)
    19μs
    1 x After Access::getAssetRules (id:2194 name:com_content.article.1647) (1.61KB) (0%)
    19μs
    1 x After Access::getAssetRules (id:2066 name:com_content.article.1524) (1.61KB) (0%)
    18μs
    1 x After Access::getAssetRules (id:2094 name:com_content.article.1552) (1.61KB) (0%)
    18μs
    1 x After Access::getAssetRules (id:1668 name:com_content.article.1158) (1.61KB) (0%)
    18μs
    1 x After Access::getAssetRules (id:2069 name:com_content.article.1527) (1.61KB) (0%)
    15μs
    1 x After Access::getAssetRules (id:2092 name:com_content.article.1550) (1.92KB) (0%)
    13μs
    1 x beforeRenderModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (800B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Меню) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Направления курсов и семинаров) (768B) (0%)
    6μs
    1 x beforeRenderModule mod_bdthemes_logo (Logo Module) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumb) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (864B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Mobile Menu) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (поиск новый) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_bdthemes_logo (Logo Small) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Контакты учебного центра) (752B) (0%)
    3μs
    1 x beforeRenderModule mod_custom (Footer Logo лого в подвале) (736B) (0%)
    3μs
108 statements were executed, 33 of which were duplicates, 75 unique76.49ms1.53MB
  • SELECT @@SESSION.sql_mode;91μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jvf27_session` WHERE `session_id` = ?484μs1.59KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jvf27_session` WHERE `session_id` = :session_id LIMIT 190μs1.59KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jvf27_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.09ms936BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jvf27_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1420μs20.7KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jvf27_viewlevels`110μs1.09KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jvf27_usergroups` AS `a` LEFT JOIN `jvf27_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest274μs1.65KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jvf27_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2,:preparedArray3) ORDER BY `ordering`1.1ms11.53KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM jvf27_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'250μs2.05KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM jvf27_rsfirewall_hashes WHERE `type`='protect'222μs824B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM jvf27_rsfirewall_configuration216μs6.16KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `jvf27_rsfirewall_logs`940μs3.47KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`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`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `jvf27_menu` AS `m` LEFT JOIN `jvf27_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`852μs69.13KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 `jvf27_categories` AS `s` INNER JOIN `jvf27_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` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`449μs6.39KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `jvf27_content` WHERE `alias` = :alias AND `catid` = :catid293μs1.64KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT * FROM jvf27_rsfirewall_hashes WHERE (`type`='4.4.7' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)257μs1.05KB/plugins/system/rsfirewall/rsfirewall.php:1078Copy
  • SELECT * FROM jvf27_rsfirewall_snapshots WHERE `type`='protect'154μs3.45KB/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM jvf27_rsfirewall_lists WHERE (`ip`='18.216.220.244' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'278μs872B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM jvf27_rsfirewall_lists WHERE (`ip`='18.216.220.244' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'175μs872B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM jvf27_rsfirewall_exceptions WHERE `published`='1'200μs1.95KB/plugins/system/rsfirewall/rsfirewall.php:729Copy
  • SELECT * FROM `jvf27_languages` WHERE `published` = 1 ORDER BY `ordering` ASC249μs2.32KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jvf27_template_styles` AS `s` LEFT JOIN `jvf27_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` = 1568μs2.09KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jvf27_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40)749μs10.2KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jvf27_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.84ms201.75KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jvf27_content`1.24ms10.31KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jvf27_content` SET `hits` = (`hits` + 1) WHERE `id` = '1646'2.22ms48B/libraries/src/Table/Table.php:1325Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0541μs8.91KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `jvf27_categories` AS `s` INNER JOIN `jvf27_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`477μs6.47KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jvf27_contentitem_tag_map` AS `m` INNER JOIN `jvf27_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3)508μs4.99KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • 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 `jvf27_categories` AS `s` INNER JOIN `jvf27_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`972μs6.47KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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, a.only_use_in_subform,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 jvf27_fields AS a LEFT JOIN `jvf27_languages` AS l ON l.lang_code = a.language LEFT JOIN jvf27_users AS uc ON uc.id=a.checked_out LEFT JOIN jvf27_viewlevels AS ag ON ag.id = a.access LEFT JOIN jvf27_users AS ua ON ua.id = a.created_user_id LEFT JOIN jvf27_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jvf27_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8,:preparedArray9)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.43ms62.55KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43) AND `item_id` = :itemid1.53ms48.73KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • 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, a.only_use_in_subform,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 jvf27_fields AS a LEFT JOIN `jvf27_languages` AS l ON l.lang_code = a.language LEFT JOIN jvf27_users AS uc ON uc.id=a.checked_out LEFT JOIN jvf27_viewlevels AS ag ON ag.id = a.access LEFT JOIN jvf27_users AS ua ON ua.id = a.created_user_id LEFT JOIN jvf27_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4,:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) ORDER BY a.ordering ASC1.33ms77.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)2.01ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.28ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.08ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1,:preparedArray2)462μs1.75KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)2.06ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.21ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.07ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1,:preparedArray2)367μs1.75KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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 `jvf27_content` AS `a` LEFT JOIN `jvf27_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC686μs27.41KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • 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 `jvf27_categories` AS `s` INNER JOIN `jvf27_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`495μs6.47KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0437μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1,:preparedArray2)392μs1.75KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0410μs40.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1,:preparedArray2)315μs1.75KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0366μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43) AND `item_id` = :itemid878μs48.61KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1,:preparedArray2)405μs1.75KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0383μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43) AND `item_id` = :itemid709μs48.73KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1,:preparedArray2)332μs1.75KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0434μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `jvf27_categories` AS `s` INNER JOIN `jvf27_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`418μs5.83KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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, a.only_use_in_subform,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 jvf27_fields AS a LEFT JOIN `jvf27_languages` AS l ON l.lang_code = a.language LEFT JOIN jvf27_users AS uc ON uc.id=a.checked_out LEFT JOIN jvf27_viewlevels AS ag ON ag.id = a.access LEFT JOIN jvf27_users AS ua ON ua.id = a.created_user_id LEFT JOIN jvf27_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jvf27_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC851μs8.38KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `item_id` = :itemid414μs1.77KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • 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 `jvf27_categories` AS `s` INNER JOIN `jvf27_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`394μs5.83KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0420μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `item_id` = :itemid184μs1.77KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0408μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `jvf27_categories` AS `s` INNER JOIN `jvf27_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`705μs6.47KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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, a.only_use_in_subform,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 jvf27_fields AS a LEFT JOIN `jvf27_languages` AS l ON l.lang_code = a.language LEFT JOIN jvf27_users AS uc ON uc.id=a.checked_out LEFT JOIN jvf27_viewlevels AS ag ON ag.id = a.access LEFT JOIN jvf27_users AS ua ON ua.id = a.created_user_id LEFT JOIN jvf27_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jvf27_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8,:preparedArray9)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.06ms62.55KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43) AND `item_id` = :itemid1.08ms24.73KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.53ms9.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.1ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1,:preparedArray2)356μs1.75KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.38ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.49ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.34ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.12ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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 `jvf27_categories` AS `s` INNER JOIN `jvf27_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`702μs6.47KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0409μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1,:preparedArray2)384μs1.75KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0358μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43) AND `item_id` = :itemid1.01ms24.73KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1,:preparedArray2)326μs1.75KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0398μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43) AND `item_id` = :itemid760μs24.73KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1,:preparedArray2)285μs1.75KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0348μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `jvf27_categories` AS `s` INNER JOIN `jvf27_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`521μs6.47KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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, a.only_use_in_subform,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 jvf27_fields AS a LEFT JOIN `jvf27_languages` AS l ON l.lang_code = a.language LEFT JOIN jvf27_users AS uc ON uc.id=a.checked_out LEFT JOIN jvf27_viewlevels AS ag ON ag.id = a.access LEFT JOIN jvf27_users AS ua ON ua.id = a.created_user_id LEFT JOIN jvf27_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jvf27_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8,:preparedArray9)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.14ms62.55KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43) AND `item_id` = :itemid1.01ms104.61KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.81ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.13ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1)275μs1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)1.24ms1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)913μs1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT id AS value, title AS text FROM jvf27_content as content WHERE content.catid IN ( SELECT id FROM jvf27_categories as cat WHERE cat.parent_id = 7426923 ) OR content.catid = 7426923 HAVING `value` IN (:preparedArray1)959μs1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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 `jvf27_categories` AS `s` INNER JOIN `jvf27_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`544μs6.47KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0340μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1)251μs1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0355μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43) AND `item_id` = :itemid665μs104.61KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1)278μs1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0366μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43) AND `item_id` = :itemid669μs104.73KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1)510μs1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0436μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `field_id`,`value` FROM `jvf27_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43) AND `item_id` = :itemid1.12ms24.55KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1)437μs1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • 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`,`a`.`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`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jvf27_content` AS `a` INNER JOIN `jvf27_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jvf27_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jvf27_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jvf27_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jvf27_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0385μs8.96KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT id AS value, title AS text FROM jvf27_content WHERE catid = 58 HAVING `value` IN (:preparedArray1)275μs1.68KBParams/plugins/fields/sql/tmpl/sql.php:34Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jvf27_modules` AS `m` LEFT JOIN `jvf27_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jvf27_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`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`947μs20.89KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `jvf27_scheduler_tasks` AS `a` WHERE `a`.`state` = 1186μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `jvf27_session` WHERE `session_id` = ?254μs1.62KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jvf27_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.85ms904BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy