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 = '3252619' OR url.en = '3252619' OR url.it = '3252619' OR url.es = '3252619' OR url.fr = '3252619' OR url.de = '3252619' OR url.pl = '3252619' OR url.nl = '3252619' OR url.fi = '3252619' OR url.sv = '3252619' ;

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 = '3252619' OR url.en = '3252619' OR url.it = '3252619' OR url.es = '3252619' OR url.fr = '3252619' OR url.de = '3252619' OR url.pl = '3252619' OR url.nl = '3252619' OR url.fi = '3252619' OR url.sv = '3252619' ;

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 LIKE :slug
  OR url.en LIKE :slug
  OR url.it LIKE :slug
  OR url.es LIKE :slug
  OR url.fr LIKE :slug
  OR url.de LIKE :slug
  OR url.pl LIKE :slug
  OR url.nl LIKE :slug
  OR url.fi LIKE :slug
  OR url.sv LIKE :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 LIKE '%3252619%' OR url.en LIKE '%3252619%' OR url.it LIKE '%3252619%' OR url.es LIKE '%3252619%' OR url.fr LIKE '%3252619%' OR url.de LIKE '%3252619%' OR url.pl LIKE '%3252619%' OR url.nl LIKE '%3252619%' OR url.fi LIKE '%3252619%' OR url.sv LIKE '%3252619%' ;

SELECT
  u.id,
  f.id AS `f.id`,
  lu.en AS `f.url`
FROM
  last_url u
  LEFT JOIN filters f ON u.en_id = f.id
  LEFT JOIN locale_url lu ON f.id = lu.filter_id
WHERE
  u.slug LIKE '3252619'
  AND u.lc LIKE 'en'
  AND u.en LIKE 'FilterEntity'

SELECT u.id, f.id AS `f.id`, lu.en AS `f.url` FROM last_url u LEFT JOIN filters f ON u.en_id = f.id LEFT JOIN locale_url lu ON f.id = lu.filter_id WHERE u.slug LIKE '3252619' AND u.lc LIKE 'en' AND u.en LIKE 'FilterEntity' ;

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_.`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,
  c0_.factory AS factory_129,
  c0_.category_price AS category_price_130,
  f1_.user_id AS user_id_131,
  f1_.country AS country_132,
  f1_.filter AS filter_133
FROM
  `collection` c0_
  LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id
WHERE
  c0_.`id` = ?
  AND (
    c0_.`test_access` IS NULL
    OR c0_.`test_access` = 0
  )
  AND (
    f1_.`test_access` IS NULL
    OR f1_.`test_access` = 0
  )

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, c0_.factory AS factory_129, c0_.category_price AS category_price_130, f1_.user_id AS user_id_131, f1_.country AS country_132, f1_.filter AS filter_133 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id WHERE c0_.`id` = 3252619 AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0);

SELECT
  t0.`id` AS id_1,
  t0.`source` AS source_2,
  t0.`ru` AS ru_3,
  t0.`en` AS en_4,
  t0.`it` AS it_5,
  t0.`es` AS es_6,
  t0.`fr` AS fr_7,
  t0.`de` AS de_8,
  t0.`pl` AS pl_9,
  t0.`pt` AS pt_10,
  t0.`nl` AS nl_11,
  t0.`fi` AS fi_12,
  t0.`ua` AS ua_13,
  t0.`sv` AS sv_14,
  t0.`no` AS no_15,
  t0.`da` AS da_16,
  t0.`cn` AS cn_17,
  t0.`zh` AS zh_18,
  t0.`created_at` AS created_at_19,
  t0.`updated_at` AS updated_at_20,
  t0.email_body_id AS email_body_id_21,
  t0.publication_body_id AS publication_body_id_22,
  t0.static_page_body_id AS static_page_body_id_23,
  t0.collection_body_id AS collection_body_id_24,
  t0.trans_val_id AS trans_val_id_25,
  t0.exh_text_id AS exh_text_id_26,
  t0.exh_brand_text_id AS exh_brand_text_id_27,
  t0.exh_collection_text_id AS exh_collection_text_id_28,
  t0.filter_html_id AS filter_html_id_29
FROM
  `locale_html` t0
WHERE
  t0.collection_body_id = ?

SELECT t0.`id` AS id_1, t0.`source` AS source_2, t0.`ru` AS ru_3, t0.`en` AS en_4, t0.`it` AS it_5, t0.`es` AS es_6, t0.`fr` AS fr_7, t0.`de` AS de_8, t0.`pl` AS pl_9, t0.`pt` AS pt_10, t0.`nl` AS nl_11, t0.`fi` AS fi_12, t0.`ua` AS ua_13, t0.`sv` AS sv_14, t0.`no` AS no_15, t0.`da` AS da_16, t0.`cn` AS cn_17, t0.`zh` AS zh_18, t0.`created_at` AS created_at_19, t0.`updated_at` AS updated_at_20, t0.email_body_id AS email_body_id_21, t0.publication_body_id AS publication_body_id_22, t0.static_page_body_id AS static_page_body_id_23, t0.collection_body_id AS collection_body_id_24, t0.trans_val_id AS trans_val_id_25, t0.exh_text_id AS exh_text_id_26, t0.exh_brand_text_id AS exh_brand_text_id_27, t0.exh_collection_text_id AS exh_collection_text_id_28, t0.filter_html_id AS filter_html_id_29 FROM `locale_html` t0 WHERE t0.collection_body_id = 3252619;