http://228deals.all4tic.tech/detail/ordina-T7c0h

Query Metrics

22 Database Queries
12 Different statements
11.48 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 2.10 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.56 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.41 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.38 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.55 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.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:
[
  2
]
7 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:
[
  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.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:
[
  15
]
11 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:
[
  11
]
12 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:
[
  12
]
13 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:
[
  5
]
14 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:
[
  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.39 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.38 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.49 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.prix AS prix_4, t0.ispromo AS ispromo_5, t0.is_solde AS is_solde_6, t0.solde_pourcentage AS solde_pourcentage_7, t0.prixpromo AS prixpromo_8, t0.etat AS etat_9, t0.imageprincipale AS imageprincipale_10, t0.status AS status_11, t0.ville AS ville_12, t0.is_noprice AS is_noprice_13, t0.pub_date AS pub_date_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.code AS code_17, t0.categorie_id AS categorie_id_18, t0.created_by_id AS created_by_id_19 FROM articles t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "ordina-T7c0h"
]
19 1.00 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.prix AS prix_4, t0.ispromo AS ispromo_5, t0.is_solde AS is_solde_6, t0.solde_pourcentage AS solde_pourcentage_7, t0.prixpromo AS prixpromo_8, t0.etat AS etat_9, t0.imageprincipale AS imageprincipale_10, t0.status AS status_11, t0.ville AS ville_12, t0.is_noprice AS is_noprice_13, t0.pub_date AS pub_date_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.code AS code_17, t0.categorie_id AS categorie_id_18, t0.created_by_id AS created_by_id_19 FROM articles t0 WHERE t0.categorie_id = ? AND t0.status = ? ORDER BY t0.pub_date DESC LIMIT 36
Parameters:
[
  1
  2
]
20 0.97 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.article_id = ?
Parameters:
[
  10
]
21 0.60 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
]
22 0.51 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\Images No errors.
App\Entity\Boutiques No errors.
App\Entity\Favoris No errors.
App\Entity\UserCode No errors.