| 1 |
0.98 ms |
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
Parameters: [
"https://kodano-pl.stage.dionizos.szkkla.com"
]
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;
|
| 2 |
0.71 ms |
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;
|
| 3 |
3.51 ms |
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.email = ? LIMIT 1
Parameters: [
"developer@kodano.pl"
]
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.email = 'developer@kodano.pl' LIMIT 1;
|
| 4 |
0.33 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 5 |
2.05 ms |
UPDATE user SET last_activity = ?, updated_at = ? WHERE id = ?
Parameters: [
"2026-10-16 12:06:05"
"2026-10-16 12:06:05"
533
]
UPDATE user SET last_activity = '2026-10-16 12:06:05', updated_at = '2026-10-16 12:06:05' WHERE id = 533;
|
| 6 |
2.06 ms |
"COMMIT"
|
| 7 |
0.62 ms |
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
Parameters: [
"https://kodano-pl.stage.dionizos.szkkla.com"
]
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;
|
| 8 |
6.19 ms |
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;
|
| 9 |
0.71 ms |
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 = 4;
|
| 10 |
0.39 ms |
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 = 7;
|
| 11 |
12.64 ms |
SELECT COUNT(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 o0_.lw_send = ? AND s2_.code <> ? AND (s3_.id = ? OR s3_.id IS NULL)
Parameters: [
3
"optical_partner"
3
]
SELECT COUNT(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 o0_.lw_send = 3 AND s2_.code <> 'optical_partner' AND (s3_.id = 3 OR s3_.id IS NULL);
|