http://127.0.0.1/base-site/cronjobs/domain/traffics

Query Metrics

296 Database Queries
9 Different statements
3862.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1182.46 ms
(30.61%)
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 20:00:00"
  "2025-09-11 21:00:00"
]
615.74 ms
(15.94%)
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"
]
528.14 ms
(13.67%)
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"
]
505.09 ms
(13.08%)
42
"COMMIT"
Parameters:
[]
493.43 ms
(12.77%)
41
UPDATE traffic_log SET start_hour = ?, end_hour = ? WHERE id = ?
Parameters:
[
  "2025-09-11 20:00:00"
  "2025-09-11 21:00:00"
  "1f08f34f-2f4f-6742-9698-f911c5d9f0cb"
]
489.47 ms
(12.67%)
42
"START TRANSACTION"
Parameters:
[]
23.85 ms
(0.62%)
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:
[]
12.35 ms
(0.32%)
1
UPDATE traffic_log SET total_bytes = ?, start_hour = ?, end_hour = ? WHERE id = ?
Parameters:
[
  "323565"
  "2025-09-11 20:00:00"
  "2025-09-11 21:00:00"
  "1f08f34f-573f-6798-9037-f911c5d9f0cb"
]
11.97 ms
(0.31%)
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.