Query Metrics
16
Database Queries
8
Different statements
105.47 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 3.40 ms |
SELECT t0.id AS id_1, t0.originalWord AS originalWord_2, t0.replacementWord AS replacementWord_3 FROM search_alias t0 WHERE t0.originalWord = ? LIMIT 1
Parameters:
[
"utilitaire"
]
|
2 | 3.01 ms |
SELECT t0.id AS id_1, t0.originalWord AS originalWord_2, t0.replacementWord AS replacementWord_3 FROM search_alias t0 WHERE t0.originalWord = ? LIMIT 1
Parameters:
[
"jumpy"
]
|
3 | 3.32 ms |
SELECT DISTINCT v0_.id AS id_0 FROM vehicle v1_ LEFT JOIN external_vehicle e2_ ON v1_.id = e2_.id INNER JOIN sale_event s3_ ON v1_.event_id = s3_.id INNER JOIN sale s4_ ON s3_.sale_id = s4_.id LEFT JOIN external_sale e5_ ON s4_.id = e5_.id INNER JOIN vehicle_category v0_ ON v1_.category_id = v0_.id WHERE v1_.salingState NOT IN (?, ?, ?) AND s4_.endDate > ? AND v0_.name LIKE ? LIMIT 1
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:10:00" "%utilitaire%" ] |
4 | 3.04 ms |
SELECT DISTINCT v0_.makerSlug AS makerSlug_0 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN (?, ?, ?) AND s3_.endDate > ? AND v0_.makerSlug LIKE ? LIMIT 1
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:10:00" "%utilitaire%" ] |
5 | 3.29 ms |
SELECT DISTINCT v0_.modelGroupSlug AS modelGroupSlug_0, v0_.makerSlug AS makerSlug_1 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN (?, ?, ?) AND s3_.endDate > ? AND v0_.modelGroupSlug LIKE ? AND v0_.modelGroupSlug <> 'n-a'
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:10:00" "%utilitaire%" ] |
6 | 3.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM vehicule_transmission t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Utilitaire"
]
|
7 | 2.99 ms |
SELECT DISTINCT v0_.segmentSizeSlug AS segmentSizeSlug_0 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN (?, ?, ?) AND s3_.endDate > ? AND v0_.segmentSizeSlug LIKE ?
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:10:00" "%utilitaire%" ] |
8 | 3.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM vehicle_energy t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Utilitaire"
]
|
9 | 3.10 ms |
SELECT o0_.id AS id_0, o0_.codeSlug AS codeSlug_1, o0_.name AS name_2, o0_.weight AS weight_3, o0_.code AS code_4 FROM option_item o0_ WHERE o0_.name LIKE ? LIMIT 1
Parameters:
[
"utilitaire%"
]
|
10 | 2.95 ms |
SELECT DISTINCT v0_.id AS id_0 FROM vehicle v1_ LEFT JOIN external_vehicle e2_ ON v1_.id = e2_.id INNER JOIN sale_event s3_ ON v1_.event_id = s3_.id INNER JOIN sale s4_ ON s3_.sale_id = s4_.id LEFT JOIN external_sale e5_ ON s4_.id = e5_.id INNER JOIN vehicle_category v0_ ON v1_.category_id = v0_.id WHERE v1_.salingState NOT IN (?, ?, ?) AND s4_.endDate > ? AND v0_.name LIKE ? LIMIT 1
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:10:00" "%jumpy%" ] |
11 | 2.94 ms |
SELECT DISTINCT v0_.makerSlug AS makerSlug_0 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN (?, ?, ?) AND s3_.endDate > ? AND v0_.makerSlug LIKE ? LIMIT 1
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:10:00" "%jumpy%" ] |
12 | 2.96 ms |
SELECT DISTINCT v0_.modelGroupSlug AS modelGroupSlug_0, v0_.makerSlug AS makerSlug_1 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN (?, ?, ?) AND s3_.endDate > ? AND v0_.modelGroupSlug LIKE ? AND v0_.modelGroupSlug <> 'n-a'
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:10:00" "%jumpy%" ] |
13 | 3.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM vehicule_transmission t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Jumpy"
]
|
14 | 57.24 ms |
SELECT DISTINCT v0_.segmentSizeSlug AS segmentSizeSlug_0 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN (?, ?, ?) AND s3_.endDate > ? AND v0_.segmentSizeSlug LIKE ?
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:10:00" "%jumpy%" ] |
15 | 4.86 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM vehicle_energy t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Jumpy"
]
|
16 | 3.03 ms |
SELECT o0_.id AS id_0, o0_.codeSlug AS codeSlug_1, o0_.name AS name_2, o0_.weight AS weight_3, o0_.code AS code_4 FROM option_item o0_ WHERE o0_.name LIKE ? LIMIT 1
Parameters:
[
"jumpy%"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
tarif | doctrine.dbal.tarif_connection |
autovista | doctrine.dbal.autovista_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\Alias | No errors. |
App\Entity\Vehicle | No errors. |
App\Entity\SaleEvent | No errors. |
App\Entity\Sale | No errors. |
App\Entity\Category | No errors. |
App\Entity\ExternalVehicle | No errors. |
App\Entity\ExternalSale | No errors. |
App\Entity\Transmission | No errors. |
App\Entity\Energy | No errors. |
App\Entity\Option | No errors. |