http://228deals.all4tic.tech/immeubledetailslug/appart-3UW95

Query Metrics

23 Database Queries
13 Different statements
17.43 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.73 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 1.38 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.81 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.62 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.90 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.37 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.33 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.33 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.33 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.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:
[
  15
]
11 0.32 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.35 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.33 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.31 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.31 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.63 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.54 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 1.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.slug = ? LIMIT 1
Parameters:
[
  "appart-3UW95"
]
19 1.51 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 12
Parameters:
[
  4
]
20 1.37 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.article_id AS article_id_4, t0.immeuble_id AS immeuble_id_5, t0.vehicule_id AS vehicule_id_6 FROM images t0 WHERE t0.immeuble_id = ?
Parameters:
[
  27
]
21 0.72 ms
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.variable_id AS variable_id_3, t0.immeuble_id AS immeuble_id_4 FROM immeuble_variable t0 WHERE t0.immeuble_id = ?
Parameters:
[
  27
]
22 1.20 ms
SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.email AS email_7, t0.boutique AS boutique_8, t0.ville AS ville_9, t0.telwhatsapp AS telwhatsapp_10, t0.is_verified AS is_verified_11, t0.shop_id AS shop_id_12 FROM "users" t0 WHERE t0.id = ?
Parameters:
[
  1
]
23 1.09 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.adresse AS adresse_4, t0.telephone AS telephone_5, t0.logo AS logo_6, t0.siteweb AS siteweb_7, t0.code AS code_8 FROM boutiques t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.
App\Entity\Boutiques No errors.
App\Entity\Favoris No errors.
App\Entity\UserCode No errors.