Менеджер по торговому маркетингу (Trade-маркетолог)

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

Менеджер по торговому маркетингу (Trade-маркетолог)

Курс повышения квалификации «Менеджер по торговому маркетингу (Trade-маркетолог)» предоставляет возможность детально изучить практические аспекты управления ассортиментом и торговым маркетингом.

Вы освоите разработку и внедрение эффективных стратегий ценообразования, оптимизацию ассортимента и проведение глубокого анализа потребительских предпочтений. После завершения курса вы сможете уверенно управлять выводом новых продуктов на рынок, налаживать эффективное взаимодействие с дистрибьюторами и применять современные методы анализа для принятия обоснованных решений.

Эти навыки помогут не только повысить вашу личную эффективность, но и значительно улучшить результаты работы всей команды.

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

  • Определять ключевые аспекты управления ассортиментом и разрабатывать эффективные стратегии для его оптимизации.
  • Применять современные методы анализа потребительских предпочтений и конкурентной среды для повышения конкурентоспособности компании.
  • Разрабатывать и внедрять ценообразовательные стратегии, учитывающие чувствительность и эластичность цен на рынке.
  • Оценивать привлекательность рыночных сегментов и формировать продуктовые стратегии, соответствующие потребностям целевой аудитории.
  • Создавать и реализовывать эффективные сбытовые и маркетинговые стратегии для успешного вывода новых продуктов на рынок.
Стоимость курса
40,000 рублей
16 ак.часов
Курс прошли: 5389 человек
Зарегистрироваться на курс
Запросить коммерческое предложение
Длительность обучения
16 ак.часов
Лицензия и ФРДО
РШУ имеет государственную лицензию лицензию на оказание образовательного услуг №020945
Гарантия качества
Член российской ассоциации бизнес-образования
Документ об образовании
Документ об образовании
Установленного государством образца
видеокурс Корпоративный
70% практики и 30% теории на курсе
85% клиентов возвращаются к нам вновь
93% слушателей используют полученные знания на практике
87% наших преподавателей являются действующими специалистами ведущих компаний
95% слушателей отмечают удобство обучения на курсах
72% выпускников продвинулись по карьерной лестнице
Кому подойдет?
Для компании
Разработка и внедрение эффективной системы оплаты труда и мотивации сотрудников. Обучение технологиям активных цифровых продаж и внедрение новых методов работы с клиентами. Оптимизация ассортиментной политики и применение современных методов анализа.
Для руководителя
Формирование комплексных маркетинговых стратегий на основе анализа рынка. Разработка и реализация гибкой ценовой политики, учитывающей рыночные условия. Обучение новым подходам в торговом маркетинге и внедрение их в практику.
Для специалиста
Обучение техникам эффективных переговоров с дистрибьюторами и партнерами. Изучение современных трендов и технологий в торговом маркетинге. Получение навыков по разработке и внедрению успешных маркетинговых и сбытовых стратегий.
Этапы обучения
1
Начало обучения. Ознакомление с процессом обучения.
2
Самостоятельное изучение теоретического материала в соответствии с учебным планом.
3
Текущий контроль знаний.
4
Промежуточная аттестация.
5
Итоговая аттестация.
Программа курса
Развернуть всю программу
01 Современные технологии управления ассортиментом
  • Ассортиментный портфель и ассортиментная политика компании.
  • Управление ассортиментом: возможности и ошибки.
  • Категорийный менеджмент. Конкурентный анализ и анализ потребительских предпочтений.
  • Ассортиментная матрица. Методы анализа ассортимента: ABC, XYZ анализы.
  • Методы оценки возможностей развития ассортимента: BCG-матрица и матрица оборачиваемости.
  • Стратегии развития ассортимента. Матрица И. Ансоффа. Позиционирование.
  • Оценка привлекательности рыночных сегментов. Продуктовые стратегии.
  • Жизненный цикл продукта. Ценовая политика компании.
  • Модели ценообразования. Чувствительность и эластичность по цене.
  • Реализация ценовой политики. Сбытовые стратегии.
02 Маркетинговая и коммерческая политика вывода продукта на рынок. Акции и стимулирование сбыта
  • Вывод продукта на рынок – целевые показатели компании. Маркетинговые и коммерческие стратегии.
  • С какой целью компания выводит на рынок новый продукт.
  • Маркетинговые и коммерческие стратегии.
  • Исследование рынков: сбор и анализ маркетинговой информации, каналы сбыта, анализ представленности.
  • Источники данных рынка и маркетинговой информации.
  • Ключевые параметры представленности (численная и взвешенная дистрибуция).
  • Позиционирование компании, ассортимента, бренда и продукта.
  • Основы теории позиционирования и их стратегии, маркетинговые войны.
  • Выведение новых продуктов на рынок: от планирования до согласованной программы.
  • Комплекс 4P, выбор или адаптация, корректировка ассортимента.
  • Определение каналов сбыта и ценовая политика.
  • Продвижение на региональном уровне.
  • Характеристики региональных торговых каналов (федеральные сети, локальные сети, специализированная и традиционная розница), структура работы с дистрибьюторами.
  • Разновидности региональных торговых каналов, федеральные и локальные сети в регионах.
  • Традиционная и специализированная розница.
  • Структура работы с дистрибьютором.
  • Коммерческая политика и система ценообразования. Принципы формирования цены для различных каналов для выравнивания полочных цен и предотвращения конфликтов.
  • Суть коммерческой политики и единая полочная цена.
  • Ценообразование федеральной и локальной сетевой розницы.
  • Ценообразование в розничных ТТ.
  • Формирование коммерческой политики с учетом ценообразования в каналах.
  • Алгоритмы выхода на региональный рынок: закрепление и расширения позиций на рынках. Подбор и система оценки потенциальных дистрибьюторов.
  • Особенности региональных рынков.
  • Алгоритм захода «сверху» и алгоритм органичного входа.
  • Подбор дистрибьюторов и их сегментация.
  • Оценка и выбор дистрибьютора.
  • Мотивация дистрибьютора: ключевые мотиваторы сотрудничества. «Первичные» переговоры с дистрибьютором: продуктовый портфель, коммерческая политика, целевые показатели.
  • Основы взаимовыгодного сотрудничества с дистрибьютором.
  • Цели и задачи первичных переговоров.
  • Согласование продуктового портфеля и коммерческих условий.
  • Развитие взаимоотношений с дистрибьютором: цели и задачи, этапы развития взаимоотношений с дистрибьюторами.
  • Цели,задачи и этапы развития взаимоотношений с дистрибьютором.
  • Работа с командой дистрибьютора, трейд-маркетинговые акции.
  • Продвижение на региональном уровне: особенности и эффективность.
  • Эффективность федеральных каналов продвижения.
  • Особенности и эффективность региональных каналов.
  • Возможности продвижения в канале дистрибьюторов и их эффективность.
03 Мини-курс: Дизайн-мышление

Основы метода и практика для бизнеса

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

Меню

Направления курсов и семинаров

Строительство Девелопмент | Безопасность | Право | Mini MBA | Стратегическое развитие | Персонал | Организация обучения | Общее управление | Маркетинг | Логистика Снабжение | Конкурсы Тендеры | Коммерческая недвижимость | Информационные технологии (IT)| Продажи | Производство | Процессы и качество | Переговоры Коммуникации | Бухгалтерия Налоги Отчетность | Управление проектами | ЖКХ | Торговля Ритейл | Управление инновациями | Аналитика | ВЭД | Финансы Экономика | Личная эффективность

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

J! InfoRequestSessionProfileQueries106Log
14.637MBMemory Usage528msRequest 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" => 1743586274 "last" => 1743586274...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (874.69KB) (2.81ms)
  • afterInitialise (2.41MB) (30.85ms)
  • afterRoute (460.98KB) (9.61ms)
  • beforeRenderComponent com_content (166.92KB) (3.28ms)
  • Before Access::preloadComponents (all components) (116.02KB) (1.39ms)
  • After Access::preloadComponents (all components) (112.11KB) (1.39ms)
  • Before Access::preloadPermissions (com_content) (3.65KB) (28μs)
  • After Access::preloadPermissions (com_content) (1.04MB) (4.53ms)
  • Before Access::getAssetRules (id:2205 name:com_content.article.1658) (66.81KB) (189μs)
  • After Access::getAssetRules (id:2205 name:com_content.article.1658) (9.75KB) (127μs)
  • Before Access::getAssetRules (id:2144 name:com_content.article.1600) (2.7MB) (77.47ms)
  • After Access::getAssetRules (id:2144 name:com_content.article.1600) (1.61KB) (21μs)
  • Before Access::getAssetRules (id:2146 name:com_content.article.1601) (1.22MB) (37.75ms)
  • After Access::getAssetRules (id:2146 name:com_content.article.1601) (1.61KB) (22μs)
  • Before Access::getAssetRules (id:2148 name:com_content.article.1602) (475.55KB) (16.17ms)
  • After Access::getAssetRules (id:2148 name:com_content.article.1602) (1.61KB) (21μs)
  • Before Access::getAssetRules (id:2121 name:com_content.article.1578) (187.77KB) (13.12ms)
  • After Access::getAssetRules (id:2121 name:com_content.article.1578) (2.86KB) (22μs)
  • Before Access::getAssetRules (id:2122 name:com_content.article.1579) (1.56MB) (35.94ms)
  • After Access::getAssetRules (id:2122 name:com_content.article.1579) (1.61KB) (28μs)
  • Before Access::getAssetRules (id:2123 name:com_content.article.1580) (709.84KB) (11.26ms)
  • After Access::getAssetRules (id:2123 name:com_content.article.1580) (1.61KB) (29μs)
  • Before Access::getAssetRules (id:2093 name:com_content.article.1551) (224.02KB) (12.77ms)
  • After Access::getAssetRules (id:2093 name:com_content.article.1551) (1.61KB) (23μs)
  • Before Access::getAssetRules (id:2092 name:com_content.article.1550) (901.2KB) (21.46ms)
  • After Access::getAssetRules (id:2092 name:com_content.article.1550) (1.92KB) (24μs)
  • Before Access::getAssetRules (id:2094 name:com_content.article.1552) (781.33KB) (15.39ms)
  • After Access::getAssetRules (id:2094 name:com_content.article.1552) (1.61KB) (31μs)
  • afterRenderComponent com_content (3.71MB) (12.21ms)
  • afterDispatch (19.84KB) (678μs)
  • beforeRenderRawModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (672.37KB) (8.18ms)
  • afterRenderRawModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (11.34KB) (880μs)
  • beforeRenderModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (800B) (10μs)
  • afterRenderModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (5.68KB) (110μs)
  • beforeRenderRawModule mod_menu (Меню) (2.65KB) (125μs)
  • afterRenderRawModule mod_menu (Меню) (87.08KB) (1.64ms)
  • beforeRenderModule mod_menu (Меню) (704B) (6μs)
  • afterRenderModule mod_menu (Меню) (3.15KB) (46μs)
  • beforeRenderRawModule mod_custom (Направления курсов и семинаров) (1.84KB) (23μs)
  • afterRenderRawModule mod_custom (Направления курсов и семинаров) (6.31KB) (542μs)
  • beforeRenderModule mod_custom (Направления курсов и семинаров) (768B) (6μs)
  • afterRenderModule mod_custom (Направления курсов и семинаров) (9.96KB) (40μs)
  • beforeRenderRawModule mod_custom (Контакты учебного центра) (6.84KB) (22μs)
  • afterRenderRawModule mod_custom (Контакты учебного центра) (960B) (130μs)
  • beforeRenderModule mod_custom (Контакты учебного центра) (752B) (3μs)
  • afterRenderModule mod_custom (Контакты учебного центра) (2.57KB) (30μs)
  • beforeRenderRawModule mod_bdthemes_logo (Logo Module) (96.9KB) (2.18ms)
  • afterRenderRawModule mod_bdthemes_logo (Logo Module) (6.1KB) (453μs)
  • beforeRenderModule mod_bdthemes_logo (Logo Module) (720B) (4μs)
  • afterRenderModule mod_bdthemes_logo (Logo Module) (2.29KB) (45μs)
  • beforeRenderRawModule mod_custom (поиск новый) (584B) (399μs)
  • afterRenderRawModule mod_custom (поиск новый) (928B) (172μs)
  • beforeRenderModule mod_custom (поиск новый) (720B) (4μs)
  • afterRenderModule mod_custom (поиск новый) (9.91KB) (40μs)
  • beforeRenderRawModule mod_menu (Main Menu) (3.76KB) (269μs)
  • afterRenderRawModule mod_menu (Main Menu) (200.95KB) (1.49ms)
  • 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.41ms)
  • afterRenderRawModule mod_bdthemes_logo (Logo Small) (1.37KB) (198μs)
  • beforeRenderModule mod_bdthemes_logo (Logo Small) (720B) (5μs)
  • afterRenderModule mod_bdthemes_logo (Logo Small) (2.35KB) (45μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumb) (16.73KB) (540μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumb) (8.98KB) (543μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumb) (704B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumb) (13.4KB) (39μs)
  • beforeRenderRawModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (11KB) (1.46ms)
  • afterRenderRawModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (1.05KB) (181μs)
  • beforeRenderModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (864B) (6μs)
  • afterRenderModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (2.37KB) (53μs)
  • beforeRenderRawModule mod_custom (Footer Logo лого в подвале) (1.24KB) (288μs)
  • afterRenderRawModule mod_custom (Footer Logo лого в подвале) (960B) (194μs)
  • beforeRenderModule mod_custom (Footer Logo лого в подвале) (736B) (5μs)
  • afterRenderModule mod_custom (Footer Logo лого в подвале) (2.09KB) (42μs)
  • beforeRenderRawModule mod_menu (Mobile Menu) (4.59KB) (463μs)
  • afterRenderRawModule mod_menu (Mobile Menu) (3.38KB) (1.03ms)
  • beforeRenderModule mod_menu (Mobile Menu) (720B) (6μs)
  • afterRenderModule mod_menu (Mobile Menu) (4.41KB) (41μs)
  • afterRender (214.26KB) (191ms)
  • 1 x afterRender (214.26KB) (36.09%)
    190.57ms
    1 x Before Access::getAssetRules (id:2144 name:com_content.article.1600) (2.7MB) (14.67%)
    77.47ms
    1 x Before Access::getAssetRules (id:2146 name:com_content.article.1601) (1.22MB) (7.15%)
    37.75ms
    1 x Before Access::getAssetRules (id:2122 name:com_content.article.1579) (1.56MB) (6.81%)
    35.94ms
    1 x afterInitialise (2.41MB) (5.84%)
    30.85ms
    1 x Before Access::getAssetRules (id:2092 name:com_content.article.1550) (901.2KB) (4.07%)
    21.46ms
    1 x Before Access::getAssetRules (id:2148 name:com_content.article.1602) (475.55KB) (3.06%)
    16.17ms
    1 x Before Access::getAssetRules (id:2094 name:com_content.article.1552) (781.33KB) (2.92%)
    15.39ms
    1 x Before Access::getAssetRules (id:2121 name:com_content.article.1578) (187.77KB) (2.49%)
    13.12ms
    1 x Before Access::getAssetRules (id:2093 name:com_content.article.1551) (224.02KB) (2.42%)
    12.77ms
    1 x afterRenderComponent com_content (3.71MB) (2.31%)
    12.21ms
    1 x Before Access::getAssetRules (id:2123 name:com_content.article.1580) (709.84KB) (2.13%)
    11.26ms
    1 x afterRoute (460.98KB) (1.82%)
    9.61ms
    1 x beforeRenderRawModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (672.37KB) (1.55%)
    8.18ms
    1 x After Access::preloadPermissions (com_content) (1.04MB) (0.86%)
    4.53ms
    1 x beforeRenderRawModule mod_bdthemes_logo (Logo Small) (209.88KB) (0.65%)
    3.41ms
    1 x beforeRenderComponent com_content (166.92KB) (0.62%)
    3.28ms
    1 x afterLoad (874.69KB) (0.53%)
    2.81ms
    1 x beforeRenderRawModule mod_bdthemes_logo (Logo Module) (96.9KB) (0.41%)
    2.18ms
    1 x afterRenderRawModule mod_menu (Меню) (87.08KB) (0.31%)
    1.64ms
    1 x afterRenderRawModule mod_menu (Main Menu) (200.95KB) (0.28%)
    1.49ms
    1 x beforeRenderRawModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (11KB) (0.28%)
    1.46ms
    1 x Before Access::preloadComponents (all components) (116.02KB) (0.26%)
    1.39ms
    1 x After Access::preloadComponents (all components) (112.11KB) (0.26%)
    1.39ms
    1 x afterRenderRawModule mod_menu (Mobile Menu) (3.38KB) (0.19%)
    1.03ms
    1 x afterRenderRawModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (11.34KB) (0.17%)
    880μs
    1 x afterDispatch (19.84KB) (0.13%)
    678μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumb) (8.98KB) (0.1%)
    543μs
    1 x afterRenderRawModule mod_custom (Направления курсов и семинаров) (6.31KB) (0.1%)
    542μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumb) (16.73KB) (0.1%)
    540μs
    1 x beforeRenderRawModule mod_menu (Mobile Menu) (4.59KB) (0.09%)
    463μs
    1 x afterRenderRawModule mod_bdthemes_logo (Logo Module) (6.1KB) (0.09%)
    453μs
    1 x beforeRenderRawModule mod_custom (поиск новый) (584B) (0.08%)
    399μs
    1 x beforeRenderRawModule mod_custom (Footer Logo лого в подвале) (1.24KB) (0.05%)
    288μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (3.76KB) (0.05%)
    269μs
    1 x afterRenderRawModule mod_bdthemes_logo (Logo Small) (1.37KB) (0.04%)
    198μs
    1 x afterRenderRawModule mod_custom (Footer Logo лого в подвале) (960B) (0.04%)
    194μs
    1 x Before Access::getAssetRules (id:2205 name:com_content.article.1658) (66.81KB) (0.04%)
    189μs
    1 x afterRenderRawModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (1.05KB) (0.03%)
    181μs
    1 x afterRenderRawModule mod_custom (поиск новый) (928B) (0.03%)
    172μs
    1 x afterRenderRawModule mod_custom (Контакты учебного центра) (960B) (0.02%)
    130μs
    1 x After Access::getAssetRules (id:2205 name:com_content.article.1658) (9.75KB) (0.02%)
    127μs
    1 x beforeRenderRawModule mod_menu (Меню) (2.65KB) (0.02%)
    125μs
    1 x afterRenderModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (5.68KB) (0.02%)
    110μs
    1 x afterRenderModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (2.37KB) (0.01%)
    53μs
    1 x afterRenderModule mod_menu (Меню) (3.15KB) (0.01%)
    46μs
    1 x afterRenderModule mod_bdthemes_logo (Logo Small) (2.35KB) (0.01%)
    45μs
    1 x afterRenderModule mod_bdthemes_logo (Logo Module) (2.29KB) (0.01%)
    45μs
    1 x afterRenderModule mod_custom (Footer Logo лого в подвале) (2.09KB) (0.01%)
    42μs
    1 x afterRenderModule mod_menu (Mobile Menu) (4.41KB) (0.01%)
    41μs
    1 x afterRenderModule mod_custom (Направления курсов и семинаров) (9.96KB) (0.01%)
    40μs
    1 x afterRenderModule mod_custom (поиск новый) (9.91KB) (0.01%)
    40μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumb) (13.4KB) (0.01%)
    39μs
    1 x afterRenderModule mod_menu (Main Menu) (4.4KB) (0.01%)
    36μs
    1 x After Access::getAssetRules (id:2094 name:com_content.article.1552) (1.61KB) (0.01%)
    31μs
    1 x afterRenderModule mod_custom (Контакты учебного центра) (2.57KB) (0.01%)
    30μs
    1 x After Access::getAssetRules (id:2123 name:com_content.article.1580) (1.61KB) (0.01%)
    29μs
    1 x Before Access::preloadPermissions (com_content) (3.65KB) (0.01%)
    28μs
    1 x After Access::getAssetRules (id:2122 name:com_content.article.1579) (1.61KB) (0.01%)
    28μs
    1 x After Access::getAssetRules (id:2092 name:com_content.article.1550) (1.92KB) (0%)
    24μs
    1 x beforeRenderRawModule mod_custom (Направления курсов и семинаров) (1.84KB) (0%)
    23μs
    1 x After Access::getAssetRules (id:2093 name:com_content.article.1551) (1.61KB) (0%)
    23μs
    1 x After Access::getAssetRules (id:2146 name:com_content.article.1601) (1.61KB) (0%)
    22μs
    1 x After Access::getAssetRules (id:2121 name:com_content.article.1578) (2.86KB) (0%)
    22μs
    1 x beforeRenderRawModule mod_custom (Контакты учебного центра) (6.84KB) (0%)
    22μs
    1 x After Access::getAssetRules (id:2144 name:com_content.article.1600) (1.61KB) (0%)
    21μs
    1 x After Access::getAssetRules (id:2148 name:com_content.article.1602) (1.61KB) (0%)
    21μs
    1 x beforeRenderModule mod_bdthemes_header ( Заголовок страницы на второстепенных страницы) (800B) (0%)
    10μs
    1 x beforeRenderModule mod_menu (Меню) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Направления курсов и семинаров) (768B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Разработка проекта и интеграция с Битрикс 24 - Группа компаний "Капитал ПЛЮС") (864B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Mobile Menu) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_bdthemes_logo (Logo Small) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Footer Logo лого в подвале) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_bdthemes_logo (Logo Module) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (поиск новый) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumb) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Контакты учебного центра) (752B) (0%)
    3μs
106 statements were executed, 29 of which were duplicates, 77 unique101ms2.31MB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6Duplicates 7Duplicates 8Duplicates 9Duplicates 10Duplicates 11
  • SELECT @@SESSION.sql_mode;124μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jvf27_session` WHERE `session_id` = ?282μs1.59KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jvf27_session` WHERE `session_id` = :session_id LIMIT 198μ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)3.15ms936BParams/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` = 1451μs20.7KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jvf27_viewlevels`388μ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` = :guest300μ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`770μs11.53KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM jvf27_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'265μs2.05KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM jvf27_rsfirewall_hashes WHERE `type`='protect'141μs824B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM jvf27_rsfirewall_configuration119μs6.16KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `jvf27_rsfirewall_logs`1.14ms3.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`1.17ms69.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`498μs6.39KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `jvf27_content` WHERE `alias` = :alias AND `catid` = :catid427μ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)214μs1.05KB/plugins/system/rsfirewall/rsfirewall.php:1078Copy
  • SELECT * FROM jvf27_rsfirewall_snapshots WHERE `type`='protect'139μs3.45KB/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM jvf27_rsfirewall_lists WHERE (`ip`='3.22.71.103' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'284μs872B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM jvf27_rsfirewall_lists WHERE (`ip`='3.22.71.103' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'146μs872B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM jvf27_rsfirewall_exceptions WHERE `published`='1'122μs1.95KB/plugins/system/rsfirewall/rsfirewall.php:729Copy
  • SELECT * FROM `jvf27_languages` WHERE `published` = 1 ORDER BY `ordering` ASC185μ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` = 1387μ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)722μ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.73ms201.75KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jvf27_content`1.38ms10.31KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jvf27_content` SET `hits` = (`hits` + 1) WHERE `id` = '1658'2.42ms48B/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` > 0757μ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`725μ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)445μ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`1.02ms6.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.26ms62.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.4ms48.55KBParams/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.7ms77.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)2ms1.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)562μ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)2.4ms1.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)2.11ms1.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.68ms1.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)618μs1.68KBParams/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 DESC556μs3.97KBParams/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`628μ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` > 01.01ms8.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)576μ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` > 0913μ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)544μ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` > 0482μ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`1.09ms6.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.82ms62.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.16ms88.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)2.23ms1.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)2.62ms1.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,:preparedArray3)675μs1.83KBParams/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.44ms1.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.64ms1.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`856μ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` > 0842μ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,:preparedArray3)704μs1.83KBParams/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` > 0813μ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.59ms56.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,:preparedArray3)523μs1.83KBParams/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.02ms1.63KBParams/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.72ms1.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` > 0462μ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` = :itemid742μs88.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,:preparedArray3)398μs9.83KBParams/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.62ms1.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.06ms1.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` > 0437μ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` = :itemid984μs273.11KBParams/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.27ms1.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.02ms1.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,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12)682μs3.11KBParams/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.55ms1.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.71ms1.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.43ms1.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` > 0500μ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,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12)697μs3.11KBParams/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` > 0634μ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.12ms273.11KBParams/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,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12)678μs3.11KBParams/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` > 0536μ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.49ms273.11KBParams/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,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10)588μs2.95KBParams/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` > 0609μ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`798μ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.26ms62.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` = :itemid795μs104.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.91ms1.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.11ms1.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)370μ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.3ms1.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)942μ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)890μ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`627μ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` > 0342μ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` = :itemid706μ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)381μ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` > 0396μ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)369μ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` > 0508μ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` = :itemid840μ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)375μ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`1.5ms20.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` = 1295μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `jvf27_session` WHERE `session_id` = ?307μs1.62KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jvf27_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.37ms904BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy