Query Metrics
7
Database Queries
6
Different statements
3.51 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.56 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.payer AS payer_3, t0.livrer AS livrer_4, t0.sousmis AS sousmis_5, t0.coastlivraison AS coastlivraison_6, t0.montantht AS montantht_7, t0.montantttc AS montantttc_8, t0.livraisonpayer AS livraisonpayer_9, t0.tel AS tel_10, t0.destination AS destination_11, t0.user_id AS user_id_12, t0.ville_id AS ville_id_13, t0.couponcard_id AS couponcard_id_14, t0.contact_id AS contact_id_15, t0.service_id AS service_id_16 FROM panier t0 WHERE t0.id = ? AND t0.sousmis = ? LIMIT 1
Parameters:
[ 0 0 ] |
2 | 0.56 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.typeservice AS typeservice_2, c0_.description AS description_3, c0_.date AS date_4, c0_.rang AS rang_5, c0_.src AS src_6, c0_.alt AS alt_7, c0_.user_id AS user_id_8 FROM categorie c0_ WHERE c0_.typeservice LIKE ? OR c0_.typeservice LIKE ? ORDER BY c0_.rang ASC LIMIT 2
Parameters:
[ "%continue%" "%diplomante%" ] |
3 | 0.56 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.breve AS breve_4, t0.keyword AS keyword_5, t0.link AS link_6, t0.nomcompte AS nomcompte_7, t0.numcompte AS numcompte_8, t0.rang AS rang_9, t0.principal AS principal_10, t0.date AS date_11, t0.typearticle AS typearticle_12, t0.date_event AS date_event_13, t0.user_id AS user_id_14, t0.souscategorie_id AS souscategorie_id_15, t0.imgservice_id AS imgservice_id_16, t0.type_id AS type_id_17 FROM service t0 WHERE t0.typearticle = ? ORDER BY t0.rang ASC LIMIT 1
Parameters:
[
"aproposinstitut"
]
|
4 | 0.57 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.src AS src_3, t0.alt AS alt_4, t0.nbtele AS nbtele_5, t0.message AS message_6, t0.typedocument AS typedocument_7, t0.timestamp AS timestamp_8, t0.user_id AS user_id_9, t0.yourcv_id AS yourcv_id_10 FROM recrutement t0 WHERE t0.typedocument = ? ORDER BY t0.date DESC LIMIT 20
Parameters:
[
"depliant"
]
|
5 | 0.41 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.src AS src_3, t0.alt AS alt_4, t0.nbtele AS nbtele_5, t0.message AS message_6, t0.typedocument AS typedocument_7, t0.timestamp AS timestamp_8, t0.user_id AS user_id_9, t0.yourcv_id AS yourcv_id_10 FROM recrutement t0 WHERE t0.typedocument = ? ORDER BY t0.date DESC LIMIT 20
Parameters:
[
"planing"
]
|
6 | 0.49 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"aproposvideo"
]
|
7 | 0.37 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.breve AS breve_4, t0.keyword AS keyword_5, t0.link AS link_6, t0.nomcompte AS nomcompte_7, t0.numcompte AS numcompte_8, t0.rang AS rang_9, t0.principal AS principal_10, t0.date AS date_11, t0.typearticle AS typearticle_12, t0.date_event AS date_event_13, t0.user_id AS user_id_14, t0.souscategorie_id AS souscategorie_id_15, t0.imgservice_id AS imgservice_id_16, t0.type_id AS type_id_17 FROM service t0 WHERE t0.typearticle = ? AND t0.principal = ? ORDER BY t0.rang ASC LIMIT 20
Parameters:
[ "actualite" 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\Produit\Produit\Panier | No errors. |
App\Entity\Users\User\User | No errors. |
App\Entity\Produit\Service\Ville | No errors. |
App\Entity\Produit\Service\Couponcard | No errors. |
App\Entity\Users\User\Contacts | No errors. |
App\Entity\Produit\Service\Service | No errors. |
App\Entity\Produit\Produit\Categorie | No errors. |
App\Entity\Produit\Produit\Souscategorie | No errors. |
App\Entity\Produit\Service\Imgservice | No errors. |
App\Entity\Produit\Service\Typearticle | No errors. |
App\Entity\Produit\Service\Evenement | No errors. |
App\Entity\Produit\Service\Commentaireblog | No errors. |
App\Entity\Produit\Service\Ressourcearticle | No errors. |
App\Entity\Produit\Service\Recrutement | No errors. |
App\Entity\Produit\Service\Yourcv | No errors. |
App\Entity\Users\Adminuser\Parametreadmin | No errors. |