Symfony Profiler

SELECT
  t0.send_status AS send_status_1,
  t0.retry_count AS retry_count_2,
  t0.last_error AS last_error_3,
  t0.visit_id AS visit_id_4,
  t0.visit_number AS visit_number_5,
  t0.idempotency_key AS idempotency_key_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.offer_id AS offer_id_10
FROM
  persefona_visit t0
WHERE
  t0.offer_id = ?

SELECT t0.send_status AS send_status_1, t0.retry_count AS retry_count_2, t0.last_error AS last_error_3, t0.visit_id AS visit_id_4, t0.visit_number AS visit_number_5, t0.idempotency_key AS idempotency_key_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.offer_id AS offer_id_10 FROM persefona_visit t0 WHERE t0.offer_id = 50998;

SELECT
  t0.name AS name_1,
  t0.is_active AS is_active_2,
  t0.code AS code_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.tiss_id AS tiss_id_7,
  t0.lw_customer_id AS lw_customer_id_8,
  t0.lw_password AS lw_password_9,
  t0.is_lw_send AS is_lw_send_10,
  t0.is_remote_edging AS is_remote_edging_11,
  t0.is_lw_stock_lenses_enabled AS is_lw_stock_lenses_enabled_12,
  t0.lw_stock_lenses_test_remark AS lw_stock_lenses_test_remark_13,
  t0.erp_id AS erp_id_14,
  t0.sale_place_kind_id AS sale_place_kind_id_15,
  t0.store_id AS store_id_16,
  t17.id AS id_18,
  t17.sale_place_id AS sale_place_id_19
FROM
  sale_place t0
  LEFT JOIN persefona_sale_place t17 ON t17.sale_place_id = t0.id
  INNER JOIN users_sale_places ON t0.id = users_sale_places.sale_place_id
WHERE
  users_sale_places.user_id = ?

SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.tiss_id AS tiss_id_7, t0.lw_customer_id AS lw_customer_id_8, t0.lw_password AS lw_password_9, t0.is_lw_send AS is_lw_send_10, t0.is_remote_edging AS is_remote_edging_11, t0.is_lw_stock_lenses_enabled AS is_lw_stock_lenses_enabled_12, t0.lw_stock_lenses_test_remark AS lw_stock_lenses_test_remark_13, t0.erp_id AS erp_id_14, t0.sale_place_kind_id AS sale_place_kind_id_15, t0.store_id AS store_id_16, t17.id AS id_18, t17.sale_place_id AS sale_place_id_19 FROM sale_place t0 LEFT JOIN persefona_sale_place t17 ON t17.sale_place_id = t0.id INNER JOIN users_sale_places ON t0.id = users_sale_places.sale_place_id WHERE users_sale_places.user_id = 533;

SELECT
  DISTINCT o0_.id AS id_0
FROM
  offer o0_
  LEFT JOIN sale_place s1_ ON o0_.sale_place_id = s1_.id
  LEFT JOIN sale_place_kind s2_ ON s1_.sale_place_kind_id = s2_.id
  LEFT JOIN store s3_ ON s1_.store_id = s3_.id
WHERE
  s2_.code NOT IN (?, ?)
  AND (
    s3_.id = ?
    OR s3_.id IS NULL
  )
LIMIT
  20

SELECT DISTINCT o0_.id AS id_0 FROM offer o0_ LEFT JOIN sale_place s1_ ON o0_.sale_place_id = s1_.id LEFT JOIN sale_place_kind s2_ ON s1_.sale_place_kind_id = s2_.id LEFT JOIN store s3_ ON s1_.store_id = s3_.id WHERE s2_.code NOT IN ('optical_partner', 'franchise_optical_salon') AND (s3_.id = 3 OR s3_.id IS NULL) LIMIT 20;

"COMMIT"

"COMMIT";

SELECT
  t0.name AS name_1,
  t0.is_active AS is_active_2,
  t0.code AS code_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  offer_type t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM offer_type t0 WHERE t0.id = 1;

SELECT
  o0_.visit_number AS visit_number_0,
  o0_.has_application AS has_application_1,
  o0_.lw_send AS lw_send_2,
  o0_.lw_retry_count AS lw_retry_count_3,
  o0_.lw_last_error AS lw_last_error_4,
  o0_.lw_remark AS lw_remark_5,
  o0_.lw_remote_edging AS lw_remote_edging_6,
  o0_.lw_polish AS lw_polish_7,
  o0_.lw_reference AS lw_reference_8,
  o0_.currency AS currency_9,
  o0_.erp_customer_id AS erp_customer_id_10,
  o0_.test_mode AS test_mode_11,
  o0_.id AS id_12,
  o0_.created_at AS created_at_13,
  o0_.updated_at AS updated_at_14,
  o0_.base_price AS base_price_15,
  o0_.final_price AS final_price_16,
  o0_.increment_id AS increment_id_17,
  o0_.offer_status_id AS offer_status_id_18,
  o0_.type_id AS type_id_19,
  o0_.sale_place_id AS sale_place_id_20,
  o0_.user_id AS user_id_21,
  o0_.parent_offer_id AS parent_offer_id_22
FROM
  offer o0_
  LEFT JOIN sale_place s1_ ON o0_.sale_place_id = s1_.id
  LEFT JOIN sale_place_kind s2_ ON s1_.sale_place_kind_id = s2_.id
  LEFT JOIN store s3_ ON s1_.store_id = s3_.id
WHERE
  s2_.code NOT IN (?, ?)
  AND (
    s3_.id = ?
    OR s3_.id IS NULL
  )
  AND o0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT o0_.visit_number AS visit_number_0, o0_.has_application AS has_application_1, o0_.lw_send AS lw_send_2, o0_.lw_retry_count AS lw_retry_count_3, o0_.lw_last_error AS lw_last_error_4, o0_.lw_remark AS lw_remark_5, o0_.lw_remote_edging AS lw_remote_edging_6, o0_.lw_polish AS lw_polish_7, o0_.lw_reference AS lw_reference_8, o0_.currency AS currency_9, o0_.erp_customer_id AS erp_customer_id_10, o0_.test_mode AS test_mode_11, o0_.id AS id_12, o0_.created_at AS created_at_13, o0_.updated_at AS updated_at_14, o0_.base_price AS base_price_15, o0_.final_price AS final_price_16, o0_.increment_id AS increment_id_17, o0_.offer_status_id AS offer_status_id_18, o0_.type_id AS type_id_19, o0_.sale_place_id AS sale_place_id_20, o0_.user_id AS user_id_21, o0_.parent_offer_id AS parent_offer_id_22 FROM offer o0_ LEFT JOIN sale_place s1_ ON o0_.sale_place_id = s1_.id LEFT JOIN sale_place_kind s2_ ON s1_.sale_place_kind_id = s2_.id LEFT JOIN store s3_ ON s1_.store_id = s3_.id WHERE s2_.code NOT IN ('optical_partner', 'franchise_optical_salon') AND (s3_.id = 3 OR s3_.id IS NULL) AND o0_.id IN (50948, 50971, 50972, 50973, 50977, 50978, 50979, 50981, 50982, 50986, 50988, 50989, 50990, 50991, 50992, 50993, 50994, 50995, 50996, 50998);

SELECT
  t0.name AS name_1,
  t0.is_active AS is_active_2,
  t0.code AS code_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6
FROM
  store t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM store t0 WHERE t0.id = 3;

SELECT
  t0.name AS name_1,
  t0.value AS value_2,
  t0.code AS code_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.store_id AS store_id_7
FROM
  config t0
WHERE
  t0.value = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.value AS value_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.store_id AS store_id_7 FROM config t0 WHERE t0.value = 'https://kodano-pl.stage.dionizos.szkkla.com' LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.is_active AS is_active_2,
  t0.code AS code_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  sale_place_kind t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sale_place_kind t0 WHERE t0.id = 4;

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  offer o0_
  LEFT JOIN sale_place s1_ ON o0_.sale_place_id = s1_.id
  LEFT JOIN sale_place_kind s2_ ON s1_.sale_place_kind_id = s2_.id
  LEFT JOIN store s3_ ON s1_.store_id = s3_.id
WHERE
  s2_.code NOT IN (?, ?)
  AND (
    s3_.id = ?
    OR s3_.id IS NULL
  )

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offer o0_ LEFT JOIN sale_place s1_ ON o0_.sale_place_id = s1_.id LEFT JOIN sale_place_kind s2_ ON s1_.sale_place_kind_id = s2_.id LEFT JOIN store s3_ ON s1_.store_id = s3_.id WHERE s2_.code NOT IN ('optical_partner', 'franchise_optical_salon') AND (s3_.id = 3 OR s3_.id IS NULL);

UPDATE
  user
SET
  last_activity = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user SET last_activity = '2026-10-16 12:06:13', updated_at = '2026-10-16 12:06:13' WHERE id = 533;

SELECT
  t0.email AS email_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.last_activity AS last_activity_6,
  t0.referral_code AS referral_code_7,
  t0.tiss_id AS tiss_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.id AS id_11,
  t0.erp_id AS erp_id_12,
  t0.is_active AS is_active_13
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.roles AS roles_4, t0.password AS password_5, t0.last_activity AS last_activity_6, t0.referral_code AS referral_code_7, t0.tiss_id AS tiss_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.erp_id AS erp_id_12, t0.is_active AS is_active_13 FROM user t0 WHERE t0.id = 533;

"START TRANSACTION"

"START TRANSACTION";