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

Query Metrics

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

Grouped Statements

Show all queries

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.