Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

47.06 ms Query time

12 Invalid entities

6012 Managed entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	1.60 ms	SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.custom_domain = ? LIMIT 1 Parameters: [`"gmc.tadkik.online"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.custom_domain = ? LIMIT 1 SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.custom_domain = 'gmc.tadkik.online' LIMIT 1;
2	0.47 ms	SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.subdomain = ? LIMIT 1 Parameters: [`"gmc"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.subdomain = ? LIMIT 1 SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.subdomain = 'gmc' LIMIT 1;
3	0.56 ms	SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.id = '1' LIMIT 1;

#▲

Time

Info

1.60 ms

SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.custom_domain = ? LIMIT 1

Parameters:

[
  "gmc.tadkik.online"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.subdomain AS subdomain_2,
  t0.custom_domain AS custom_domain_3,
  t0.organisation_name AS organisation_name_4,
  t0.db_name AS db_name_5,
  t0.driver_type AS driver_type_6,
  t0.db_user_name AS db_user_name_7,
  t0.db_password AS db_password_8,
  t0.db_host AS db_host_9,
  t0.db_port AS db_port_10,
  t0.database_status AS database_status_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted AS deleted_14,
  t0.deleted_at AS deleted_at_15
FROM
  tenant t0
WHERE
  t0.custom_domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.custom_domain = 'gmc.tadkik.online' LIMIT 1;

0.47 ms

SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.subdomain = ? LIMIT 1

Parameters:

[
  "gmc"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.subdomain AS subdomain_2,
  t0.custom_domain AS custom_domain_3,
  t0.organisation_name AS organisation_name_4,
  t0.db_name AS db_name_5,
  t0.driver_type AS driver_type_6,
  t0.db_user_name AS db_user_name_7,
  t0.db_password AS db_password_8,
  t0.db_host AS db_host_9,
  t0.db_port AS db_port_10,
  t0.database_status AS database_status_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted AS deleted_14,
  t0.deleted_at AS deleted_at_15
FROM
  tenant t0
WHERE
  t0.subdomain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.subdomain = 'gmc' LIMIT 1;

0.56 ms

SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.subdomain AS subdomain_2,
  t0.custom_domain AS custom_domain_3,
  t0.organisation_name AS organisation_name_4,
  t0.db_name AS db_name_5,
  t0.driver_type AS driver_type_6,
  t0.db_user_name AS db_user_name_7,
  t0.db_password AS db_password_8,
  t0.db_host AS db_host_9,
  t0.db_port AS db_port_10,
  t0.database_status AS database_status_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted AS deleted_14,
  t0.deleted_at AS deleted_at_15
FROM
  tenant t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.subdomain AS subdomain_2, t0.custom_domain AS custom_domain_3, t0.organisation_name AS organisation_name_4, t0.db_name AS db_name_5, t0.driver_type AS driver_type_6, t0.db_user_name AS db_user_name_7, t0.db_password AS db_password_8, t0.db_host AS db_host_9, t0.db_port AS db_port_10, t0.database_status AS database_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15 FROM tenant t0 WHERE t0.id = '1' LIMIT 1;

tenant connection

#▲	Time	Info
1	0.99 ms	SELECT t0.id AS id_1, t0.fullName AS fullName_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.tenant AS tenant_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.pseudo AS pseudo_14, t12.fonction AS fonction_15, t12.tauxHoraire AS tauxHoraire_16, t12.telephone AS telephone_17, t12.gender AS gender_18, t12.firstname AS firstname_19, t12.lastname AS lastname_20, t12.email AS email_21, t12.photoUrl AS photoUrl_22, t12.online AS online_23, t12.active AS active_24, t12.createdAt AS createdAt_25, t12.updatedAt AS updatedAt_26, t12.deleted AS deleted_27, t12.deletedAt AS deletedAt_28, t12.adresse AS adresse_29, t12.city AS city_30, t12.postalCode AS postalCode_31, t12.user_id AS user_id_32 FROM user t0 LEFT JOIN collaborateur t12 ON t12.user_id = t0.id WHERE t0.email = ? LIMIT 1 Parameters: [`"gmac@mail.com"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fullName AS fullName_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.tenant AS tenant_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.pseudo AS pseudo_14, t12.fonction AS fonction_15, t12.tauxHoraire AS tauxHoraire_16, t12.telephone AS telephone_17, t12.gender AS gender_18, t12.firstname AS firstname_19, t12.lastname AS lastname_20, t12.email AS email_21, t12.photoUrl AS photoUrl_22, t12.online AS online_23, t12.active AS active_24, t12.createdAt AS createdAt_25, t12.updatedAt AS updatedAt_26, t12.deleted AS deleted_27, t12.deletedAt AS deletedAt_28, t12.adresse AS adresse_29, t12.city AS city_30, t12.postalCode AS postalCode_31, t12.user_id AS user_id_32 FROM user t0 LEFT JOIN collaborateur t12 ON t12.user_id = t0.id WHERE t0.email = ? LIMIT 1 SELECT t0.id AS id_1, t0.fullName AS fullName_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.tenant AS tenant_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.pseudo AS pseudo_14, t12.fonction AS fonction_15, t12.tauxHoraire AS tauxHoraire_16, t12.telephone AS telephone_17, t12.gender AS gender_18, t12.firstname AS firstname_19, t12.lastname AS lastname_20, t12.email AS email_21, t12.photoUrl AS photoUrl_22, t12.online AS online_23, t12.active AS active_24, t12.createdAt AS createdAt_25, t12.updatedAt AS updatedAt_26, t12.deleted AS deleted_27, t12.deletedAt AS deletedAt_28, t12.adresse AS adresse_29, t12.city AS city_30, t12.postalCode AS postalCode_31, t12.user_id AS user_id_32 FROM user t0 LEFT JOIN collaborateur t12 ON t12.user_id = t0.id WHERE t0.email = 'gmac@mail.com' LIMIT 1;
2	42.64 ms	SELECT l0_.id AS id_0, l0_.content AS content_1, l0_.action AS action_2, l0_.entity AS entity_3, l0_.entityId AS entityId_4, l0_.level AS level_5, l0_.ipAddress AS ipAddress_6, l0_.metadata AS metadata_7, l0_.createdAt AS createdAt_8, l0_.updatedAt AS updatedAt_9, l0_.deleted AS deleted_10, l0_.deletedAt AS deletedAt_11, c1_.id AS id_12, c1_.pseudo AS pseudo_13, c1_.fonction AS fonction_14, c1_.tauxHoraire AS tauxHoraire_15, c1_.telephone AS telephone_16, c1_.gender AS gender_17, c1_.firstname AS firstname_18, c1_.lastname AS lastname_19, c1_.email AS email_20, c1_.photoUrl AS photoUrl_21, c1_.online AS online_22, c1_.active AS active_23, c1_.createdAt AS createdAt_24, c1_.updatedAt AS updatedAt_25, c1_.deleted AS deleted_26, c1_.deletedAt AS deletedAt_27, c1_.adresse AS adresse_28, c1_.city AS city_29, c1_.postalCode AS postalCode_30, m2_.id AS id_31, m2_.type AS type_32, m2_.dateDebut AS dateDebut_33, m2_.dateFin AS dateFin_34, m2_.situation AS situation_35, m2_.statut AS statut_36, m2_.espacelimit AS espacelimit_37, m2_.dueDate AS dueDate_38, m2_.beginDate AS beginDate_39, m2_.currency AS currency_40, m2_.createdAt AS createdAt_41, m2_.updatedAt AS updatedAt_42, m2_.deleted AS deleted_43, m2_.deletedAt AS deletedAt_44, l0_.col_id AS col_id_45, l0_.mission_id AS mission_id_46, c1_.user_id AS user_id_47, m2_.dossierType_id AS dossierType_id_48, m2_.company_id AS company_id_49, m2_.templat_id AS templat_id_50, m2_.mission_id AS mission_id_51, m2_.owner_id AS owner_id_52 FROM Logs l0_ LEFT JOIN collaborateur c1_ ON l0_.col_id = c1_.id LEFT JOIN mission m2_ ON l0_.mission_id = m2_.id ORDER BY l0_.createdAt DESC Parameters: [] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.content AS content_1, l0_.action AS action_2, l0_.entity AS entity_3, l0_.entityId AS entityId_4, l0_.level AS level_5, l0_.ipAddress AS ipAddress_6, l0_.metadata AS metadata_7, l0_.createdAt AS createdAt_8, l0_.updatedAt AS updatedAt_9, l0_.deleted AS deleted_10, l0_.deletedAt AS deletedAt_11, c1_.id AS id_12, c1_.pseudo AS pseudo_13, c1_.fonction AS fonction_14, c1_.tauxHoraire AS tauxHoraire_15, c1_.telephone AS telephone_16, c1_.gender AS gender_17, c1_.firstname AS firstname_18, c1_.lastname AS lastname_19, c1_.email AS email_20, c1_.photoUrl AS photoUrl_21, c1_.online AS online_22, c1_.active AS active_23, c1_.createdAt AS createdAt_24, c1_.updatedAt AS updatedAt_25, c1_.deleted AS deleted_26, c1_.deletedAt AS deletedAt_27, c1_.adresse AS adresse_28, c1_.city AS city_29, c1_.postalCode AS postalCode_30, m2_.id AS id_31, m2_.type AS type_32, m2_.dateDebut AS dateDebut_33, m2_.dateFin AS dateFin_34, m2_.situation AS situation_35, m2_.statut AS statut_36, m2_.espacelimit AS espacelimit_37, m2_.dueDate AS dueDate_38, m2_.beginDate AS beginDate_39, m2_.currency AS currency_40, m2_.createdAt AS createdAt_41, m2_.updatedAt AS updatedAt_42, m2_.deleted AS deleted_43, m2_.deletedAt AS deletedAt_44, l0_.col_id AS col_id_45, l0_.mission_id AS mission_id_46, c1_.user_id AS user_id_47, m2_.dossierType_id AS dossierType_id_48, m2_.company_id AS company_id_49, m2_.templat_id AS templat_id_50, m2_.mission_id AS mission_id_51, m2_.owner_id AS owner_id_52 FROM Logs l0_ LEFT JOIN collaborateur c1_ ON l0_.col_id = c1_.id LEFT JOIN mission m2_ ON l0_.mission_id = m2_.id ORDER BY l0_.createdAt DESC SELECT l0_.id AS id_0, l0_.content AS content_1, l0_.action AS action_2, l0_.entity AS entity_3, l0_.entityId AS entityId_4, l0_.level AS level_5, l0_.ipAddress AS ipAddress_6, l0_.metadata AS metadata_7, l0_.createdAt AS createdAt_8, l0_.updatedAt AS updatedAt_9, l0_.deleted AS deleted_10, l0_.deletedAt AS deletedAt_11, c1_.id AS id_12, c1_.pseudo AS pseudo_13, c1_.fonction AS fonction_14, c1_.tauxHoraire AS tauxHoraire_15, c1_.telephone AS telephone_16, c1_.gender AS gender_17, c1_.firstname AS firstname_18, c1_.lastname AS lastname_19, c1_.email AS email_20, c1_.photoUrl AS photoUrl_21, c1_.online AS online_22, c1_.active AS active_23, c1_.createdAt AS createdAt_24, c1_.updatedAt AS updatedAt_25, c1_.deleted AS deleted_26, c1_.deletedAt AS deletedAt_27, c1_.adresse AS adresse_28, c1_.city AS city_29, c1_.postalCode AS postalCode_30, m2_.id AS id_31, m2_.type AS type_32, m2_.dateDebut AS dateDebut_33, m2_.dateFin AS dateFin_34, m2_.situation AS situation_35, m2_.statut AS statut_36, m2_.espacelimit AS espacelimit_37, m2_.dueDate AS dueDate_38, m2_.beginDate AS beginDate_39, m2_.currency AS currency_40, m2_.createdAt AS createdAt_41, m2_.updatedAt AS updatedAt_42, m2_.deleted AS deleted_43, m2_.deletedAt AS deletedAt_44, l0_.col_id AS col_id_45, l0_.mission_id AS mission_id_46, c1_.user_id AS user_id_47, m2_.dossierType_id AS dossierType_id_48, m2_.company_id AS company_id_49, m2_.templat_id AS templat_id_50, m2_.mission_id AS mission_id_51, m2_.owner_id AS owner_id_52 FROM Logs l0_ LEFT JOIN collaborateur c1_ ON l0_.col_id = c1_.id LEFT JOIN mission m2_ ON l0_.mission_id = m2_.id ORDER BY l0_.createdAt DESC;
3	0.80 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.ref AS ref_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deleted AS deleted_7, t0.deletedAt AS deletedAt_8, t0.mission_id AS mission_id_9, t0.document_id AS document_id_10 FROM leadcomptable t0 WHERE t0.mission_id = ? Parameters: [`29`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.ref AS ref_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deleted AS deleted_7, t0.deletedAt AS deletedAt_8, t0.mission_id AS mission_id_9, t0.document_id AS document_id_10 FROM leadcomptable t0 WHERE t0.mission_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.ref AS ref_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deleted AS deleted_7, t0.deletedAt AS deletedAt_8, t0.mission_id AS mission_id_9, t0.document_id AS document_id_10 FROM leadcomptable t0 WHERE t0.mission_id = 29;

#▲

Time

Info

0.99 ms

SELECT t0.id AS id_1, t0.fullName AS fullName_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.tenant AS tenant_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.pseudo AS pseudo_14, t12.fonction AS fonction_15, t12.tauxHoraire AS tauxHoraire_16, t12.telephone AS telephone_17, t12.gender AS gender_18, t12.firstname AS firstname_19, t12.lastname AS lastname_20, t12.email AS email_21, t12.photoUrl AS photoUrl_22, t12.online AS online_23, t12.active AS active_24, t12.createdAt AS createdAt_25, t12.updatedAt AS updatedAt_26, t12.deleted AS deleted_27, t12.deletedAt AS deletedAt_28, t12.adresse AS adresse_29, t12.city AS city_30, t12.postalCode AS postalCode_31, t12.user_id AS user_id_32 FROM user t0 LEFT JOIN collaborateur t12 ON t12.user_id = t0.id WHERE t0.email = ? LIMIT 1

Parameters:

[
  "gmac@mail.com"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.fullName AS fullName_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.tenant AS tenant_7,
  t0.createdAt AS createdAt_8,
  t0.updatedAt AS updatedAt_9,
  t0.deleted AS deleted_10,
  t0.deletedAt AS deletedAt_11,
  t12.id AS id_13,
  t12.pseudo AS pseudo_14,
  t12.fonction AS fonction_15,
  t12.tauxHoraire AS tauxHoraire_16,
  t12.telephone AS telephone_17,
  t12.gender AS gender_18,
  t12.firstname AS firstname_19,
  t12.lastname AS lastname_20,
  t12.email AS email_21,
  t12.photoUrl AS photoUrl_22,
  t12.online AS online_23,
  t12.active AS active_24,
  t12.createdAt AS createdAt_25,
  t12.updatedAt AS updatedAt_26,
  t12.deleted AS deleted_27,
  t12.deletedAt AS deletedAt_28,
  t12.adresse AS adresse_29,
  t12.city AS city_30,
  t12.postalCode AS postalCode_31,
  t12.user_id AS user_id_32
FROM
  user t0
  LEFT JOIN collaborateur t12 ON t12.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fullName AS fullName_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.tenant AS tenant_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.pseudo AS pseudo_14, t12.fonction AS fonction_15, t12.tauxHoraire AS tauxHoraire_16, t12.telephone AS telephone_17, t12.gender AS gender_18, t12.firstname AS firstname_19, t12.lastname AS lastname_20, t12.email AS email_21, t12.photoUrl AS photoUrl_22, t12.online AS online_23, t12.active AS active_24, t12.createdAt AS createdAt_25, t12.updatedAt AS updatedAt_26, t12.deleted AS deleted_27, t12.deletedAt AS deletedAt_28, t12.adresse AS adresse_29, t12.city AS city_30, t12.postalCode AS postalCode_31, t12.user_id AS user_id_32 FROM user t0 LEFT JOIN collaborateur t12 ON t12.user_id = t0.id WHERE t0.email = 'gmac@mail.com' LIMIT 1;

42.64 ms

SELECT l0_.id AS id_0, l0_.content AS content_1, l0_.action AS action_2, l0_.entity AS entity_3, l0_.entityId AS entityId_4, l0_.level AS level_5, l0_.ipAddress AS ipAddress_6, l0_.metadata AS metadata_7, l0_.createdAt AS createdAt_8, l0_.updatedAt AS updatedAt_9, l0_.deleted AS deleted_10, l0_.deletedAt AS deletedAt_11, c1_.id AS id_12, c1_.pseudo AS pseudo_13, c1_.fonction AS fonction_14, c1_.tauxHoraire AS tauxHoraire_15, c1_.telephone AS telephone_16, c1_.gender AS gender_17, c1_.firstname AS firstname_18, c1_.lastname AS lastname_19, c1_.email AS email_20, c1_.photoUrl AS photoUrl_21, c1_.online AS online_22, c1_.active AS active_23, c1_.createdAt AS createdAt_24, c1_.updatedAt AS updatedAt_25, c1_.deleted AS deleted_26, c1_.deletedAt AS deletedAt_27, c1_.adresse AS adresse_28, c1_.city AS city_29, c1_.postalCode AS postalCode_30, m2_.id AS id_31, m2_.type AS type_32, m2_.dateDebut AS dateDebut_33, m2_.dateFin AS dateFin_34, m2_.situation AS situation_35, m2_.statut AS statut_36, m2_.espacelimit AS espacelimit_37, m2_.dueDate AS dueDate_38, m2_.beginDate AS beginDate_39, m2_.currency AS currency_40, m2_.createdAt AS createdAt_41, m2_.updatedAt AS updatedAt_42, m2_.deleted AS deleted_43, m2_.deletedAt AS deletedAt_44, l0_.col_id AS col_id_45, l0_.mission_id AS mission_id_46, c1_.user_id AS user_id_47, m2_.dossierType_id AS dossierType_id_48, m2_.company_id AS company_id_49, m2_.templat_id AS templat_id_50, m2_.mission_id AS mission_id_51, m2_.owner_id AS owner_id_52 FROM Logs l0_ LEFT JOIN collaborateur c1_ ON l0_.col_id = c1_.id LEFT JOIN mission m2_ ON l0_.mission_id = m2_.id ORDER BY l0_.createdAt DESC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  l0_.id AS id_0,
  l0_.content AS content_1,
  l0_.action AS action_2,
  l0_.entity AS entity_3,
  l0_.entityId AS entityId_4,
  l0_.level AS level_5,
  l0_.ipAddress AS ipAddress_6,
  l0_.metadata AS metadata_7,
  l0_.createdAt AS createdAt_8,
  l0_.updatedAt AS updatedAt_9,
  l0_.deleted AS deleted_10,
  l0_.deletedAt AS deletedAt_11,
  c1_.id AS id_12,
  c1_.pseudo AS pseudo_13,
  c1_.fonction AS fonction_14,
  c1_.tauxHoraire AS tauxHoraire_15,
  c1_.telephone AS telephone_16,
  c1_.gender AS gender_17,
  c1_.firstname AS firstname_18,
  c1_.lastname AS lastname_19,
  c1_.email AS email_20,
  c1_.photoUrl AS photoUrl_21,
  c1_.online AS online_22,
  c1_.active AS active_23,
  c1_.createdAt AS createdAt_24,
  c1_.updatedAt AS updatedAt_25,
  c1_.deleted AS deleted_26,
  c1_.deletedAt AS deletedAt_27,
  c1_.adresse AS adresse_28,
  c1_.city AS city_29,
  c1_.postalCode AS postalCode_30,
  m2_.id AS id_31,
  m2_.type AS type_32,
  m2_.dateDebut AS dateDebut_33,
  m2_.dateFin AS dateFin_34,
  m2_.situation AS situation_35,
  m2_.statut AS statut_36,
  m2_.espacelimit AS espacelimit_37,
  m2_.dueDate AS dueDate_38,
  m2_.beginDate AS beginDate_39,
  m2_.currency AS currency_40,
  m2_.createdAt AS createdAt_41,
  m2_.updatedAt AS updatedAt_42,
  m2_.deleted AS deleted_43,
  m2_.deletedAt AS deletedAt_44,
  l0_.col_id AS col_id_45,
  l0_.mission_id AS mission_id_46,
  c1_.user_id AS user_id_47,
  m2_.dossierType_id AS dossierType_id_48,
  m2_.company_id AS company_id_49,
  m2_.templat_id AS templat_id_50,
  m2_.mission_id AS mission_id_51,
  m2_.owner_id AS owner_id_52
FROM
  Logs l0_
  LEFT JOIN collaborateur c1_ ON l0_.col_id = c1_.id
  LEFT JOIN mission m2_ ON l0_.mission_id = m2_.id
ORDER BY
  l0_.createdAt DESC

SELECT l0_.id AS id_0, l0_.content AS content_1, l0_.action AS action_2, l0_.entity AS entity_3, l0_.entityId AS entityId_4, l0_.level AS level_5, l0_.ipAddress AS ipAddress_6, l0_.metadata AS metadata_7, l0_.createdAt AS createdAt_8, l0_.updatedAt AS updatedAt_9, l0_.deleted AS deleted_10, l0_.deletedAt AS deletedAt_11, c1_.id AS id_12, c1_.pseudo AS pseudo_13, c1_.fonction AS fonction_14, c1_.tauxHoraire AS tauxHoraire_15, c1_.telephone AS telephone_16, c1_.gender AS gender_17, c1_.firstname AS firstname_18, c1_.lastname AS lastname_19, c1_.email AS email_20, c1_.photoUrl AS photoUrl_21, c1_.online AS online_22, c1_.active AS active_23, c1_.createdAt AS createdAt_24, c1_.updatedAt AS updatedAt_25, c1_.deleted AS deleted_26, c1_.deletedAt AS deletedAt_27, c1_.adresse AS adresse_28, c1_.city AS city_29, c1_.postalCode AS postalCode_30, m2_.id AS id_31, m2_.type AS type_32, m2_.dateDebut AS dateDebut_33, m2_.dateFin AS dateFin_34, m2_.situation AS situation_35, m2_.statut AS statut_36, m2_.espacelimit AS espacelimit_37, m2_.dueDate AS dueDate_38, m2_.beginDate AS beginDate_39, m2_.currency AS currency_40, m2_.createdAt AS createdAt_41, m2_.updatedAt AS updatedAt_42, m2_.deleted AS deleted_43, m2_.deletedAt AS deletedAt_44, l0_.col_id AS col_id_45, l0_.mission_id AS mission_id_46, c1_.user_id AS user_id_47, m2_.dossierType_id AS dossierType_id_48, m2_.company_id AS company_id_49, m2_.templat_id AS templat_id_50, m2_.mission_id AS mission_id_51, m2_.owner_id AS owner_id_52 FROM Logs l0_ LEFT JOIN collaborateur c1_ ON l0_.col_id = c1_.id LEFT JOIN mission m2_ ON l0_.mission_id = m2_.id ORDER BY l0_.createdAt DESC;

0.80 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.ref AS ref_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deleted AS deleted_7, t0.deletedAt AS deletedAt_8, t0.mission_id AS mission_id_9, t0.document_id AS document_id_10 FROM leadcomptable t0 WHERE t0.mission_id = ?

Parameters:

[
  29
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.ref AS ref_4,
  t0.createdAt AS createdAt_5,
  t0.updatedAt AS updatedAt_6,
  t0.deleted AS deleted_7,
  t0.deletedAt AS deletedAt_8,
  t0.mission_id AS mission_id_9,
  t0.document_id AS document_id_10
FROM
  leadcomptable t0
WHERE
  t0.mission_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.ref AS ref_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deleted AS deleted_7, t0.deletedAt AS deletedAt_8, t0.mission_id AS mission_id_9, t0.document_id AS document_id_10 FROM leadcomptable t0 WHERE t0.mission_id = 29;

Database Connections

Name	Service
tenant	doctrine.dbal.tenant_connection
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
tenant	doctrine.orm.tenant_entity_manager
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

tenant entity manager

Class	Amount of managed objects
App\Entity\Tenant\Logs	5978
App\Entity\Tenant\User	14
App\Entity\Tenant\Collaborateur	14
App\Entity\Tenant\Mission	1
App\Entity\Tenant\DossierType	1
App\Entity\Tenant\Company	1
App\Entity\Tenant\WorkPlan	1
App\Entity\Tenant\Lead	1

default entity manager

Class	Amount of managed objects
App\Entity\Main\Tenant	1

Entities Mapping

tenant entity manager

Class	Mapping errors
App\Entity\Tenant\User	No errors.
App\Entity\Tenant\Collaborateur	No errors.
App\Entity\Tenant\MissionMembers	No errors.
App\Entity\Tenant\TimeSheet	The field 'App\Entity\Tenant\TimeSheet#navigation' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Tenant\InherentRisk	No errors.
App\Entity\Tenant\ControlRisk	No errors.
App\Entity\Tenant\FraudRisk	No errors.
App\Entity\Tenant\Findings	No errors.
App\Entity\Tenant\ReviewNote	The mappings App\Entity\Tenant\ReviewNote#toCollaborator and App\Entity\Tenant\Collaborateur#reviewNotes are inconsistent with each other.
App\Entity\Tenant\ReviewNoteResponse	No errors.
App\Entity\Tenant\Notification	No errors.
App\Entity\Tenant\TimeBudget	The field 'App\Entity\Tenant\TimeBudget#duration' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Tenant\Documents	The association App\Entity\Tenant\Documents#processResumEntretien refers to the inverse side field App\Entity\Tenant\Process#ResumEntretien which does not exist. The association App\Entity\Tenant\Documents#processDescription refers to the inverse side field App\Entity\Tenant\Process#Description which does not exist.
App\Entity\Tenant\Participant	No errors.
App\Entity\Tenant\Message	No errors.
App\Entity\Tenant\TasksMission	The field 'App\Entity\Tenant\TasksMission#progress' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Tenant\Logs	The field 'App\Entity\Tenant\Logs#entityId' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Tenant\DocumentRequestEmail	No errors.
App\Entity\Tenant\Mission	The mappings App\Entity\Tenant\Mission#EtatsFinanciers and App\Entity\Tenant\MissionEtatsFinanciers#mission are inconsistent with each other.
App\Entity\Tenant\DossierType	No errors.
App\Entity\Tenant\Company	No errors.
App\Entity\Tenant\WorkPlan	No errors.
App\Entity\Tenant\Lead	No errors.
App\Entity\Tenant\Balance	The field 'App\Entity\Tenant\Balance#sum' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Tenant\Compte	The field 'App\Entity\Tenant\Compte#soldeN' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Compte#soldeNAfter' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Compte#soldeI' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Compte#soldeN1' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Compte#variationAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Compte#variationAmountAfter' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Compte#variationPourcentage' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Compte#variationPourcentageAfter' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Compte#soldeAjs' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Tenant\SectionsMission	No errors.
App\Entity\Tenant\RiskAssessment	No errors.
App\Entity\Tenant\Process	No errors.
App\Entity\Tenant\AdjustmentEntry	No errors.
App\Entity\Tenant\AccountControlTest	No errors.
App\Entity\Tenant\PointsFollowUp	No errors.
App\Entity\Tenant\MissionEtatsFinanciers	The field 'App\Entity\Tenant\MissionEtatsFinanciers#soldeN' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\MissionEtatsFinanciers#soldeI' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\MissionEtatsFinanciers#soldeN1' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\MissionEtatsFinanciers#soldeNAfter' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\MissionEtatsFinanciers#soldeIAfter' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\MissionEtatsFinanciers#soldeN1After' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The association App\Entity\Tenant\MissionEtatsFinanciers#mission refers to the inverse side field App\Entity\Tenant\Mission#etatsFinanciers which does not exist.
App\Entity\Tenant\WorkProgram	No errors.
App\Entity\Tenant\Seuil	No errors.
App\Entity\Tenant\MissionExtraCharge	The field 'App\Entity\Tenant\MissionExtraCharge#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Tenant\Facture	The field 'App\Entity\Tenant\Facture#priceHt' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Facture#priceTtc' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Facture#tva' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Facture#discount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Facture#totalTva' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tenant\Facture#totalAdv' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Tenant\MissionEtfDocs	No errors.
App\Entity\Tenant\Conversation	No errors.

default entity manager

Class	Mapping errors
App\Entity\Main\Tenant	No errors.
App\Entity\Main\Support	No errors.

Symfony Profiler

GET https://gmc.tadkik.online/app/api/logs/all

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

tenant connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

tenant entity manager

default entity manager

Entities Mapping

tenant entity manager

default entity manager