Symfony Profiler

SELECT
  f.id,
  f.rank AS `rank`,
  f.alt_name AS `altName`,
  f.old_command AS `sphinxName`,
  f.old_id AS `sphinxId`,
  htmlshow.fr AS `isHtmlShow`,
  fp.name_menu_fr AS `nameMenu`,
  fp.name_many_fr AS `nameMany`,
  fp.name_single_fr AS `nameSingle`,
  fp.html_fr AS `html`,
  fp.description_fr AS `description`,
  metadesc.fr 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.fr AS `groupName`,
  url.fr 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_fr AS `countryName`,
  cnurl.fr 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.fr AS `isHtmlShow`, fp.name_menu_fr AS `nameMenu`, fp.name_many_fr AS `nameMany`, fp.name_single_fr AS `nameSingle`, fp.html_fr AS `html`, fp.description_fr AS `description`, metadesc.fr 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.fr AS `groupName`, url.fr 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_fr AS `countryName`, cnurl.fr 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 = 'retifie' OR url.en = 'retifie' OR url.it = 'retifie' OR url.es = 'retifie' OR url.fr = 'retifie' OR url.de = 'retifie' OR url.pl = 'retifie' OR url.nl = 'retifie' OR url.fi = 'retifie' OR url.sv = 'retifie' ;

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;;

SELECT
  f.id,
  f.rank AS `rank`,
  f.alt_name AS `altName`,
  f.old_command AS `sphinxName`,
  f.old_id AS `sphinxId`,
  htmlshow.fr AS `isHtmlShow`,
  fp.name_menu_fr AS `nameMenu`,
  fp.name_many_fr AS `nameMany`,
  fp.name_single_fr AS `nameSingle`,
  fp.html_fr AS `html`,
  fp.description_fr AS `description`,
  metadesc.fr 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.fr AS `groupName`,
  url.fr 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_fr AS `countryName`,
  cnurl.fr 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.fr AS `isHtmlShow`, fp.name_menu_fr AS `nameMenu`, fp.name_many_fr AS `nameMany`, fp.name_single_fr AS `nameSingle`, fp.html_fr AS `html`, fp.description_fr AS `description`, metadesc.fr 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.fr AS `groupName`, url.fr 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_fr AS `countryName`, cnurl.fr 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 (10174) ORDER BY gr.sort, f.sort;

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;;

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;;

SELECT
  c0_.`id` AS id_0,
  c0_.`rating` AS rating_1
FROM
  `collection` c0_
WHERE
  c0_.`id` IN (
    3244645, 1654, 1082850, 672, 1714563,
    3244755, 139, 3246855, 2091986, 3244522,
    402365, 3246258, 3244986, 3244718,
    1204, 1861195, 3247413, 140524, 3247927,
    1317965, 2116999, 2568318, 363218,
    658435, 1117, 3246170, 3245572, 3246338,
    3244559, 3244978
  )

SELECT c0_.`id` AS id_0, c0_.`rating` AS rating_1 FROM `collection` c0_ WHERE c0_.`id` IN (3244645, 1654, 1082850, 672, 1714563, 3244755, 139, 3246855, 2091986, 3244522, 402365, 3246258, 3244986, 3244718, 1204, 1861195, 3247413, 140524, 3247927, 1317965, 2116999, 2568318, 363218, 658435, 1117, 3246170, 3245572, 3246338, 3244559, 3244978);

SELECT
  i0_.`id` AS id_0
FROM
  `idea` i1_
  INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id
  INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id
WHERE
  i1_.`token` = ?
GROUP BY
  i0_.`id`

SELECT i0_.`id` AS id_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = '9ae6422274511d1ededfc55faa6d7c576cc7c713a81ef11bab9f1d50e8dfb602' GROUP BY i0_.`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_advanced != 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_advanced != 0 
GROUP BY
    f.parent_id;;

SELECT
  f0_.`old_id` AS old_id_0,
  f1_.`name_single_fr` AS name_single_fr_1,
  f1_.`name_menu_fr` AS name_menu_fr_2
FROM
  `filters` f0_
  LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id
  LEFT JOIN `filter_groups` f2_ ON f0_.group_id = f2_.id
WHERE
  f2_.`id` = 407
ORDER BY
  f0_.`sort` ASC

SELECT f0_.`old_id` AS old_id_0, f1_.`name_single_fr` AS name_single_fr_1, f1_.`name_menu_fr` AS name_menu_fr_2 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id LEFT JOIN `filter_groups` f2_ ON f0_.group_id = f2_.id WHERE f2_.`id` = 407 ORDER BY f0_.`sort` ASC;

SELECT
  t0.`id` AS id_1,
  t0.`unid` AS unid_2,
  t0.`name` AS name_3,
  t0.`name_inv` AS name_inv_4,
  t0.`url` AS url_5,
  t0.`alternate_name` AS alternate_name_6,
  t0.`description_ru` AS description_ru_7,
  t0.`description_en` AS description_en_8,
  t0.`description_it` AS description_it_9,
  t0.`description_es` AS description_es_10,
  t0.`description_fr` AS description_fr_11,
  t0.`description_de` AS description_de_12,
  t0.`description_pt` AS description_pt_13,
  t0.`description_pl` AS description_pl_14,
  t0.`description_nl` AS description_nl_15,
  t0.`description_fi` AS description_fi_16,
  t0.`description_ua` AS description_ua_17,
  t0.`description_sv` AS description_sv_18,
  t0.`description_no` AS description_no_19,
  t0.`description_da` AS description_da_20,
  t0.`description_zh` AS description_zh_21,
  t0.`delivery_time` AS delivery_time_22,
  t0.`not_regular` AS not_regular_23,
  t0.`suspended` AS suspended_24,
  t0.`status` AS status_25,
  t0.`type` AS type_26,
  t0.`discount` AS discount_27,
  t0.`discount_date_start` AS discount_date_start_28,
  t0.`discount_date_end` AS discount_date_end_29,
  t0.`transcription` AS transcription_30,
  t0.`cost_delivery` AS cost_delivery_31,
  t0.`create_date` AS create_date_32,
  t0.`is_accepted` AS is_accepted_33,
  t0.`accepted_at` AS accepted_at_34,
  t0.`accept_state` AS accept_state_35,
  t0.`description_edit` AS description_edit_36,
  t0.`stated_at` AS stated_at_37,
  t0.`state` AS state_38,
  t0.`description_state` AS description_state_39,
  t0.`video` AS video_40,
  t0.`parser_address` AS parser_address_41,
  t0.`accessible` AS accessible_42,
  t0.`sound` AS sound_43,
  t0.`test_access` AS test_access_44,
  t0.`total_ideas` AS total_ideas_45,
  t0.`votes_submit` AS votes_submit_46,
  t0.`votes_stars` AS votes_stars_47,
  t0.`brand_link` AS brand_link_48,
  t0.`brand_logo` AS brand_logo_49,
  t0.`no_send_portl_message` AS no_send_portl_message_50,
  t0.user_id AS user_id_51,
  t0.country AS country_52,
  t0.filter AS filter_53
FROM
  `factory` t0
WHERE
  t0.`url` = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`url` = 'retifie' LIMIT 1;

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;;

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;;

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;;

SELECT
  v0_.`id` AS id_0,
  v0_.`token` AS token_1,
  v0_.`url` AS url_2,
  v0_.`title` AS title_3,
  v0_.`icon` AS icon_4,
  v0_.`visit_date` AS visit_date_5,
  v0_.`v_type` AS v_type_6,
  v0_.`v_object_id` AS v_object_id_7
FROM
  `visit` v0_
WHERE
  v0_.`token` = ?
  AND v0_.`url` = ?
  AND v0_.`url` <> '/.*catalog.*/'
LIMIT
  1

SELECT v0_.`id` AS id_0, v0_.`token` AS token_1, v0_.`url` AS url_2, v0_.`title` AS title_3, v0_.`icon` AS icon_4, v0_.`visit_date` AS visit_date_5, v0_.`v_type` AS v_type_6, v0_.`v_object_id` AS v_object_id_7 FROM `visit` v0_ WHERE v0_.`token` = '9ae6422274511d1ededfc55faa6d7c576cc7c713a81ef11bab9f1d50e8dfb602' AND v0_.`url` = 'catalogue/retifie' AND v0_.`url` <> '/.*catalog.*/' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO `visit` (
  `token`, `url`, `title`, `icon`, `visit_date`,
  `v_type`, `v_object_id`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO `visit` (`token`, `url`, `title`, `icon`, `visit_date`, `v_type`, `v_object_id`) VALUES ('9ae6422274511d1ededfc55faa6d7c57', 'catalogue/retifie', 'Carrelage rectifié: TOP 10 sur 2372 collections', '/img/histories/tile-catalogue.jpg?64', '2025-08-03 01:29:01', 5, 0);

"COMMIT"

"COMMIT";

SELECT
  u0_.`id` AS id_0,
  u0_.`unid` AS unid_1,
  u0_.`corporate_unid` AS corporate_unid_2,
  u0_.`token` AS token_3,
  u0_.`is_active` AS is_active_4,
  u0_.`proved` AS proved_5,
  u0_.`alias` AS alias_6,
  u0_.`foreign_alias` AS foreign_alias_7,
  u0_.`lotus_name` AS lotus_name_8,
  u0_.`password` AS password_9,
  u0_.`expired` AS expired_10,
  u0_.`expires_at` AS expires_at_11,
  u0_.`credentials_expired` AS credentials_expired_12,
  u0_.`credentials_expire_at` AS credentials_expire_at_13,
  u0_.`last_ip` AS last_ip_14,
  u0_.`source` AS source_15,
  u0_.`social_network` AS social_network_16,
  u0_.`social_network_id` AS social_network_id_17,
  u0_.`google_id` AS google_id_18,
  u0_.`fb_id` AS fb_id_19,
  u0_.`vk_id` AS vk_id_20,
  u0_.`ig_id` AS ig_id_21,
  u0_.`test` AS test_22,
  u0_.`token_fixed` AS token_fixed_23,
  u0_.`bid` AS bid_24,
  u0_.`email` AS email_25,
  u0_.`salt` AS salt_26,
  u0_.`review_request_sent` AS review_request_sent_27,
  u0_.`username` AS username_28,
  u0_.`roles` AS roles_29,
  u0_.`enabled` AS enabled_30,
  u0_.`confirmation_token` AS confirmation_token_31,
  u0_.`last_login` AS last_login_32,
  u0_.`password_requested_at` AS password_requested_at_33,
  u0_.`security_field` AS security_field_34,
  u0_.`created_at` AS created_at_35,
  u0_.`is_legal_entity` AS is_legal_entity_36,
  u0_.`companyName` AS companyName_37,
  u0_.`vatNumber` AS vatNumber_38,
  u0_.`lang` AS lang_39
FROM
  `user` u0_
WHERE
  u0_.`token` = ?
LIMIT
  1

SELECT u0_.`id` AS id_0, u0_.`unid` AS unid_1, u0_.`corporate_unid` AS corporate_unid_2, u0_.`token` AS token_3, u0_.`is_active` AS is_active_4, u0_.`proved` AS proved_5, u0_.`alias` AS alias_6, u0_.`foreign_alias` AS foreign_alias_7, u0_.`lotus_name` AS lotus_name_8, u0_.`password` AS password_9, u0_.`expired` AS expired_10, u0_.`expires_at` AS expires_at_11, u0_.`credentials_expired` AS credentials_expired_12, u0_.`credentials_expire_at` AS credentials_expire_at_13, u0_.`last_ip` AS last_ip_14, u0_.`source` AS source_15, u0_.`social_network` AS social_network_16, u0_.`social_network_id` AS social_network_id_17, u0_.`google_id` AS google_id_18, u0_.`fb_id` AS fb_id_19, u0_.`vk_id` AS vk_id_20, u0_.`ig_id` AS ig_id_21, u0_.`test` AS test_22, u0_.`token_fixed` AS token_fixed_23, u0_.`bid` AS bid_24, u0_.`email` AS email_25, u0_.`salt` AS salt_26, u0_.`review_request_sent` AS review_request_sent_27, u0_.`username` AS username_28, u0_.`roles` AS roles_29, u0_.`enabled` AS enabled_30, u0_.`confirmation_token` AS confirmation_token_31, u0_.`last_login` AS last_login_32, u0_.`password_requested_at` AS password_requested_at_33, u0_.`security_field` AS security_field_34, u0_.`created_at` AS created_at_35, u0_.`is_legal_entity` AS is_legal_entity_36, u0_.`companyName` AS companyName_37, u0_.`vatNumber` AS vatNumber_38, u0_.`lang` AS lang_39 FROM `user` u0_ WHERE u0_.`token` = '9ae6422274511d1ededfc55faa6d7c576cc7c713a81ef11bab9f1d50e8dfb602' LIMIT 1;

SELECT
  COUNT(b0_.`code`) AS sclr_0
FROM
  `buy_order` b1_
  LEFT JOIN `buy_order_article` b0_ ON b1_.id = b0_.buy_order_id
WHERE
  b1_.`token` = ?
  AND b1_.`status` <> 12

SELECT COUNT(b0_.`code`) AS sclr_0 FROM `buy_order` b1_ LEFT JOIN `buy_order_article` b0_ ON b1_.id = b0_.buy_order_id WHERE b1_.`token` = '9ae6422274511d1ededfc55faa6d7c576cc7c713a81ef11bab9f1d50e8dfb602' AND b1_.`status` <> 12;

SELECT
  b0_.`id` AS id_0
FROM
  `buy_order` b0_
WHERE
  b0_.`token` = ?
  AND b0_.`status` <> 12

SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = '9ae6422274511d1ededfc55faa6d7c576cc7c713a81ef11bab9f1d50e8dfb602' AND b0_.`status` <> 12;

SELECT
  COUNT(v0_.`id`) AS sclr_0
FROM
  `visit` v0_
WHERE
  v0_.`token` = ?
  AND v0_.`url` <> '/.*catalog.*/'

SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = '9ae6422274511d1ededfc55faa6d7c576cc7c713a81ef11bab9f1d50e8dfb602' AND v0_.`url` <> '/.*catalog.*/';

SELECT
  COUNT(i0_.`id`) AS sclr_0
FROM
  `idea` i1_
  INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id
  INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id
WHERE
  i1_.`token` = ?

SELECT COUNT(i0_.`id`) AS sclr_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = '9ae6422274511d1ededfc55faa6d7c576cc7c713a81ef11bab9f1d50e8dfb602';

SELECT
  b0_.`id` AS id_0,
  b0_.`name` AS name_1,
  b0_.`descr` AS descr_2,
  b0_.`val` AS val_3
FROM
  `BoolDBSetting` b0_
WHERE
  b0_.`name` = ?

SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = 'RTWidget';