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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1003.86 ms
(31.35%)
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-12 01:00:00"
  "2025-09-12 02:00:00"
]
521.37 ms
(16.28%)
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"
]
437.18 ms
(13.65%)
42
"COMMIT"
Parameters:
[]
422.57 ms
(13.20%)
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"
]
393.72 ms
(12.30%)
41
UPDATE traffic_log SET start_hour = ?, end_hour = ? WHERE id = ?
Parameters:
[
  "2025-09-12 01:00:00"
  "2025-09-12 02:00:00"
  "1f08f5ed-c198-6b30-b208-3fe2c8739147"
]
384.94 ms
(12.02%)
42
"START TRANSACTION"
Parameters:
[]
19.17 ms
(0.60%)
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:
[]
9.90 ms
(0.31%)
1
UPDATE traffic_log SET total_bytes = ?, start_hour = ?, end_hour = ? WHERE id = ?
Parameters:
[
  "9166672"
  "2025-09-12 01:00:00"
  "2025-09-12 02:00:00"
  "1f08f5ed-ecca-674a-92e2-3fe2c8739147"
]
9.26 ms
(0.29%)
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.