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 f1_.`id` NOT IN (?)
  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 f1_.`id` NOT IN (14) 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
  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
  t0.`id` AS id_1,
  t0.`keyEmail` AS keyEmail_2,
  t0.`comment` AS comment_3,
  t4.`id` AS id_5,
  t4.`source` AS source_6,
  t4.`ru` AS ru_7,
  t4.`en` AS en_8,
  t4.`it` AS it_9,
  t4.`es` AS es_10,
  t4.`fr` AS fr_11,
  t4.`de` AS de_12,
  t4.`pl` AS pl_13,
  t4.`pt` AS pt_14,
  t4.`nl` AS nl_15,
  t4.`fi` AS fi_16,
  t4.`ua` AS ua_17,
  t4.`sv` AS sv_18,
  t4.`no` AS no_19,
  t4.`da` AS da_20,
  t4.`cn` AS cn_21,
  t4.`zh` AS zh_22,
  t4.`created_at` AS created_at_23,
  t4.`updated_at` AS updated_at_24,
  t4.email_body_id AS email_body_id_25,
  t4.publication_body_id AS publication_body_id_26,
  t4.static_page_body_id AS static_page_body_id_27,
  t4.collection_body_id AS collection_body_id_28,
  t4.trans_val_id AS trans_val_id_29,
  t4.exh_text_id AS exh_text_id_30,
  t4.exh_brand_text_id AS exh_brand_text_id_31,
  t4.exh_collection_text_id AS exh_collection_text_id_32,
  t4.filter_html_id AS filter_html_id_33,
  t34.`id` AS id_35,
  t34.`source` AS source_36,
  t34.`ru` AS ru_37,
  t34.`en` AS en_38,
  t34.`it` AS it_39,
  t34.`es` AS es_40,
  t34.`fr` AS fr_41,
  t34.`de` AS de_42,
  t34.`pl` AS pl_43,
  t34.`pt` AS pt_44,
  t34.`nl` AS nl_45,
  t34.`fi` AS fi_46,
  t34.`ua` AS ua_47,
  t34.`sv` AS sv_48,
  t34.`no` AS no_49,
  t34.`da` AS da_50,
  t34.`cn` AS cn_51,
  t34.`zh` AS zh_52,
  t34.`created_at` AS created_at_53,
  t34.`updated_at` AS updated_at_54,
  t34.email_title_id AS email_title_id_55,
  t34.publication_id AS publication_id_56,
  t34.static_page_title_id AS static_page_title_id_57,
  t34.exh_title_id AS exh_title_id_58,
  t34.filter_name_single_id AS filter_name_single_id_59,
  t34.filter_name_many_id AS filter_name_many_id_60,
  t34.filter_name_menu_id AS filter_name_menu_id_61
FROM
  `list_email` t0
  LEFT JOIN `locale_html` t4 ON t4.email_body_id = t0.id
  LEFT JOIN `locale_title` t34 ON t34.email_title_id = t0.id

SELECT t0.`id` AS id_1, t0.`keyEmail` AS keyEmail_2, t0.`comment` AS comment_3, t4.`id` AS id_5, t4.`source` AS source_6, t4.`ru` AS ru_7, t4.`en` AS en_8, t4.`it` AS it_9, t4.`es` AS es_10, t4.`fr` AS fr_11, t4.`de` AS de_12, t4.`pl` AS pl_13, t4.`pt` AS pt_14, t4.`nl` AS nl_15, t4.`fi` AS fi_16, t4.`ua` AS ua_17, t4.`sv` AS sv_18, t4.`no` AS no_19, t4.`da` AS da_20, t4.`cn` AS cn_21, t4.`zh` AS zh_22, t4.`created_at` AS created_at_23, t4.`updated_at` AS updated_at_24, t4.email_body_id AS email_body_id_25, t4.publication_body_id AS publication_body_id_26, t4.static_page_body_id AS static_page_body_id_27, t4.collection_body_id AS collection_body_id_28, t4.trans_val_id AS trans_val_id_29, t4.exh_text_id AS exh_text_id_30, t4.exh_brand_text_id AS exh_brand_text_id_31, t4.exh_collection_text_id AS exh_collection_text_id_32, t4.filter_html_id AS filter_html_id_33, t34.`id` AS id_35, t34.`source` AS source_36, t34.`ru` AS ru_37, t34.`en` AS en_38, t34.`it` AS it_39, t34.`es` AS es_40, t34.`fr` AS fr_41, t34.`de` AS de_42, t34.`pl` AS pl_43, t34.`pt` AS pt_44, t34.`nl` AS nl_45, t34.`fi` AS fi_46, t34.`ua` AS ua_47, t34.`sv` AS sv_48, t34.`no` AS no_49, t34.`da` AS da_50, t34.`cn` AS cn_51, t34.`zh` AS zh_52, t34.`created_at` AS created_at_53, t34.`updated_at` AS updated_at_54, t34.email_title_id AS email_title_id_55, t34.publication_id AS publication_id_56, t34.static_page_title_id AS static_page_title_id_57, t34.exh_title_id AS exh_title_id_58, t34.filter_name_single_id AS filter_name_single_id_59, t34.filter_name_many_id AS filter_name_many_id_60, t34.filter_name_menu_id AS filter_name_menu_id_61 FROM `list_email` t0 LEFT JOIN `locale_html` t4 ON t4.email_body_id = t0.id LEFT JOIN `locale_title` t34 ON t34.email_title_id = t0.id;

SELECT
  b0_.`id` AS id_0,
  b0_.`name` AS name_1,
  b0_.`descr` AS descr_2,
  b0_.`val` AS val_3
FROM
  `BoolDBSetting` b0_
WHERE
  b0_.`name` = ?

SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = 'RTWidget';

SELECT
  o0_.`id` AS id_0,
  o0_.`hash` AS hash_1,
  o0_.`update_date` AS update_date_2,
  o0_.`marker_reset` AS marker_reset_3,
  o0_.`token` AS token_4,
  o0_.`unid` AS unid_5,
  o0_.`frozen` AS frozen_6,
  o0_.`zip_code` AS zip_code_7,
  o0_.`region` AS region_8,
  o0_.`city` AS city_9,
  o0_.`street` AS street_10,
  o0_.`building` AS building_11,
  o0_.`delivery_apartment_office` AS delivery_apartment_office_12,
  o0_.`sex` AS sex_13,
  o0_.`client_name` AS client_name_14,
  o0_.`client_surname` AS client_surname_15,
  o0_.`company_name` AS company_name_16,
  o0_.`company_address` AS company_address_17,
  o0_.`vat_type` AS vat_type_18,
  o0_.`vat_number` AS vat_number_19,
  o0_.`tax_number` AS tax_number_20,
  o0_.`email` AS email_21,
  o0_.`phone_code` AS phone_code_22,
  o0_.`phone` AS phone_23,
  o0_.`phone_two` AS phone_two_24,
  o0_.`description` AS description_25,
  o0_.`is_main_recipient` AS is_main_recipient_26,
  o0_.`address_type` AS address_type_27,
  l1_.`id` AS id_28,
  l1_.`code` AS code_29,
  l1_.`locale` AS locale_30,
  l1_.`phone_code` AS phone_code_31,
  l1_.`phone_mask` AS phone_mask_32,
  l1_.`min_valid_phone_numbers` AS min_valid_phone_numbers_33,
  l1_.`zip_code_mask` AS zip_code_mask_34,
  l1_.`percent_vat` AS percent_vat_35,
  l1_.`name` AS name_36,
  l1_.`name_en` AS name_en_37,
  l1_.`alias` AS alias_38,
  l1_.`sort` AS sort_39,
  l1_.`count` AS count_40,
  l1_.`hide` AS hide_41,
  l1_.`important` AS important_42,
  l1_.`pay_pal_percent` AS pay_pal_percent_43,
  l1_.`pay_pal_percent_own` AS pay_pal_percent_own_44,
  l1_.`vat` AS vat_45,
  l1_.`pv_type` AS pv_type_46,
  l1_.`capital_timezone_diff` AS capital_timezone_diff_47,
  l1_.`capital` AS capital_48,
  l1_.`free_sample_delivery` AS free_sample_delivery_49,
  l1_.`units` AS units_50,
  b2_.`id` AS id_51,
  b2_.`mirror` AS mirror_52,
  b2_.`unid` AS unid_53,
  b2_.`unid_vat_player` AS unid_vat_player_54,
  b2_.`hash` AS hash_55,
  b2_.`number` AS number_56,
  b2_.`number_donor` AS number_donor_57,
  b2_.`token` AS token_58,
  b2_.`email` AS email_59,
  b2_.`email_send` AS email_send_60,
  b2_.`status` AS status_61,
  b2_.`step` AS step_62,
  b2_.`name` AS name_63,
  b2_.`adyen` AS adyen_64,
  b2_.`tax_number` AS tax_number_65,
  b2_.`vat_type` AS vat_type_66,
  b2_.`vat_number` AS vat_number_67,
  b2_.`vat_percent` AS vat_percent_68,
  b2_.`discount` AS discount_69,
  b2_.`address_equal` AS address_equal_70,
  b2_.`full_payment_date` AS full_payment_date_71,
  b2_.`delivery_index` AS delivery_index_72,
  b2_.`personal_data_agree` AS personal_data_agree_73,
  b2_.`delivery_region` AS delivery_region_74,
  b2_.`delivery_city` AS delivery_city_75,
  b2_.`delivery_address` AS delivery_address_76,
  b2_.`delivery_building` AS delivery_building_77,
  b2_.`delivery_apartment_office` AS delivery_apartment_office_78,
  b2_.`delivery_phone_code` AS delivery_phone_code_79,
  b2_.`delivery_phone` AS delivery_phone_80,
  b2_.`where_delivered` AS where_delivered_81,
  b2_.`warehouse_data` AS warehouse_data_82,
  b2_.`ref_number` AS ref_number_83,
  b2_.`sex` AS sex_84,
  b2_.`client_name` AS client_name_85,
  b2_.`client_surname` AS client_surname_86,
  b2_.`company_name` AS company_name_87,
  b2_.`description` AS description_88,
  b2_.`pay_type` AS pay_type_89,
  b2_.`pay_date_execution` AS pay_date_execution_90,
  b2_.`accept_pay` AS accept_pay_91,
  b2_.`cancel_date` AS cancel_date_92,
  b2_.`create_date` AS create_date_93,
  b2_.`update_date` AS update_date_94,
  b2_.`marker_reset` AS marker_reset_95,
  b2_.`marker_change` AS marker_change_96,
  b2_.`marker_delivery_change` AS marker_delivery_change_97,
  b2_.`locale` AS locale_98,
  b2_.`currency` AS currency_99,
  b2_.`payment_euro` AS payment_euro_100,
  b2_.`cur_rate` AS cur_rate_101,
  b2_.`measure` AS measure_102,
  b2_.`tracking_number` AS tracking_number_103,
  b2_.`carrier_name` AS carrier_name_104,
  b2_.`carrier_contact_data` AS carrier_contact_data_105,
  b2_.`write_off_reason` AS write_off_reason_106,
  b2_.`offset_explain` AS offset_explain_107,
  b2_.`weight_gross` AS weight_gross_108,
  b2_.`weight_limit` AS weight_limit_109,
  b2_.`remember` AS remember_110,
  b2_.`bank_details` AS bank_details_111,
  b2_.`recipient_number` AS recipient_number_112,
  b2_.`date_payment_back` AS date_payment_back_113,
  b2_.`send_create_1c` AS send_create_1c_114,
  b2_.`bank_transfer_requested` AS bank_transfer_requested_115,
  b2_.`marker_test` AS marker_test_116,
  b2_.`no_change` AS no_change_117,
  b2_.`kladr_id` AS kladr_id_118,
  b2_.`okato_id` AS okato_id_119,
  b2_.`product_review` AS product_review_120,
  b2_.`entrance_review` AS entrance_review_121,
  b2_.`send_review` AS send_review_122,
  b2_.`reserve` AS reserve_123,
  b2_.`key_email` AS key_email_124,
  b2_.`process` AS process_125,
  b2_.`spec_price` AS spec_price_126,
  b2_.`compensation` AS compensation_127,
  b2_.`check_breakdown` AS check_breakdown_128,
  b2_.`truspilot_review_requested` AS truspilot_review_requested_129,
  b2_.`collection_review_requested` AS collection_review_requested_130,
  b2_.`prohibit_send_review_request` AS prohibit_send_review_request_131,
  b3_.`id` AS id_132,
  b3_.`mirror` AS mirror_133,
  b3_.`unid` AS unid_134,
  b3_.`unid_vat_player` AS unid_vat_player_135,
  b3_.`hash` AS hash_136,
  b3_.`number` AS number_137,
  b3_.`number_donor` AS number_donor_138,
  b3_.`token` AS token_139,
  b3_.`email` AS email_140,
  b3_.`email_send` AS email_send_141,
  b3_.`status` AS status_142,
  b3_.`step` AS step_143,
  b3_.`name` AS name_144,
  b3_.`adyen` AS adyen_145,
  b3_.`tax_number` AS tax_number_146,
  b3_.`vat_type` AS vat_type_147,
  b3_.`vat_number` AS vat_number_148,
  b3_.`vat_percent` AS vat_percent_149,
  b3_.`discount` AS discount_150,
  b3_.`address_equal` AS address_equal_151,
  b3_.`full_payment_date` AS full_payment_date_152,
  b3_.`delivery_index` AS delivery_index_153,
  b3_.`personal_data_agree` AS personal_data_agree_154,
  b3_.`delivery_region` AS delivery_region_155,
  b3_.`delivery_city` AS delivery_city_156,
  b3_.`delivery_address` AS delivery_address_157,
  b3_.`delivery_building` AS delivery_building_158,
  b3_.`delivery_apartment_office` AS delivery_apartment_office_159,
  b3_.`delivery_phone_code` AS delivery_phone_code_160,
  b3_.`delivery_phone` AS delivery_phone_161,
  b3_.`where_delivered` AS where_delivered_162,
  b3_.`warehouse_data` AS warehouse_data_163,
  b3_.`ref_number` AS ref_number_164,
  b3_.`sex` AS sex_165,
  b3_.`client_name` AS client_name_166,
  b3_.`client_surname` AS client_surname_167,
  b3_.`company_name` AS company_name_168,
  b3_.`description` AS description_169,
  b3_.`pay_type` AS pay_type_170,
  b3_.`pay_date_execution` AS pay_date_execution_171,
  b3_.`accept_pay` AS accept_pay_172,
  b3_.`cancel_date` AS cancel_date_173,
  b3_.`create_date` AS create_date_174,
  b3_.`update_date` AS update_date_175,
  b3_.`marker_reset` AS marker_reset_176,
  b3_.`marker_change` AS marker_change_177,
  b3_.`marker_delivery_change` AS marker_delivery_change_178,
  b3_.`locale` AS locale_179,
  b3_.`currency` AS currency_180,
  b3_.`payment_euro` AS payment_euro_181,
  b3_.`cur_rate` AS cur_rate_182,
  b3_.`measure` AS measure_183,
  b3_.`tracking_number` AS tracking_number_184,
  b3_.`carrier_name` AS carrier_name_185,
  b3_.`carrier_contact_data` AS carrier_contact_data_186,
  b3_.`write_off_reason` AS write_off_reason_187,
  b3_.`offset_explain` AS offset_explain_188,
  b3_.`weight_gross` AS weight_gross_189,
  b3_.`weight_limit` AS weight_limit_190,
  b3_.`remember` AS remember_191,
  b3_.`bank_details` AS bank_details_192,
  b3_.`recipient_number` AS recipient_number_193,
  b3_.`date_payment_back` AS date_payment_back_194,
  b3_.`send_create_1c` AS send_create_1c_195,
  b3_.`bank_transfer_requested` AS bank_transfer_requested_196,
  b3_.`marker_test` AS marker_test_197,
  b3_.`no_change` AS no_change_198,
  b3_.`kladr_id` AS kladr_id_199,
  b3_.`okato_id` AS okato_id_200,
  b3_.`product_review` AS product_review_201,
  b3_.`entrance_review` AS entrance_review_202,
  b3_.`send_review` AS send_review_203,
  b3_.`reserve` AS reserve_204,
  b3_.`key_email` AS key_email_205,
  b3_.`process` AS process_206,
  b3_.`spec_price` AS spec_price_207,
  b3_.`compensation` AS compensation_208,
  b3_.`check_breakdown` AS check_breakdown_209,
  b3_.`truspilot_review_requested` AS truspilot_review_requested_210,
  b3_.`collection_review_requested` AS collection_review_requested_211,
  b3_.`prohibit_send_review_request` AS prohibit_send_review_request_212,
  o0_.user_id AS user_id_213,
  o0_.country AS country_214,
  b2_.user_id AS user_id_215,
  b2_.warehouse AS warehouse_216,
  b2_.address_recipient AS address_recipient_217,
  b2_.address_payer AS address_payer_218,
  b2_.delivery_country AS delivery_country_219,
  b2_.mailing_id AS mailing_id_220,
  b2_.buy_order_manager AS buy_order_manager_221,
  b3_.user_id AS user_id_222,
  b3_.warehouse AS warehouse_223,
  b3_.address_recipient AS address_recipient_224,
  b3_.address_payer AS address_payer_225,
  b3_.delivery_country AS delivery_country_226,
  b3_.mailing_id AS mailing_id_227,
  b3_.buy_order_manager AS buy_order_manager_228
FROM
  `order_address` o0_
  LEFT JOIN `list_country` l1_ ON o0_.country = l1_.id
  LEFT JOIN `buy_order` b2_ ON o0_.id = b2_.address_recipient
  LEFT JOIN `buy_order` b3_ ON o0_.id = b3_.address_payer
WHERE
  o0_.`token` = ?
ORDER BY
  o0_.`zip_code` DESC,
  o0_.`frozen` ASC

SELECT o0_.`id` AS id_0, o0_.`hash` AS hash_1, o0_.`update_date` AS update_date_2, o0_.`marker_reset` AS marker_reset_3, o0_.`token` AS token_4, o0_.`unid` AS unid_5, o0_.`frozen` AS frozen_6, o0_.`zip_code` AS zip_code_7, o0_.`region` AS region_8, o0_.`city` AS city_9, o0_.`street` AS street_10, o0_.`building` AS building_11, o0_.`delivery_apartment_office` AS delivery_apartment_office_12, o0_.`sex` AS sex_13, o0_.`client_name` AS client_name_14, o0_.`client_surname` AS client_surname_15, o0_.`company_name` AS company_name_16, o0_.`company_address` AS company_address_17, o0_.`vat_type` AS vat_type_18, o0_.`vat_number` AS vat_number_19, o0_.`tax_number` AS tax_number_20, o0_.`email` AS email_21, o0_.`phone_code` AS phone_code_22, o0_.`phone` AS phone_23, o0_.`phone_two` AS phone_two_24, o0_.`description` AS description_25, o0_.`is_main_recipient` AS is_main_recipient_26, o0_.`address_type` AS address_type_27, l1_.`id` AS id_28, l1_.`code` AS code_29, l1_.`locale` AS locale_30, l1_.`phone_code` AS phone_code_31, l1_.`phone_mask` AS phone_mask_32, l1_.`min_valid_phone_numbers` AS min_valid_phone_numbers_33, l1_.`zip_code_mask` AS zip_code_mask_34, l1_.`percent_vat` AS percent_vat_35, l1_.`name` AS name_36, l1_.`name_en` AS name_en_37, l1_.`alias` AS alias_38, l1_.`sort` AS sort_39, l1_.`count` AS count_40, l1_.`hide` AS hide_41, l1_.`important` AS important_42, l1_.`pay_pal_percent` AS pay_pal_percent_43, l1_.`pay_pal_percent_own` AS pay_pal_percent_own_44, l1_.`vat` AS vat_45, l1_.`pv_type` AS pv_type_46, l1_.`capital_timezone_diff` AS capital_timezone_diff_47, l1_.`capital` AS capital_48, l1_.`free_sample_delivery` AS free_sample_delivery_49, l1_.`units` AS units_50, b2_.`id` AS id_51, b2_.`mirror` AS mirror_52, b2_.`unid` AS unid_53, b2_.`unid_vat_player` AS unid_vat_player_54, b2_.`hash` AS hash_55, b2_.`number` AS number_56, b2_.`number_donor` AS number_donor_57, b2_.`token` AS token_58, b2_.`email` AS email_59, b2_.`email_send` AS email_send_60, b2_.`status` AS status_61, b2_.`step` AS step_62, b2_.`name` AS name_63, b2_.`adyen` AS adyen_64, b2_.`tax_number` AS tax_number_65, b2_.`vat_type` AS vat_type_66, b2_.`vat_number` AS vat_number_67, b2_.`vat_percent` AS vat_percent_68, b2_.`discount` AS discount_69, b2_.`address_equal` AS address_equal_70, b2_.`full_payment_date` AS full_payment_date_71, b2_.`delivery_index` AS delivery_index_72, b2_.`personal_data_agree` AS personal_data_agree_73, b2_.`delivery_region` AS delivery_region_74, b2_.`delivery_city` AS delivery_city_75, b2_.`delivery_address` AS delivery_address_76, b2_.`delivery_building` AS delivery_building_77, b2_.`delivery_apartment_office` AS delivery_apartment_office_78, b2_.`delivery_phone_code` AS delivery_phone_code_79, b2_.`delivery_phone` AS delivery_phone_80, b2_.`where_delivered` AS where_delivered_81, b2_.`warehouse_data` AS warehouse_data_82, b2_.`ref_number` AS ref_number_83, b2_.`sex` AS sex_84, b2_.`client_name` AS client_name_85, b2_.`client_surname` AS client_surname_86, b2_.`company_name` AS company_name_87, b2_.`description` AS description_88, b2_.`pay_type` AS pay_type_89, b2_.`pay_date_execution` AS pay_date_execution_90, b2_.`accept_pay` AS accept_pay_91, b2_.`cancel_date` AS cancel_date_92, b2_.`create_date` AS create_date_93, b2_.`update_date` AS update_date_94, b2_.`marker_reset` AS marker_reset_95, b2_.`marker_change` AS marker_change_96, b2_.`marker_delivery_change` AS marker_delivery_change_97, b2_.`locale` AS locale_98, b2_.`currency` AS currency_99, b2_.`payment_euro` AS payment_euro_100, b2_.`cur_rate` AS cur_rate_101, b2_.`measure` AS measure_102, b2_.`tracking_number` AS tracking_number_103, b2_.`carrier_name` AS carrier_name_104, b2_.`carrier_contact_data` AS carrier_contact_data_105, b2_.`write_off_reason` AS write_off_reason_106, b2_.`offset_explain` AS offset_explain_107, b2_.`weight_gross` AS weight_gross_108, b2_.`weight_limit` AS weight_limit_109, b2_.`remember` AS remember_110, b2_.`bank_details` AS bank_details_111, b2_.`recipient_number` AS recipient_number_112, b2_.`date_payment_back` AS date_payment_back_113, b2_.`send_create_1c` AS send_create_1c_114, b2_.`bank_transfer_requested` AS bank_transfer_requested_115, b2_.`marker_test` AS marker_test_116, b2_.`no_change` AS no_change_117, b2_.`kladr_id` AS kladr_id_118, b2_.`okato_id` AS okato_id_119, b2_.`product_review` AS product_review_120, b2_.`entrance_review` AS entrance_review_121, b2_.`send_review` AS send_review_122, b2_.`reserve` AS reserve_123, b2_.`key_email` AS key_email_124, b2_.`process` AS process_125, b2_.`spec_price` AS spec_price_126, b2_.`compensation` AS compensation_127, b2_.`check_breakdown` AS check_breakdown_128, b2_.`truspilot_review_requested` AS truspilot_review_requested_129, b2_.`collection_review_requested` AS collection_review_requested_130, b2_.`prohibit_send_review_request` AS prohibit_send_review_request_131, b3_.`id` AS id_132, b3_.`mirror` AS mirror_133, b3_.`unid` AS unid_134, b3_.`unid_vat_player` AS unid_vat_player_135, b3_.`hash` AS hash_136, b3_.`number` AS number_137, b3_.`number_donor` AS number_donor_138, b3_.`token` AS token_139, b3_.`email` AS email_140, b3_.`email_send` AS email_send_141, b3_.`status` AS status_142, b3_.`step` AS step_143, b3_.`name` AS name_144, b3_.`adyen` AS adyen_145, b3_.`tax_number` AS tax_number_146, b3_.`vat_type` AS vat_type_147, b3_.`vat_number` AS vat_number_148, b3_.`vat_percent` AS vat_percent_149, b3_.`discount` AS discount_150, b3_.`address_equal` AS address_equal_151, b3_.`full_payment_date` AS full_payment_date_152, b3_.`delivery_index` AS delivery_index_153, b3_.`personal_data_agree` AS personal_data_agree_154, b3_.`delivery_region` AS delivery_region_155, b3_.`delivery_city` AS delivery_city_156, b3_.`delivery_address` AS delivery_address_157, b3_.`delivery_building` AS delivery_building_158, b3_.`delivery_apartment_office` AS delivery_apartment_office_159, b3_.`delivery_phone_code` AS delivery_phone_code_160, b3_.`delivery_phone` AS delivery_phone_161, b3_.`where_delivered` AS where_delivered_162, b3_.`warehouse_data` AS warehouse_data_163, b3_.`ref_number` AS ref_number_164, b3_.`sex` AS sex_165, b3_.`client_name` AS client_name_166, b3_.`client_surname` AS client_surname_167, b3_.`company_name` AS company_name_168, b3_.`description` AS description_169, b3_.`pay_type` AS pay_type_170, b3_.`pay_date_execution` AS pay_date_execution_171, b3_.`accept_pay` AS accept_pay_172, b3_.`cancel_date` AS cancel_date_173, b3_.`create_date` AS create_date_174, b3_.`update_date` AS update_date_175, b3_.`marker_reset` AS marker_reset_176, b3_.`marker_change` AS marker_change_177, b3_.`marker_delivery_change` AS marker_delivery_change_178, b3_.`locale` AS locale_179, b3_.`currency` AS currency_180, b3_.`payment_euro` AS payment_euro_181, b3_.`cur_rate` AS cur_rate_182, b3_.`measure` AS measure_183, b3_.`tracking_number` AS tracking_number_184, b3_.`carrier_name` AS carrier_name_185, b3_.`carrier_contact_data` AS carrier_contact_data_186, b3_.`write_off_reason` AS write_off_reason_187, b3_.`offset_explain` AS offset_explain_188, b3_.`weight_gross` AS weight_gross_189, b3_.`weight_limit` AS weight_limit_190, b3_.`remember` AS remember_191, b3_.`bank_details` AS bank_details_192, b3_.`recipient_number` AS recipient_number_193, b3_.`date_payment_back` AS date_payment_back_194, b3_.`send_create_1c` AS send_create_1c_195, b3_.`bank_transfer_requested` AS bank_transfer_requested_196, b3_.`marker_test` AS marker_test_197, b3_.`no_change` AS no_change_198, b3_.`kladr_id` AS kladr_id_199, b3_.`okato_id` AS okato_id_200, b3_.`product_review` AS product_review_201, b3_.`entrance_review` AS entrance_review_202, b3_.`send_review` AS send_review_203, b3_.`reserve` AS reserve_204, b3_.`key_email` AS key_email_205, b3_.`process` AS process_206, b3_.`spec_price` AS spec_price_207, b3_.`compensation` AS compensation_208, b3_.`check_breakdown` AS check_breakdown_209, b3_.`truspilot_review_requested` AS truspilot_review_requested_210, b3_.`collection_review_requested` AS collection_review_requested_211, b3_.`prohibit_send_review_request` AS prohibit_send_review_request_212, o0_.user_id AS user_id_213, o0_.country AS country_214, b2_.user_id AS user_id_215, b2_.warehouse AS warehouse_216, b2_.address_recipient AS address_recipient_217, b2_.address_payer AS address_payer_218, b2_.delivery_country AS delivery_country_219, b2_.mailing_id AS mailing_id_220, b2_.buy_order_manager AS buy_order_manager_221, b3_.user_id AS user_id_222, b3_.warehouse AS warehouse_223, b3_.address_recipient AS address_recipient_224, b3_.address_payer AS address_payer_225, b3_.delivery_country AS delivery_country_226, b3_.mailing_id AS mailing_id_227, b3_.buy_order_manager AS buy_order_manager_228 FROM `order_address` o0_ LEFT JOIN `list_country` l1_ ON o0_.country = l1_.id LEFT JOIN `buy_order` b2_ ON o0_.id = b2_.address_recipient LEFT JOIN `buy_order` b3_ ON o0_.id = b3_.address_payer WHERE o0_.`token` = '84aae6c69942540e96e489d3274f0f9c38e8c1d0212ccb23821eb9eaaaa38f10' ORDER BY o0_.`zip_code` DESC, o0_.`frozen` ASC;

SELECT
  lu.en AS slug
FROM
  publication p
  LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id
  LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id
  LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id
WHERE
  p.id = 2232
  AND lp.en = 1
  AND lst.en = 1;

SELECT
       			lu.en AS slug
            FROM
                publication p
            LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id
            LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id
            LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id
			WHERE p.id = 2232 AND lp.en = 1 AND lst.en = 1;
            ;