https://mezghich.smart-it-partner.com/

Query Metrics

16 Database Queries
10 Different statements
12.91 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.