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.en AS `isHtmlShow`,
  fp.name_menu_en AS `nameMenu`,
  fp.name_many_en AS `nameMany`,
  fp.name_single_en AS `nameSingle`,
  fp.html_en AS `html`,
  fp.description_en AS `description`,
  metadesc.en 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.en AS `groupName`,
  url.en 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_en AS `countryName`,
  cnurl.en 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.en AS `isHtmlShow`, fp.name_menu_en AS `nameMenu`, fp.name_many_en AS `nameMany`, fp.name_single_en AS `nameSingle`, fp.html_en AS `html`, fp.description_en AS `description`, metadesc.en 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.en AS `groupName`, url.en 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_en AS `countryName`, cnurl.en 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 = 'non-rettificato' OR url.en = 'non-rettificato' OR url.it = 'non-rettificato' OR url.es = 'non-rettificato' OR url.fr = 'non-rettificato' OR url.de = 'non-rettificato' OR url.pl = 'non-rettificato' OR url.nl = 'non-rettificato' OR url.fi = 'non-rettificato' OR url.sv = 'non-rettificato' ;

SELECT
  i.id AS iId,
  i.url AS iUrl,
  i.name AS iName,
  i.alt AS iAlt,
  i.file AS iFile,
  i.status AS iStatus,
  i.file_size_x AS iFileSizeX,
  i.file_size_y AS iFileSizeY,
  i.file_size_z_x AS iFileSizeZX,
  i.file_size_z_y AS iFileSizeZY,
  i.file_size_hd_x AS iFileSizeHdX,
  i.file_size_hd_y AS iFileSizeHdY,
  i.file_size_shd_x AS iFileSizeShdX,
  i.file_size_shd_y AS iFileSizeShdY,
  i.file_size4k_x AS iFileSize4kX,
  i.file_size4k_y AS iFileSize4kY,
  c.id AS cId,
  c.url AS cUrl,
  c.status AS cStatus,
  c.name AS cName,
  c.alternate_name AS cAName,
  c.pr_min_euro AS prMinEuro,
  c.pr_min_euro_de AS prMinEuroDe,
  c.pr_min_euro_fr AS prMinEuroFr,
  c.pr_min_euro_it AS prMinEuroIt,
  c.pr_min_euro_be AS prMinEuroBe,
  c.pr_min_euro_ie AS prMinEuroIe,
  c.pr_min_euro_nl AS prMinEuroNl,
  c.pr_min_euro_es AS prMinEuroEs,
  c.pr_min_rue AS prMinRUB,
  c.pr_min_rue AS prMinRUE,
  c.pr_min_gbp AS prMinGBP,
  c.pr_min_gbe AS prMinGBE,
  c.pr_min_usd AS prMinUSD,
  c.pr_min_use AS prMinUSE,
  c.pr_min_f_usd AS prMinFUSD,
  c.pr_min_f_use AS prMinFUSE,
  c.pr_min_chf AS prMinCHF,
  c.pr_min_che AS prMinCHE,
  c.pr_min_sek AS prMinSEK,
  c.pr_min_see AS prMinSEE,
  c.pr_min_dkk AS prMinDKK,
  c.pr_min_dke AS prMinDKE,
  c.pr_min_nok AS prMinNOK,
  c.pr_min_noe AS prMinNOE,
  c.pr_min_pln AS prMinPLN,
  c.pr_min_ple AS prMinPLE,
  c.pr_min_cad AS prMinCAD,
  c.pr_min_cae AS prMinCAE,
  c.pr_min_f_cad AS prMinEuroFCAD,
  c.pr_min_f_cae AS prMinEuroFCAE,
  f.id AS fId,
  f.url AS fUrl,
  f.status AS fStatus,
  f.name AS fName,
  f.alternate_name AS fAName,
  f.suspended AS fSuspended,
  a.id AS itemId,
  lc.id AS lcId,
  lc.code AS lcCode,
  lc.alias AS lcAlias,
  la.id AS laId,
  la.alias AS laAlias,
  lst.id AS lstId,
  lst.alias AS lstAlias,
  lt.id AS ltId,
  lt.alias AS ltAlias,
  (
    SELECT
      COUNT(ii.idea_id)
    FROM
      `idea_interior` ii
    WHERE
      `ii`.`interior_id` = `i`.id
  ) AS ideaCount
FROM
  interior i
  LEFT JOIN collection c ON c.id = i.collection
  LEFT JOIN factory f ON f.id = c.factory
  LEFT JOIN interior_article iat ON iat.interior_id = i.id
  LEFT JOIN article a ON a.id = iat.article_id
  LEFT JOIN list_country lc ON lc.id = f.country
  LEFT JOIN interior_apply ia ON ia.interior_id = i.id
  LEFT JOIN list_apply la ON la.id = ia.apply_id
  LEFT JOIN interior_texture it ON it.interior_id = i.id
  LEFT JOIN list_texture lt ON lt.id = it.texture_id
  LEFT JOIN interior_style ist ON ist.interior_id = i.id
  LEFT JOIN list_style lst ON lst.id = ist.style_id
WHERE
  c.id = 413
  AND i.status = 1

SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 413 AND i.status = 1
        ;

UPDATE
  `collection`
SET
  `views` = `views` + '1'
WHERE
  `id` = :id

UPDATE `collection` SET `views` = `views` + '1' WHERE `id` = 413;

SELECT
  c0_.`id` AS id_0,
  c0_.`unid` AS unid_1,
  c0_.`code` AS code_2,
  c0_.`name` AS name_3,
  c0_.`alternate_name` AS alternate_name_4,
  c0_.`name_full` AS name_full_5,
  c0_.`url` AS url_6,
  c0_.`status` AS status_7,
  c0_.`type` AS type_8,
  c0_.`typeSet` AS typeSet_9,
  c0_.`pc_as_m` AS pc_as_m_10,
  c0_.`publish_date` AS publish_date_11,
  c0_.`update_date` AS update_date_12,
  c0_.`archive` AS archive_13,
  c0_.`pr_min_euro` AS pr_min_euro_14,
  c0_.`pr_min_euro_de` AS pr_min_euro_de_15,
  c0_.`pr_min_euro_at` AS pr_min_euro_at_16,
  c0_.`pr_min_euro_fi` AS pr_min_euro_fi_17,
  c0_.`pr_min_euro_fr` AS pr_min_euro_fr_18,
  c0_.`pr_min_euro_it` AS pr_min_euro_it_19,
  c0_.`pr_min_euro_be` AS pr_min_euro_be_20,
  c0_.`pr_min_euro_ie` AS pr_min_euro_ie_21,
  c0_.`pr_min_euro_nl` AS pr_min_euro_nl_22,
  c0_.`pr_min_euro_es` AS pr_min_euro_es_23,
  c0_.`pr_min_rub` AS pr_min_rub_24,
  c0_.`pr_min_rue` AS pr_min_rue_25,
  c0_.`pr_min_gbp` AS pr_min_gbp_26,
  c0_.`pr_min_gbe` AS pr_min_gbe_27,
  c0_.`pr_min_usd` AS pr_min_usd_28,
  c0_.`pr_min_use` AS pr_min_use_29,
  c0_.`pr_min_f_usd` AS pr_min_f_usd_30,
  c0_.`pr_min_f_use` AS pr_min_f_use_31,
  c0_.`pr_min_chf` AS pr_min_chf_32,
  c0_.`pr_min_che` AS pr_min_che_33,
  c0_.`pr_min_sek` AS pr_min_sek_34,
  c0_.`pr_min_see` AS pr_min_see_35,
  c0_.`pr_min_dkk` AS pr_min_dkk_36,
  c0_.`pr_min_dke` AS pr_min_dke_37,
  c0_.`pr_min_nok` AS pr_min_nok_38,
  c0_.`pr_min_noe` AS pr_min_noe_39,
  c0_.`pr_min_pln` AS pr_min_pln_40,
  c0_.`pr_min_ple` AS pr_min_ple_41,
  c0_.`pr_min_cad` AS pr_min_cad_42,
  c0_.`pr_min_cae` AS pr_min_cae_43,
  c0_.`pr_min_f_cad` AS pr_min_f_cad_44,
  c0_.`pr_min_f_cae` AS pr_min_f_cae_45,
  c0_.`pr_min_ed` AS pr_min_ed_46,
  c0_.`important` AS important_47,
  c0_.`author` AS author_48,
  c0_.`author_id` AS author_id_49,
  c0_.`rating` AS rating_50,
  c0_.`header` AS header_51,
  c0_.`settings` AS settings_52,
  c0_.`fids` AS fids_53,
  c0_.`portal_unid` AS portal_unid_54,
  c0_.`accepted_at` AS accepted_at_55,
  c0_.`accept_state` AS accept_state_56,
  c0_.`description_edit` AS description_edit_57,
  c0_.`link_award` AS link_award_58,
  c0_.`awards` AS awards_59,
  c0_.`video` AS video_60,
  c0_.`stated_at` AS stated_at_61,
  c0_.`state` AS state_62,
  c0_.`description_state` AS description_state_63,
  c0_.`body_hide` AS body_hide_64,
  c0_.`release_year` AS release_year_65,
  c0_.`site` AS site_66,
  c0_.`show_main` AS show_main_67,
  c0_.`glue_url` AS glue_url_68,
  c0_.`accessible` AS accessible_69,
  c0_.`delivery_suspended` AS delivery_suspended_70,
  c0_.`process` AS process_71,
  c0_.`exhibition` AS exhibition_72,
  c0_.`test_access` AS test_access_73,
  c0_.`views` AS views_74,
  c0_.`comment_unid` AS comment_unid_75,
  c0_.`accesible_at` AS accesible_at_76,
  c0_.`created_at` AS created_at_77,
  c0_.`updated_at` AS updated_at_78,
  f1_.`id` AS id_79,
  f1_.`unid` AS unid_80,
  f1_.`name` AS name_81,
  f1_.`name_inv` AS name_inv_82,
  f1_.`url` AS url_83,
  f1_.`alternate_name` AS alternate_name_84,
  f1_.`description_ru` AS description_ru_85,
  f1_.`description_en` AS description_en_86,
  f1_.`description_it` AS description_it_87,
  f1_.`description_es` AS description_es_88,
  f1_.`description_fr` AS description_fr_89,
  f1_.`description_de` AS description_de_90,
  f1_.`description_pt` AS description_pt_91,
  f1_.`description_pl` AS description_pl_92,
  f1_.`description_nl` AS description_nl_93,
  f1_.`description_fi` AS description_fi_94,
  f1_.`description_ua` AS description_ua_95,
  f1_.`description_sv` AS description_sv_96,
  f1_.`description_no` AS description_no_97,
  f1_.`description_da` AS description_da_98,
  f1_.`description_zh` AS description_zh_99,
  f1_.`delivery_time` AS delivery_time_100,
  f1_.`not_regular` AS not_regular_101,
  f1_.`suspended` AS suspended_102,
  f1_.`status` AS status_103,
  f1_.`type` AS type_104,
  f1_.`discount` AS discount_105,
  f1_.`discount_date_start` AS discount_date_start_106,
  f1_.`discount_date_end` AS discount_date_end_107,
  f1_.`transcription` AS transcription_108,
  f1_.`cost_delivery` AS cost_delivery_109,
  f1_.`create_date` AS create_date_110,
  f1_.`is_accepted` AS is_accepted_111,
  f1_.`accepted_at` AS accepted_at_112,
  f1_.`accept_state` AS accept_state_113,
  f1_.`description_edit` AS description_edit_114,
  f1_.`stated_at` AS stated_at_115,
  f1_.`state` AS state_116,
  f1_.`description_state` AS description_state_117,
  f1_.`video` AS video_118,
  f1_.`parser_address` AS parser_address_119,
  f1_.`accessible` AS accessible_120,
  f1_.`sound` AS sound_121,
  f1_.`test_access` AS test_access_122,
  f1_.`total_ideas` AS total_ideas_123,
  f1_.`votes_submit` AS votes_submit_124,
  f1_.`votes_stars` AS votes_stars_125,
  f1_.`brand_link` AS brand_link_126,
  f1_.`brand_logo` AS brand_logo_127,
  f1_.`no_send_portl_message` AS no_send_portl_message_128,
  l2_.`id` AS id_129,
  l2_.`code` AS code_130,
  l2_.`locale` AS locale_131,
  l2_.`phone_code` AS phone_code_132,
  l2_.`phone_mask` AS phone_mask_133,
  l2_.`min_valid_phone_numbers` AS min_valid_phone_numbers_134,
  l2_.`zip_code_mask` AS zip_code_mask_135,
  l2_.`percent_vat` AS percent_vat_136,
  l2_.`name` AS name_137,
  l2_.`name_en` AS name_en_138,
  l2_.`alias` AS alias_139,
  l2_.`sort` AS sort_140,
  l2_.`count` AS count_141,
  l2_.`hide` AS hide_142,
  l2_.`important` AS important_143,
  l2_.`pay_pal_percent` AS pay_pal_percent_144,
  l2_.`pay_pal_percent_own` AS pay_pal_percent_own_145,
  l2_.`vat` AS vat_146,
  l2_.`pv_type` AS pv_type_147,
  l2_.`capital_timezone_diff` AS capital_timezone_diff_148,
  l2_.`capital` AS capital_149,
  l2_.`free_sample_delivery` AS free_sample_delivery_150,
  l2_.`units` AS units_151,
  l3_.`id` AS id_152,
  l3_.`source` AS source_153,
  l3_.`ru` AS ru_154,
  l3_.`en` AS en_155,
  l3_.`it` AS it_156,
  l3_.`es` AS es_157,
  l3_.`fr` AS fr_158,
  l3_.`de` AS de_159,
  l3_.`pl` AS pl_160,
  l3_.`pt` AS pt_161,
  l3_.`nl` AS nl_162,
  l3_.`fi` AS fi_163,
  l3_.`ua` AS ua_164,
  l3_.`sv` AS sv_165,
  l3_.`no` AS no_166,
  l3_.`da` AS da_167,
  l3_.`cn` AS cn_168,
  l3_.`zh` AS zh_169,
  l3_.`created_at` AS created_at_170,
  l3_.`updated_at` AS updated_at_171,
  l4_.`id` AS id_172,
  l4_.`source` AS source_173,
  l4_.`ru` AS ru_174,
  l4_.`en` AS en_175,
  l4_.`it` AS it_176,
  l4_.`es` AS es_177,
  l4_.`fr` AS fr_178,
  l4_.`de` AS de_179,
  l4_.`pl` AS pl_180,
  l4_.`pt` AS pt_181,
  l4_.`nl` AS nl_182,
  l4_.`fi` AS fi_183,
  l4_.`ua` AS ua_184,
  l4_.`sv` AS sv_185,
  l4_.`no` AS no_186,
  l4_.`da` AS da_187,
  l4_.`cn` AS cn_188,
  l4_.`zh` AS zh_189,
  l4_.`created_at` AS created_at_190,
  l4_.`updated_at` AS updated_at_191,
  l5_.`id` AS id_192,
  l5_.`source` AS source_193,
  l5_.`ru` AS ru_194,
  l5_.`en` AS en_195,
  l5_.`it` AS it_196,
  l5_.`es` AS es_197,
  l5_.`fr` AS fr_198,
  l5_.`de` AS de_199,
  l5_.`pl` AS pl_200,
  l5_.`pt` AS pt_201,
  l5_.`nl` AS nl_202,
  l5_.`fi` AS fi_203,
  l5_.`ua` AS ua_204,
  l5_.`sv` AS sv_205,
  l5_.`no` AS no_206,
  l5_.`da` AS da_207,
  l5_.`cn` AS cn_208,
  l5_.`zh` AS zh_209,
  l5_.`created_at` AS created_at_210,
  l5_.`updated_at` AS updated_at_211
FROM
  `collection` c0_
  LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id
  LEFT JOIN `list_country` l2_ ON f1_.country = l2_.id
  LEFT JOIN `locale_html` l3_ ON c0_.id = l3_.collection_body_id
  LEFT JOIN `locale_meta` l4_ ON c0_.id = l4_.collection_keywords_id
  LEFT JOIN `locale_meta` l5_ ON c0_.id = l5_.collection_description_id
WHERE
  f1_.`status` > ?
  AND f1_.`url` = ?
  AND c0_.`url` = ?

SELECT c0_.`id` AS id_0, c0_.`unid` AS unid_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, c0_.`url` AS url_6, c0_.`status` AS status_7, c0_.`type` AS type_8, c0_.`typeSet` AS typeSet_9, c0_.`pc_as_m` AS pc_as_m_10, c0_.`publish_date` AS publish_date_11, c0_.`update_date` AS update_date_12, c0_.`archive` AS archive_13, c0_.`pr_min_euro` AS pr_min_euro_14, c0_.`pr_min_euro_de` AS pr_min_euro_de_15, c0_.`pr_min_euro_at` AS pr_min_euro_at_16, c0_.`pr_min_euro_fi` AS pr_min_euro_fi_17, c0_.`pr_min_euro_fr` AS pr_min_euro_fr_18, c0_.`pr_min_euro_it` AS pr_min_euro_it_19, c0_.`pr_min_euro_be` AS pr_min_euro_be_20, c0_.`pr_min_euro_ie` AS pr_min_euro_ie_21, c0_.`pr_min_euro_nl` AS pr_min_euro_nl_22, c0_.`pr_min_euro_es` AS pr_min_euro_es_23, c0_.`pr_min_rub` AS pr_min_rub_24, c0_.`pr_min_rue` AS pr_min_rue_25, c0_.`pr_min_gbp` AS pr_min_gbp_26, c0_.`pr_min_gbe` AS pr_min_gbe_27, c0_.`pr_min_usd` AS pr_min_usd_28, c0_.`pr_min_use` AS pr_min_use_29, c0_.`pr_min_f_usd` AS pr_min_f_usd_30, c0_.`pr_min_f_use` AS pr_min_f_use_31, c0_.`pr_min_chf` AS pr_min_chf_32, c0_.`pr_min_che` AS pr_min_che_33, c0_.`pr_min_sek` AS pr_min_sek_34, c0_.`pr_min_see` AS pr_min_see_35, c0_.`pr_min_dkk` AS pr_min_dkk_36, c0_.`pr_min_dke` AS pr_min_dke_37, c0_.`pr_min_nok` AS pr_min_nok_38, c0_.`pr_min_noe` AS pr_min_noe_39, c0_.`pr_min_pln` AS pr_min_pln_40, c0_.`pr_min_ple` AS pr_min_ple_41, c0_.`pr_min_cad` AS pr_min_cad_42, c0_.`pr_min_cae` AS pr_min_cae_43, c0_.`pr_min_f_cad` AS pr_min_f_cad_44, c0_.`pr_min_f_cae` AS pr_min_f_cae_45, c0_.`pr_min_ed` AS pr_min_ed_46, c0_.`important` AS important_47, c0_.`author` AS author_48, c0_.`author_id` AS author_id_49, c0_.`rating` AS rating_50, c0_.`header` AS header_51, c0_.`settings` AS settings_52, c0_.`fids` AS fids_53, c0_.`portal_unid` AS portal_unid_54, c0_.`accepted_at` AS accepted_at_55, c0_.`accept_state` AS accept_state_56, c0_.`description_edit` AS description_edit_57, c0_.`link_award` AS link_award_58, c0_.`awards` AS awards_59, c0_.`video` AS video_60, c0_.`stated_at` AS stated_at_61, c0_.`state` AS state_62, c0_.`description_state` AS description_state_63, c0_.`body_hide` AS body_hide_64, c0_.`release_year` AS release_year_65, c0_.`site` AS site_66, c0_.`show_main` AS show_main_67, c0_.`glue_url` AS glue_url_68, c0_.`accessible` AS accessible_69, c0_.`delivery_suspended` AS delivery_suspended_70, c0_.`process` AS process_71, c0_.`exhibition` AS exhibition_72, c0_.`test_access` AS test_access_73, c0_.`views` AS views_74, c0_.`comment_unid` AS comment_unid_75, c0_.`accesible_at` AS accesible_at_76, c0_.`created_at` AS created_at_77, c0_.`updated_at` AS updated_at_78, f1_.`id` AS id_79, f1_.`unid` AS unid_80, f1_.`name` AS name_81, f1_.`name_inv` AS name_inv_82, f1_.`url` AS url_83, f1_.`alternate_name` AS alternate_name_84, f1_.`description_ru` AS description_ru_85, f1_.`description_en` AS description_en_86, f1_.`description_it` AS description_it_87, f1_.`description_es` AS description_es_88, f1_.`description_fr` AS description_fr_89, f1_.`description_de` AS description_de_90, f1_.`description_pt` AS description_pt_91, f1_.`description_pl` AS description_pl_92, f1_.`description_nl` AS description_nl_93, f1_.`description_fi` AS description_fi_94, f1_.`description_ua` AS description_ua_95, f1_.`description_sv` AS description_sv_96, f1_.`description_no` AS description_no_97, f1_.`description_da` AS description_da_98, f1_.`description_zh` AS description_zh_99, f1_.`delivery_time` AS delivery_time_100, f1_.`not_regular` AS not_regular_101, f1_.`suspended` AS suspended_102, f1_.`status` AS status_103, f1_.`type` AS type_104, f1_.`discount` AS discount_105, f1_.`discount_date_start` AS discount_date_start_106, f1_.`discount_date_end` AS discount_date_end_107, f1_.`transcription` AS transcription_108, f1_.`cost_delivery` AS cost_delivery_109, f1_.`create_date` AS create_date_110, f1_.`is_accepted` AS is_accepted_111, f1_.`accepted_at` AS accepted_at_112, f1_.`accept_state` AS accept_state_113, f1_.`description_edit` AS description_edit_114, f1_.`stated_at` AS stated_at_115, f1_.`state` AS state_116, f1_.`description_state` AS description_state_117, f1_.`video` AS video_118, f1_.`parser_address` AS parser_address_119, f1_.`accessible` AS accessible_120, f1_.`sound` AS sound_121, f1_.`test_access` AS test_access_122, f1_.`total_ideas` AS total_ideas_123, f1_.`votes_submit` AS votes_submit_124, f1_.`votes_stars` AS votes_stars_125, f1_.`brand_link` AS brand_link_126, f1_.`brand_logo` AS brand_logo_127, f1_.`no_send_portl_message` AS no_send_portl_message_128, l2_.`id` AS id_129, l2_.`code` AS code_130, l2_.`locale` AS locale_131, l2_.`phone_code` AS phone_code_132, l2_.`phone_mask` AS phone_mask_133, l2_.`min_valid_phone_numbers` AS min_valid_phone_numbers_134, l2_.`zip_code_mask` AS zip_code_mask_135, l2_.`percent_vat` AS percent_vat_136, l2_.`name` AS name_137, l2_.`name_en` AS name_en_138, l2_.`alias` AS alias_139, l2_.`sort` AS sort_140, l2_.`count` AS count_141, l2_.`hide` AS hide_142, l2_.`important` AS important_143, l2_.`pay_pal_percent` AS pay_pal_percent_144, l2_.`pay_pal_percent_own` AS pay_pal_percent_own_145, l2_.`vat` AS vat_146, l2_.`pv_type` AS pv_type_147, l2_.`capital_timezone_diff` AS capital_timezone_diff_148, l2_.`capital` AS capital_149, l2_.`free_sample_delivery` AS free_sample_delivery_150, l2_.`units` AS units_151, l3_.`id` AS id_152, l3_.`source` AS source_153, l3_.`ru` AS ru_154, l3_.`en` AS en_155, l3_.`it` AS it_156, l3_.`es` AS es_157, l3_.`fr` AS fr_158, l3_.`de` AS de_159, l3_.`pl` AS pl_160, l3_.`pt` AS pt_161, l3_.`nl` AS nl_162, l3_.`fi` AS fi_163, l3_.`ua` AS ua_164, l3_.`sv` AS sv_165, l3_.`no` AS no_166, l3_.`da` AS da_167, l3_.`cn` AS cn_168, l3_.`zh` AS zh_169, l3_.`created_at` AS created_at_170, l3_.`updated_at` AS updated_at_171, l4_.`id` AS id_172, l4_.`source` AS source_173, l4_.`ru` AS ru_174, l4_.`en` AS en_175, l4_.`it` AS it_176, l4_.`es` AS es_177, l4_.`fr` AS fr_178, l4_.`de` AS de_179, l4_.`pl` AS pl_180, l4_.`pt` AS pt_181, l4_.`nl` AS nl_182, l4_.`fi` AS fi_183, l4_.`ua` AS ua_184, l4_.`sv` AS sv_185, l4_.`no` AS no_186, l4_.`da` AS da_187, l4_.`cn` AS cn_188, l4_.`zh` AS zh_189, l4_.`created_at` AS created_at_190, l4_.`updated_at` AS updated_at_191, l5_.`id` AS id_192, l5_.`source` AS source_193, l5_.`ru` AS ru_194, l5_.`en` AS en_195, l5_.`it` AS it_196, l5_.`es` AS es_197, l5_.`fr` AS fr_198, l5_.`de` AS de_199, l5_.`pl` AS pl_200, l5_.`pt` AS pt_201, l5_.`nl` AS nl_202, l5_.`fi` AS fi_203, l5_.`ua` AS ua_204, l5_.`sv` AS sv_205, l5_.`no` AS no_206, l5_.`da` AS da_207, l5_.`cn` AS cn_208, l5_.`zh` AS zh_209, l5_.`created_at` AS created_at_210, l5_.`updated_at` AS updated_at_211 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id LEFT JOIN `list_country` l2_ ON f1_.country = l2_.id LEFT JOIN `locale_html` l3_ ON c0_.id = l3_.collection_body_id LEFT JOIN `locale_meta` l4_ ON c0_.id = l4_.collection_keywords_id LEFT JOIN `locale_meta` l5_ ON c0_.id = l5_.collection_description_id WHERE f1_.`status` > 0 AND f1_.`url` = 'mutina' AND c0_.`url` = 'tex';

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
  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` = 'us';