https://catainsales2.ht2.ipol.tech/app/order/widget/1183092/578753cf06aa9e4913fd9e9f2c471472/108274212

Query Metrics

2 Database Queries
2 Different statements
2.64 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
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"
]
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
Parameters:
[
  1183092
]

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.