http://228deals.all4tic.tech/vehiculesearch/Vehicules_7I3Y4

Method
GET
HTTP Status
200
IP
18.191.144.65
Profiled on
Token
810649

Query Metrics

22 Database Queries
10 Different statements
11.84 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.33 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.is_actif AS is_actif_4, t0.icon AS icon_5, t0.code AS code_6, t0.slug AS slug_7, t0.parent_id AS parent_id_8 FROM categories t0 ORDER BY t0.libelle ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 1.18 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.slug AS slug_3, t0.nom AS nom_4, t0.status AS status_5 FROM villes t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 0.69 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.slug AS slug_3, t0.nom AS nom_4, t0.is_status AS is_status_5, t0.ville_id AS ville_id_6 FROM quartiers t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.40 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.status AS status_3, t0.image AS image_4, t0.libelle AS libelle_5, t0.description AS description_6, t0.zone_id AS zone_id_7 FROM pub_image t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 0.64 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
6 0.28 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
7 0.24 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
8 0.23 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
9 0.29 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query
10 0.24 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
11 0.19 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
12 0.20 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
13 0.19 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
14 0.20 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
15 0.25 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.dimensions AS dimensions_5 FROM zone t0 WHERE t0.id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
16 0.43 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.code AS code_4, t0.is_actif AS is_actif_5, t0.slug AS slug_6 FROM marques t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
17 0.40 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.is_actif AS is_actif_4, t0.code AS code_5, t0.slug AS slug_6, t0.marque_id AS marque_id_7 FROM modeles t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 1.02 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.slug AS slug_3, t0.description AS description_4, t0.prix AS prix_5, t0.is_noprice AS is_noprice_6, t0.photo_image AS photo_image_7, t0.created_at AS created_at_8, t0.pub_date AS pub_date_9, t0.status AS status_10, t0.typeoperation AS typeoperation_11, t0.etat AS etat_12, t0.libelle AS libelle_13, t0.vendeur_id AS vendeur_id_14, t0.marque_id AS marque_id_15, t0.modele_id AS modele_id_16, t0.ville_id AS ville_id_17 FROM vehicules t0 WHERE t0.status = ? ORDER BY t0.pub_date DESC LIMIT 6
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
19 1.98 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.is_actif AS is_actif_4, t0.icon AS icon_5, t0.code AS code_6, t0.slug AS slug_7, t0.parent_id AS parent_id_8 FROM categories t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "Vehicules_7I3Y4"
]
View formatted query    View runnable query    Explain query
20 0.69 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.code AS code_4, t0.is_actif AS is_actif_5, t0.slug AS slug_6 FROM marques t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
21 0.27 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.is_actif AS is_actif_4, t0.code AS code_5, t0.slug AS slug_6, t0.marque_id AS marque_id_7 FROM modeles t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
22 0.50 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.slug AS slug_3, t0.description AS description_4, t0.prix AS prix_5, t0.is_noprice AS is_noprice_6, t0.photo_image AS photo_image_7, t0.created_at AS created_at_8, t0.pub_date AS pub_date_9, t0.status AS status_10, t0.typeoperation AS typeoperation_11, t0.etat AS etat_12, t0.libelle AS libelle_13, t0.vendeur_id AS vendeur_id_14, t0.marque_id AS marque_id_15, t0.modele_id AS modele_id_16, t0.ville_id AS ville_id_17 FROM vehicules t0 ORDER BY t0.pub_date DESC LIMIT 1000
Parameters: 
[]
View formatted query    View runnable query    Explain query

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\Categories
  • The field App\Entity\Categories#parent is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Categories#parent does not contain the required 'mappedBy="parent"' attribute.
  • If association App\Entity\Categories#parent is many-to-one, then the inversed side App\Entity\Categories#parent has to be one-to-many.
App\Entity\Articles No errors.
App\Entity\Variables No errors.
App\Entity\Immeubles No errors.
App\Entity\Villes No errors.
App\Entity\Quartiers No errors.
App\Entity\Vehicules No errors.
App\Entity\PubImage No errors.
App\Entity\Zone No errors.
App\Entity\Marques No errors.
App\Entity\Modeles No errors.
App\Entity\User No errors.
App\Entity\VehiculeVariable No errors.
App\Entity\Images No errors.