Query Metrics
5
Database Queries
5
Different statements
4.57 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.27 ms (27.76%) |
1 |
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 ] |
1.19 ms (26.09%) |
1 |
SELECT t0.id AS id_1, t0.designation_fr AS designation_fr_2, t0.designation_ar AS designation_ar_3 FROM categorie t0
Parameters:
[] |
0.73 ms (15.87%) |
1 |
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:
[] |
0.70 ms (15.28%) |
1 |
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:
[] |
0.68 ms (15.00%) |
1 |
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 |
|
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. |