Query Metrics
6
Database Queries
5
Different statements
177.22 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
175.71 ms (99.15%) |
2 |
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 "100325632" ] |
0.68 ms (0.38%) |
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.id AS id_23, t16.create_at AS create_at_24, t16.update_at AS update_at_25, t16.shop_id AS shop_id_26, t27.length AS length_28, t27.depth AS depth_29, t27.width AS width_30, t27.weight AS weight_31, t27.def_mode AS def_mode_32, t27.free_delivery_from AS free_delivery_from_33, t27.append_delivery_price_percent AS append_delivery_price_percent_34, t27.append_delivery_price_fixed AS append_delivery_price_fixed_35, t27.round_price AS round_price_36, t27.append_delivery_day AS append_delivery_day_37, t27.dadata_apikey AS dadata_apikey_38, t27.sender_locality_id AS sender_locality_id_39, t27.sender_zip AS sender_zip_40, t27.sender_city AS sender_city_41, t27.sender_id AS sender_id_42, t27.delivery_default_price AS delivery_default_price_43, t27.default_markup_val AS default_markup_val_44, t27.default_markup_type AS default_markup_type_45, t27.mind_ensurance AS mind_ensurance_46, t27.no_pvzno_order AS no_pvzno_order_47, t27.need_reselect AS need_reselect_48, t27.map_open_mode AS map_open_mode_49, t27.widget_delivery_types AS widget_delivery_types_50, t27.widget_delivery_from AS widget_delivery_from_51, t27.address_field AS address_field_52, t27.cash AS cash_53, t27.card AS card_54, t27.notify_enabled AS notify_enabled_55, t27.enable_dadata_in_insales AS enable_dadata_in_insales_56, t27.sender_poa AS sender_poa_57, t27.from_name AS from_name_58, t27.from_passport_series AS from_passport_series_59, t27.from_passport_number AS from_passport_number_60, t27.from_passport_date AS from_passport_date_61, t27.send_receiver_poa_email AS send_receiver_poa_email_62, t27.id AS id_63, t27.create_at AS create_at_64, t27.update_at AS update_at_65, t27.shop_id AS shop_id_66 FROM shop t0 LEFT JOIN configuration_connection t16 ON t16.shop_id = t0.id LEFT JOIN configuration_calculation t27 ON t27.shop_id = t0.id WHERE t0.insales_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
1183092
]
|
0.58 ms (0.33%) |
1 |
UPDATE orders SET manage_token = ?, manage_token_expire = ?, update_at = ? WHERE id = ?
Parameters:
[ "c18b25c790af5a60181df508b1ef1478" "2024-07-19 02:41:51" "2024-07-19 02:26:51" 146 ] |
0.15 ms (0.09%) |
1 |
"COMMIT"
Parameters:
[] |
0.09 ms (0.05%) |
1 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Shop | No errors. |
App\Entity\Configuration\Connection | No errors. |
App\Entity\Configuration\Calculation | No errors. |
App\Entity\Configuration\Status | No errors. |
App\Entity\Package | No errors. |
App\Entity\Order | No errors. |
App\Entity\Relation\CalculationDeliveryOperators | No errors. |