Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.api_key AS api_key_2,
  e0_.shoptet_id AS shoptet_id_3,
  e0_.locale AS locale_4,
  e0_.currency AS currency_5,
  e0_.url AS url_6,
  e0_.logo AS logo_7,
  e0_.last_order_change AS last_order_change_8,
  e0_.last_product_change AS last_product_change_9,
  e0_.storno_status AS storno_status_10,
  e0_.export_status AS export_status_11,
  e0_.pack_status AS pack_status_12,
  e0_.last_stock_movement AS last_stock_movement_13,
  e0_.stock AS stock_14,
  e0_.discard_order_before_date AS discard_order_before_date_15,
  e0_.locked AS locked_16,
  e0_.createts AS createts_17,
  e0_.editts AS editts_18,
  e0_.create_user_id AS create_user_id_19,
  e0_.edit_user_id AS edit_user_id_20
FROM
  eshop e0_
ORDER BY
  e0_.last_order_change ASC
LIMIT
  1

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.api_key AS api_key_2, e0_.shoptet_id AS shoptet_id_3, e0_.locale AS locale_4, e0_.currency AS currency_5, e0_.url AS url_6, e0_.logo AS logo_7, e0_.last_order_change AS last_order_change_8, e0_.last_product_change AS last_product_change_9, e0_.storno_status AS storno_status_10, e0_.export_status AS export_status_11, e0_.pack_status AS pack_status_12, e0_.last_stock_movement AS last_stock_movement_13, e0_.stock AS stock_14, e0_.discard_order_before_date AS discard_order_before_date_15, e0_.locked AS locked_16, e0_.createts AS createts_17, e0_.editts AS editts_18, e0_.create_user_id AS create_user_id_19, e0_.edit_user_id AS edit_user_id_20 FROM eshop e0_ ORDER BY e0_.last_order_change ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.api_key AS api_key_3,
  t0.shoptet_id AS shoptet_id_4,
  t0.locale AS locale_5,
  t0.currency AS currency_6,
  t0.url AS url_7,
  t0.logo AS logo_8,
  t0.last_order_change AS last_order_change_9,
  t0.last_product_change AS last_product_change_10,
  t0.storno_status AS storno_status_11,
  t0.export_status AS export_status_12,
  t0.pack_status AS pack_status_13,
  t0.last_stock_movement AS last_stock_movement_14,
  t0.stock AS stock_15,
  t0.discard_order_before_date AS discard_order_before_date_16,
  t0.locked AS locked_17,
  t0.createts AS createts_18,
  t0.editts AS editts_19,
  t0.create_user_id AS create_user_id_20,
  t0.edit_user_id AS edit_user_id_21
FROM
  eshop t0
WHERE
  t0.shoptet_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.shoptet_id AS shoptet_id_4, t0.locale AS locale_5, t0.currency AS currency_6, t0.url AS url_7, t0.logo AS logo_8, t0.last_order_change AS last_order_change_9, t0.last_product_change AS last_product_change_10, t0.storno_status AS storno_status_11, t0.export_status AS export_status_12, t0.pack_status AS pack_status_13, t0.last_stock_movement AS last_stock_movement_14, t0.stock AS stock_15, t0.discard_order_before_date AS discard_order_before_date_16, t0.locked AS locked_17, t0.createts AS createts_18, t0.editts AS editts_19, t0.create_user_id AS create_user_id_20, t0.edit_user_id AS edit_user_id_21 FROM eshop t0 WHERE t0.shoptet_id = 312604 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO webhook (
  createts, event, event_instance, processed,
  eshop_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO webhook (createts, event, event_instance, processed, eshop_id) VALUES ('2026-07-07 13:42:04', 'order:create', '1202604367', 0, 1);

"COMMIT"

"COMMIT";

SELECT
  v0_.code AS code_0,
  v0_.weight AS weight_1
FROM
  `variant` v0_
WHERE
  v0_.name <> ?

SELECT v0_.code AS code_0, v0_.weight AS weight_1 FROM `variant` v0_ WHERE v0_.name <> 'sklad';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.email AS email_3,
  t0.eshop_id AS eshop_id_4,
  t0.createts AS createts_5,
  t0.items AS items_6,
  t0.status AS status_7,
  t0.deleted AS deleted_8,
  t0.we_care AS we_care_9,
  t0.origin AS origin_10
FROM
  `order` t0
WHERE
  t0.code = ?
  AND t0.eshop_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.email AS email_3, t0.eshop_id AS eshop_id_4, t0.createts AS createts_5, t0.items AS items_6, t0.status AS status_7, t0.deleted AS deleted_8, t0.we_care AS we_care_9, t0.origin AS origin_10 FROM `order` t0 WHERE t0.code = '1202604367' AND t0.eshop_id = 312604 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO `order` (
  code, email, eshop_id, createts, items,
  status, deleted, we_care, origin
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO `order` (code, email, eshop_id, createts, items, status, deleted, we_care, origin) VALUES ('1202604367', 'savs.hrdlicka@seznam.cz', 312604, '2026-07-07 13:42:04', '{\"790868\":{\"code\":\"HASIS-NATURAL-10\",\"amount\":1.0,\"unit\":\"10 g\",\"itemId\":790868,\"isPacked\":null,\"packedUser\":null,\"packedTS\":null},\"790865\":{\"code\":\"CBD-ORANGE-BUD-25\",\"amount\":1.0,\"unit\":\"25 g\",\"itemId\":790865,\"isPacked\":null,\"packedUser\":null,\"packedTS\":null},\"790877\":{\"code\":\"M9067\",\"amount\":1.0,\"unit\":null,\"itemId\":790877,\"isPacked\":null,\"packedUser\":null,\"packedTS\":null},\"790874\":{\"code\":\"30102101\",\"amount\":1.0,\"unit\":null,\"itemId\":790874,\"isPacked\":null,\"packedUser\":null,\"packedTS\":null},\"790871\":{\"code\":\"222031\",\"amount\":1.0,\"unit\":null,\"itemId\":790871,\"isPacked\":null,\"packedUser\":null,\"packedTS\":null},\"790886\":{\"code\":\"884\",\"amount\":1.0,\"unit\":null,\"itemId\":790886,\"isPacked\":null,\"packedUser\":null,\"packedTS\":null},\"790883\":{\"code\":\"114\",\"amount\":1.0,\"unit\":null,\"itemId\":790883,\"isPacked\":null,\"packedUser\":null,\"packedTS\":null}}', -1, NULL, 1, 'webhook');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.email AS email_3,
  t0.eshop_id AS eshop_id_4,
  t0.createts AS createts_5,
  t0.items AS items_6,
  t0.status AS status_7,
  t0.deleted AS deleted_8,
  t0.we_care AS we_care_9,
  t0.origin AS origin_10
FROM
  `order` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.email AS email_3, t0.eshop_id AS eshop_id_4, t0.createts AS createts_5, t0.items AS items_6, t0.status AS status_7, t0.deleted AS deleted_8, t0.we_care AS we_care_9, t0.origin AS origin_10 FROM `order` t0 WHERE t0.id = 47825;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.weight AS weight_4,
  t0.stock AS stock_5,
  t0.buy_price AS buy_price_6,
  t0.createts AS createts_7,
  t0.editts AS editts_8,
  t0.product_id AS product_id_9,
  t0.create_user_id AS create_user_id_10,
  t0.edit_user_id AS edit_user_id_11
FROM
  `variant` t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = 'HASIS-NATURAL-10' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.guid AS guid_3,
  t0.name AS name_4,
  t0.url AS url_5,
  t0.category_name AS category_name_6,
  t0.variants_checked AS variants_checked_7,
  t0.createts AS createts_8,
  t0.editts AS editts_9,
  t0.eshop_id AS eshop_id_10,
  t0.create_user_id AS create_user_id_11,
  t0.edit_user_id AS edit_user_id_12
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.guid AS guid_3, t0.name AS name_4, t0.url AS url_5, t0.category_name AS category_name_6, t0.variants_checked AS variants_checked_7, t0.createts AS createts_8, t0.editts AS editts_9, t0.eshop_id AS eshop_id_10, t0.create_user_id AS create_user_id_11, t0.edit_user_id AS edit_user_id_12 FROM product t0 WHERE t0.id = 115;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.weight AS weight_4,
  t0.stock AS stock_5,
  t0.buy_price AS buy_price_6,
  t0.createts AS createts_7,
  t0.editts AS editts_8,
  t0.product_id AS product_id_9,
  t0.create_user_id AS create_user_id_10,
  t0.edit_user_id AS edit_user_id_11
FROM
  `variant` t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.weight ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.product_id = 115 ORDER BY t0.weight ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO product_log (
  code, `before`, `current`, `change`,
  `type`, eshop_id, type_id, createts,
  editts, product_id, create_user_id,
  edit_user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO product_log (code, `before`, `current`, `change`, `type`, eshop_id, type_id, createts, editts, product_id, create_user_id, edit_user_id) VALUES ('HASIS-NATURAL-10', 560, 550, -10, 3, 312604, '1202604367', '2026-07-07 13:42:04', NULL, 115, NULL, NULL);

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 55, editts = '2026-07-07 13:42:05' WHERE id = 1147;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 550, editts = '2026-07-07 13:42:05' WHERE id = 1150;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 550, editts = '2026-07-07 13:42:05' WHERE id = 1151;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 275, editts = '2026-07-07 13:42:05' WHERE id = 1146;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 183, editts = '2026-07-07 13:42:05' WHERE id = 1149;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 110, editts = '2026-07-07 13:42:05' WHERE id = 1148;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.weight AS weight_4,
  t0.stock AS stock_5,
  t0.buy_price AS buy_price_6,
  t0.createts AS createts_7,
  t0.editts AS editts_8,
  t0.product_id AS product_id_9,
  t0.create_user_id AS create_user_id_10,
  t0.edit_user_id AS edit_user_id_11
FROM
  `variant` t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = 'CBD-ORANGE-BUD-25' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.guid AS guid_3,
  t0.name AS name_4,
  t0.url AS url_5,
  t0.category_name AS category_name_6,
  t0.variants_checked AS variants_checked_7,
  t0.createts AS createts_8,
  t0.editts AS editts_9,
  t0.eshop_id AS eshop_id_10,
  t0.create_user_id AS create_user_id_11,
  t0.edit_user_id AS edit_user_id_12
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.guid AS guid_3, t0.name AS name_4, t0.url AS url_5, t0.category_name AS category_name_6, t0.variants_checked AS variants_checked_7, t0.createts AS createts_8, t0.editts AS editts_9, t0.eshop_id AS eshop_id_10, t0.create_user_id AS create_user_id_11, t0.edit_user_id AS edit_user_id_12 FROM product t0 WHERE t0.id = 92;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.weight AS weight_4,
  t0.stock AS stock_5,
  t0.buy_price AS buy_price_6,
  t0.createts AS createts_7,
  t0.editts AS editts_8,
  t0.product_id AS product_id_9,
  t0.create_user_id AS create_user_id_10,
  t0.edit_user_id AS edit_user_id_11
FROM
  `variant` t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.weight ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.product_id = 92 ORDER BY t0.weight ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO product_log (
  code, `before`, `current`, `change`,
  `type`, eshop_id, type_id, createts,
  editts, product_id, create_user_id,
  edit_user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO product_log (code, `before`, `current`, `change`, `type`, eshop_id, type_id, createts, editts, product_id, create_user_id, edit_user_id) VALUES ('CBD-ORANGE-BUD-25', 1173, 1148, -25, 3, 312604, '1202604367', '2026-07-07 13:42:05', NULL, 92, NULL, NULL);

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 45, editts = '2026-07-07 13:42:05' WHERE id = 904;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 1148, editts = '2026-07-07 13:42:05' WHERE id = 909;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 1148, editts = '2026-07-07 13:42:05' WHERE id = 910;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 574, editts = '2026-07-07 13:42:05' WHERE id = 908;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 382, editts = '2026-07-07 13:42:05' WHERE id = 907;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 229, editts = '2026-07-07 13:42:05' WHERE id = 906;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 164, editts = '2026-07-07 13:42:05' WHERE id = 901;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 114, editts = '2026-07-07 13:42:05' WHERE id = 905;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 76, editts = '2026-07-07 13:42:05' WHERE id = 900;

UPDATE
  `variant`
SET
  stock = ?,
  editts = ?
WHERE
  id = ?

UPDATE `variant` SET stock = 22, editts = '2026-07-07 13:42:05' WHERE id = 903;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.weight AS weight_4,
  t0.stock AS stock_5,
  t0.buy_price AS buy_price_6,
  t0.createts AS createts_7,
  t0.editts AS editts_8,
  t0.product_id AS product_id_9,
  t0.create_user_id AS create_user_id_10,
  t0.edit_user_id AS edit_user_id_11
FROM
  `variant` t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = 'M9067' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.weight AS weight_4,
  t0.stock AS stock_5,
  t0.buy_price AS buy_price_6,
  t0.createts AS createts_7,
  t0.editts AS editts_8,
  t0.product_id AS product_id_9,
  t0.create_user_id AS create_user_id_10,
  t0.edit_user_id AS edit_user_id_11
FROM
  `variant` t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = '30102101' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.weight AS weight_4,
  t0.stock AS stock_5,
  t0.buy_price AS buy_price_6,
  t0.createts AS createts_7,
  t0.editts AS editts_8,
  t0.product_id AS product_id_9,
  t0.create_user_id AS create_user_id_10,
  t0.edit_user_id AS edit_user_id_11
FROM
  `variant` t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = '222031' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.weight AS weight_4,
  t0.stock AS stock_5,
  t0.buy_price AS buy_price_6,
  t0.createts AS createts_7,
  t0.editts AS editts_8,
  t0.product_id AS product_id_9,
  t0.create_user_id AS create_user_id_10,
  t0.edit_user_id AS edit_user_id_11
FROM
  `variant` t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = '884' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.weight AS weight_4,
  t0.stock AS stock_5,
  t0.buy_price AS buy_price_6,
  t0.createts AS createts_7,
  t0.editts AS editts_8,
  t0.product_id AS product_id_9,
  t0.create_user_id AS create_user_id_10,
  t0.edit_user_id AS edit_user_id_11
FROM
  `variant` t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = '114' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  webhook
SET
  processed = ?
WHERE
  id = ?

UPDATE webhook SET processed = 1 WHERE id = 440523;

"COMMIT"

"COMMIT";