http://maroc-dattes.org/index/

Query Metrics

5 Database Queries
5 Different statements
4.57 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.19 ms
SELECT t0.id AS id_1, t0.designation_fr AS designation_fr_2, t0.designation_ar AS designation_ar_3 FROM categorie t0
Parameters:
[]
2 0.70 ms
SELECT t0.id AS id_1, t0.designation_fr AS designation_fr_2, t0.designation_ar AS designation_ar_3, t0.province_id AS province_id_4 FROM commune t0
Parameters:
[]
3 0.73 ms
SELECT t0.id AS id_1, t0.designation_fr AS designation_fr_2, t0.designation_ar AS designation_ar_3, t0.singe_fr AS singe_fr_4, t0.singe_ar AS singe_ar_5, t0.image AS image_6, t0.prix AS prix_7 FROM variete t0
Parameters:
[]
4 1.27 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.created AS created_3, t0.daterecolte AS daterecolte_4, t0.expired AS expired_5, t0.is_active AS is_active_6, t0.is_vendu AS is_vendu_7, t0.is_autorise AS is_autorise_8, t0.is_igp AS is_igp_9, t0.is_bio AS is_bio_10, t0.quantite AS quantite_11, t0.unite_id AS unite_id_12, t0.province_id AS province_id_13, t0.commune_id AS commune_id_14, t0.categorie_id AS categorie_id_15, t0.variete_id AS variete_id_16, t0.fournisseur_id AS fournisseur_id_17 FROM offre t0 WHERE t0.is_active = ? AND t0.is_vendu = ? ORDER BY t0.created DESC LIMIT 8
Parameters:
[
  1
  0
]
5 0.68 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_ar AS titre_ar_3, t0.description_fr AS description_fr_4, t0.description_ar AS description_ar_5, t0.image AS image_6, t0.created AS created_7 FROM actualite t0 ORDER BY t0.created DESC LIMIT 3
Parameters:
[]

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
AdminBundle\Entity\Categorie No errors.
AdminBundle\Entity\Commune No errors.
AdminBundle\Entity\Province
  • The association AdminBundle\Entity\Province#communes refers to the owning side field AdminBundle\Entity\Province#province which does not exist.
AdminBundle\Entity\Variete No errors.
FournisseurBundle\Entity\Offre No errors.
AdminBundle\Entity\Unite No errors.
FOS\UserBundle\Model\User No errors.
AdminBundle\Entity\User No errors.
AdminBundle\Entity\Actualite No errors.