GET https://kodano-pl.stage.dionizos.szkkla.com/wszechmogacy

Query Metrics

11 Database Queries
8 Different statements
30.19 ms Query time
0 Invalid entities
14 Managed entities

Queries

Group similar statements

#▲ Time Info
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"
]
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 = ?
Parameters:
[
  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"
]
4 0.33 ms
"START TRANSACTION"
Parameters:
[]
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
]
6 2.06 ms
"COMMIT"
Parameters:
[]
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"
]
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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\SalePlace 5
App\Entity\Store 3
App\Entity\PersefonaSalePlace 3
App\Entity\Config 1
App\Entity\User 1
App\Entity\SalePlaceKind 1

Entities Mapping

Class Mapping errors
App\Entity\Store No errors.
App\Entity\Config No errors.
App\Entity\Promotion No errors.
App\Entity\Service No errors.
App\Entity\AbstractDictionary No errors.
App\Entity\SalePlace No errors.
App\Entity\User No errors.
App\Entity\Offer No errors.
App\Entity\EyeExamination No errors.
App\Entity\SalePlaceKind No errors.
App\Entity\PersefonaSalePlace No errors.