1.67 ms (63.22%)
|
1 |
SELECT t0.order_id AS order_id_1, t0.order_key AS order_key_2, t0.number AS number_3, t0.payed AS payed_4, t0.delivery_variant_id AS delivery_variant_id_5, t0.delivery_information AS delivery_information_6, t0.products AS products_7, t0.shipping_address AS shipping_address_8, t0.field_values AS field_values_9, t0.client AS client_10, t0.price AS price_11, t0.comment AS comment_12, t0.manager_comment AS manager_comment_13, t0.manage_token AS manage_token_14, t0.manage_token_expire AS manage_token_expire_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.shop_id AS shop_id_19, t20.catapulto_id AS catapulto_id_21, t20.number AS number_22, t20.tracking_number AS tracking_number_23, t20.tracking_link AS tracking_link_24, t20.main_status AS main_status_25, t20.main_status_display AS main_status_display_26, t20.pickup_day AS pickup_day_27, t20.delivery_day AS delivery_day_28, t20.price AS price_29, t20.weight AS weight_30, t20.operator AS operator_31, t20.sender_contact_id AS sender_contact_id_32, t20.sender_company AS sender_company_33, t20.receiver_contact_id AS receiver_contact_id_34, t20.receiver_locality AS receiver_locality_35, t20.receiver_name AS receiver_name_36, t20.receiver_company AS receiver_company_37, t20.receiver_phone AS receiver_phone_38, t20.receiver_address AS receiver_address_39, t20.description AS description_40, t20.with_insurance AS with_insurance_41, t20.insurance_cost AS insurance_cost_42, t20.documents AS documents_43, t20.last_tracking_text AS last_tracking_text_44, t20.problem_text AS problem_text_45, t20.is_pod AS is_pod_46, t20.sum_to_pay AS sum_to_pay_47, t20.payment AS payment_48, t20.tracking_status AS tracking_status_49, t20.catapulto_key AS catapulto_key_50, t20.rate_result_id AS rate_result_id_51, t20.terminal_code AS terminal_code_52, t20.pod AS pod_53, t20.message AS message_54, t20.comment AS comment_55, t20.ok AS ok_56, t20.uptime AS uptime_57, t20.is_send AS is_send_58, t20.id AS id_59, t20.create_at AS create_at_60, t20.update_at AS update_at_61, t20.shop_id AS shop_id_62, t20.order_id AS order_id_63 FROM orders t0 LEFT JOIN catapulto_orders t20 ON t20.order_id = t0.id WHERE t0.shop_id = ? AND t0.order_id = ? LIMIT 1
Parameters: [
2
"108274212"
]
SELECT
t0.order_id AS order_id_1,
t0.order_key AS order_key_2,
t0.number AS number_3,
t0.payed AS payed_4,
t0.delivery_variant_id AS delivery_variant_id_5,
t0.delivery_information AS delivery_information_6,
t0.products AS products_7,
t0.shipping_address AS shipping_address_8,
t0.field_values AS field_values_9,
t0.client AS client_10,
t0.price AS price_11,
t0.comment AS comment_12,
t0.manager_comment AS manager_comment_13,
t0.manage_token AS manage_token_14,
t0.manage_token_expire AS manage_token_expire_15,
t0.id AS id_16,
t0.create_at AS create_at_17,
t0.update_at AS update_at_18,
t0.shop_id AS shop_id_19,
t20.catapulto_id AS catapulto_id_21,
t20.number AS number_22,
t20.tracking_number AS tracking_number_23,
t20.tracking_link AS tracking_link_24,
t20.main_status AS main_status_25,
t20.main_status_display AS main_status_display_26,
t20.pickup_day AS pickup_day_27,
t20.delivery_day AS delivery_day_28,
t20.price AS price_29,
t20.weight AS weight_30,
t20.operator AS operator_31,
t20.sender_contact_id AS sender_contact_id_32,
t20.sender_company AS sender_company_33,
t20.receiver_contact_id AS receiver_contact_id_34,
t20.receiver_locality AS receiver_locality_35,
t20.receiver_name AS receiver_name_36,
t20.receiver_company AS receiver_company_37,
t20.receiver_phone AS receiver_phone_38,
t20.receiver_address AS receiver_address_39,
t20.description AS description_40,
t20.with_insurance AS with_insurance_41,
t20.insurance_cost AS insurance_cost_42,
t20.documents AS documents_43,
t20.last_tracking_text AS last_tracking_text_44,
t20.problem_text AS problem_text_45,
t20.is_pod AS is_pod_46,
t20.sum_to_pay AS sum_to_pay_47,
t20.payment AS payment_48,
t20.tracking_status AS tracking_status_49,
t20.catapulto_key AS catapulto_key_50,
t20.rate_result_id AS rate_result_id_51,
t20.terminal_code AS terminal_code_52,
t20.pod AS pod_53,
t20.message AS message_54,
t20.comment AS comment_55,
t20.ok AS ok_56,
t20.uptime AS uptime_57,
t20.is_send AS is_send_58,
t20.id AS id_59,
t20.create_at AS create_at_60,
t20.update_at AS update_at_61,
t20.shop_id AS shop_id_62,
t20.order_id AS order_id_63
FROM
orders t0
LEFT JOIN catapulto_orders t20 ON t20.order_id = t0.id
WHERE
t0.shop_id = ?
AND t0.order_id = ?
LIMIT
1
SELECT t0.order_id AS order_id_1, t0.order_key AS order_key_2, t0.number AS number_3, t0.payed AS payed_4, t0.delivery_variant_id AS delivery_variant_id_5, t0.delivery_information AS delivery_information_6, t0.products AS products_7, t0.shipping_address AS shipping_address_8, t0.field_values AS field_values_9, t0.client AS client_10, t0.price AS price_11, t0.comment AS comment_12, t0.manager_comment AS manager_comment_13, t0.manage_token AS manage_token_14, t0.manage_token_expire AS manage_token_expire_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.shop_id AS shop_id_19, t20.catapulto_id AS catapulto_id_21, t20.number AS number_22, t20.tracking_number AS tracking_number_23, t20.tracking_link AS tracking_link_24, t20.main_status AS main_status_25, t20.main_status_display AS main_status_display_26, t20.pickup_day AS pickup_day_27, t20.delivery_day AS delivery_day_28, t20.price AS price_29, t20.weight AS weight_30, t20.operator AS operator_31, t20.sender_contact_id AS sender_contact_id_32, t20.sender_company AS sender_company_33, t20.receiver_contact_id AS receiver_contact_id_34, t20.receiver_locality AS receiver_locality_35, t20.receiver_name AS receiver_name_36, t20.receiver_company AS receiver_company_37, t20.receiver_phone AS receiver_phone_38, t20.receiver_address AS receiver_address_39, t20.description AS description_40, t20.with_insurance AS with_insurance_41, t20.insurance_cost AS insurance_cost_42, t20.documents AS documents_43, t20.last_tracking_text AS last_tracking_text_44, t20.problem_text AS problem_text_45, t20.is_pod AS is_pod_46, t20.sum_to_pay AS sum_to_pay_47, t20.payment AS payment_48, t20.tracking_status AS tracking_status_49, t20.catapulto_key AS catapulto_key_50, t20.rate_result_id AS rate_result_id_51, t20.terminal_code AS terminal_code_52, t20.pod AS pod_53, t20.message AS message_54, t20.comment AS comment_55, t20.ok AS ok_56, t20.uptime AS uptime_57, t20.is_send AS is_send_58, t20.id AS id_59, t20.create_at AS create_at_60, t20.update_at AS update_at_61, t20.shop_id AS shop_id_62, t20.order_id AS order_id_63 FROM orders t0 LEFT JOIN catapulto_orders t20 ON t20.order_id = t0.id WHERE t0.shop_id = 2 AND t0.order_id = '108274212' LIMIT 1;
|
0.97 ms (36.78%)
|
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.id AS id_64, t28.create_at AS create_at_65, t28.update_at AS update_at_66, t28.shop_id AS shop_id_67 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.id AS id_64,
t28.create_at AS create_at_65,
t28.update_at AS update_at_66,
t28.shop_id AS shop_id_67
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.id AS id_64, t28.create_at AS create_at_65, t28.update_at AS update_at_66, t28.shop_id AS shop_id_67 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;
|