Query Metrics
296
Database Queries
9
Different statements
4751.21 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1561.76 ms (32.87%) |
84 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.in_bytes AS in_bytes_9, t0.out_bytes AS out_bytes_10, t0.total_bytes AS total_bytes_11, t0.start_hour AS start_hour_12, t0.end_hour AS end_hour_13, t0.website_id AS website_id_14 FROM traffic_log t0 WHERE t0.website_id = ? AND t0.start_hour = ? AND t0.end_hour = ? LIMIT 1
Parameters:
[ "1f07b685-d0d1-6014-ba91-15157c3485c9" "2025-09-11 21:00:00" "2025-09-11 22:00:00" ] |
755.84 ms (15.91%) |
42 |
"START TRANSACTION"
Parameters:
[] |
690.98 ms (14.54%) |
42 |
SELECT t0_.end_hour AS end_hour_0, t0_.start_hour AS start_hour_1, t0_.total_bytes AS total_bytes_2 FROM traffic_log t0_ WHERE t0_.website_id = ? AND t0_.start_hour >= ? AND t0_.end_hour <= ?
Parameters:
[ "1f07b685-d0d1-6014-ba91-15157c3485c9" "2025-08-17 16:00:00" "2025-09-16 23:59:59" ] |
575.43 ms (12.11%) |
42 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.is_connected AS is_connected_9, t0.address AS address_10, t0.ns1 AS ns1_11, t0.ns2 AS ns2_12, t0.valid_until AS valid_until_13, t0.website_id AS website_id_14 FROM domain t0 WHERE t0.website_id = ?
Parameters:
[
"1f07b685-d0d1-6014-ba91-15157c3485c9"
]
|
561.79 ms (11.82%) |
42 |
"COMMIT"
Parameters:
[] |
551.22 ms (11.60%) |
41 |
UPDATE traffic_log SET start_hour = ?, end_hour = ? WHERE id = ?
Parameters:
[ "2025-09-11 21:00:00" "2025-09-11 22:00:00" "1f08f3d5-4e02-6244-9b58-d3974e821726" ] |
27.73 ms (0.58%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.subdomain AS subdomain_10, t0.shop_balance AS shop_balance_11, t0.theme AS theme_12, t0.analytics_data AS analytics_data_13, t0.expired_at AS expired_at_14, t0.traffic_usage AS traffic_usage_15, t0.plan_started_at AS plan_started_at_16, t0.owner_id AS owner_id_17, t0.current_plan_id AS current_plan_id_18 FROM website t0
Parameters:
[] |
13.36 ms (0.28%) |
1 |
UPDATE traffic_log SET total_bytes = ?, start_hour = ?, end_hour = ? WHERE id = ?
Parameters:
[ "673894" "2025-09-11 21:00:00" "2025-09-11 22:00:00" "1f08f3d5-6eaa-6852-bd65-d3974e821726" ] |
13.09 ms (0.28%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.subdomain AS subdomain_10, t0.shop_balance AS shop_balance_11, t0.theme AS theme_12, t0.analytics_data AS analytics_data_13, t0.expired_at AS expired_at_14, t0.traffic_usage AS traffic_usage_15, t0.plan_started_at AS plan_started_at_16, t0.owner_id AS owner_id_17, t0.current_plan_id AS current_plan_id_18 FROM website t0 WHERE t0.subdomain = ? LIMIT 1
Parameters:
[
"127"
]
|
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.