Query Metrics
16
Database Queries
10
Different statements
12.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.85 ms (29.81%) |
7 |
SELECT t0.id AS id_1, t0.fullname AS fullname_2, t0.type AS type_3, t0.titleofsubject AS titleofsubject_4, t0.datedebut AS datedebut_5, t0.datefin AS datefin_6, t0.email AS email_7, t0.telephone AS telephone_8, t0.lien AS lien_9 FROM encadrement t0 INNER JOIN publication_encadrement ON t0.id = publication_encadrement.encadrement_id WHERE publication_encadrement.publication_id = ?
Parameters:
[
7
]
|
|
1.77 ms (13.71%) |
1 |
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.lienfb AS lienfb_3, t0.lienyoutube AS lienyoutube_4, t0.lienlikedin AS lienlikedin_5, t0.icon AS icon_6, t0.github AS github_7, t0.reaserach_gate AS reaserach_gate_8, t0.dblp AS dblp_9, t0.biographie AS biographie_10, t0.titre AS titre_11, t0.email AS email_12, t0.telph AS telph_13, t0.adresse AS adresse_14, t0.about AS about_15, t0.encadrement AS encadrement_16, t0.certification AS certification_17, t0.temoignage AS temoignage_18, t0.contact AS contact_19, t0.nbencadrementpfemaster AS nbencadrementpfemaster_20, t0.nbencadrementthese AS nbencadrementthese_21, t0.nbconference AS nbconference_22, t0.nbrevues AS nbrevues_23, t0.faits AS faits_24, t0.skills AS skills_25, t0.resume AS resume_26, t0.summaryfullname AS summaryfullname_27, t0.summaryabout AS summaryabout_28, t0.summaryplace AS summaryplace_29, t0.summarymobile AS summarymobile_30, t0.summaryemail AS summaryemail_31 FROM configuration t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
1.63 ms (12.59%) |
1 |
SELECT t0.id AS id_1, t0.degree AS degree_2, t0.time AS time_3, t0.institute AS institute_4, t0.description AS description_5 FROM education t0 ORDER BY t0.id DESC
Parameters:
[] |
|
1.11 ms (8.58%) |
1 |
SELECT t0.id AS id_1, t0.fullname AS fullname_2, t0.type AS type_3, t0.titleofsubject AS titleofsubject_4, t0.datedebut AS datedebut_5, t0.datefin AS datefin_6, t0.email AS email_7, t0.telephone AS telephone_8, t0.lien AS lien_9 FROM encadrement t0
Parameters:
[] |
|
1.03 ms (7.99%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description1 AS description1_3, t0.birthday AS birthday_4, t0.website AS website_5, t0.phone AS phone_6, t0.city AS city_7, t0.age AS age_8, t0.degree AS degree_9, t0.email AS email_10, t0.freelance AS freelance_11, t0.description2 AS description2_12, t0.photo AS photo_13 FROM apropos t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.87 ms (6.73%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.photo AS photo_3, t0.lien AS lien_4 FROM certification t0
Parameters:
[] |
|
0.78 ms (6.03%) |
1 |
SELECT t0.id AS id_1, t0.fullname AS fullname_2, t0.travail AS travail_3, t0.photo AS photo_4, t0.description AS description_5 FROM temoignage t0
Parameters:
[] |
|
0.68 ms (5.27%) |
1 |
SELECT t0.id AS id_1, t0.poste AS poste_2, t0.time AS time_3, t0.company AS company_4, t0.task1 AS task1_5, t0.task2 AS task2_6, t0.task3 AS task3_7, t0.task4 AS task4_8 FROM experience t0 ORDER BY t0.id DESC
Parameters:
[] |
|
0.63 ms (4.90%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.booktitle AS booktitle_3, t0.pages AS pages_4, t0.year AS year_5, t0.organization AS organization_6 FROM publication t0 ORDER BY t0.year DESC
Parameters:
[] |
|
0.57 ms (4.40%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.pourcentage AS pourcentage_3 FROM skills t0
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 |
|---|---|
| App\Entity\Configuration | No errors. |
| App\Entity\Apropos | No errors. |
| App\Entity\Certification | No errors. |
| App\Entity\Encadrement | No errors. |
| App\Entity\Publication | No errors. |
| App\Entity\Temoignage | No errors. |
| App\Entity\Skills | No errors. |
| App\Entity\Experience | No errors. |
| App\Entity\Education | No errors. |