http://228deals.all4tic.tech/immeublesearch/Terrain%20%C3%A0%20vendre_XWBWC

Query Metrics

20 Database Queries
10 Different statements
9.56 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.45 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:
[]
2 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.status AS status_5 FROM villes t0
Parameters:
[]
3 0.62 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:
[]
4 0.49 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:
[]
5 0.58 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
]
6 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:
[
  2
]
7 0.22 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
]
8 0.21 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
]
9 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:
[
  14
]
10 0.22 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
]
11 0.18 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
]
12 0.18 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
]
13 0.22 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
]
14 0.21 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
]
15 0.21 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
]
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:
[]
17 0.44 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:
[]
18 0.77 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:
[
  "Terrain à vendre_XWBWC"
]
19 1.32 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.slug AS slug_4, t0.code AS code_5, t0.typeoperation AS typeoperation_6, t0.status AS status_7, t0.prix AS prix_8, t0.is_noprice AS is_noprice_9, t0.photo AS photo_10, t0.created_at AS created_at_11, t0.pub_date AS pub_date_12, t0.vendeur_id AS vendeur_id_13, t0.ville_id AS ville_id_14, t0.quartier_id AS quartier_id_15, t0.categorie_id AS categorie_id_16 FROM immeubles t0 WHERE t0.status = ? ORDER BY t0.pub_date DESC LIMIT 6
Parameters:
[
  2
]
20 0.67 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.slug AS slug_4, t0.code AS code_5, t0.typeoperation AS typeoperation_6, t0.status AS status_7, t0.prix AS prix_8, t0.is_noprice AS is_noprice_9, t0.photo AS photo_10, t0.created_at AS created_at_11, t0.pub_date AS pub_date_12, t0.vendeur_id AS vendeur_id_13, t0.ville_id AS ville_id_14, t0.quartier_id AS quartier_id_15, t0.categorie_id AS categorie_id_16 FROM immeubles t0 WHERE t0.categorie_id = ? ORDER BY t0.pub_date DESC LIMIT 1000
Parameters:
[
  6
]

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\ImmeubleVariable No errors.
App\Entity\Images No errors.