Symfony Profiler

SELECT
  t0.`id` AS id_1,
  t0.`unid` AS unid_2,
  t0.`code` AS code_3,
  t0.`name` AS name_4,
  t0.`alternate_name` AS alternate_name_5,
  t0.`name_full` AS name_full_6,
  t0.`url` AS url_7,
  t0.`status` AS status_8,
  t0.`type` AS type_9,
  t0.`typeSet` AS typeSet_10,
  t0.`pc_as_m` AS pc_as_m_11,
  t0.`publish_date` AS publish_date_12,
  t0.`update_date` AS update_date_13,
  t0.`archive` AS archive_14,
  t0.`pr_min_euro` AS pr_min_euro_15,
  t0.`pr_min_euro_de` AS pr_min_euro_de_16,
  t0.`pr_min_euro_at` AS pr_min_euro_at_17,
  t0.`pr_min_euro_fi` AS pr_min_euro_fi_18,
  t0.`pr_min_euro_fr` AS pr_min_euro_fr_19,
  t0.`pr_min_euro_it` AS pr_min_euro_it_20,
  t0.`pr_min_euro_be` AS pr_min_euro_be_21,
  t0.`pr_min_euro_ie` AS pr_min_euro_ie_22,
  t0.`pr_min_euro_nl` AS pr_min_euro_nl_23,
  t0.`pr_min_euro_es` AS pr_min_euro_es_24,
  t0.`pr_min_rub` AS pr_min_rub_25,
  t0.`pr_min_rue` AS pr_min_rue_26,
  t0.`pr_min_gbp` AS pr_min_gbp_27,
  t0.`pr_min_gbe` AS pr_min_gbe_28,
  t0.`pr_min_usd` AS pr_min_usd_29,
  t0.`pr_min_use` AS pr_min_use_30,
  t0.`pr_min_f_usd` AS pr_min_f_usd_31,
  t0.`pr_min_f_use` AS pr_min_f_use_32,
  t0.`pr_min_chf` AS pr_min_chf_33,
  t0.`pr_min_che` AS pr_min_che_34,
  t0.`pr_min_sek` AS pr_min_sek_35,
  t0.`pr_min_see` AS pr_min_see_36,
  t0.`pr_min_dkk` AS pr_min_dkk_37,
  t0.`pr_min_dke` AS pr_min_dke_38,
  t0.`pr_min_nok` AS pr_min_nok_39,
  t0.`pr_min_noe` AS pr_min_noe_40,
  t0.`pr_min_pln` AS pr_min_pln_41,
  t0.`pr_min_ple` AS pr_min_ple_42,
  t0.`pr_min_cad` AS pr_min_cad_43,
  t0.`pr_min_cae` AS pr_min_cae_44,
  t0.`pr_min_f_cad` AS pr_min_f_cad_45,
  t0.`pr_min_f_cae` AS pr_min_f_cae_46,
  t0.`pr_min_ed` AS pr_min_ed_47,
  t0.`important` AS important_48,
  t0.`author` AS author_49,
  t0.`author_id` AS author_id_50,
  t0.`rating` AS rating_51,
  t0.`header` AS header_52,
  t0.`settings` AS settings_53,
  t0.`fids` AS fids_54,
  t0.`portal_unid` AS portal_unid_55,
  t0.`accepted_at` AS accepted_at_56,
  t0.`accept_state` AS accept_state_57,
  t0.`description_edit` AS description_edit_58,
  t0.`link_award` AS link_award_59,
  t0.`awards` AS awards_60,
  t0.`video` AS video_61,
  t0.`stated_at` AS stated_at_62,
  t0.`state` AS state_63,
  t0.`description_state` AS description_state_64,
  t0.`body_hide` AS body_hide_65,
  t0.`release_year` AS release_year_66,
  t0.`site` AS site_67,
  t0.`show_main` AS show_main_68,
  t0.`glue_url` AS glue_url_69,
  t0.`accessible` AS accessible_70,
  t0.`delivery_suspended` AS delivery_suspended_71,
  t0.`process` AS process_72,
  t0.`exhibition` AS exhibition_73,
  t0.`test_access` AS test_access_74,
  t0.`views` AS views_75,
  t0.`comment_unid` AS comment_unid_76,
  t0.`accesible_at` AS accesible_at_77,
  t0.`created_at` AS created_at_78,
  t0.`updated_at` AS updated_at_79,
  t0.factory AS factory_80,
  t0.category_price AS category_price_81,
  t82.`id` AS id_83,
  t82.`source` AS source_84,
  t82.`ru` AS ru_85,
  t82.`en` AS en_86,
  t82.`it` AS it_87,
  t82.`es` AS es_88,
  t82.`fr` AS fr_89,
  t82.`de` AS de_90,
  t82.`pl` AS pl_91,
  t82.`pt` AS pt_92,
  t82.`nl` AS nl_93,
  t82.`fi` AS fi_94,
  t82.`ua` AS ua_95,
  t82.`sv` AS sv_96,
  t82.`no` AS no_97,
  t82.`da` AS da_98,
  t82.`cn` AS cn_99,
  t82.`zh` AS zh_100,
  t82.`created_at` AS created_at_101,
  t82.`updated_at` AS updated_at_102,
  t82.email_body_id AS email_body_id_103,
  t82.publication_body_id AS publication_body_id_104,
  t82.static_page_body_id AS static_page_body_id_105,
  t82.collection_body_id AS collection_body_id_106,
  t82.trans_val_id AS trans_val_id_107,
  t82.exh_text_id AS exh_text_id_108,
  t82.exh_brand_text_id AS exh_brand_text_id_109,
  t82.exh_collection_text_id AS exh_collection_text_id_110,
  t82.filter_html_id AS filter_html_id_111,
  t112.`id` AS id_113,
  t112.`source` AS source_114,
  t112.`ru` AS ru_115,
  t112.`en` AS en_116,
  t112.`it` AS it_117,
  t112.`es` AS es_118,
  t112.`fr` AS fr_119,
  t112.`de` AS de_120,
  t112.`pl` AS pl_121,
  t112.`pt` AS pt_122,
  t112.`nl` AS nl_123,
  t112.`fi` AS fi_124,
  t112.`ua` AS ua_125,
  t112.`sv` AS sv_126,
  t112.`no` AS no_127,
  t112.`da` AS da_128,
  t112.`cn` AS cn_129,
  t112.`zh` AS zh_130,
  t112.`created_at` AS created_at_131,
  t112.`updated_at` AS updated_at_132,
  t112.static_page_title_id AS static_page_title_id_133,
  t112.static_page_keywords_id AS static_page_keywords_id_134,
  t112.static_page_description_id AS static_page_description_id_135,
  t112.collection_keywords_id AS collection_keywords_id_136,
  t112.collection_description_id AS collection_description_id_137,
  t112.blog_keywords_id AS blog_keywords_id_138,
  t112.blog_description_id AS blog_description_id_139,
  t112.exh_keywords_id AS exh_keywords_id_140,
  t112.exh_description_id AS exh_description_id_141,
  t142.`id` AS id_143,
  t142.`source` AS source_144,
  t142.`ru` AS ru_145,
  t142.`en` AS en_146,
  t142.`it` AS it_147,
  t142.`es` AS es_148,
  t142.`fr` AS fr_149,
  t142.`de` AS de_150,
  t142.`pl` AS pl_151,
  t142.`pt` AS pt_152,
  t142.`nl` AS nl_153,
  t142.`fi` AS fi_154,
  t142.`ua` AS ua_155,
  t142.`sv` AS sv_156,
  t142.`no` AS no_157,
  t142.`da` AS da_158,
  t142.`cn` AS cn_159,
  t142.`zh` AS zh_160,
  t142.`created_at` AS created_at_161,
  t142.`updated_at` AS updated_at_162,
  t142.static_page_title_id AS static_page_title_id_163,
  t142.static_page_keywords_id AS static_page_keywords_id_164,
  t142.static_page_description_id AS static_page_description_id_165,
  t142.collection_keywords_id AS collection_keywords_id_166,
  t142.collection_description_id AS collection_description_id_167,
  t142.blog_keywords_id AS blog_keywords_id_168,
  t142.blog_description_id AS blog_description_id_169,
  t142.exh_keywords_id AS exh_keywords_id_170,
  t142.exh_description_id AS exh_description_id_171
FROM
  `collection` t0
  LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id
  LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id
  LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id
WHERE
  t0.factory = ?

SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = 80;

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` = '87c303e7ef34bc016374a5080bfd73caf1c0f17897d3083e10a01d5a8be7fdae' AND v0_.`url` <> '/.*catalog.*/';

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` = '87c303e7ef34bc016374a5080bfd73caf1c0f17897d3083e10a01d5a8be7fdae' AND v0_.`url` = 'catalogue/tau' AND v0_.`url` <> '/.*catalog.*/' LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`reviewId` AS reviewId_2,
  t0.`referenceId` AS referenceId_3,
  t0.`conversationId` AS conversationId_4,
  t0.`p_id` AS p_id_5,
  t0.`sku` AS sku_6,
  t0.`gtin` AS gtin_7,
  t0.`mpn` AS mpn_8,
  t0.`url` AS url_9,
  t0.`star` AS star_10,
  t0.`score` AS score_11,
  t0.`date` AS date_12,
  t0.`created_at` AS created_at_13,
  t0.`content` AS content_14,
  t0.`username` AS username_15,
  t0.`country` AS country_16,
  t0.`locale` AS locale_17,
  t0.`language` AS language_18,
  t0.`state` AS state_19,
  t0.`unid_theme` AS unid_theme_20,
  t0.`send_portal_date` AS send_portal_date_21,
  t0.`answer` AS answer_22,
  t0.`manager` AS manager_23,
  t0.`is_anonymous` AS is_anonymous_24,
  t0.`is_collection_review` AS is_collection_review_25,
  t0.article_id AS article_id_26,
  t0.collection_id AS collection_id_27,
  t0.order_id AS order_id_28,
  t0.user_id AS user_id_29
FROM
  `product_reviews_cache` t0
WHERE
  t0.collection_id IN (?)

SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (22, 61, 125, 137, 153, 194, 279, 368, 460, 462, 480, 533, 647, 719, 771, 775, 784, 888, 890, 911, 1107, 1182, 1222, 1304, 1397, 1530, 1555, 1582, 1662, 248572, 248573, 380779, 3244703, 3246197, 3246541, 3246542, 3246549, 3246550, 3246551, 3246562, 3246563, 3246564, 3246565, 3246569, 3246570, 3246571, 3246646, 3247024, 3247074, 3247228, 3247290, 3247298, 3247301, 3247302, 3247304, 3247306, 3247307, 3247319, 3247320, 3247321, 3247323, 3247328, 3247341, 3247351, 3247352, 3247353, 3247354, 3247494, 3247587, 3247621, 3247622, 3247623, 3247921, 3247922, 3247941, 3247991, 3248037, 3248041, 3248053, 3248191, 3248201, 3248202, 3248258, 3248447, 3248448, 3248473, 3248569, 3248579, 3248698, 3248700, 3248701, 3248702, 3248703, 3249020, 3249032, 3249034, 3249050, 3249488, 3250616, 3250883);

SELECT
  f0_.`old_id` AS old_id_0,
  f1_.`name_single_en` AS name_single_en_1,
  f1_.`name_menu_en` AS name_menu_en_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_en` AS name_single_en_1, f1_.`name_menu_en` AS name_menu_en_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
  p0_.`id` AS id_0,
  p0_.`reviewId` AS reviewId_1,
  p0_.`referenceId` AS referenceId_2,
  p0_.`conversationId` AS conversationId_3,
  p0_.`p_id` AS p_id_4,
  p0_.`sku` AS sku_5,
  p0_.`gtin` AS gtin_6,
  p0_.`mpn` AS mpn_7,
  p0_.`url` AS url_8,
  p0_.`star` AS star_9,
  p0_.`score` AS score_10,
  p0_.`date` AS date_11,
  p0_.`created_at` AS created_at_12,
  p0_.`content` AS content_13,
  p0_.`username` AS username_14,
  p0_.`country` AS country_15,
  p0_.`locale` AS locale_16,
  p0_.`language` AS language_17,
  p0_.`state` AS state_18,
  p0_.`unid_theme` AS unid_theme_19,
  p0_.`send_portal_date` AS send_portal_date_20,
  p0_.`answer` AS answer_21,
  p0_.`manager` AS manager_22,
  p0_.`is_anonymous` AS is_anonymous_23,
  p0_.`is_collection_review` AS is_collection_review_24
FROM
  `product_reviews_cache` p0_

SELECT p0_.`id` AS id_0, p0_.`reviewId` AS reviewId_1, p0_.`referenceId` AS referenceId_2, p0_.`conversationId` AS conversationId_3, p0_.`p_id` AS p_id_4, p0_.`sku` AS sku_5, p0_.`gtin` AS gtin_6, p0_.`mpn` AS mpn_7, p0_.`url` AS url_8, p0_.`star` AS star_9, p0_.`score` AS score_10, p0_.`date` AS date_11, p0_.`created_at` AS created_at_12, p0_.`content` AS content_13, p0_.`username` AS username_14, p0_.`country` AS country_15, p0_.`locale` AS locale_16, p0_.`language` AS language_17, p0_.`state` AS state_18, p0_.`unid_theme` AS unid_theme_19, p0_.`send_portal_date` AS send_portal_date_20, p0_.`answer` AS answer_21, p0_.`manager` AS manager_22, p0_.`is_anonymous` AS is_anonymous_23, p0_.`is_collection_review` AS is_collection_review_24 FROM `product_reviews_cache` p0_;

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

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 ('87c303e7ef34bc016374a5080bfd73ca', 'catalogue/tau', 'Manufacturer Tau', '/img/histories/tile-catalogue.jpg?64', '2025-10-22 21:15:22', 5, 0);

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` = '87c303e7ef34bc016374a5080bfd73caf1c0f17897d3083e10a01d5a8be7fdae' 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_.`id` AS id_0
FROM
  `geo_country` g1_
  LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id
  LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id
WHERE
  g1_.`code` = ?

SELECT f0_.`id` AS id_0 FROM `geo_country` g1_ LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id WHERE g1_.`code` = 'it';

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` = '87c303e7ef34bc016374a5080bfd73caf1c0f17897d3083e10a01d5a8be7fdae' LIMIT 1;

SELECT
  t0.`id` AS id_1,
  t0.`token` AS token_2,
  t0.`current_welcome_cons` AS current_welcome_cons_3,
  t0.`current_country` AS current_country_4,
  t0.`current_country_by_ip` AS current_country_by_ip_5,
  t0.`current_locale` AS current_locale_6,
  t0.`is_interview` AS is_interview_7,
  t0.`job_seeker_unid` AS job_seeker_unid_8,
  t0.interview_id AS interview_id_9
FROM
  `chat_b` t0
WHERE
  t0.`token` = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`token` AS token_2, t0.`current_welcome_cons` AS current_welcome_cons_3, t0.`current_country` AS current_country_4, t0.`current_country_by_ip` AS current_country_by_ip_5, t0.`current_locale` AS current_locale_6, t0.`is_interview` AS is_interview_7, t0.`job_seeker_unid` AS job_seeker_unid_8, t0.interview_id AS interview_id_9 FROM `chat_b` t0 WHERE t0.`token` = '87c303e7ef34bc016374a5080bfd73caf1c0f17897d3083e10a01d5a8be7fdae' 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` = ?
LIMIT
  1