Symfony Profiler

SELECT
  a0_.`id` AS id_0,
  a0_.`code` AS code_1,
  a0_.`alternate_name` AS alternate_name_2,
  a0_.`urla` AS urla_3,
  a1_.`file` AS file_4,
  a0_.`price_euro` AS price_euro_5,
  a0_.`price_usd` AS price_usd_6,
  a0_.`price_prx` AS price_prx_7,
  a0_.`size_x` AS size_x_8,
  a0_.`size_y` AS size_y_9,
  a0_.`size_gb_x` AS size_gb_x_10,
  a0_.`size_gb_y` AS size_gb_y_11,
  a0_.`thick` AS thick_12,
  a0_.`weight` AS weight_13,
  a1_.`file_size2_x` AS file_size2_x_14,
  a1_.`file_size2_y` AS file_size2_y_15,
  l2_.`alias` AS alias_16,
  l3_.`alias` AS alias_17,
  l4_.`alias` AS alias_18,
  l5_.`alias` AS alias_19,
  l6_.`alias` AS alias_20,
  l7_.`alias` AS alias_21,
  c8_.`code` AS code_22,
  c8_.`name` AS name_23,
  c8_.`alternate_name` AS alternate_name_24,
  c8_.`url` AS url_25,
  f9_.`name` AS name_26,
  f9_.`url` AS url_27,
  l10_.`alias` AS alias_28,
  l11_.`alias` AS alias_29,
  l12_.`alias` AS alias_30
FROM
  `article` a0_
  LEFT JOIN `list_type` l2_ ON a0_.type = l2_.id
  LEFT JOIN `list_edge_type` l3_ ON a0_.edge_type = l3_.id
  LEFT JOIN `list_shape` l4_ ON a0_.shape = l4_.id
  LEFT JOIN `list_material` l5_ ON a0_.material = l5_.id
  LEFT JOIN `list_sliding` l6_ ON a0_.sliding = l6_.id
  LEFT JOIN `list_off_shade` l7_ ON a0_.off_shade = l7_.id
  LEFT JOIN `list_using` l10_ ON a0_.using = l10_.id
  LEFT JOIN `collection` c8_ ON a0_.collection = c8_.id
  LEFT JOIN `list_price` l12_ ON a0_.category_price = l12_.id
  LEFT JOIN `list_delivery` l13_ ON a0_.delivery = l13_.id
  LEFT JOIN `article_detail` a1_ ON a0_.id = a1_.article_id
  LEFT JOIN `factory` f9_ ON c8_.factory = f9_.id
  LEFT JOIN `list_country` l11_ ON f9_.country = l11_.id
WHERE
  c8_.`id` IS NOT NULL
  AND l13_.`id` <> 6
  AND a0_.`price_euro` > 0
  AND c8_.`status` IN (1, 2, 3, 4, 7)
  AND (
    c8_.`url` IS NOT NULL
    AND c8_.`url` <> ''
  )
  AND f9_.`status` = 1
  AND a1_.`file` IS NOT NULL
  AND a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, a0_.`code` AS code_1, a0_.`alternate_name` AS alternate_name_2, a0_.`urla` AS urla_3, a1_.`file` AS file_4, a0_.`price_euro` AS price_euro_5, a0_.`price_usd` AS price_usd_6, a0_.`price_prx` AS price_prx_7, a0_.`size_x` AS size_x_8, a0_.`size_y` AS size_y_9, a0_.`size_gb_x` AS size_gb_x_10, a0_.`size_gb_y` AS size_gb_y_11, a0_.`thick` AS thick_12, a0_.`weight` AS weight_13, a1_.`file_size2_x` AS file_size2_x_14, a1_.`file_size2_y` AS file_size2_y_15, l2_.`alias` AS alias_16, l3_.`alias` AS alias_17, l4_.`alias` AS alias_18, l5_.`alias` AS alias_19, l6_.`alias` AS alias_20, l7_.`alias` AS alias_21, c8_.`code` AS code_22, c8_.`name` AS name_23, c8_.`alternate_name` AS alternate_name_24, c8_.`url` AS url_25, f9_.`name` AS name_26, f9_.`url` AS url_27, l10_.`alias` AS alias_28, l11_.`alias` AS alias_29, l12_.`alias` AS alias_30 FROM `article` a0_ LEFT JOIN `list_type` l2_ ON a0_.type = l2_.id LEFT JOIN `list_edge_type` l3_ ON a0_.edge_type = l3_.id LEFT JOIN `list_shape` l4_ ON a0_.shape = l4_.id LEFT JOIN `list_material` l5_ ON a0_.material = l5_.id LEFT JOIN `list_sliding` l6_ ON a0_.sliding = l6_.id LEFT JOIN `list_off_shade` l7_ ON a0_.off_shade = l7_.id LEFT JOIN `list_using` l10_ ON a0_.using = l10_.id LEFT JOIN `collection` c8_ ON a0_.collection = c8_.id LEFT JOIN `list_price` l12_ ON a0_.category_price = l12_.id LEFT JOIN `list_delivery` l13_ ON a0_.delivery = l13_.id LEFT JOIN `article_detail` a1_ ON a0_.id = a1_.article_id LEFT JOIN `factory` f9_ ON c8_.factory = f9_.id LEFT JOIN `list_country` l11_ ON f9_.country = l11_.id WHERE c8_.`id` IS NOT NULL AND l13_.`id` <> 6 AND a0_.`price_euro` > 0 AND c8_.`status` IN (1, 2, 3, 4, 7) AND (c8_.`url` IS NOT NULL AND c8_.`url` <> '') AND f9_.`status` = 1 AND a1_.`file` IS NOT NULL AND a0_.`id` IN ('23210637');

SELECT
  f.id,
  f.rank AS `rank`,
  f.alt_name AS `altName`,
  f.old_command AS `sphinxName`,
  f.old_id AS `sphinxId`,
  htmlshow.de AS `isHtmlShow`,
  fp.name_menu_de AS `nameMenu`,
  fp.name_many_de AS `nameMany`,
  fp.name_single_de AS `nameSingle`,
  fp.html_de AS `html`,
  fp.description_de AS `description`,
  metadesc.de 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.de AS `groupName`,
  url.de 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_de AS `countryName`,
  cnurl.de 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.de AS `isHtmlShow`, fp.name_menu_de AS `nameMenu`, fp.name_many_de AS `nameMany`, fp.name_single_de AS `nameSingle`, fp.html_de AS `html`, fp.description_de AS `description`, metadesc.de 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.de AS `groupName`, url.de 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_de AS `countryName`, cnurl.de 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 = 'newker' OR url.en = 'newker' OR url.it = 'newker' OR url.es = 'newker' OR url.fr = 'newker' OR url.de = 'newker' OR url.pl = 'newker' OR url.nl = 'newker' OR url.fi = 'newker' OR url.sv = 'newker' ;

SELECT
  a0_.`id` AS id_0,
  f1_.`name_single_en` AS name_single_en_1,
  f1_.`name_single_it` AS name_single_it_2,
  f1_.`name_single_es` AS name_single_es_3,
  f1_.`name_single_fr` AS name_single_fr_4,
  f1_.`name_single_de` AS name_single_de_5,
  f1_.`name_single_pl` AS name_single_pl_6,
  f1_.`name_single_ua` AS name_single_ua_7,
  f1_.`name_single_ru` AS name_single_ru_8,
  f1_.`name_single_sv` AS name_single_sv_9,
  f1_.`name_single_da` AS name_single_da_10
FROM
  `article` a0_
  LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id
  LEFT JOIN collection_filters c4_ ON c2_.id = c4_.collection_id
  LEFT JOIN `filters` f3_ ON f3_.id = c4_.filter_id
  LEFT JOIN `filter_pages` f1_ ON f3_.page_id = f1_.id
  INNER JOIN `filter_groups` f5_ ON f3_.group_id = f5_.id
  AND (f5_.`id` = 419)
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, f1_.`name_single_en` AS name_single_en_1, f1_.`name_single_it` AS name_single_it_2, f1_.`name_single_es` AS name_single_es_3, f1_.`name_single_fr` AS name_single_fr_4, f1_.`name_single_de` AS name_single_de_5, f1_.`name_single_pl` AS name_single_pl_6, f1_.`name_single_ua` AS name_single_ua_7, f1_.`name_single_ru` AS name_single_ru_8, f1_.`name_single_sv` AS name_single_sv_9, f1_.`name_single_da` AS name_single_da_10 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c4_ ON c2_.id = c4_.collection_id LEFT JOIN `filters` f3_ ON f3_.id = c4_.filter_id LEFT JOIN `filter_pages` f1_ ON f3_.page_id = f1_.id INNER JOIN `filter_groups` f5_ ON f3_.group_id = f5_.id AND (f5_.`id` = 419) WHERE a0_.`id` IN (23210637);

SELECT
  a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  INNER JOIN article_texture a2_ ON a0_.id = a2_.article_id
  INNER JOIN `list_texture` l1_ ON l1_.id = a2_.texture_id
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_texture a2_ ON a0_.id = a2_.article_id INNER JOIN `list_texture` l1_ ON l1_.id = a2_.texture_id WHERE a0_.`id` IN (23210637);

SELECT
  a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  INNER JOIN article_color a2_ ON a0_.id = a2_.article_id
  INNER JOIN `list_color` l1_ ON l1_.id = a2_.color_id
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_color a2_ ON a0_.id = a2_.article_id INNER JOIN `list_color` l1_ ON l1_.id = a2_.color_id WHERE a0_.`id` IN (23210637);

SELECT
  a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  INNER JOIN article_motiv a2_ ON a0_.id = a2_.article_id
  INNER JOIN `list_motiv` l1_ ON l1_.id = a2_.motiv_id
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_motiv a2_ ON a0_.id = a2_.article_id INNER JOIN `list_motiv` l1_ ON l1_.id = a2_.motiv_id WHERE a0_.`id` IN (23210637);

SELECT
  a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  INNER JOIN article_style a2_ ON a0_.id = a2_.article_id
  INNER JOIN `list_style` l1_ ON l1_.id = a2_.style_id
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_style a2_ ON a0_.id = a2_.article_id INNER JOIN `list_style` l1_ ON l1_.id = a2_.style_id WHERE a0_.`id` IN (23210637);

SELECT
  a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  INNER JOIN article_surface a2_ ON a0_.id = a2_.article_id
  INNER JOIN `list_surface` l1_ ON l1_.id = a2_.surface_id
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_surface a2_ ON a0_.id = a2_.article_id INNER JOIN `list_surface` l1_ ON l1_.id = a2_.surface_id WHERE a0_.`id` IN (23210637);

SELECT
  a0_.`id` AS id_0,
  f1_.`name` AS name_1
FROM
  `article` a0_
  LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id
  LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id
  LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id
  INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id
  AND (f4_.`id` = 420)
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, f1_.`name` AS name_1 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id AND (f4_.`id` = 420) WHERE a0_.`id` IN (23210637);

SELECT
  DISTINCT a0_.`id` AS id_0,
  l1_.`alias` AS alias_1
FROM
  `article` a0_
  LEFT JOIN interior_article i3_ ON a0_.id = i3_.article_id
  LEFT JOIN `interior` i2_ ON i2_.id = i3_.interior_id
  INNER JOIN interior_apply i4_ ON i2_.id = i4_.interior_id
  INNER JOIN `list_apply` l1_ ON l1_.id = i4_.apply_id
WHERE
  a0_.`id` IN (?)

SELECT DISTINCT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ LEFT JOIN interior_article i3_ ON a0_.id = i3_.article_id LEFT JOIN `interior` i2_ ON i2_.id = i3_.interior_id INNER JOIN interior_apply i4_ ON i2_.id = i4_.interior_id INNER JOIN `list_apply` l1_ ON l1_.id = i4_.apply_id WHERE a0_.`id` IN (23210637);

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
  a0_.`id` AS id_0,
  f1_.`name` AS name_1
FROM
  `article` a0_
  LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id
  LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id
  LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id
  INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id
  AND (
    f4_.`id` = 417
    AND f1_.`id` <> 10546
  )
WHERE
  a0_.`id` IN (?)

SELECT a0_.`id` AS id_0, f1_.`name` AS name_1 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id AND (f4_.`id` = 417 AND f1_.`id` <> 10546) WHERE a0_.`id` IN (23210637);

SELECT
  f0_.`old_id` AS old_id_0,
  f1_.`name_single_de` AS name_single_de_1,
  f1_.`name_menu_de` AS name_menu_de_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_de` AS name_single_de_1, f1_.`name_menu_de` AS name_menu_de_2 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id LEFT JOIN `filter_groups` f2_ ON f0_.group_id = f2_.id WHERE f2_.`id` = 407 ORDER BY f0_.`sort` ASC;

SELECT
  t0.`id` AS id_1,
  t0.`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 (1158153, 1778033, 1778034, 1779483, 3245059, 3245060, 3245319, 3245320, 3245431, 3245432, 3245958, 3245959, 3245960, 3246482, 3246763, 3246764, 3246765, 3247348, 3247356, 3247979, 3247980, 3247981, 3248317, 3248340, 3248779, 3248889, 3248890, 3248891, 3248892, 3248893, 3248894, 3248895, 3248896, 3248897, 3248898, 3249049, 3249182, 3249228, 3249483, 3249531, 3249632, 3249633, 3249634, 3249635, 3249787, 3249788, 3250077, 3250082, 3250947, 3250953, 3250959, 3251234, 3251238, 3251242, 3251246, 3251290, 3251294, 3251298, 3251346, 3251349, 3251352, 3251355, 3251358, 3251361, 3251364, 3251367, 3251370, 3251373, 3251376, 3251379, 3251382, 3251385, 3251388, 3251391, 3251394, 3251397, 3251400, 3251403, 3251406, 3252457, 3254140, 3254962, 3254965, 3255151, 3255181);

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