Query Metrics
94
Database Queries
5
Different statements
20.62 ms
Query time
3
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
12.55 ms (60.86%) |
80 |
SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.libelle AS libelle_3, t0.code_publication_id AS code_publication_id_4 FROM blog.fichier_publication t0 WHERE t0.code_publication_id = ?
Parameters:
[
49
]
|
|
2.97 ms (14.38%) |
11 |
SELECT t0.id AS id_1, t0.libelle_publication AS libelle_publication_2, t0.fichier AS fichier_3, t0.actif AS actif_4, t0.code_category_id AS code_category_id_5 FROM blog.publication t0 WHERE t0.code_category_id = ?
Parameters:
[
11
]
|
|
1.86 ms (9.00%) |
1 |
SELECT t0.id AS id_1, t0.numero_exploitant AS numero_exploitant_2, t0.raison_sociale_exploitant AS raison_sociale_exploitant_3, t0.qualite_exploitant AS qualite_exploitant_4, t0.marteau_exploitant AS marteau_exploitant_5, t0.adresse_exploitant AS adresse_exploitant_6, t0.tel_exploitant AS tel_exploitant_7, t0.ncc_exploitant AS ncc_exploitant_8, t0.sigle AS sigle_9, t0.datecreation AS datecreation_10, t0.forme_juridique AS forme_juridique_11, t0.capital AS capital_12, t0.rccim AS rccim_13, t0.situation_geographie AS situation_geographie_14, t0.mobile_exploitant AS mobile_exploitant_15, t0.email_info AS email_info_16, t0.fax AS fax_17, t0.nb_salarie AS nb_salarie_18, t0.ca AS ca_19, t0.gerant AS gerant_20, t0.personne_ressource AS personne_ressource_21, t0.email_personne_ressource AS email_personne_ressource_22, t0.mobile_personne_ressource AS mobile_personne_ressource_23, t0.export AS export_24, t0.code_exportateur AS code_exportateur_25, t0.created_at AS created_at_26, t0.created_by AS created_by_27, t0.updated_by AS updated_by_28, t0.updated_at AS updated_at_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.filiale_id AS filiale_id_33 FROM metier.exploitant t0
Parameters:
[] |
|
1.80 ms (8.72%) |
1 |
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.cloture AS cloture_3, t0.date_expiration_rallonge AS date_expiration_rallonge_4, t0.rallonge AS rallonge_5, t0.nb_mois AS nb_mois_6, t0.date_debut AS date_debut_7, t0.datefin AS datefin_8 FROM admin.exercice t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[] |
|
1.45 ms (7.03%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.code_groupe_id AS code_groupe_id_4 FROM blog.category_publication t0
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| alt | doctrine.dbal.alt_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.