Query Metrics
8
Database Queries
8
Different statements
5.64 ms
Query time
0
Invalid entities
Grouped Statements
admin connection
| Time▼ | Count | Info |
|---|---|---|
|
0.63 ms (11.17%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.id_role AS id_role_4, t0.password AS password_5, t0.id_tiers AS id_tiers_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.password_requested_at AS password_requested_at_11, t0.token AS token_12, t0.avatar_user AS avatar_user_13, t0.theme_user AS theme_user_14, t0.is_active AS is_active_15, t0.workflow_column_preferences AS workflow_column_preferences_16, t0.tiers_id AS tiers_id_17 FROM user t0 WHERE t0.id = ?
Parameters:
[
10
]
|
dev connection
| Time▼ | Count | Info |
|---|---|---|
|
0.72 ms (12.73%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.id_role AS id_role_4, t0.password AS password_5, t0.id_tiers AS id_tiers_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.password_requested_at AS password_requested_at_11, t0.token AS token_12, t0.avatar_user AS avatar_user_13, t0.theme_user AS theme_user_14, t0.is_active AS is_active_15, t0.workflow_column_preferences AS workflow_column_preferences_16, t0.tiers_id AS tiers_id_17 FROM user t0 WHERE t0.id = ?
Parameters:
[
10
]
|
gunsmoke connection
| Time▼ | Count | Info |
|---|---|---|
|
0.85 ms (15.11%) |
1 |
SELECT t0.id AS id_1, t0.num_prod AS num_prod_2, t0.num_administratif AS num_administratif_3, t0.lib_projet AS lib_projet_4, t0.type_projet AS type_projet_5, t0.date_deb AS date_deb_6, t0.date_fin AS date_fin_7, t0.date_crea AS date_crea_8, t0.user_crea AS user_crea_9, t0.date_modif AS date_modif_10, t0.user_modif AS user_modif_11, t0.is_active AS is_active_12, t0.commentaire AS commentaire_13, t0.is_appel_offre AS is_appel_offre_14, t0.societe_id AS societe_id_15, t0.producteur_id AS producteur_id_16, t0.tiers_id AS tiers_id_17, t0.statut_id AS statut_id_18 FROM projet t0 WHERE t0.id = ?
Parameters:
[
362
]
|
|
0.78 ms (13.83%) |
1 |
SELECT t0.id AS id_1, t0.tarif_jour AS tarif_jour_2, t0.type_salarie AS type_salarie_3, t0.date_naissance AS date_naissance_4, t0.lieu_naissance AS lieu_naissance_5, t0.situation_familiale AS situation_familiale_6, t0.nationalite AS nationalite_7, t0.num_secu_sociale AS num_secu_sociale_8, t0.num_conges_spectacle AS num_conges_spectacle_9, t0.num_carte_sejour AS num_carte_sejour_10, t0.num_carte_presse AS num_carte_presse_11, t0.date_visite_medicale AS date_visite_medicale_12, t0.statut_cadre AS statut_cadre_13, t0.nb_enfant AS nb_enfant_14, t0.iban AS iban_15, t0.fonction AS fonction_16, t0.date_modif AS date_modif_17, t0.user_modif AS user_modif_18, t0.date_crea AS date_crea_19, t0.user_crea AS user_crea_20, t21.id AS id_22, t21.nom_tiers AS nom_tiers_23, t21.prenom_tiers AS prenom_tiers_24, t21.tel_fixe_tiers AS tel_fixe_tiers_25, t21.tel_portable_tiers AS tel_portable_tiers_26, t21.email_tiers AS email_tiers_27, t21.commentaire_tiers AS commentaire_tiers_28, t21.date_crea AS date_crea_29, t21.user_crea AS user_crea_30, t21.date_modif AS date_modif_31, t21.user_modif AS user_modif_32, t21.is_active AS is_active_33, t21.id_type_tiers AS id_type_tiers_34, t21.info_salarie_id AS info_salarie_id_35 FROM info_salarie t0 LEFT JOIN tiers t21 ON t21.info_salarie_id = t0.id WHERE t0.id = ?
Parameters:
[
744
]
|
|
0.76 ms (13.49%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.id_role AS id_role_4, t0.password AS password_5, t0.id_tiers AS id_tiers_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.password_requested_at AS password_requested_at_11, t0.token AS token_12, t0.avatar_user AS avatar_user_13, t0.theme_user AS theme_user_14, t0.is_active AS is_active_15, t0.workflow_column_preferences AS workflow_column_preferences_16, t0.tiers_id AS tiers_id_17 FROM user t0 WHERE t0.id = ?
Parameters:
[
10
]
|
|
0.65 ms (11.50%) |
1 |
SELECT t0.id AS id_1, t0.nom_tiers AS nom_tiers_2, t0.prenom_tiers AS prenom_tiers_3, t0.tel_fixe_tiers AS tel_fixe_tiers_4, t0.tel_portable_tiers AS tel_portable_tiers_5, t0.email_tiers AS email_tiers_6, t0.commentaire_tiers AS commentaire_tiers_7, t0.date_crea AS date_crea_8, t0.user_crea AS user_crea_9, t0.date_modif AS date_modif_10, t0.user_modif AS user_modif_11, t0.is_active AS is_active_12, t0.id_type_tiers AS id_type_tiers_13, t14.id AS id_15, t14.email AS email_16, t14.roles AS roles_17, t14.id_role AS id_role_18, t14.password AS password_19, t14.id_tiers AS id_tiers_20, t14.date_crea AS date_crea_21, t14.user_crea AS user_crea_22, t14.date_modif AS date_modif_23, t14.user_modif AS user_modif_24, t14.password_requested_at AS password_requested_at_25, t14.token AS token_26, t14.avatar_user AS avatar_user_27, t14.theme_user AS theme_user_28, t14.is_active AS is_active_29, t14.workflow_column_preferences AS workflow_column_preferences_30, t14.tiers_id AS tiers_id_31, t0.info_salarie_id AS info_salarie_id_32 FROM tiers t0 LEFT JOIN user t14 ON t14.tiers_id = t0.id WHERE t0.id = ?
Parameters:
[
1788
]
|
|
0.63 ms (11.24%) |
1 |
SELECT t0.id AS id_1, t0.lib_adresse AS lib_adresse_2, t0.ligne_1 AS ligne_1_3, t0.ligne_2 AS ligne_2_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.tiers_id AS tiers_id_8, t0.societe_id AS societe_id_9 FROM adresse t0 WHERE t0.tiers_id = ?
Parameters:
[
1788
]
|
|
0.62 ms (10.94%) |
1 |
SELECT t0.id AS id_1, t0.nb_jour_pointage AS nb_jour_pointage_2, t0.tarif_jour AS tarif_jour_3, t0.charge AS charge_4, t0.heure_par_jour AS heure_par_jour_5, t0.liste_date_pointage AS liste_date_pointage_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.id_signature_elec AS id_signature_elec_11, t0.id_statut_signature_elec AS id_statut_signature_elec_12, t0.description AS description_13, t0.mois AS mois_14, t0.annee AS annee_15, t0.id_projet AS id_projet_16, t0.date_urssaf AS date_urssaf_17, t0.statut_urssaf AS statut_urssaf_18, t0.salarie_id AS salarie_id_19 FROM contrat t0 WHERE t0.id = ?
Parameters:
[
"947"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| admin | doctrine.dbal.admin_connection |
| dev | doctrine.dbal.dev_connection |
| gunsmoke | doctrine.dbal.gunsmoke_connection |
| foodandcurious | doctrine.dbal.foodandcurious_connection |
| butterjam | doctrine.dbal.butterjam_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| admin | doctrine.orm.admin_entity_manager |
| dev | doctrine.orm.dev_entity_manager |
| gunsmoke | doctrine.orm.gunsmoke_entity_manager |
| foodandcurious | doctrine.orm.foodandcurious_entity_manager |
| butterjam | doctrine.orm.butterjam_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
No loaded entities.
admin entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Tiers | No errors. |
dev entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Tiers | No errors. |
gunsmoke entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Tiers | No errors. |
| App\Entity\Contrat | No errors. |
| App\Entity\InfoSalarie | No errors. |
| App\Entity\Adresse | No errors. |
| App\Entity\Societe | No errors. |
| App\Entity\Projet | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\LdvStatutProjet | No errors. |
foodandcurious entity manager
No loaded entities.
butterjam entity manager
No loaded entities.