Symfony Profiler

SELECT
  t0.created_at AS created_at_1,
  t0.phone AS phone_2,
  t0.password AS password_3,
  t0.deprecated_user_id AS deprecated_user_id_4,
  t0.cookie AS cookie_5,
  t0.id AS id_6,
  t7.created_at AS created_at_8,
  t7.guest_id AS guest_id_9,
  t7.first_name AS first_name_10,
  t7.last_name AS last_name_11,
  t7.father_name AS father_name_12,
  t7.phone AS phone_13,
  t7.delivery_type AS delivery_type_14,
  t7.town AS town_15,
  t7.postcode AS postcode_16,
  t7.street AS street_17,
  t7.house AS house_18,
  t7.apartment AS apartment_19,
  t7.longitude AS longitude_20,
  t7.latitude AS latitude_21,
  t7.payment_type AS payment_type_22,
  t7.comment AS comment_23,
  t7.id AS id_24,
  t7.user_id AS user_id_25,
  t7.transport_company_id AS transport_company_id_26,
  t27.created_at AS created_at_28,
  t27.visible AS visible_29,
  t27.first_name AS first_name_30,
  t27.last_name AS last_name_31,
  t27.father_name AS father_name_32,
  t27.mango_extension_number AS mango_extension_number_33,
  t27.id AS id_34,
  t27.user_id AS user_id_35
FROM
  users__users t0
  LEFT JOIN carts__carts t7 ON t7.user_id = t0.id
  LEFT JOIN managers t27 ON t27.user_id = t0.id
WHERE
  t0.deprecated_user_id = ?
LIMIT
  1

SELECT t0.created_at AS created_at_1, t0.phone AS phone_2, t0.password AS password_3, t0.deprecated_user_id AS deprecated_user_id_4, t0.cookie AS cookie_5, t0.id AS id_6, t7.created_at AS created_at_8, t7.guest_id AS guest_id_9, t7.first_name AS first_name_10, t7.last_name AS last_name_11, t7.father_name AS father_name_12, t7.phone AS phone_13, t7.delivery_type AS delivery_type_14, t7.town AS town_15, t7.postcode AS postcode_16, t7.street AS street_17, t7.house AS house_18, t7.apartment AS apartment_19, t7.longitude AS longitude_20, t7.latitude AS latitude_21, t7.payment_type AS payment_type_22, t7.comment AS comment_23, t7.id AS id_24, t7.user_id AS user_id_25, t7.transport_company_id AS transport_company_id_26, t27.created_at AS created_at_28, t27.visible AS visible_29, t27.first_name AS first_name_30, t27.last_name AS last_name_31, t27.father_name AS father_name_32, t27.mango_extension_number AS mango_extension_number_33, t27.id AS id_34, t27.user_id AS user_id_35 FROM users__users t0 LEFT JOIN carts__carts t7 ON t7.user_id = t0.id LEFT JOIN managers t27 ON t27.user_id = t0.id WHERE t0.deprecated_user_id = 2 LIMIT 1;

SELECT
  t0.created_at AS created_at_1,
  t0.crm_order_id AS crm_order_id_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.father_name AS father_name_5,
  t0.phone AS phone_6,
  t0.delivery_type AS delivery_type_7,
  t0.town AS town_8,
  t0.postcode AS postcode_9,
  t0.street AS street_10,
  t0.house AS house_11,
  t0.apartment AS apartment_12,
  t0.longitude AS longitude_13,
  t0.latitude AS latitude_14,
  t0.payment_type AS payment_type_15,
  t0.comment AS comment_16,
  t0.hash AS hash_17,
  t0.confirmed_date AS confirmed_date_18,
  t0.collected_date AS collected_date_19,
  t0.issued_date AS issued_date_20,
  t0.canceled_date AS canceled_date_21,
  t0.id AS id_22,
  t0.user_id AS user_id_23,
  t0.transport_company_id AS transport_company_id_24
FROM
  orders__orders t0
WHERE
  t0.crm_order_id = ?
LIMIT
  1

SELECT t0.created_at AS created_at_1, t0.crm_order_id AS crm_order_id_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.father_name AS father_name_5, t0.phone AS phone_6, t0.delivery_type AS delivery_type_7, t0.town AS town_8, t0.postcode AS postcode_9, t0.street AS street_10, t0.house AS house_11, t0.apartment AS apartment_12, t0.longitude AS longitude_13, t0.latitude AS latitude_14, t0.payment_type AS payment_type_15, t0.comment AS comment_16, t0.hash AS hash_17, t0.confirmed_date AS confirmed_date_18, t0.collected_date AS collected_date_19, t0.issued_date AS issued_date_20, t0.canceled_date AS canceled_date_21, t0.id AS id_22, t0.user_id AS user_id_23, t0.transport_company_id AS transport_company_id_24 FROM orders__orders t0 WHERE t0.crm_order_id = 103870 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO orders__orders (
  created_at, crm_order_id, first_name,
  last_name, father_name, phone, delivery_type,
  town, postcode, street, house, apartment,
  longitude, latitude, payment_type,
  comment, hash, confirmed_date, collected_date,
  issued_date, canceled_date, user_id,
  transport_company_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO orders__orders (created_at, crm_order_id, first_name, last_name, father_name, phone, delivery_type, town, postcode, street, house, apartment, longitude, latitude, payment_type, comment, hash, confirmed_date, collected_date, issued_date, canceled_date, user_id, transport_company_id) VALUES ('2025-06-05 14:42:05', 103870, '1', '', '', '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, 'terminal', NULL, 'w9kws7on', NULL, NULL, NULL, NULL, 9, NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.name AS name_1,
  t0.legal_name AS legal_name_2,
  t0.car_manufacturer AS car_manufacturer_3,
  t0.slug AS slug_4,
  t0.id AS id_5
FROM
  brands__brands t0
WHERE
  t0.legal_name = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.legal_name AS legal_name_2, t0.car_manufacturer AS car_manufacturer_3, t0.slug AS slug_4, t0.id AS id_5 FROM brands__brands t0 WHERE t0.legal_name = 'SATA' LIMIT 1;

SELECT
  t0.article_search AS article_search_1,
  t0.article_original AS article_original_2,
  t0.description AS description_3,
  t0.id AS id_4,
  t0.brand_id AS brand_id_5,
  t6.place AS place_7,
  t6.id AS id_8,
  t6.product_id AS product_id_9
FROM
  products__products t0
  LEFT JOIN storages__storages t6 ON t6.product_id = t0.id
WHERE
  t0.brand_id = ?
  AND t0.article_search = ?
LIMIT
  1

SELECT t0.article_search AS article_search_1, t0.article_original AS article_original_2, t0.description AS description_3, t0.id AS id_4, t0.brand_id AS brand_id_5, t6.place AS place_7, t6.id AS id_8, t6.product_id AS product_id_9 FROM products__products t0 LEFT JOIN storages__storages t6 ON t6.product_id = t0.id WHERE t0.brand_id = 2310 AND t0.article_search = '24206' LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.alias AS alias_2,
  t0.id AS id_3
FROM
  warehouses__warehouses t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.alias AS alias_2, t0.id AS id_3 FROM warehouses__warehouses t0 WHERE t0.alias = 'sklad' LIMIT 1;

SELECT
  t0.stock AS stock_1,
  t0.price AS price_2,
  t0.show_in_search AS show_in_search_3,
  t0.id AS id_4,
  t0.updated AS updated_5,
  t0.product_id AS product_id_6,
  t0.warehouse_id AS warehouse_id_7
FROM
  products__items t0
WHERE
  t0.warehouse_id = ?
  AND t0.product_id = ?
LIMIT
  1

SELECT t0.stock AS stock_1, t0.price AS price_2, t0.show_in_search AS show_in_search_3, t0.id AS id_4, t0.updated AS updated_5, t0.product_id AS product_id_6, t0.warehouse_id AS warehouse_id_7 FROM products__items t0 WHERE t0.warehouse_id = 1 AND t0.product_id = 2397 LIMIT 1;

SELECT
  t0.created_at AS created_at_1,
  t0.phone AS phone_2,
  t0.password AS password_3,
  t0.deprecated_user_id AS deprecated_user_id_4,
  t0.cookie AS cookie_5,
  t0.id AS id_6,
  t7.created_at AS created_at_8,
  t7.guest_id AS guest_id_9,
  t7.first_name AS first_name_10,
  t7.last_name AS last_name_11,
  t7.father_name AS father_name_12,
  t7.phone AS phone_13,
  t7.delivery_type AS delivery_type_14,
  t7.town AS town_15,
  t7.postcode AS postcode_16,
  t7.street AS street_17,
  t7.house AS house_18,
  t7.apartment AS apartment_19,
  t7.longitude AS longitude_20,
  t7.latitude AS latitude_21,
  t7.payment_type AS payment_type_22,
  t7.comment AS comment_23,
  t7.id AS id_24,
  t7.user_id AS user_id_25,
  t7.transport_company_id AS transport_company_id_26,
  t27.created_at AS created_at_28,
  t27.visible AS visible_29,
  t27.first_name AS first_name_30,
  t27.last_name AS last_name_31,
  t27.father_name AS father_name_32,
  t27.mango_extension_number AS mango_extension_number_33,
  t27.id AS id_34,
  t27.user_id AS user_id_35
FROM
  users__users t0
  LEFT JOIN carts__carts t7 ON t7.user_id = t0.id
  LEFT JOIN managers t27 ON t27.user_id = t0.id
WHERE
  t0.deprecated_user_id = ?
LIMIT
  1

SELECT t0.created_at AS created_at_1, t0.phone AS phone_2, t0.password AS password_3, t0.deprecated_user_id AS deprecated_user_id_4, t0.cookie AS cookie_5, t0.id AS id_6, t7.created_at AS created_at_8, t7.guest_id AS guest_id_9, t7.first_name AS first_name_10, t7.last_name AS last_name_11, t7.father_name AS father_name_12, t7.phone AS phone_13, t7.delivery_type AS delivery_type_14, t7.town AS town_15, t7.postcode AS postcode_16, t7.street AS street_17, t7.house AS house_18, t7.apartment AS apartment_19, t7.longitude AS longitude_20, t7.latitude AS latitude_21, t7.payment_type AS payment_type_22, t7.comment AS comment_23, t7.id AS id_24, t7.user_id AS user_id_25, t7.transport_company_id AS transport_company_id_26, t27.created_at AS created_at_28, t27.visible AS visible_29, t27.first_name AS first_name_30, t27.last_name AS last_name_31, t27.father_name AS father_name_32, t27.mango_extension_number AS mango_extension_number_33, t27.id AS id_34, t27.user_id AS user_id_35 FROM users__users t0 LEFT JOIN carts__carts t7 ON t7.user_id = t0.id LEFT JOIN managers t27 ON t27.user_id = t0.id WHERE t0.deprecated_user_id = 2 LIMIT 1;

SELECT
  t0.created_at AS created_at_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.crm_spare_id AS crm_spare_id_4,
  t0.id AS id_5,
  t0.order_id AS order_id_6,
  t0.item_id AS item_id_7,
  t0.searcher_user_id AS searcher_user_id_8,
  t0.supplier_item_id AS supplier_item_id_9
FROM
  orders__elements t0
WHERE
  t0.order_id = ?
  AND t0.item_id = ?
LIMIT
  1

SELECT t0.created_at AS created_at_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.crm_spare_id AS crm_spare_id_4, t0.id AS id_5, t0.order_id AS order_id_6, t0.item_id AS item_id_7, t0.searcher_user_id AS searcher_user_id_8, t0.supplier_item_id AS supplier_item_id_9 FROM orders__elements t0 WHERE t0.order_id = 3743 AND t0.item_id = 4872 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO orders__elements (
  created_at, quantity, price, crm_spare_id,
  order_id, item_id, searcher_user_id,
  supplier_item_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO orders__elements (created_at, quantity, price, crm_spare_id, order_id, item_id, searcher_user_id, supplier_item_id) VALUES ('2025-06-05 14:42:05', 1, 20000, NULL, 3743, 4872, NULL, NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  orders__elements
SET
  crm_spare_id = ?
WHERE
  id = ?

UPDATE orders__elements SET crm_spare_id = 271424 WHERE id = 6354;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  orders__elements
SET
  searcher_user_id = ?
WHERE
  id = ?

UPDATE orders__elements SET searcher_user_id = 9 WHERE id = 6354;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO orders__payments (
  created_at, type, amount, order_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO orders__payments (created_at, type, amount, order_id) VALUES ('2025-06-05 14:42:05', 'terminal', 20000, 3743);

"COMMIT"

"COMMIT";

SELECT
  t0.created_at AS created_at_1,
  t0.price AS price_2,
  t0.reward_margin AS reward_margin_3,
  t0.id AS id_4,
  t0.payment_order_id AS payment_order_id_5,
  t0.order_element_id AS order_element_id_6
FROM
  orders__elements_payments t0
WHERE
  t0.payment_order_id = ?
  AND t0.order_element_id = ?
LIMIT
  1

SELECT t0.created_at AS created_at_1, t0.price AS price_2, t0.reward_margin AS reward_margin_3, t0.id AS id_4, t0.payment_order_id AS payment_order_id_5, t0.order_element_id AS order_element_id_6 FROM orders__elements_payments t0 WHERE t0.payment_order_id = 2496 AND t0.order_element_id = 6354 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO orders__elements_payments (
  created_at, price, reward_margin,
  payment_order_id, order_element_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO orders__elements_payments (created_at, price, reward_margin, payment_order_id, order_element_id) VALUES ('2025-06-05 14:42:05', 20000, 0, 2496, 6354);

"COMMIT"

"COMMIT";