Symfony Profiler

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 = '94787220' LIMIT 1;

INSERT INTO orders (
  order_id, order_key, number, payed,
  delivery_variant_id, delivery_information,
  products, shipping_address, field_values,
  client, price, comment, manager_comment,
  manage_token, manage_token_expire,
  create_at, update_at, shop_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO orders (order_id, order_key, number, payed, delivery_variant_id, delivery_information, products, shipping_address, field_values, client, price, comment, manager_comment, manage_token, manage_token_expire, create_at, update_at, shop_id) VALUES ('94787220', 'e9f3e7f74d9b24a21aeaade1deb13fe4', '1430', 0, '8021085', 'a:12:{s:19:\"delivery_variant_id\";i:8021085;s:9:\"tariff_id\";N;s:5:\"title\";N;s:11:\"description\";N;s:5:\"price\";i:0;s:16:\"shipping_company\";N;s:23:\"shipping_company_handle\";N;s:17:\"delivery_interval\";a:3:{s:8:\"min_days\";N;s:8:\"max_days\";N;s:11:\"description\";s:0:\"\";}s:6:\"errors\";a:0:{}s:8:\"warnings\";a:0:{}s:6:\"outlet\";a:9:{s:2:\"id\";N;s:11:\"external_id\";N;s:8:\"latitude\";N;s:9:\"longitude\";N;s:5:\"title\";N;s:11:\"description\";N;s:7:\"address\";N;s:14:\"payment_method\";a:0:{}s:9:\"source_id\";N;}s:13:\"not_available\";N;}', 'a:1:{i:0;a:27:{s:2:\"id\";i:655589485;s:8:\"order_id\";i:94787220;s:10:\"sale_price\";d:200;s:15:\"full_sale_price\";d:200;s:11:\"total_price\";d:200;s:16:\"full_total_price\";d:200;s:16:\"discounts_amount\";d:0;s:8:\"quantity\";i:1;s:17:\"reserved_quantity\";i:1;s:6:\"weight\";s:4:\"50.0\";s:10:\"dimensions\";s:8:\"50x50x50\";s:10:\"variant_id\";i:700469941;s:10:\"product_id\";i:421859649;s:3:\"sku\";N;s:7:\"barcode\";N;s:5:\"title\";s:18:\"Товар 50 кг\";s:4:\"unit\";s:3:\"pce\";s:7:\"comment\";N;s:10:\"updated_at\";s:29:\"2024-02-28T09:10:00.000+03:00\";s:10:\"created_at\";s:29:\"2024-02-28T09:10:00.000+03:00\";s:9:\"bundle_id\";N;s:3:\"vat\";i:-1;s:19:\"fiscal_product_type\";i:1;s:16:\"requires_marking\";N;s:13:\"marking_codes\";N;s:15:\"accessory_lines\";a:0:{}s:19:\"external_variant_id\";N;}}', 'a:21:{s:2:\"id\";i:103135087;s:13:\"fields_values\";a:0:{}s:4:\"name\";s:8:\"Тест\";s:7:\"surname\";N;s:10:\"middlename\";N;s:5:\"phone\";s:12:\"+79000000000\";s:9:\"full_name\";s:8:\"Тест\";s:18:\"full_locality_name\";s:68:\"г Великий Новгород, Новгородская обл.\";s:21:\"full_delivery_address\";s:112:\"173020, г Великий Новгород, Новгородская обл., пр-кт Мира д. 24, кв. 6\";s:15:\"address_for_gis\";s:112:\"173020, г Великий Новгород, Новгородская обл., пр-кт Мира д. 24, кв. 6\";s:14:\"location_valid\";b:1;s:7:\"address\";s:34:\"пр-кт Мира д. 24, кв. 6\";s:7:\"country\";N;s:5:\"state\";s:31:\"обл Новгородская\";s:4:\"city\";s:31:\"Великий Новгород\";s:3:\"zip\";s:6:\"173020\";s:6:\"street\";s:18:\"пр-кт Мира\";s:5:\"house\";s:2:\"24\";s:4:\"flat\";s:1:\"6\";s:10:\"kladr_json\";a:18:{s:10:\"kladr_code\";s:13:\"5300000100000\";s:3:\"zip\";s:6:\"173020\";s:9:\"kladr_zip\";N;s:10:\"region_zip\";s:6:\"173000\";s:7:\"country\";s:2:\"RU\";s:5:\"state\";s:24:\"Новгородская\";s:10:\"state_type\";s:6:\"обл\";s:4:\"area\";N;s:9:\"area_type\";N;s:4:\"city\";s:31:\"Великий Новгород\";s:9:\"city_type\";s:2:\"г\";s:10:\"settlement\";N;s:15:\"settlement_type\";N;s:6:\"result\";s:68:\"г Великий Новгород, Новгородская обл.\";s:8:\"latitude\";s:17:\"58.56095631962427\";s:9:\"longitude\";s:18:\"31.310136999999994\";s:12:\"autodetected\";N;s:8:\"is_kladr\";b:1;}s:8:\"location\";a:22:{s:10:\"kladr_code\";s:13:\"5300000100000\";s:3:\"zip\";s:6:\"173020\";s:9:\"kladr_zip\";s:6:\"173020\";s:10:\"region_zip\";s:6:\"173000\";s:7:\"country\";s:2:\"RU\";s:5:\"state\";s:24:\"Новгородская\";s:10:\"state_type\";s:6:\"обл\";s:4:\"area\";N;s:9:\"area_type\";N;s:4:\"city\";s:31:\"Великий Новгород\";s:9:\"city_type\";s:2:\"г\";s:10:\"settlement\";N;s:15:\"settlement_type\";N;s:7:\"address\";s:34:\"пр-кт Мира д. 24, кв. 6\";s:6:\"street\";s:8:\"Мира\";s:11:\"street_type\";s:9:\"пр-кт\";s:5:\"house\";s:2:\"24\";s:4:\"flat\";s:1:\"6\";s:8:\"is_kladr\";b:1;s:8:\"latitude\";s:17:\"58.56095631962427\";s:9:\"longitude\";s:18:\"31.310136999999994\";s:12:\"autodetected\";N;}}', 'a:2:{i:0;a:8:{s:2:\"id\";i:216054688;s:8:\"field_id\";i:20362968;s:5:\"value\";s:1771:\"{"rate_result_id":356740112,"rate_result":{"id":356740112,"delivery_day":"2024-03-23","delivery_time":["В течение дня"],"operator":"dellin","pickup_day":"2024-03-19","rate":"Автотранспортная перевозка","shipping_type":"d2d","price":3654,"price_orig":3654,"pvz":false,"was_insurance":false,"is_cod":false,"services":[{"name":"loading_amount","description":"Погрузочные работы","cost":2170},{"name":"unloading_amount","description":"Разгрузочные работы","cost":2170},{"name":"crating_amount","description":"Обрешетка","cost":1000},{"name":"crating_amount","description":"Обрешетка","cost":1050},{"name":"crating_amount","description":"Обрешетка","cost":450},{"name":"crating_amount","description":"Обрешетка","cost":500},{"name":"crating_amount","description":"Обрешетка","cost":1750},{"name":"crating_amount","description":"Обрешетка","cost":1250},{"name":"insurance","description":"Страховка","cost":0}]},"rate_cost":3654,"rate_term":"10.03.2024"}\";s:10:\"created_at\";s:29:\"2024-02-28T09:10:00.199+03:00\";s:10:\"updated_at\";s:29:\"2024-02-28T09:10:00.199+03:00\";s:4:\"type\";s:10:\"Текст\";s:4:\"name\";s:84:\"Служебная информация о способе доставки Catapulto\";s:6:\"handle\";s:21:\"catapulto_rate_result\";}i:1;a:8:{s:2:\"id\";i:216054712;s:8:\"field_id\";i:20362967;s:5:\"value\";s:12:\"CTP587522851\";s:10:\"created_at\";s:29:\"2024-02-28T09:10:35.318+03:00\";s:10:\"updated_at\";s:29:\"2024-02-28T09:10:35.318+03:00\";s:4:\"type\";s:10:\"Текст\";s:4:\"name\";s:29:\"Трек номер Catapulto\";s:6:\"handle\";s:22:\"catapulto_track_number\";}}', 'a:24:{s:2:\"id\";i:79093569;s:5:\"email\";N;s:4:\"name\";s:8:\"Тест\";s:5:\"phone\";s:12:\"+79000000000\";s:10:\"created_at\";s:29:\"2024-02-28T09:10:00.000+03:00\";s:10:\"updated_at\";s:29:\"2024-02-28T09:10:00.000+03:00\";s:7:\"comment\";N;s:10:\"registered\";N;s:9:\"subscribe\";b:1;s:15:\"client_group_id\";N;s:7:\"surname\";N;s:10:\"middlename\";N;s:12:\"bonus_points\";i:0;s:4:\"type\";s:18:\"Client::Individual\";s:21:\"correspondent_account\";N;s:18:\"settlement_account\";N;s:24:\"consent_to_personal_data\";b:1;s:15:\"o_auth_provider\";N;s:22:\"messenger_subscription\";b:1;s:12:\"contact_name\";s:8:\"Тест\";s:20:\"progressive_discount\";N;s:14:\"group_discount\";N;s:7:\"ip_addr\";s:12:\"79.99.48.170\";s:13:\"fields_values\";a:0:{}}', '200', NULL, NULL, NULL, NULL, '2024-07-01 03:04:48', '2024-07-01 03:04:48', 2);

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

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 = 1183092 ORDER BY t0.id DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

"ROLLBACK"

"ROLLBACK";