Query Metrics

5 Database Queries
4 Different statements
233.91 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 23.56 ms
"START TRANSACTION"
Parameters:
[]
2 31.21 ms
INSERT INTO track_click (created_at, company_id, dep_datetime, cents, currency, ip, url, ua, cookie_ga, dep_stop_id_id, arr_stop_id_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-05-24 00:55:46"
  2 => 1
  3 => "2025-05-23 00:00:00"
  4 => 2898
  5 => null
  6 => "34.173.8.190"
  7 => "http://test-www.comparabus.com/fr/redirect?arrStopExt=AMT&arrStopId=1&cents=2898&companyId=1&currency=EUR&dateFrom=2025-05-23&depStopExt=PAR&depStopId=10&link=1407%7C2025-05-23%7C2025-05-23%7CXPB%7CZYR%7C1661%7C2025-05-23%7C2025-05-23%7CZYR%7CXAM"
  8 => "Scrapy/2.11.2 (+https://scrapy.org)"
  9 => null
  10 => "10"
  11 => "1"
]
3 7.70 ms
"COMMIT"
Parameters:
[]
4 135.53 ms
SELECT t0.company_id AS company_id_1, t0.code AS code_2, t0.name AS name_3, t0.country AS country_4, t0.lat AS lat_5, t0.lon AS lon_6, t0.stop_id AS stop_id_7 FROM stop_ext t0 WHERE t0.company_id = ? AND t0.code = ?
Parameters:
[
  1
  "PAR"
]
5 35.90 ms
SELECT t0.company_id AS company_id_1, t0.code AS code_2, t0.name AS name_3, t0.country AS country_4, t0.lat AS lat_5, t0.lon AS lon_6, t0.stop_id AS stop_id_7 FROM stop_ext t0 WHERE t0.company_id = ? AND t0.code = ?
Parameters:
[
  1
  "AMT"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Stop No errors.
App\Entity\StopExt No errors.
App\Entity\TrackClick No errors.
App\Entity\Block No errors.