Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

6 Database Queries

3 Different statements

51.91 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug
SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug
SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug
SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu != 0  
GROUP BY
    f.parent_id;
SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE f.id IN (?) ORDER BY gr.sort, f.sort

#▲	Time	Info
1	13.62 ms	SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug Parameters: [`"slug" => "derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod"`] View formatted query View runnable query Explain query SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.en = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.it = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.es = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.fr = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.de = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.pl = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.nl = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.fi = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.sv = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' ;
2	12.23 ms	SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug Parameters: [`"slug" => "derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа"`] View formatted query View runnable query Explain query SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа' OR url.en = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа' OR url.it = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа' OR url.es = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа' OR url.fr = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа' OR url.de = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа' OR url.pl = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа' OR url.nl = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа' OR url.fi = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа' OR url.sv = 'derevo-faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа' ;
3	12.51 ms	SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug Parameters: [`"slug" => "faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod"`] View formatted query View runnable query Explain query SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = 'faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.en = 'faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.it = 'faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.es = 'faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.fr = 'faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.de = 'faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.pl = 'faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.nl = 'faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.fi = 'faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' OR url.sv = 'faktura-pod-faktura-pod-faktura-pod-faktura-pod-fаkturа-pod' ;
4	12.81 ms	SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug Parameters: [`"slug" => "derevo"`] View formatted query View runnable query Explain query SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = 'derevo' OR url.en = 'derevo' OR url.it = 'derevo' OR url.es = 'derevo' OR url.fr = 'derevo' OR url.de = 'derevo' OR url.pl = 'derevo' OR url.nl = 'derevo' OR url.fi = 'derevo' OR url.sv = 'derevo' ;
5	0.10 ms	SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; Parameters: [] View formatted query View runnable query Explain query SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id; SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id;;
6	0.64 ms	SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE f.id IN (?) ORDER BY gr.sort, f.sort Parameters: [`1 => 10541`] View formatted query View runnable query Explain query SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE f.id IN (?) ORDER BY gr.sort, f.sort SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE f.id IN (10541) ORDER BY gr.sort, f.sort;

oneC connection

No database queries were performed.

logs connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
oneC	doctrine.dbal.oneC_connection
logs	doctrine.dbal.logs_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
oneC	doctrine.orm.oneC_entity_manager
logs	doctrine.orm.logs_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
WebBundle\Entity\User	No errors.
WebBundle\Entity\Publication	No errors.
WebBundle\Entity\FilterEntity	No errors.
WebBundle\Entity\Collection	No errors.
WebBundle\Entity\Factory	No errors.
WebBundle\Entity\ListMeasure	No errors.
WebBundle\Entity\ListMaterial	No errors.
WebBundle\Entity\ProductReviewsCache	No errors.
WebBundle\Entity\ReviewsCache	No errors.
WebBundle\Entity\ListCountry	No errors.
WebBundle\Entity\Article	No errors.
WebBundle\Entity\Interior	No errors.
WebBundle\Entity\Idea	No errors.
WebBundle\Entity\CollectionAlsoViewed	No errors.
WebBundle\Entity\InteriorHistory	No errors.
FlexApp\Entity\ChatB	No errors.
FlexApp\Entity\ChatBMessage	No errors.
FlexApp\Entity\BoolDBSetting	No errors.
FlexApp\Entity\Widget	No errors.
FlexApp\Entity\CountryAndLangSpecificDataEntity	No errors.
FlexApp\Entity\ConsultantEntity	No errors.
FlexApp\Entity\GeoCountryEntity	No errors.

oneC entity manager

No loaded entities.

logs entity manager