3.33 ms
(100.00%)
|
1 |
SELECT t0.insales_id AS insales_id_1, t0.shop AS shop_2, t0.password AS password_3, t0.password_token AS password_token_4, t0.widget_password AS widget_password_5, t0.delivery_id AS delivery_id_6, t0.rate_result_property_id AS rate_result_property_id_7, t0.update_statuses AS update_statuses_8, t0.use_custom_statuses AS use_custom_statuses_9, t0.first_sync AS first_sync_10, t0.mark_payed AS mark_payed_11, t0.blocking_status AS blocking_status_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t16.apikey AS apikey_17, t16.test_mode AS test_mode_18, t16.connection AS connection_19, t16.connection_error AS connection_error_20, t16.connection_timeout AS connection_timeout_21, t16.custom_base_api_url AS custom_base_api_url_22, t16.custom_base_ws_url AS custom_base_ws_url_23, t16.id AS id_24, t16.create_at AS create_at_25, t16.update_at AS update_at_26, t16.shop_id AS shop_id_27, t28.length AS length_29, t28.depth AS depth_30, t28.width AS width_31, t28.weight AS weight_32, t28.def_mode AS def_mode_33, t28.free_delivery_from AS free_delivery_from_34, t28.append_delivery_price_percent AS append_delivery_price_percent_35, t28.append_delivery_price_fixed AS append_delivery_price_fixed_36, t28.round_price AS round_price_37, t28.append_delivery_day AS append_delivery_day_38, t28.dadata_apikey AS dadata_apikey_39, t28.sender_locality_id AS sender_locality_id_40, t28.sender_zip AS sender_zip_41, t28.sender_city AS sender_city_42, t28.sender_id AS sender_id_43, t28.delivery_default_price AS delivery_default_price_44, t28.default_markup_val AS default_markup_val_45, t28.default_markup_type AS default_markup_type_46, t28.mind_ensurance AS mind_ensurance_47, t28.no_pvzno_order AS no_pvzno_order_48, t28.need_reselect AS need_reselect_49, t28.map_open_mode AS map_open_mode_50, t28.widget_delivery_types AS widget_delivery_types_51, t28.widget_delivery_from AS widget_delivery_from_52, t28.address_field AS address_field_53, t28.cash AS cash_54, t28.card AS card_55, t28.notify_enabled AS notify_enabled_56, t28.enable_dadata_in_insales AS enable_dadata_in_insales_57, t28.sender_poa AS sender_poa_58, t28.from_name AS from_name_59, t28.from_passport_series AS from_passport_series_60, t28.from_passport_number AS from_passport_number_61, t28.from_passport_date AS from_passport_date_62, t28.send_receiver_poa_email AS send_receiver_poa_email_63, t28.custom_logo AS custom_logo_64, t28.run_widget AS run_widget_65, t28.id AS id_66, t28.create_at AS create_at_67, t28.update_at AS update_at_68, t28.shop_id AS shop_id_69 FROM shop t0 LEFT JOIN configuration_connection t16 ON t16.shop_id = t0.id LEFT JOIN configuration_calculation t28 ON t28.shop_id = t0.id WHERE t0.insales_id = ? ORDER BY t0.id DESC LIMIT 1
SELECT
t0.insales_id AS insales_id_1,
t0.shop AS shop_2,
t0.password AS password_3,
t0.password_token AS password_token_4,
t0.widget_password AS widget_password_5,
t0.delivery_id AS delivery_id_6,
t0.rate_result_property_id AS rate_result_property_id_7,
t0.update_statuses AS update_statuses_8,
t0.use_custom_statuses AS use_custom_statuses_9,
t0.first_sync AS first_sync_10,
t0.mark_payed AS mark_payed_11,
t0.blocking_status AS blocking_status_12,
t0.id AS id_13,
t0.create_at AS create_at_14,
t0.update_at AS update_at_15,
t16.apikey AS apikey_17,
t16.test_mode AS test_mode_18,
t16.connection AS connection_19,
t16.connection_error AS connection_error_20,
t16.connection_timeout AS connection_timeout_21,
t16.custom_base_api_url AS custom_base_api_url_22,
t16.custom_base_ws_url AS custom_base_ws_url_23,
t16.id AS id_24,
t16.create_at AS create_at_25,
t16.update_at AS update_at_26,
t16.shop_id AS shop_id_27,
t28.length AS length_29,
t28.depth AS depth_30,
t28.width AS width_31,
t28.weight AS weight_32,
t28.def_mode AS def_mode_33,
t28.free_delivery_from AS free_delivery_from_34,
t28.append_delivery_price_percent AS append_delivery_price_percent_35,
t28.append_delivery_price_fixed AS append_delivery_price_fixed_36,
t28.round_price AS round_price_37,
t28.append_delivery_day AS append_delivery_day_38,
t28.dadata_apikey AS dadata_apikey_39,
t28.sender_locality_id AS sender_locality_id_40,
t28.sender_zip AS sender_zip_41,
t28.sender_city AS sender_city_42,
t28.sender_id AS sender_id_43,
t28.delivery_default_price AS delivery_default_price_44,
t28.default_markup_val AS default_markup_val_45,
t28.default_markup_type AS default_markup_type_46,
t28.mind_ensurance AS mind_ensurance_47,
t28.no_pvzno_order AS no_pvzno_order_48,
t28.need_reselect AS need_reselect_49,
t28.map_open_mode AS map_open_mode_50,
t28.widget_delivery_types AS widget_delivery_types_51,
t28.widget_delivery_from AS widget_delivery_from_52,
t28.address_field AS address_field_53,
t28.cash AS cash_54,
t28.card AS card_55,
t28.notify_enabled AS notify_enabled_56,
t28.enable_dadata_in_insales AS enable_dadata_in_insales_57,
t28.sender_poa AS sender_poa_58,
t28.from_name AS from_name_59,
t28.from_passport_series AS from_passport_series_60,
t28.from_passport_number AS from_passport_number_61,
t28.from_passport_date AS from_passport_date_62,
t28.send_receiver_poa_email AS send_receiver_poa_email_63,
t28.custom_logo AS custom_logo_64,
t28.run_widget AS run_widget_65,
t28.id AS id_66,
t28.create_at AS create_at_67,
t28.update_at AS update_at_68,
t28.shop_id AS shop_id_69
FROM
shop t0
LEFT JOIN configuration_connection t16 ON t16.shop_id = t0.id
LEFT JOIN configuration_calculation t28 ON t28.shop_id = t0.id
WHERE
t0.insales_id = ?
ORDER BY
t0.id DESC
LIMIT
1
SELECT t0.insales_id AS insales_id_1, t0.shop AS shop_2, t0.password AS password_3, t0.password_token AS password_token_4, t0.widget_password AS widget_password_5, t0.delivery_id AS delivery_id_6, t0.rate_result_property_id AS rate_result_property_id_7, t0.update_statuses AS update_statuses_8, t0.use_custom_statuses AS use_custom_statuses_9, t0.first_sync AS first_sync_10, t0.mark_payed AS mark_payed_11, t0.blocking_status AS blocking_status_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t16.apikey AS apikey_17, t16.test_mode AS test_mode_18, t16.connection AS connection_19, t16.connection_error AS connection_error_20, t16.connection_timeout AS connection_timeout_21, t16.custom_base_api_url AS custom_base_api_url_22, t16.custom_base_ws_url AS custom_base_ws_url_23, t16.id AS id_24, t16.create_at AS create_at_25, t16.update_at AS update_at_26, t16.shop_id AS shop_id_27, t28.length AS length_29, t28.depth AS depth_30, t28.width AS width_31, t28.weight AS weight_32, t28.def_mode AS def_mode_33, t28.free_delivery_from AS free_delivery_from_34, t28.append_delivery_price_percent AS append_delivery_price_percent_35, t28.append_delivery_price_fixed AS append_delivery_price_fixed_36, t28.round_price AS round_price_37, t28.append_delivery_day AS append_delivery_day_38, t28.dadata_apikey AS dadata_apikey_39, t28.sender_locality_id AS sender_locality_id_40, t28.sender_zip AS sender_zip_41, t28.sender_city AS sender_city_42, t28.sender_id AS sender_id_43, t28.delivery_default_price AS delivery_default_price_44, t28.default_markup_val AS default_markup_val_45, t28.default_markup_type AS default_markup_type_46, t28.mind_ensurance AS mind_ensurance_47, t28.no_pvzno_order AS no_pvzno_order_48, t28.need_reselect AS need_reselect_49, t28.map_open_mode AS map_open_mode_50, t28.widget_delivery_types AS widget_delivery_types_51, t28.widget_delivery_from AS widget_delivery_from_52, t28.address_field AS address_field_53, t28.cash AS cash_54, t28.card AS card_55, t28.notify_enabled AS notify_enabled_56, t28.enable_dadata_in_insales AS enable_dadata_in_insales_57, t28.sender_poa AS sender_poa_58, t28.from_name AS from_name_59, t28.from_passport_series AS from_passport_series_60, t28.from_passport_number AS from_passport_number_61, t28.from_passport_date AS from_passport_date_62, t28.send_receiver_poa_email AS send_receiver_poa_email_63, t28.custom_logo AS custom_logo_64, t28.run_widget AS run_widget_65, t28.id AS id_66, t28.create_at AS create_at_67, t28.update_at AS update_at_68, t28.shop_id AS shop_id_69 FROM shop t0 LEFT JOIN configuration_connection t16 ON t16.shop_id = t0.id LEFT JOIN configuration_calculation t28 ON t28.shop_id = t0.id WHERE t0.insales_id = 1183092 ORDER BY t0.id DESC LIMIT 1;
|