POST https://kodano-pl.stage.dionizos.szkkla.com/service-packages/1/activate

Query Metrics

13 Database Queries
10 Different statements
11.08 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.58 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.66 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.code = ? AND t0.store_id = ? LIMIT 1
Parameters:
[
  "shop_domain"
  3
]
3 0.65 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"
]
4 0.44 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
]
5 0.74 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.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.erp_id AS erp_id_10, t0.is_active AS is_active_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  530
]
6 1.07 ms
SELECT t0.number AS number_1, t0.package_price AS package_price_2, t0.package_value AS package_value_3, t0.expiry_date AS expiry_date_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.source_offer_id AS source_offer_id_8, t0.type_id AS type_id_9, t0.status_id AS status_id_10 FROM service_package t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
7 0.95 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 FROM service_package_status t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.50 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 FROM service_package_status t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "active"
]
9 0.51 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"
]
10 0.40 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.code = ? AND t0.store_id = ? LIMIT 1
Parameters:
[
  "service_package_activation_days"
  3
]
11 0.32 ms
"START TRANSACTION"
Parameters:
[]
12 1.14 ms
UPDATE service_package SET expiry_date = ?, status_id = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2027-04-30"
  2
  "2026-04-30 09:40:55"
  1
]
13 2.12 ms
"COMMIT"
Parameters:
[]

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.