Symfony Profiler

SELECT
  c0_.`id` AS id_0,
  c0_.`url` AS url_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,
  f1_.`id` AS id_6,
  f1_.`url` AS url_7,
  f1_.`unid` AS unid_8,
  f2_.`id` AS id_9,
  f1_.`url` AS url_10,
  f1_.`name` AS name_11,
  (
    SELECT
      COUNT(p3_.`star`) AS sclr_13
    FROM
      `product_reviews_cache` p3_
    WHERE
      p3_.`sku` = c0_.`code`
  ) AS sclr_12,
  (
    SELECT
      SUM(p4_.`star`) AS sclr_15
    FROM
      `product_reviews_cache` p4_
    WHERE
      p4_.`sku` = c0_.`code`
  ) AS sclr_14
FROM
  `collection` c0_
  INNER JOIN `factory` f1_ ON c0_.factory = f1_.id
  INNER JOIN `filters` f2_ ON f1_.filter = f2_.id
  INNER JOIN `list_country` l5_ ON f1_.country = l5_.id
  LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id
  LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id
WHERE
  f1_.filter IS NOT NULL
  AND c0_.factory <> ''
  AND f1_.`status` = ?
  AND (
    c0_.`test_access` IS NULL
    OR c0_.`test_access` = 0
  )
  AND (
    f1_.`test_access` IS NULL
    OR f1_.`test_access` = 0
  )
  AND c0_.`status` = ?
  AND c0_.`status` = ?
  AND f1_.`status` = ?
ORDER BY
  c0_.`id` ASC

SELECT c0_.`id` AS id_0, c0_.`url` AS url_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, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = 1 AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = 1 AND c0_.`status` = 1 AND f1_.`status` = 1 ORDER BY c0_.`id` ASC;

SELECT
  COUNT(c0_.`id`) AS sclr_0
FROM
  `collection` c0_
  LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id
  LEFT JOIN `article` a2_ ON c0_.id = a2_.collection
WHERE
  c0_.factory <> ''
  AND f1_.`id` <> 99
  AND f1_.`status` = ?
  AND c0_.`status` = ?
  AND c0_.`archive` <> 1
  AND a2_.`price_euro` IS NOT NULL
  AND (
    c0_.`test_access` IS NULL
    OR c0_.`test_access` = 0
  )
  AND (
    f1_.`test_access` IS NULL
    OR f1_.`test_access` = 0
  )
  AND f1_.`id` IN (82)
GROUP BY
  c0_.`id`
ORDER BY
  c0_.`name` ASC,
  c0_.`publish_date` ASC

SELECT COUNT(c0_.`id`) AS sclr_0 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id LEFT JOIN `article` a2_ ON c0_.id = a2_.collection WHERE c0_.factory <> '' AND f1_.`id` <> 99 AND f1_.`status` = 1 AND c0_.`status` = 1 AND c0_.`archive` <> 1 AND a2_.`price_euro` IS NOT NULL AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND f1_.`id` IN (82) GROUP BY c0_.`id` ORDER BY c0_.`name` ASC, c0_.`publish_date` ASC;

SELECT
  f0_.`id` AS id_0,
  f0_.`old_command` AS old_command_1,
  f0_.`old_id` AS old_id_2,
  f0_.`left_menu` AS left_menu_3,
  f1_.`id` AS id_4,
  f0_.`important` AS important_5,
  l2_.`en` AS en_6,
  f3_.`name_menu_en` AS name_menu_en_7,
  f4_.`alt_name` AS alt_name_8,
  f5_.`count` AS count_9,
  f0_.`id` AS id_10,
  f0_.`name` AS name_11,
  f0_.`alt_name` AS alt_name_12,
  f0_.`left_menu` AS left_menu_13,
  f0_.`sort` AS sort_14,
  f0_.`important` AS important_15,
  f0_.`old_command` AS old_command_16,
  f0_.`old_id` AS old_id_17,
  f0_.`sub_key` AS sub_key_18,
  f0_.`parent_key` AS parent_key_19,
  f0_.`rank` AS rank_20,
  f0_.`icon` AS icon_21,
  f0_.`icon_url` AS icon_url_22,
  f0_.`logo` AS logo_23,
  f0_.`logo_url` AS logo_url_24,
  f0_.`created_at` AS created_at_25,
  f0_.`updated_at` AS updated_at_26,
  f6_.`id` AS id_27,
  f6_.`name` AS name_28,
  f6_.`alt_name` AS alt_name_29,
  f6_.`left_menu` AS left_menu_30,
  f6_.`sort` AS sort_31,
  f6_.`important` AS important_32,
  f6_.`old_command` AS old_command_33,
  f6_.`old_id` AS old_id_34,
  f6_.`sub_key` AS sub_key_35,
  f6_.`parent_key` AS parent_key_36,
  f6_.`rank` AS rank_37,
  f6_.`icon` AS icon_38,
  f6_.`icon_url` AS icon_url_39,
  f6_.`logo` AS logo_40,
  f6_.`logo_url` AS logo_url_41,
  f6_.`created_at` AS created_at_42,
  f6_.`updated_at` AS updated_at_43
FROM
  `filters` f0_
  LEFT JOIN `locale_url` l2_ ON f0_.id = l2_.filter_id
  LEFT JOIN `filter_pages` f3_ ON f0_.page_id = f3_.id
  LEFT JOIN `filter_params` f5_ ON f0_.param_id = f5_.id
  LEFT JOIN `filter_groups` f4_ ON f0_.group_id = f4_.id
  LEFT JOIN `filters` f6_ ON f0_.country_id = f6_.id
  LEFT JOIN `filters` f1_ ON f0_.parent_id = f1_.id
WHERE
  f5_.`is_enable` = 1
  AND (
    f5_.`show_menu` = 1
    OR f5_.`show_menu_advanced` = 1
  )
  AND l2_.`en` IS NOT NULL
  AND f5_.`count` > 0
  AND f4_.`alt_name` IN (?)
ORDER BY
  f0_.`sort` ASC,
  f0_.`name` ASC

SELECT f0_.`id` AS id_0, f0_.`old_command` AS old_command_1, f0_.`old_id` AS old_id_2, f0_.`left_menu` AS left_menu_3, f1_.`id` AS id_4, f0_.`important` AS important_5, l2_.`en` AS en_6, f3_.`name_menu_en` AS name_menu_en_7, f4_.`alt_name` AS alt_name_8, f5_.`count` AS count_9, f0_.`id` AS id_10, f0_.`name` AS name_11, f0_.`alt_name` AS alt_name_12, f0_.`left_menu` AS left_menu_13, f0_.`sort` AS sort_14, f0_.`important` AS important_15, f0_.`old_command` AS old_command_16, f0_.`old_id` AS old_id_17, f0_.`sub_key` AS sub_key_18, f0_.`parent_key` AS parent_key_19, f0_.`rank` AS rank_20, f0_.`icon` AS icon_21, f0_.`icon_url` AS icon_url_22, f0_.`logo` AS logo_23, f0_.`logo_url` AS logo_url_24, f0_.`created_at` AS created_at_25, f0_.`updated_at` AS updated_at_26, f6_.`id` AS id_27, f6_.`name` AS name_28, f6_.`alt_name` AS alt_name_29, f6_.`left_menu` AS left_menu_30, f6_.`sort` AS sort_31, f6_.`important` AS important_32, f6_.`old_command` AS old_command_33, f6_.`old_id` AS old_id_34, f6_.`sub_key` AS sub_key_35, f6_.`parent_key` AS parent_key_36, f6_.`rank` AS rank_37, f6_.`icon` AS icon_38, f6_.`icon_url` AS icon_url_39, f6_.`logo` AS logo_40, f6_.`logo_url` AS logo_url_41, f6_.`created_at` AS created_at_42, f6_.`updated_at` AS updated_at_43 FROM `filters` f0_ LEFT JOIN `locale_url` l2_ ON f0_.id = l2_.filter_id LEFT JOIN `filter_pages` f3_ ON f0_.page_id = f3_.id LEFT JOIN `filter_params` f5_ ON f0_.param_id = f5_.id LEFT JOIN `filter_groups` f4_ ON f0_.group_id = f4_.id LEFT JOIN `filters` f6_ ON f0_.country_id = f6_.id LEFT JOIN `filters` f1_ ON f0_.parent_id = f1_.id WHERE f5_.`is_enable` = 1 AND (f5_.`show_menu` = 1 OR f5_.`show_menu_advanced` = 1) AND l2_.`en` IS NOT NULL AND f5_.`count` > 0 AND f4_.`alt_name` IN ('effect', 'style', 'samples', 'price', 'color', 'using', 'brand') ORDER BY f0_.`sort` ASC, f0_.`name` ASC;

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 ('9710745', '9710746', '49496', '49496', '27757', '200004851', '19692', '200004852', '200004853', '200004854', '461719277', '461719291', '520058398', '8264', '29553', '32975', '50978', '911153', '200004857', '200004858', '520058396', '528353343', '528390029', '9174', '8504', '14190', '17512', '911152', '200004855', '200004856', '520058380', '528256051', '528353459', '520058373', '520058377', '528255975', '528353256', '528353260', '528353334', '528353364', '528353451', '528365934', '528390011', '120718758', '120718759', '520057825', '520058399', '528256038', '528256049', '528353318', '528353335', '528353360', '528353463', '911140', '911141', '520058384', '520058395', '528255979', '528256037', '528353321', '528353325', '528353341', '528353458', '528353471', '528390003', '911139', '32264421', '520058390', '520058391', '520058392', '520058393', '528256030', '528256050', '528256053', '528256054', '528353251', '528353253', '528353328', '528353342', '528353345', '528353350', '528353354', '528353359', '528353467', '528353469', '528365933', '528390025', '50082', '7703', '20290', '25830', '37660', '51718', '32140265', '520058389', '528262865', '528353249', '32138708', '32138709', '32138710', '32257094', '32257095', '32257096', '32257097', '32257099', '32257100', '32257101', '32257102', '32257104', '32257105', '32257106', '520058381', '520058401', '528256036', '528256047', '528256056', '528389998', '1262843323', '528255977', '528256044', '528259166', '528353257', '528353315', '528353324', '528353339', '528353468', '18561', '17990', '53492', '210', '1353', '11406', '16171', '19230', '34664', '38363', '39108', '40453', '42384', '46463', '520058388', '528256046', '528256048', '528259168', '528353323', '528353464', '528256039', '528353258', '528353353', '528353362', '528353363', '528353462', '528390007', '528390023', '520058378', '3890', '32879', '3493', '15784', '17678', '18024', '21113', '24041', '26522', '28156', '36994', '39101', '50284', '32264393', '520058387', '528262866', '528353320', '528353340', '528353457', '528390012', '1928', '5997', '22341', '36500', '37320', '38997', '47491', '520058386', '528353252', '528353338', '9599', '21921', '28326', '37278', '39714', '53252', '32264389', '520058394', '528353317', '528365932', '528256052', '528259165', '528262867', '528353259', '528353329', '528353333', '528353450', '528390008', '528390013', '528255980', '528256032', '528353254', '528353319', '528353337', '528353357', '528353446', '528353447', '528390021', '32176871', '130049012', '133365148', '162654813', '218961494', '448939938', '528256043', '528353327', '528353351', '528353466', '520058375', '528255976', '528256028', '528256035', '528256040', '528256041', '528353316', '528353355', '528353361', '528353448', '528390017', '32136413', '32176872', '32176873', '32178757', '32178758', '105852095', '133365149', '133365150', '162654812', '200661461', '218961493', '218961495', '245990698', '520057826', '520058374', '520058376', '520058379', '520058382', '520058383', '520058397', '520058400', '528255978', '528256027', '528256029', '528256031', '528256033', '528256034', '528256042', '528256045', '528256055', '528259167', '528262864', '528353250', '528353322', '528353326', '528353330', '528353344', '528353348', '528353349', '528353352', '528353356', '528353358', '528353449', '528353454', '528353455', '528353456', '528353460', '528353461', '528353465', '528353470', '528389990', '528389991', '528389994', '528389999', '528390000', '528390010', '528390016');

SELECT
  COUNT(i0_.`id`) AS sclr_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` = ?

SELECT COUNT(i0_.`id`) AS sclr_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` = '34434564e1a8e7b3fe00c094e3e1aa4250d87bed637b8f452e41926a81c3cbac';

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.`url` = ?
  AND t0.factory = ?
LIMIT
  1

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.`url` = 'studio-adex' AND t0.factory = 82 LIMIT 1;