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.ru AS `isHtmlShow`,
  fp.name_menu_ru AS `nameMenu`,
  fp.name_many_ru AS `nameMany`,
  fp.name_single_ru AS `nameSingle`,
  fp.html_ru AS `html`,
  fp.description_ru AS `description`,
  metadesc.ru AS `metaDescriptionName`,
  par.count AS `count`,
  par.code AS `code`,
  par.is_enable AS `isEnable`,
  gr.id AS `groupId`,
  gr.alt_name AS `groupAltName`,
  gpname.ru AS `groupName`,
  url.ru AS `slug`,
  url.ru AS `slug.ru`,
  url.en AS `slug.en`,
  url.it AS `slug.it`,
  url.es AS `slug.es`,
  url.fr AS `slug.fr`,
  url.de AS `slug.de`,
  url.pl AS `slug.pl`,
  url.nl AS `slug.nl`,
  url.fi AS `slug.fi`,
  url.sv AS `slug.sv`,
  b.id AS `brandId`,
  b.status AS `brandStatus`,
  b.stated_at AS `brandStatedAt`,
  b.type AS `brandType`,
  b.name AS `brandName`,
  f.logo AS `brandLogo`,
  f.logo_url AS `brandLogoUrl`,
  b.sound AS `brandSound`,
  b.video AS `brandVideo`,
  cn.id AS `countryId`,
  cnfp.name_single_ru AS `countryName`,
  cnurl.ru AS `countrySlug`,
  cnpar.code AS `countryCode`
FROM
  filters f
  LEFT JOIN filter_pages fp ON fp.id = f.page_id
  LEFT JOIN filter_params par ON par.id = f.param_id
  LEFT JOIN filter_groups gr ON gr.id = f.group_id
  LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id
  LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id
  LEFT JOIN locale_url url ON url.filter_id = f.id
  LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id
  LEFT JOIN factory b ON b.id = f.brand
  LEFT JOIN filters cn ON cn.id = f.country_id
  LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id
  LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id
  LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id
WHERE
  url.ru = :slug
  OR url.en = :slug
  OR url.it = :slug
  OR url.es = :slug
  OR url.fr = :slug
  OR url.de = :slug
  OR url.pl = :slug
  OR url.nl = :slug
  OR url.fi = :slug
  OR url.sv = :slug

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

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.ru AS `isHtmlShow`,
  fp.name_menu_ru AS `nameMenu`,
  fp.name_many_ru AS `nameMany`,
  fp.name_single_ru AS `nameSingle`,
  fp.html_ru AS `html`,
  fp.description_ru AS `description`,
  metadesc.ru AS `metaDescriptionName`,
  par.count AS `count`,
  par.code AS `code`,
  par.is_enable AS `isEnable`,
  gr.id AS `groupId`,
  gr.alt_name AS `groupAltName`,
  gpname.ru AS `groupName`,
  url.ru AS `slug`,
  url.ru AS `slug.ru`,
  url.en AS `slug.en`,
  url.it AS `slug.it`,
  url.es AS `slug.es`,
  url.fr AS `slug.fr`,
  url.de AS `slug.de`,
  url.pl AS `slug.pl`,
  url.nl AS `slug.nl`,
  url.fi AS `slug.fi`,
  url.sv AS `slug.sv`,
  b.id AS `brandId`,
  b.status AS `brandStatus`,
  b.stated_at AS `brandStatedAt`,
  b.type AS `brandType`,
  b.name AS `brandName`,
  f.logo AS `brandLogo`,
  f.logo_url AS `brandLogoUrl`,
  b.sound AS `brandSound`,
  b.video AS `brandVideo`,
  cn.id AS `countryId`,
  cnfp.name_single_ru AS `countryName`,
  cnurl.ru AS `countrySlug`,
  cnpar.code AS `countryCode`
FROM
  filters f
  LEFT JOIN filter_pages fp ON fp.id = f.page_id
  LEFT JOIN filter_params par ON par.id = f.param_id
  LEFT JOIN filter_groups gr ON gr.id = f.group_id
  LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id
  LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id
  LEFT JOIN locale_url url ON url.filter_id = f.id
  LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id
  LEFT JOIN factory b ON b.id = f.brand
  LEFT JOIN filters cn ON cn.id = f.country_id
  LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id
  LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id
  LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id
WHERE
  f.id IN (?)
ORDER BY
  gr.sort,
  f.sort

SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.ru AS `isHtmlShow`, fp.name_menu_ru AS `nameMenu`, fp.name_many_ru AS `nameMany`, fp.name_single_ru AS `nameSingle`, fp.html_ru AS `html`, fp.description_ru AS `description`, metadesc.ru AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.ru AS `groupName`, url.ru AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_ru AS `countryName`, cnurl.ru AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE f.id IN (10213) 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
  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` = 'se';

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
  t0.`id` AS id_1,
  t0.`name` AS name_2,
  t0.`alias` AS alias_3,
  t0.`sort` AS sort_4,
  t0.`count` AS count_5,
  t0.`hide` AS hide_6,
  t0.`important` AS important_7
FROM
  `list_measure` t0
WHERE
  t0.`hide` = ?

SELECT t0.`id` AS id_1, t0.`name` AS name_2, t0.`alias` AS alias_3, t0.`sort` AS sort_4, t0.`count` AS count_5, t0.`hide` AS hide_6, t0.`important` AS important_7 FROM `list_measure` t0 WHERE t0.`hide` = 0;

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
  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` = 'e64696d62b52c6708e6196ee7f46ee09f25fcd8ea7f4d2ad186368888ea398d8' 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
  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.`id` = ?

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.`id` = 38;

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 = ?