Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.44 ms
(73.29%)
2
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"
]
31.21 ms
(13.34%)
1
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"
]
23.56 ms
(10.07%)
1
"START TRANSACTION"
Parameters:
[]
7.70 ms
(3.29%)
1
"COMMIT"
Parameters:
[]

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.