Symfony Profiler

SELECT
  b0_.`id` AS id_0,
  b0_.`mirror` AS mirror_1,
  b0_.`unid` AS unid_2,
  b0_.`unid_vat_player` AS unid_vat_player_3,
  b0_.`hash` AS hash_4,
  b0_.`number` AS number_5,
  b0_.`number_donor` AS number_donor_6,
  b0_.`token` AS token_7,
  b0_.`email` AS email_8,
  b0_.`email_send` AS email_send_9,
  b0_.`status` AS status_10,
  b0_.`step` AS step_11,
  b0_.`name` AS name_12,
  b0_.`adyen` AS adyen_13,
  b0_.`tax_number` AS tax_number_14,
  b0_.`vat_type` AS vat_type_15,
  b0_.`vat_number` AS vat_number_16,
  b0_.`vat_percent` AS vat_percent_17,
  b0_.`discount` AS discount_18,
  b0_.`address_equal` AS address_equal_19,
  b0_.`full_payment_date` AS full_payment_date_20,
  b0_.`delivery_index` AS delivery_index_21,
  b0_.`personal_data_agree` AS personal_data_agree_22,
  b0_.`delivery_region` AS delivery_region_23,
  b0_.`delivery_city` AS delivery_city_24,
  b0_.`delivery_address` AS delivery_address_25,
  b0_.`delivery_building` AS delivery_building_26,
  b0_.`delivery_apartment_office` AS delivery_apartment_office_27,
  b0_.`delivery_phone_code` AS delivery_phone_code_28,
  b0_.`delivery_phone` AS delivery_phone_29,
  b0_.`where_delivered` AS where_delivered_30,
  b0_.`warehouse_data` AS warehouse_data_31,
  b0_.`ref_number` AS ref_number_32,
  b0_.`sex` AS sex_33,
  b0_.`client_name` AS client_name_34,
  b0_.`client_surname` AS client_surname_35,
  b0_.`company_name` AS company_name_36,
  b0_.`description` AS description_37,
  b0_.`pay_type` AS pay_type_38,
  b0_.`pay_date_execution` AS pay_date_execution_39,
  b0_.`accept_pay` AS accept_pay_40,
  b0_.`cancel_date` AS cancel_date_41,
  b0_.`create_date` AS create_date_42,
  b0_.`update_date` AS update_date_43,
  b0_.`marker_reset` AS marker_reset_44,
  b0_.`marker_change` AS marker_change_45,
  b0_.`marker_delivery_change` AS marker_delivery_change_46,
  b0_.`locale` AS locale_47,
  b0_.`currency` AS currency_48,
  b0_.`payment_euro` AS payment_euro_49,
  b0_.`cur_rate` AS cur_rate_50,
  b0_.`measure` AS measure_51,
  b0_.`tracking_number` AS tracking_number_52,
  b0_.`carrier_name` AS carrier_name_53,
  b0_.`carrier_contact_data` AS carrier_contact_data_54,
  b0_.`write_off_reason` AS write_off_reason_55,
  b0_.`offset_explain` AS offset_explain_56,
  b0_.`weight_gross` AS weight_gross_57,
  b0_.`weight_limit` AS weight_limit_58,
  b0_.`remember` AS remember_59,
  b0_.`bank_details` AS bank_details_60,
  b0_.`recipient_number` AS recipient_number_61,
  b0_.`date_payment_back` AS date_payment_back_62,
  b0_.`send_create_1c` AS send_create_1c_63,
  b0_.`bank_transfer_requested` AS bank_transfer_requested_64,
  b0_.`marker_test` AS marker_test_65,
  b0_.`no_change` AS no_change_66,
  b0_.`kladr_id` AS kladr_id_67,
  b0_.`okato_id` AS okato_id_68,
  b0_.`product_review` AS product_review_69,
  b0_.`entrance_review` AS entrance_review_70,
  b0_.`send_review` AS send_review_71,
  b0_.`reserve` AS reserve_72,
  b0_.`key_email` AS key_email_73,
  b0_.`process` AS process_74,
  b0_.`spec_price` AS spec_price_75,
  b0_.`compensation` AS compensation_76,
  b0_.`check_breakdown` AS check_breakdown_77,
  b0_.`truspilot_review_requested` AS truspilot_review_requested_78,
  b0_.`collection_review_requested` AS collection_review_requested_79,
  b0_.`prohibit_send_review_request` AS prohibit_send_review_request_80,
  u1_.`id` AS id_81,
  u1_.`unid` AS unid_82,
  u1_.`corporate_unid` AS corporate_unid_83,
  u1_.`token` AS token_84,
  u1_.`is_active` AS is_active_85,
  u1_.`proved` AS proved_86,
  u1_.`alias` AS alias_87,
  u1_.`foreign_alias` AS foreign_alias_88,
  u1_.`lotus_name` AS lotus_name_89,
  u1_.`password` AS password_90,
  u1_.`expired` AS expired_91,
  u1_.`expires_at` AS expires_at_92,
  u1_.`credentials_expired` AS credentials_expired_93,
  u1_.`credentials_expire_at` AS credentials_expire_at_94,
  u1_.`last_ip` AS last_ip_95,
  u1_.`source` AS source_96,
  u1_.`social_network` AS social_network_97,
  u1_.`social_network_id` AS social_network_id_98,
  u1_.`google_id` AS google_id_99,
  u1_.`fb_id` AS fb_id_100,
  u1_.`vk_id` AS vk_id_101,
  u1_.`ig_id` AS ig_id_102,
  u1_.`test` AS test_103,
  u1_.`token_fixed` AS token_fixed_104,
  u1_.`bid` AS bid_105,
  u1_.`email` AS email_106,
  u1_.`salt` AS salt_107,
  u1_.`review_request_sent` AS review_request_sent_108,
  u1_.`username` AS username_109,
  u1_.`roles` AS roles_110,
  u1_.`enabled` AS enabled_111,
  u1_.`confirmation_token` AS confirmation_token_112,
  u1_.`last_login` AS last_login_113,
  u1_.`password_requested_at` AS password_requested_at_114,
  u1_.`security_field` AS security_field_115,
  u1_.`created_at` AS created_at_116,
  u1_.`is_legal_entity` AS is_legal_entity_117,
  u1_.`companyName` AS companyName_118,
  u1_.`vatNumber` AS vatNumber_119,
  u1_.`lang` AS lang_120,
  b2_.`id` AS id_121,
  b2_.`type` AS type_122,
  b2_.`article_time_type` AS article_time_type_123,
  b2_.`code` AS code_124,
  b2_.`packaging_count` AS packaging_count_125,
  b2_.`packaging` AS packaging_126,
  b2_.`pallet` AS pallet_127,
  b2_.`multiple_pallet` AS multiple_pallet_128,
  b2_.`weight` AS weight_129,
  b2_.`amount` AS amount_130,
  b2_.`price` AS price_131,
  b2_.`price_eur` AS price_eur_132,
  b2_.`currency` AS currency_133,
  b2_.`measure` AS measure_134,
  b2_.`delivery_time_min` AS delivery_time_min_135,
  b2_.`delivery_time_max` AS delivery_time_max_136,
  b2_.`delivery_time_min_faster` AS delivery_time_min_faster_137,
  b2_.`delivery_time_max_faster` AS delivery_time_max_faster_138,
  b2_.`delivery_time_confirm_min` AS delivery_time_confirm_min_139,
  b2_.`delivery_time_confirm_max` AS delivery_time_confirm_max_140,
  b2_.`holiday` AS holiday_141,
  b2_.`sample_format` AS sample_format_142,
  b2_.`sample_type` AS sample_type_143,
  b2_.`sample_code` AS sample_code_144,
  b2_.`swimming_pool` AS swimming_pool_145,
  b2_.`add_time` AS add_time_146,
  a3_.`id` AS id_147,
  a3_.`code` AS code_148,
  a3_.`name` AS name_149,
  a3_.`alternate_name` AS alternate_name_150,
  a3_.`urla` AS urla_151,
  a3_.`file` AS file_152,
  a3_.`size_x` AS size_x_153,
  a3_.`size_y` AS size_y_154,
  a3_.`size_gb_x` AS size_gb_x_155,
  a3_.`size_gb_y` AS size_gb_y_156,
  a3_.`size_tessera` AS size_tessera_157,
  a3_.`file_size1_x` AS file_size1_x_158,
  a3_.`file_size1_y` AS file_size1_y_159,
  a3_.`file_size2_x` AS file_size2_x_160,
  a3_.`file_size2_y` AS file_size2_y_161,
  a3_.`file_size3_x` AS file_size3_x_162,
  a3_.`file_size3_y` AS file_size3_y_163,
  a3_.`file_size500_x` AS file_size500_x_164,
  a3_.`file_size500_y` AS file_size500_y_165,
  a3_.`file_size740_x` AS file_size740_x_166,
  a3_.`file_size740_y` AS file_size740_y_167,
  a3_.`file_size8_x` AS file_size8_x_168,
  a3_.`file_size8_y` AS file_size8_y_169,
  a3_.`pallet` AS pallet_170,
  a3_.`pallet_ft` AS pallet_ft_171,
  a3_.`type_constraint` AS type_constraint_172,
  a3_.`multiple_pallet` AS multiple_pallet_173,
  a3_.`min_order` AS min_order_174,
  a3_.`price_euro` AS price_euro_175,
  a3_.`price_mq_euro` AS price_mq_euro_176,
  a3_.`price_euro_de` AS price_euro_de_177,
  a3_.`price_mq_euro_de` AS price_mq_euro_de_178,
  a3_.`price_euro_at` AS price_euro_at_179,
  a3_.`price_mq_euro_at` AS price_mq_euro_at_180,
  a3_.`price_euro_fi` AS price_euro_fi_181,
  a3_.`price_mq_euro_fi` AS price_mq_euro_fi_182,
  a3_.`price_euro_fr` AS price_euro_fr_183,
  a3_.`price_mq_euro_fr` AS price_mq_euro_fr_184,
  a3_.`price_euro_it` AS price_euro_it_185,
  a3_.`price_mq_euro_it` AS price_mq_euro_it_186,
  a3_.`price_euro_be` AS price_euro_be_187,
  a3_.`price_mq_euro_be` AS price_mq_euro_be_188,
  a3_.`price_euro_ie` AS price_euro_ie_189,
  a3_.`price_mq_euro_ie` AS price_mq_euro_ie_190,
  a3_.`price_euro_nl` AS price_euro_nl_191,
  a3_.`price_mq_euro_nl` AS price_mq_euro_nl_192,
  a3_.`price_euro_es` AS price_euro_es_193,
  a3_.`price_mq_euro_es` AS price_mq_euro_es_194,
  a3_.`price_rub` AS price_rub_195,
  a3_.`price_rue` AS price_rue_196,
  a3_.`price_mq_rub` AS price_mq_rub_197,
  a3_.`price_mq_rue` AS price_mq_rue_198,
  a3_.`price_gbp` AS price_gbp_199,
  a3_.`price_gbe` AS price_gbe_200,
  a3_.`price_mq_gbp` AS price_mq_gbp_201,
  a3_.`price_mq_gbe` AS price_mq_gbe_202,
  a3_.`price_usd` AS price_usd_203,
  a3_.`price_use` AS price_use_204,
  a3_.`price_fq_usd` AS price_fq_usd_205,
  a3_.`price_fq_use` AS price_fq_use_206,
  a3_.`price_mq_usd` AS price_mq_usd_207,
  a3_.`price_mq_use` AS price_mq_use_208,
  a3_.`price_chf` AS price_chf_209,
  a3_.`price_che` AS price_che_210,
  a3_.`price_mq_chf` AS price_mq_chf_211,
  a3_.`price_mq_che` AS price_mq_che_212,
  a3_.`price_sek` AS price_sek_213,
  a3_.`price_see` AS price_see_214,
  a3_.`price_mq_sek` AS price_mq_sek_215,
  a3_.`price_mq_see` AS price_mq_see_216,
  a3_.`price_dkk` AS price_dkk_217,
  a3_.`price_dke` AS price_dke_218,
  a3_.`price_mq_dkk` AS price_mq_dkk_219,
  a3_.`price_mq_dke` AS price_mq_dke_220,
  a3_.`price_nok` AS price_nok_221,
  a3_.`price_noe` AS price_noe_222,
  a3_.`price_mq_nok` AS price_mq_nok_223,
  a3_.`price_mq_noe` AS price_mq_noe_224,
  a3_.`price_pln` AS price_pln_225,
  a3_.`price_ple` AS price_ple_226,
  a3_.`price_mq_pln` AS price_mq_pln_227,
  a3_.`price_mq_ple` AS price_mq_ple_228,
  a3_.`price_cad` AS price_cad_229,
  a3_.`price_cae` AS price_cae_230,
  a3_.`price_fq_cad` AS price_fq_cad_231,
  a3_.`price_fq_cae` AS price_fq_cae_232,
  a3_.`price_mq_cad` AS price_mq_cad_233,
  a3_.`price_mq_cae` AS price_mq_cae_234,
  a3_.`thick` AS thick_235,
  a3_.`weight` AS weight_236,
  a3_.`packaging_count` AS packaging_count_237,
  a3_.`packaging_count_ft` AS packaging_count_ft_238,
  a3_.`packaging_count_pc` AS packaging_count_pc_239,
  a3_.`m2one_ps` AS m2one_ps_240,
  a3_.`description_ru` AS description_ru_241,
  a3_.`description_en` AS description_en_242,
  a3_.`description_it` AS description_it_243,
  a3_.`description_es` AS description_es_244,
  a3_.`description_fr` AS description_fr_245,
  a3_.`description_de` AS description_de_246,
  a3_.`description_pt` AS description_pt_247,
  a3_.`description_pl` AS description_pl_248,
  a3_.`description_nl` AS description_nl_249,
  a3_.`description_fi` AS description_fi_250,
  a3_.`description_ua` AS description_ua_251,
  a3_.`description_sv` AS description_sv_252,
  a3_.`description_no` AS description_no_253,
  a3_.`description_da` AS description_da_254,
  a3_.`description_cn` AS description_cn_255,
  a3_.`scheme` AS scheme_256,
  a3_.`sale_date` AS sale_date_257,
  a3_.`thin_granite` AS thin_granite_258,
  a3_.`glazed_granite` AS glazed_granite_259,
  a3_.`pei` AS pei_260,
  a3_.`is_grouped` AS is_grouped_261,
  a3_.`is_rotate` AS is_rotate_262,
  a3_.`price_prx` AS price_prx_263,
  a3_.`background_white` AS background_white_264,
  a3_.`border_grey` AS border_grey_265,
  a3_.`is_edit` AS is_edit_266,
  a3_.`edited_at` AS edited_at_267,
  a3_.`comment` AS comment_268,
  a3_.`file_edit` AS file_edit_269,
  a3_.`image_setting` AS image_setting_270,
  a3_.`file_w` AS file_w_271,
  a3_.`file_h` AS file_h_272,
  a3_.`file_w4000` AS file_w4000_273,
  a3_.`file_h4000` AS file_h4000_274,
  a3_.`size_z` AS size_z_275,
  a3_.`size_gb_z` AS size_gb_z_276,
  a3_.`repeat_number` AS repeat_number_277,
  a3_.`size_big` AS size_big_278,
  a3_.`delivery_suspended` AS delivery_suspended_279,
  a3_.`poddon_x` AS poddon_x_280,
  a3_.`poddon_y` AS poddon_y_281,
  a3_.`poddon_z` AS poddon_z_282,
  a3_.`module` AS module_283,
  a3_.`tessera_size_x` AS tessera_size_x_284,
  a3_.`tessera_size_y` AS tessera_size_y_285,
  a3_.`tessera_size_z` AS tessera_size_z_286,
  a3_.`poddon_count` AS poddon_count_287,
  a3_.`poddon_weight` AS poddon_weight_288,
  a3_.`added_to_cart` AS added_to_cart_289,
  a3_.`sold_out` AS sold_out_290,
  a3_.`sold_out_vol` AS sold_out_vol_291,
  a3_.`swimming_pool` AS swimming_pool_292,
  a3_.`can_select_substrate` AS can_select_substrate_293,
  a3_.`designer` AS designer_294,
  a3_.`designer_id` AS designer_id_295,
  a3_.`mosaic_effect` AS mosaic_effect_296,
  a3_.`not_sample` AS not_sample_297,
  a3_.`express_sample` AS express_sample_298,
  a3_.`description_edit` AS description_edit_299,
  a3_.`comment_scheme_image` AS comment_scheme_image_300,
  a3_.`variant_image` AS variant_image_301,
  a3_.`square` AS square_302,
  a3_.`fix_big_size` AS fix_big_size_303,
  a3_.`overflow_sink` AS overflow_sink_304,
  a3_.`drain_size_sink` AS drain_size_sink_305,
  a3_.`faucet_hole_sink` AS faucet_hole_sink_306,
  a3_.`rotate` AS rotate_307,
  a3_.`dyed_in_mass` AS dyed_in_mass_308,
  a3_.`durability_class` AS durability_class_309,
  a3_.`is_comment_ru` AS is_comment_ru_310,
  a3_.`file_rotation` AS file_rotation_311,
  a3_.`created_at` AS created_at_312,
  a3_.`updated_at` AS updated_at_313,
  l4_.`id` AS id_314,
  l4_.`code` AS code_315,
  l4_.`locale` AS locale_316,
  l4_.`phone_code` AS phone_code_317,
  l4_.`phone_mask` AS phone_mask_318,
  l4_.`min_valid_phone_numbers` AS min_valid_phone_numbers_319,
  l4_.`zip_code_mask` AS zip_code_mask_320,
  l4_.`percent_vat` AS percent_vat_321,
  l4_.`name` AS name_322,
  l4_.`name_en` AS name_en_323,
  l4_.`alias` AS alias_324,
  l4_.`sort` AS sort_325,
  l4_.`count` AS count_326,
  l4_.`hide` AS hide_327,
  l4_.`important` AS important_328,
  l4_.`pay_pal_percent` AS pay_pal_percent_329,
  l4_.`pay_pal_percent_own` AS pay_pal_percent_own_330,
  l4_.`vat` AS vat_331,
  l4_.`pv_type` AS pv_type_332,
  l4_.`capital_timezone_diff` AS capital_timezone_diff_333,
  l4_.`capital` AS capital_334,
  l4_.`free_sample_delivery` AS free_sample_delivery_335,
  l4_.`units` AS units_336,
  o5_.`id` AS id_337,
  o5_.`hash` AS hash_338,
  o5_.`transaction_id` AS transaction_id_339,
  o5_.`pay_sys` AS pay_sys_340,
  o5_.`pay_sys_name` AS pay_sys_name_341,
  o5_.`percent_ps` AS percent_ps_342,
  o5_.`date` AS date_343,
  o5_.`data` AS data_344,
  o5_.`amount` AS amount_345,
  o5_.`status` AS status_346,
  o5_.`save_to_1c` AS save_to_1c_347,
  o5_.`cur_rate` AS cur_rate_348,
  o5_.`currency` AS currency_349,
  b0_.user_id AS user_id_350,
  b0_.warehouse AS warehouse_351,
  b0_.address_recipient AS address_recipient_352,
  b0_.address_payer AS address_payer_353,
  b0_.delivery_country AS delivery_country_354,
  b0_.mailing_id AS mailing_id_355,
  b0_.buy_order_manager AS buy_order_manager_356,
  b2_.buy_order_id AS buy_order_id_357,
  b2_.article_id AS article_id_358,
  a3_.collection AS collection_359,
  a3_.newCollection AS newCollection_360,
  a3_.type AS type_361,
  a3_.measure AS measure_362,
  a3_.surface AS surface_363,
  a3_.pr_status AS pr_status_364,
  a3_.category_price AS category_price_365,
  a3_.edge_type AS edge_type_366,
  a3_.using AS using_367,
  a3_.shape AS shape_368,
  a3_.material AS material_369,
  a3_.delivery AS delivery_370,
  a3_.sliding AS sliding_371,
  a3_.off_shade AS off_shade_372,
  a3_.style AS style_373,
  a3_.repeat_draw AS repeat_draw_374,
  a3_.measurement_size AS measurement_size_375,
  a3_.installation_type AS installation_type_376,
  a3_.meth_laying AS meth_laying_377,
  a3_.draw AS draw_378,
  o5_.order_id AS order_id_379
FROM
  `buy_order` b0_
  LEFT JOIN `user` u1_ ON b0_.user_id = u1_.id
  LEFT JOIN `buy_order_article` b2_ ON b0_.id = b2_.buy_order_id
  LEFT JOIN `article` a3_ ON b2_.article_id = a3_.id
  LEFT JOIN `list_country` l4_ ON b0_.delivery_country = l4_.id
  LEFT JOIN `order_payment` o5_ ON b0_.id = o5_.order_id
WHERE
  b0_.`hash` = ?
  AND b0_.`status` <> 12
ORDER BY
  a3_.collection ASC,
  b2_.`id` DESC,
  o5_.`date` ASC

SELECT b0_.`id` AS id_0, b0_.`mirror` AS mirror_1, b0_.`unid` AS unid_2, b0_.`unid_vat_player` AS unid_vat_player_3, b0_.`hash` AS hash_4, b0_.`number` AS number_5, b0_.`number_donor` AS number_donor_6, b0_.`token` AS token_7, b0_.`email` AS email_8, b0_.`email_send` AS email_send_9, b0_.`status` AS status_10, b0_.`step` AS step_11, b0_.`name` AS name_12, b0_.`adyen` AS adyen_13, b0_.`tax_number` AS tax_number_14, b0_.`vat_type` AS vat_type_15, b0_.`vat_number` AS vat_number_16, b0_.`vat_percent` AS vat_percent_17, b0_.`discount` AS discount_18, b0_.`address_equal` AS address_equal_19, b0_.`full_payment_date` AS full_payment_date_20, b0_.`delivery_index` AS delivery_index_21, b0_.`personal_data_agree` AS personal_data_agree_22, b0_.`delivery_region` AS delivery_region_23, b0_.`delivery_city` AS delivery_city_24, b0_.`delivery_address` AS delivery_address_25, b0_.`delivery_building` AS delivery_building_26, b0_.`delivery_apartment_office` AS delivery_apartment_office_27, b0_.`delivery_phone_code` AS delivery_phone_code_28, b0_.`delivery_phone` AS delivery_phone_29, b0_.`where_delivered` AS where_delivered_30, b0_.`warehouse_data` AS warehouse_data_31, b0_.`ref_number` AS ref_number_32, b0_.`sex` AS sex_33, b0_.`client_name` AS client_name_34, b0_.`client_surname` AS client_surname_35, b0_.`company_name` AS company_name_36, b0_.`description` AS description_37, b0_.`pay_type` AS pay_type_38, b0_.`pay_date_execution` AS pay_date_execution_39, b0_.`accept_pay` AS accept_pay_40, b0_.`cancel_date` AS cancel_date_41, b0_.`create_date` AS create_date_42, b0_.`update_date` AS update_date_43, b0_.`marker_reset` AS marker_reset_44, b0_.`marker_change` AS marker_change_45, b0_.`marker_delivery_change` AS marker_delivery_change_46, b0_.`locale` AS locale_47, b0_.`currency` AS currency_48, b0_.`payment_euro` AS payment_euro_49, b0_.`cur_rate` AS cur_rate_50, b0_.`measure` AS measure_51, b0_.`tracking_number` AS tracking_number_52, b0_.`carrier_name` AS carrier_name_53, b0_.`carrier_contact_data` AS carrier_contact_data_54, b0_.`write_off_reason` AS write_off_reason_55, b0_.`offset_explain` AS offset_explain_56, b0_.`weight_gross` AS weight_gross_57, b0_.`weight_limit` AS weight_limit_58, b0_.`remember` AS remember_59, b0_.`bank_details` AS bank_details_60, b0_.`recipient_number` AS recipient_number_61, b0_.`date_payment_back` AS date_payment_back_62, b0_.`send_create_1c` AS send_create_1c_63, b0_.`bank_transfer_requested` AS bank_transfer_requested_64, b0_.`marker_test` AS marker_test_65, b0_.`no_change` AS no_change_66, b0_.`kladr_id` AS kladr_id_67, b0_.`okato_id` AS okato_id_68, b0_.`product_review` AS product_review_69, b0_.`entrance_review` AS entrance_review_70, b0_.`send_review` AS send_review_71, b0_.`reserve` AS reserve_72, b0_.`key_email` AS key_email_73, b0_.`process` AS process_74, b0_.`spec_price` AS spec_price_75, b0_.`compensation` AS compensation_76, b0_.`check_breakdown` AS check_breakdown_77, b0_.`truspilot_review_requested` AS truspilot_review_requested_78, b0_.`collection_review_requested` AS collection_review_requested_79, b0_.`prohibit_send_review_request` AS prohibit_send_review_request_80, u1_.`id` AS id_81, u1_.`unid` AS unid_82, u1_.`corporate_unid` AS corporate_unid_83, u1_.`token` AS token_84, u1_.`is_active` AS is_active_85, u1_.`proved` AS proved_86, u1_.`alias` AS alias_87, u1_.`foreign_alias` AS foreign_alias_88, u1_.`lotus_name` AS lotus_name_89, u1_.`password` AS password_90, u1_.`expired` AS expired_91, u1_.`expires_at` AS expires_at_92, u1_.`credentials_expired` AS credentials_expired_93, u1_.`credentials_expire_at` AS credentials_expire_at_94, u1_.`last_ip` AS last_ip_95, u1_.`source` AS source_96, u1_.`social_network` AS social_network_97, u1_.`social_network_id` AS social_network_id_98, u1_.`google_id` AS google_id_99, u1_.`fb_id` AS fb_id_100, u1_.`vk_id` AS vk_id_101, u1_.`ig_id` AS ig_id_102, u1_.`test` AS test_103, u1_.`token_fixed` AS token_fixed_104, u1_.`bid` AS bid_105, u1_.`email` AS email_106, u1_.`salt` AS salt_107, u1_.`review_request_sent` AS review_request_sent_108, u1_.`username` AS username_109, u1_.`roles` AS roles_110, u1_.`enabled` AS enabled_111, u1_.`confirmation_token` AS confirmation_token_112, u1_.`last_login` AS last_login_113, u1_.`password_requested_at` AS password_requested_at_114, u1_.`security_field` AS security_field_115, u1_.`created_at` AS created_at_116, u1_.`is_legal_entity` AS is_legal_entity_117, u1_.`companyName` AS companyName_118, u1_.`vatNumber` AS vatNumber_119, u1_.`lang` AS lang_120, b2_.`id` AS id_121, b2_.`type` AS type_122, b2_.`article_time_type` AS article_time_type_123, b2_.`code` AS code_124, b2_.`packaging_count` AS packaging_count_125, b2_.`packaging` AS packaging_126, b2_.`pallet` AS pallet_127, b2_.`multiple_pallet` AS multiple_pallet_128, b2_.`weight` AS weight_129, b2_.`amount` AS amount_130, b2_.`price` AS price_131, b2_.`price_eur` AS price_eur_132, b2_.`currency` AS currency_133, b2_.`measure` AS measure_134, b2_.`delivery_time_min` AS delivery_time_min_135, b2_.`delivery_time_max` AS delivery_time_max_136, b2_.`delivery_time_min_faster` AS delivery_time_min_faster_137, b2_.`delivery_time_max_faster` AS delivery_time_max_faster_138, b2_.`delivery_time_confirm_min` AS delivery_time_confirm_min_139, b2_.`delivery_time_confirm_max` AS delivery_time_confirm_max_140, b2_.`holiday` AS holiday_141, b2_.`sample_format` AS sample_format_142, b2_.`sample_type` AS sample_type_143, b2_.`sample_code` AS sample_code_144, b2_.`swimming_pool` AS swimming_pool_145, b2_.`add_time` AS add_time_146, a3_.`id` AS id_147, a3_.`code` AS code_148, a3_.`name` AS name_149, a3_.`alternate_name` AS alternate_name_150, a3_.`urla` AS urla_151, a3_.`file` AS file_152, a3_.`size_x` AS size_x_153, a3_.`size_y` AS size_y_154, a3_.`size_gb_x` AS size_gb_x_155, a3_.`size_gb_y` AS size_gb_y_156, a3_.`size_tessera` AS size_tessera_157, a3_.`file_size1_x` AS file_size1_x_158, a3_.`file_size1_y` AS file_size1_y_159, a3_.`file_size2_x` AS file_size2_x_160, a3_.`file_size2_y` AS file_size2_y_161, a3_.`file_size3_x` AS file_size3_x_162, a3_.`file_size3_y` AS file_size3_y_163, a3_.`file_size500_x` AS file_size500_x_164, a3_.`file_size500_y` AS file_size500_y_165, a3_.`file_size740_x` AS file_size740_x_166, a3_.`file_size740_y` AS file_size740_y_167, a3_.`file_size8_x` AS file_size8_x_168, a3_.`file_size8_y` AS file_size8_y_169, a3_.`pallet` AS pallet_170, a3_.`pallet_ft` AS pallet_ft_171, a3_.`type_constraint` AS type_constraint_172, a3_.`multiple_pallet` AS multiple_pallet_173, a3_.`min_order` AS min_order_174, a3_.`price_euro` AS price_euro_175, a3_.`price_mq_euro` AS price_mq_euro_176, a3_.`price_euro_de` AS price_euro_de_177, a3_.`price_mq_euro_de` AS price_mq_euro_de_178, a3_.`price_euro_at` AS price_euro_at_179, a3_.`price_mq_euro_at` AS price_mq_euro_at_180, a3_.`price_euro_fi` AS price_euro_fi_181, a3_.`price_mq_euro_fi` AS price_mq_euro_fi_182, a3_.`price_euro_fr` AS price_euro_fr_183, a3_.`price_mq_euro_fr` AS price_mq_euro_fr_184, a3_.`price_euro_it` AS price_euro_it_185, a3_.`price_mq_euro_it` AS price_mq_euro_it_186, a3_.`price_euro_be` AS price_euro_be_187, a3_.`price_mq_euro_be` AS price_mq_euro_be_188, a3_.`price_euro_ie` AS price_euro_ie_189, a3_.`price_mq_euro_ie` AS price_mq_euro_ie_190, a3_.`price_euro_nl` AS price_euro_nl_191, a3_.`price_mq_euro_nl` AS price_mq_euro_nl_192, a3_.`price_euro_es` AS price_euro_es_193, a3_.`price_mq_euro_es` AS price_mq_euro_es_194, a3_.`price_rub` AS price_rub_195, a3_.`price_rue` AS price_rue_196, a3_.`price_mq_rub` AS price_mq_rub_197, a3_.`price_mq_rue` AS price_mq_rue_198, a3_.`price_gbp` AS price_gbp_199, a3_.`price_gbe` AS price_gbe_200, a3_.`price_mq_gbp` AS price_mq_gbp_201, a3_.`price_mq_gbe` AS price_mq_gbe_202, a3_.`price_usd` AS price_usd_203, a3_.`price_use` AS price_use_204, a3_.`price_fq_usd` AS price_fq_usd_205, a3_.`price_fq_use` AS price_fq_use_206, a3_.`price_mq_usd` AS price_mq_usd_207, a3_.`price_mq_use` AS price_mq_use_208, a3_.`price_chf` AS price_chf_209, a3_.`price_che` AS price_che_210, a3_.`price_mq_chf` AS price_mq_chf_211, a3_.`price_mq_che` AS price_mq_che_212, a3_.`price_sek` AS price_sek_213, a3_.`price_see` AS price_see_214, a3_.`price_mq_sek` AS price_mq_sek_215, a3_.`price_mq_see` AS price_mq_see_216, a3_.`price_dkk` AS price_dkk_217, a3_.`price_dke` AS price_dke_218, a3_.`price_mq_dkk` AS price_mq_dkk_219, a3_.`price_mq_dke` AS price_mq_dke_220, a3_.`price_nok` AS price_nok_221, a3_.`price_noe` AS price_noe_222, a3_.`price_mq_nok` AS price_mq_nok_223, a3_.`price_mq_noe` AS price_mq_noe_224, a3_.`price_pln` AS price_pln_225, a3_.`price_ple` AS price_ple_226, a3_.`price_mq_pln` AS price_mq_pln_227, a3_.`price_mq_ple` AS price_mq_ple_228, a3_.`price_cad` AS price_cad_229, a3_.`price_cae` AS price_cae_230, a3_.`price_fq_cad` AS price_fq_cad_231, a3_.`price_fq_cae` AS price_fq_cae_232, a3_.`price_mq_cad` AS price_mq_cad_233, a3_.`price_mq_cae` AS price_mq_cae_234, a3_.`thick` AS thick_235, a3_.`weight` AS weight_236, a3_.`packaging_count` AS packaging_count_237, a3_.`packaging_count_ft` AS packaging_count_ft_238, a3_.`packaging_count_pc` AS packaging_count_pc_239, a3_.`m2one_ps` AS m2one_ps_240, a3_.`description_ru` AS description_ru_241, a3_.`description_en` AS description_en_242, a3_.`description_it` AS description_it_243, a3_.`description_es` AS description_es_244, a3_.`description_fr` AS description_fr_245, a3_.`description_de` AS description_de_246, a3_.`description_pt` AS description_pt_247, a3_.`description_pl` AS description_pl_248, a3_.`description_nl` AS description_nl_249, a3_.`description_fi` AS description_fi_250, a3_.`description_ua` AS description_ua_251, a3_.`description_sv` AS description_sv_252, a3_.`description_no` AS description_no_253, a3_.`description_da` AS description_da_254, a3_.`description_cn` AS description_cn_255, a3_.`scheme` AS scheme_256, a3_.`sale_date` AS sale_date_257, a3_.`thin_granite` AS thin_granite_258, a3_.`glazed_granite` AS glazed_granite_259, a3_.`pei` AS pei_260, a3_.`is_grouped` AS is_grouped_261, a3_.`is_rotate` AS is_rotate_262, a3_.`price_prx` AS price_prx_263, a3_.`background_white` AS background_white_264, a3_.`border_grey` AS border_grey_265, a3_.`is_edit` AS is_edit_266, a3_.`edited_at` AS edited_at_267, a3_.`comment` AS comment_268, a3_.`file_edit` AS file_edit_269, a3_.`image_setting` AS image_setting_270, a3_.`file_w` AS file_w_271, a3_.`file_h` AS file_h_272, a3_.`file_w4000` AS file_w4000_273, a3_.`file_h4000` AS file_h4000_274, a3_.`size_z` AS size_z_275, a3_.`size_gb_z` AS size_gb_z_276, a3_.`repeat_number` AS repeat_number_277, a3_.`size_big` AS size_big_278, a3_.`delivery_suspended` AS delivery_suspended_279, a3_.`poddon_x` AS poddon_x_280, a3_.`poddon_y` AS poddon_y_281, a3_.`poddon_z` AS poddon_z_282, a3_.`module` AS module_283, a3_.`tessera_size_x` AS tessera_size_x_284, a3_.`tessera_size_y` AS tessera_size_y_285, a3_.`tessera_size_z` AS tessera_size_z_286, a3_.`poddon_count` AS poddon_count_287, a3_.`poddon_weight` AS poddon_weight_288, a3_.`added_to_cart` AS added_to_cart_289, a3_.`sold_out` AS sold_out_290, a3_.`sold_out_vol` AS sold_out_vol_291, a3_.`swimming_pool` AS swimming_pool_292, a3_.`can_select_substrate` AS can_select_substrate_293, a3_.`designer` AS designer_294, a3_.`designer_id` AS designer_id_295, a3_.`mosaic_effect` AS mosaic_effect_296, a3_.`not_sample` AS not_sample_297, a3_.`express_sample` AS express_sample_298, a3_.`description_edit` AS description_edit_299, a3_.`comment_scheme_image` AS comment_scheme_image_300, a3_.`variant_image` AS variant_image_301, a3_.`square` AS square_302, a3_.`fix_big_size` AS fix_big_size_303, a3_.`overflow_sink` AS overflow_sink_304, a3_.`drain_size_sink` AS drain_size_sink_305, a3_.`faucet_hole_sink` AS faucet_hole_sink_306, a3_.`rotate` AS rotate_307, a3_.`dyed_in_mass` AS dyed_in_mass_308, a3_.`durability_class` AS durability_class_309, a3_.`is_comment_ru` AS is_comment_ru_310, a3_.`file_rotation` AS file_rotation_311, a3_.`created_at` AS created_at_312, a3_.`updated_at` AS updated_at_313, l4_.`id` AS id_314, l4_.`code` AS code_315, l4_.`locale` AS locale_316, l4_.`phone_code` AS phone_code_317, l4_.`phone_mask` AS phone_mask_318, l4_.`min_valid_phone_numbers` AS min_valid_phone_numbers_319, l4_.`zip_code_mask` AS zip_code_mask_320, l4_.`percent_vat` AS percent_vat_321, l4_.`name` AS name_322, l4_.`name_en` AS name_en_323, l4_.`alias` AS alias_324, l4_.`sort` AS sort_325, l4_.`count` AS count_326, l4_.`hide` AS hide_327, l4_.`important` AS important_328, l4_.`pay_pal_percent` AS pay_pal_percent_329, l4_.`pay_pal_percent_own` AS pay_pal_percent_own_330, l4_.`vat` AS vat_331, l4_.`pv_type` AS pv_type_332, l4_.`capital_timezone_diff` AS capital_timezone_diff_333, l4_.`capital` AS capital_334, l4_.`free_sample_delivery` AS free_sample_delivery_335, l4_.`units` AS units_336, o5_.`id` AS id_337, o5_.`hash` AS hash_338, o5_.`transaction_id` AS transaction_id_339, o5_.`pay_sys` AS pay_sys_340, o5_.`pay_sys_name` AS pay_sys_name_341, o5_.`percent_ps` AS percent_ps_342, o5_.`date` AS date_343, o5_.`data` AS data_344, o5_.`amount` AS amount_345, o5_.`status` AS status_346, o5_.`save_to_1c` AS save_to_1c_347, o5_.`cur_rate` AS cur_rate_348, o5_.`currency` AS currency_349, b0_.user_id AS user_id_350, b0_.warehouse AS warehouse_351, b0_.address_recipient AS address_recipient_352, b0_.address_payer AS address_payer_353, b0_.delivery_country AS delivery_country_354, b0_.mailing_id AS mailing_id_355, b0_.buy_order_manager AS buy_order_manager_356, b2_.buy_order_id AS buy_order_id_357, b2_.article_id AS article_id_358, a3_.collection AS collection_359, a3_.newCollection AS newCollection_360, a3_.type AS type_361, a3_.measure AS measure_362, a3_.surface AS surface_363, a3_.pr_status AS pr_status_364, a3_.category_price AS category_price_365, a3_.edge_type AS edge_type_366, a3_.using AS using_367, a3_.shape AS shape_368, a3_.material AS material_369, a3_.delivery AS delivery_370, a3_.sliding AS sliding_371, a3_.off_shade AS off_shade_372, a3_.style AS style_373, a3_.repeat_draw AS repeat_draw_374, a3_.measurement_size AS measurement_size_375, a3_.installation_type AS installation_type_376, a3_.meth_laying AS meth_laying_377, a3_.draw AS draw_378, o5_.order_id AS order_id_379 FROM `buy_order` b0_ LEFT JOIN `user` u1_ ON b0_.user_id = u1_.id LEFT JOIN `buy_order_article` b2_ ON b0_.id = b2_.buy_order_id LEFT JOIN `article` a3_ ON b2_.article_id = a3_.id LEFT JOIN `list_country` l4_ ON b0_.delivery_country = l4_.id LEFT JOIN `order_payment` o5_ ON b0_.id = o5_.order_id WHERE b0_.`hash` = 'edeed68172d1d88edabcdb17e7b4deb4' AND b0_.`status` <> 12 ORDER BY a3_.collection ASC, b2_.`id` DESC, o5_.`date` ASC;

SELECT
  t0.`id` AS id_1,
  t0.`price` AS price_2,
  t0.`price_euro` AS price_euro_3,
  t0.`status` AS status_4,
  t0.`type` AS type_5,
  t0.`calculate_type` AS calculate_type_6,
  t0.`time_type` AS time_type_7,
  t0.`time_min` AS time_min_8,
  t0.`time_max` AS time_max_9,
  t0.`time_fast_pay_min` AS time_fast_pay_min_10,
  t0.`time_fast_pay_max` AS time_fast_pay_max_11,
  t0.`time_confirm_min` AS time_confirm_min_12,
  t0.`time_confirm_max` AS time_confirm_max_13,
  t0.`old_time_min` AS old_time_min_14,
  t0.`old_time_max` AS old_time_max_15,
  t0.`lift` AS lift_16,
  t0.`customs_payment` AS customs_payment_17,
  t0.`fee` AS fee_18,
  t0.`show_msg` AS show_msg_19,
  t0.`weight_report` AS weight_report_20,
  t0.`sending_date` AS sending_date_21,
  t0.`sending_date_max` AS sending_date_max_22,
  t0.`ship_date` AS ship_date_23,
  t0.`proposed_date` AS proposed_date_24,
  t0.`fact_date` AS fact_date_25,
  t0.`offset_date` AS offset_date_26,
  t0.`offset_reason` AS offset_reason_27,
  t0.order_id AS order_id_28
FROM
  `buy_order_delivery` t0
WHERE
  t0.order_id = ?

SELECT t0.`id` AS id_1, t0.`price` AS price_2, t0.`price_euro` AS price_euro_3, t0.`status` AS status_4, t0.`type` AS type_5, t0.`calculate_type` AS calculate_type_6, t0.`time_type` AS time_type_7, t0.`time_min` AS time_min_8, t0.`time_max` AS time_max_9, t0.`time_fast_pay_min` AS time_fast_pay_min_10, t0.`time_fast_pay_max` AS time_fast_pay_max_11, t0.`time_confirm_min` AS time_confirm_min_12, t0.`time_confirm_max` AS time_confirm_max_13, t0.`old_time_min` AS old_time_min_14, t0.`old_time_max` AS old_time_max_15, t0.`lift` AS lift_16, t0.`customs_payment` AS customs_payment_17, t0.`fee` AS fee_18, t0.`show_msg` AS show_msg_19, t0.`weight_report` AS weight_report_20, t0.`sending_date` AS sending_date_21, t0.`sending_date_max` AS sending_date_max_22, t0.`ship_date` AS ship_date_23, t0.`proposed_date` AS proposed_date_24, t0.`fact_date` AS fact_date_25, t0.`offset_date` AS offset_date_26, t0.`offset_reason` AS offset_reason_27, t0.order_id AS order_id_28 FROM `buy_order_delivery` t0 WHERE t0.order_id = 3783866;