Symfony Profiler

Query Metrics

17 Database Queries

10 Different statements

33.43 ms Query time

5 Invalid entities

135 Managed entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	1.50 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	11.36 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	11.88 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.50 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;

11.36 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;

11.88 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


SELECT t0.id AS id_1, t0.type AS type_2, t0.dateDebut AS dateDebut_3, t0.dateFin AS dateFin_4, t0.situation AS situation_5, t0.statut AS statut_6, t0.espacelimit AS espacelimit_7, t0.dueDate AS dueDate_8, t0.beginDate AS beginDate_9, t0.currency AS currency_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deleted AS deleted_13, t0.deletedAt AS deletedAt_14, t0.dossierType_id AS dossierType_id_15, t0.company_id AS company_id_16, t0.templat_id AS templat_id_17, t18.id AS id_19, t18.name AS name_20, t18.status AS status_21, t18.ref AS ref_22, t18.createdAt AS createdAt_23, t18.updatedAt AS updatedAt_24, t18.deleted AS deleted_25, t18.deletedAt AS deletedAt_26, t18.mission_id AS mission_id_27, t18.document_id AS document_id_28, t0.mission_id AS mission_id_29, t0.owner_id AS owner_id_30, t31.id AS id_32, t31.type AS type_33, t31.dateDebut AS dateDebut_34, t31.dateFin AS dateFin_35, t31.situation AS situation_36, t31.statut AS statut_37, t31.espacelimit AS espacelimit_38, t31.dueDate AS dueDate_39, t31.beginDate AS beginDate_40, t31.currency AS currency_41, t31.createdAt AS createdAt_42, t31.updatedAt AS updatedAt_43, t31.deleted AS deleted_44, t31.deletedAt AS deletedAt_45, t31.dossierType_id AS dossierType_id_46, t31.company_id AS company_id_47, t31.templat_id AS templat_id_48, t31.mission_id AS mission_id_49, t31.owner_id AS owner_id_50 FROM mission t0 LEFT JOIN leadcomptable t18 ON t18.mission_id = t0.id LEFT JOIN mission t31 ON t31.mission_id = t0.id WHERE t0.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 = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.dateDebut AS dateDebut_3, t0.dateFin AS dateFin_4, t0.situation AS situation_5, t0.statut AS statut_6, t0.espacelimit AS espacelimit_7, t0.dueDate AS dueDate_8, t0.beginDate AS beginDate_9, t0.currency AS currency_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deleted AS deleted_13, t0.deletedAt AS deletedAt_14, t0.dossierType_id AS dossierType_id_15, t0.company_id AS company_id_16, t0.templat_id AS templat_id_17, t18.id AS id_19, t18.name AS name_20, t18.status AS status_21, t18.ref AS ref_22, t18.createdAt AS createdAt_23, t18.updatedAt AS updatedAt_24, t18.deleted AS deleted_25, t18.deletedAt AS deletedAt_26, t18.mission_id AS mission_id_27, t18.document_id AS document_id_28, t0.mission_id AS mission_id_29, t0.owner_id AS owner_id_30, t31.id AS id_32, t31.type AS type_33, t31.dateDebut AS dateDebut_34, t31.dateFin AS dateFin_35, t31.situation AS situation_36, t31.statut AS statut_37, t31.espacelimit AS espacelimit_38, t31.dueDate AS dueDate_39, t31.beginDate AS beginDate_40, t31.currency AS currency_41, t31.createdAt AS createdAt_42, t31.updatedAt AS updatedAt_43, t31.deleted AS deleted_44, t31.deletedAt AS deletedAt_45, t31.dossierType_id AS dossierType_id_46, t31.company_id AS company_id_47, t31.templat_id AS templat_id_48, t31.mission_id AS mission_id_49, t31.owner_id AS owner_id_50 FROM mission t0 LEFT JOIN leadcomptable t18 ON t18.mission_id = t0.id LEFT JOIN mission t31 ON t31.mission_id = t0.id WHERE t0.mission_id = ?
SELECT t0.id AS id_1, t0.description AS description_2, t0.anomalyType AS anomalyType_3, t0.riskType AS riskType_4, t0.riskLevel AS riskLevel_5, t0.type AS type_6, t0.rtype AS rtype_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12, t0.processControlTest_id AS processControlTest_id_13, t0.process_id AS process_id_14, t0.cycle_id AS cycle_id_15, t0.accountControlTest_id AS accountControlTest_id_16, t0.collaborator_id AS collaborator_id_17 FROM findings t0 WHERE t0.mission_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.cIndex AS cIndex_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deleted AS deleted_6, t0.deletedAt AS deletedAt_7, t0.dossiertype_id AS dossiertype_id_8 FROM cycledossiertype t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = ?

#▲	Time	Info
1	1.40 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.dateDebut AS dateDebut_3, t0.dateFin AS dateFin_4, t0.situation AS situation_5, t0.statut AS statut_6, t0.espacelimit AS espacelimit_7, t0.dueDate AS dueDate_8, t0.beginDate AS beginDate_9, t0.currency AS currency_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deleted AS deleted_13, t0.deletedAt AS deletedAt_14, t0.dossierType_id AS dossierType_id_15, t0.company_id AS company_id_16, t0.templat_id AS templat_id_17, t18.id AS id_19, t18.name AS name_20, t18.status AS status_21, t18.ref AS ref_22, t18.createdAt AS createdAt_23, t18.updatedAt AS updatedAt_24, t18.deleted AS deleted_25, t18.deletedAt AS deletedAt_26, t18.mission_id AS mission_id_27, t18.document_id AS document_id_28, t0.mission_id AS mission_id_29, t0.owner_id AS owner_id_30, t31.id AS id_32, t31.type AS type_33, t31.dateDebut AS dateDebut_34, t31.dateFin AS dateFin_35, t31.situation AS situation_36, t31.statut AS statut_37, t31.espacelimit AS espacelimit_38, t31.dueDate AS dueDate_39, t31.beginDate AS beginDate_40, t31.currency AS currency_41, t31.createdAt AS createdAt_42, t31.updatedAt AS updatedAt_43, t31.deleted AS deleted_44, t31.deletedAt AS deletedAt_45, t31.dossierType_id AS dossierType_id_46, t31.company_id AS company_id_47, t31.templat_id AS templat_id_48, t31.mission_id AS mission_id_49, t31.owner_id AS owner_id_50 FROM mission t0 LEFT JOIN leadcomptable t18 ON t18.mission_id = t0.id LEFT JOIN mission t31 ON t31.mission_id = t0.id WHERE t0.id = ? Parameters: [`29`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.dateDebut AS dateDebut_3, t0.dateFin AS dateFin_4, t0.situation AS situation_5, t0.statut AS statut_6, t0.espacelimit AS espacelimit_7, t0.dueDate AS dueDate_8, t0.beginDate AS beginDate_9, t0.currency AS currency_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deleted AS deleted_13, t0.deletedAt AS deletedAt_14, t0.dossierType_id AS dossierType_id_15, t0.company_id AS company_id_16, t0.templat_id AS templat_id_17, t18.id AS id_19, t18.name AS name_20, t18.status AS status_21, t18.ref AS ref_22, t18.createdAt AS createdAt_23, t18.updatedAt AS updatedAt_24, t18.deleted AS deleted_25, t18.deletedAt AS deletedAt_26, t18.mission_id AS mission_id_27, t18.document_id AS document_id_28, t0.mission_id AS mission_id_29, t0.owner_id AS owner_id_30, t31.id AS id_32, t31.type AS type_33, t31.dateDebut AS dateDebut_34, t31.dateFin AS dateFin_35, t31.situation AS situation_36, t31.statut AS statut_37, t31.espacelimit AS espacelimit_38, t31.dueDate AS dueDate_39, t31.beginDate AS beginDate_40, t31.currency AS currency_41, t31.createdAt AS createdAt_42, t31.updatedAt AS updatedAt_43, t31.deleted AS deleted_44, t31.deletedAt AS deletedAt_45, t31.dossierType_id AS dossierType_id_46, t31.company_id AS company_id_47, t31.templat_id AS templat_id_48, t31.mission_id AS mission_id_49, t31.owner_id AS owner_id_50 FROM mission t0 LEFT JOIN leadcomptable t18 ON t18.mission_id = t0.id LEFT JOIN mission t31 ON t31.mission_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.type AS type_2, t0.dateDebut AS dateDebut_3, t0.dateFin AS dateFin_4, t0.situation AS situation_5, t0.statut AS statut_6, t0.espacelimit AS espacelimit_7, t0.dueDate AS dueDate_8, t0.beginDate AS beginDate_9, t0.currency AS currency_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deleted AS deleted_13, t0.deletedAt AS deletedAt_14, t0.dossierType_id AS dossierType_id_15, t0.company_id AS company_id_16, t0.templat_id AS templat_id_17, t18.id AS id_19, t18.name AS name_20, t18.status AS status_21, t18.ref AS ref_22, t18.createdAt AS createdAt_23, t18.updatedAt AS updatedAt_24, t18.deleted AS deleted_25, t18.deletedAt AS deletedAt_26, t18.mission_id AS mission_id_27, t18.document_id AS document_id_28, t0.mission_id AS mission_id_29, t0.owner_id AS owner_id_30, t31.id AS id_32, t31.type AS type_33, t31.dateDebut AS dateDebut_34, t31.dateFin AS dateFin_35, t31.situation AS situation_36, t31.statut AS statut_37, t31.espacelimit AS espacelimit_38, t31.dueDate AS dueDate_39, t31.beginDate AS beginDate_40, t31.currency AS currency_41, t31.createdAt AS createdAt_42, t31.updatedAt AS updatedAt_43, t31.deleted AS deleted_44, t31.deletedAt AS deletedAt_45, t31.dossierType_id AS dossierType_id_46, t31.company_id AS company_id_47, t31.templat_id AS templat_id_48, t31.mission_id AS mission_id_49, t31.owner_id AS owner_id_50 FROM mission t0 LEFT JOIN leadcomptable t18 ON t18.mission_id = t0.id LEFT JOIN mission t31 ON t31.mission_id = t0.id WHERE t0.id = 29;
2	0.82 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: [`76`] 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 = 76;
3	0.64 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.dateDebut AS dateDebut_3, t0.dateFin AS dateFin_4, t0.situation AS situation_5, t0.statut AS statut_6, t0.espacelimit AS espacelimit_7, t0.dueDate AS dueDate_8, t0.beginDate AS beginDate_9, t0.currency AS currency_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deleted AS deleted_13, t0.deletedAt AS deletedAt_14, t0.dossierType_id AS dossierType_id_15, t0.company_id AS company_id_16, t0.templat_id AS templat_id_17, t18.id AS id_19, t18.name AS name_20, t18.status AS status_21, t18.ref AS ref_22, t18.createdAt AS createdAt_23, t18.updatedAt AS updatedAt_24, t18.deleted AS deleted_25, t18.deletedAt AS deletedAt_26, t18.mission_id AS mission_id_27, t18.document_id AS document_id_28, t0.mission_id AS mission_id_29, t0.owner_id AS owner_id_30, t31.id AS id_32, t31.type AS type_33, t31.dateDebut AS dateDebut_34, t31.dateFin AS dateFin_35, t31.situation AS situation_36, t31.statut AS statut_37, t31.espacelimit AS espacelimit_38, t31.dueDate AS dueDate_39, t31.beginDate AS beginDate_40, t31.currency AS currency_41, t31.createdAt AS createdAt_42, t31.updatedAt AS updatedAt_43, t31.deleted AS deleted_44, t31.deletedAt AS deletedAt_45, t31.dossierType_id AS dossierType_id_46, t31.company_id AS company_id_47, t31.templat_id AS templat_id_48, t31.mission_id AS mission_id_49, t31.owner_id AS owner_id_50 FROM mission t0 LEFT JOIN leadcomptable t18 ON t18.mission_id = t0.id LEFT JOIN mission t31 ON t31.mission_id = t0.id WHERE t0.mission_id = ? Parameters: [`76`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.dateDebut AS dateDebut_3, t0.dateFin AS dateFin_4, t0.situation AS situation_5, t0.statut AS statut_6, t0.espacelimit AS espacelimit_7, t0.dueDate AS dueDate_8, t0.beginDate AS beginDate_9, t0.currency AS currency_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deleted AS deleted_13, t0.deletedAt AS deletedAt_14, t0.dossierType_id AS dossierType_id_15, t0.company_id AS company_id_16, t0.templat_id AS templat_id_17, t18.id AS id_19, t18.name AS name_20, t18.status AS status_21, t18.ref AS ref_22, t18.createdAt AS createdAt_23, t18.updatedAt AS updatedAt_24, t18.deleted AS deleted_25, t18.deletedAt AS deletedAt_26, t18.mission_id AS mission_id_27, t18.document_id AS document_id_28, t0.mission_id AS mission_id_29, t0.owner_id AS owner_id_30, t31.id AS id_32, t31.type AS type_33, t31.dateDebut AS dateDebut_34, t31.dateFin AS dateFin_35, t31.situation AS situation_36, t31.statut AS statut_37, t31.espacelimit AS espacelimit_38, t31.dueDate AS dueDate_39, t31.beginDate AS beginDate_40, t31.currency AS currency_41, t31.createdAt AS createdAt_42, t31.updatedAt AS updatedAt_43, t31.deleted AS deleted_44, t31.deletedAt AS deletedAt_45, t31.dossierType_id AS dossierType_id_46, t31.company_id AS company_id_47, t31.templat_id AS templat_id_48, t31.mission_id AS mission_id_49, t31.owner_id AS owner_id_50 FROM mission t0 LEFT JOIN leadcomptable t18 ON t18.mission_id = t0.id LEFT JOIN mission t31 ON t31.mission_id = t0.id WHERE t0.mission_id = ? SELECT t0.id AS id_1, t0.type AS type_2, t0.dateDebut AS dateDebut_3, t0.dateFin AS dateFin_4, t0.situation AS situation_5, t0.statut AS statut_6, t0.espacelimit AS espacelimit_7, t0.dueDate AS dueDate_8, t0.beginDate AS beginDate_9, t0.currency AS currency_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deleted AS deleted_13, t0.deletedAt AS deletedAt_14, t0.dossierType_id AS dossierType_id_15, t0.company_id AS company_id_16, t0.templat_id AS templat_id_17, t18.id AS id_19, t18.name AS name_20, t18.status AS status_21, t18.ref AS ref_22, t18.createdAt AS createdAt_23, t18.updatedAt AS updatedAt_24, t18.deleted AS deleted_25, t18.deletedAt AS deletedAt_26, t18.mission_id AS mission_id_27, t18.document_id AS document_id_28, t0.mission_id AS mission_id_29, t0.owner_id AS owner_id_30, t31.id AS id_32, t31.type AS type_33, t31.dateDebut AS dateDebut_34, t31.dateFin AS dateFin_35, t31.situation AS situation_36, t31.statut AS statut_37, t31.espacelimit AS espacelimit_38, t31.dueDate AS dueDate_39, t31.beginDate AS beginDate_40, t31.currency AS currency_41, t31.createdAt AS createdAt_42, t31.updatedAt AS updatedAt_43, t31.deleted AS deleted_44, t31.deletedAt AS deletedAt_45, t31.dossierType_id AS dossierType_id_46, t31.company_id AS company_id_47, t31.templat_id AS templat_id_48, t31.mission_id AS mission_id_49, t31.owner_id AS owner_id_50 FROM mission t0 LEFT JOIN leadcomptable t18 ON t18.mission_id = t0.id LEFT JOIN mission t31 ON t31.mission_id = t0.id WHERE t0.mission_id = 76;
4	1.06 ms	SELECT t0.id AS id_1, t0.description AS description_2, t0.anomalyType AS anomalyType_3, t0.riskType AS riskType_4, t0.riskLevel AS riskLevel_5, t0.type AS type_6, t0.rtype AS rtype_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12, t0.processControlTest_id AS processControlTest_id_13, t0.process_id AS process_id_14, t0.cycle_id AS cycle_id_15, t0.accountControlTest_id AS accountControlTest_id_16, t0.collaborator_id AS collaborator_id_17 FROM findings t0 WHERE t0.mission_id = ? Parameters: [`29`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.description AS description_2, t0.anomalyType AS anomalyType_3, t0.riskType AS riskType_4, t0.riskLevel AS riskLevel_5, t0.type AS type_6, t0.rtype AS rtype_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12, t0.processControlTest_id AS processControlTest_id_13, t0.process_id AS process_id_14, t0.cycle_id AS cycle_id_15, t0.accountControlTest_id AS accountControlTest_id_16, t0.collaborator_id AS collaborator_id_17 FROM findings t0 WHERE t0.mission_id = ? SELECT t0.id AS id_1, t0.description AS description_2, t0.anomalyType AS anomalyType_3, t0.riskType AS riskType_4, t0.riskLevel AS riskLevel_5, t0.type AS type_6, t0.rtype AS rtype_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12, t0.processControlTest_id AS processControlTest_id_13, t0.process_id AS process_id_14, t0.cycle_id AS cycle_id_15, t0.accountControlTest_id AS accountControlTest_id_16, t0.collaborator_id AS collaborator_id_17 FROM findings t0 WHERE t0.mission_id = 29;
5	0.82 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? Parameters: [`48`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = 48;
6	0.57 ms	SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = 3;
7	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? Parameters: [`115`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = 115;
8	0.44 ms	SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = 2;
9	0.37 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? Parameters: [`118`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = 118;
10	0.42 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? Parameters: [`119`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = 119;
11	0.36 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? Parameters: [`117`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = 117;
12	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? Parameters: [`113`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.processType AS processType_3, t0.automated AS automated_4, t0.appName AS appName_5, t0.integrated AS integrated_6, t0.description AS description_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.mission_id AS mission_id_12 FROM process t0 WHERE t0.id = 113;
13	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.cIndex AS cIndex_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deleted AS deleted_6, t0.deletedAt AS deletedAt_7, t0.dossiertype_id AS dossiertype_id_8 FROM cycledossiertype t0 WHERE t0.id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.cIndex AS cIndex_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deleted AS deleted_6, t0.deletedAt AS deletedAt_7, t0.dossiertype_id AS dossiertype_id_8 FROM cycledossiertype t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.cIndex AS cIndex_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deleted AS deleted_6, t0.deletedAt AS deletedAt_7, t0.dossiertype_id AS dossiertype_id_8 FROM cycledossiertype t0 WHERE t0.id = 16;
14	0.42 ms	SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.fonction AS fonction_3, t0.tauxHoraire AS tauxHoraire_4, t0.telephone AS telephone_5, t0.authId AS authId_6, t0.cabinet AS cabinet_7, t0.gender AS gender_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.photoUrl AS photoUrl_12, t0.online AS online_13, t0.active AS active_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deleted AS deleted_17, t0.deletedAt AS deletedAt_18, t0.adresse_id AS adresse_id_19 FROM collaborateur t0 WHERE t0.id = 1;

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\Findings	64
App\Entity\Tenant\Mission\ProcessControlTest	53
App\Entity\Tenant\Mission\Process	6
App\Entity\Tenant\Collaborateur	3
App\Entity\Tenant\Mission	2
App\Entity\Tenant\DossierType	1
App\Entity\Tenant\Company	1
App\Entity\Tenant\Mission\WorkPlan	1
App\Entity\Tenant\Lead	1
App\Entity\Tenant\CycleDossierType	1
App\Entity\Tenant\Mission\AccountControlTest	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\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\Mission\WorkPlan	No errors.
App\Entity\Tenant\Lead	No errors.
App\Entity\Tenant\Documents	The association App\Entity\Tenant\Documents#processResumEntretien refers to the inverse side field App\Entity\Tenant\Mission\Process#ResumEntretien which does not exist. The association App\Entity\Tenant\Documents#processDescription refers to the inverse side field App\Entity\Tenant\Mission\Process#Description which does not exist.
App\Entity\Tenant\Collaborateur	No errors.
App\Entity\Tenant\MissionMembers	No errors.
App\Entity\Tenant\TimeSheet	No errors.
App\Entity\Tenant\Mission\TasksMission	No errors.
App\Entity\Tenant\Mission\SectionsMission	No errors.
App\Entity\Tenant\Findings	No errors.
App\Entity\Tenant\Mission\RiskAssessment	No errors.
App\Entity\Tenant\Mission\Process	No errors.
App\Entity\Tenant\Mission\AdjustmentEntry	No errors.
App\Entity\Tenant\Mission\AccountControlTest	No errors.
App\Entity\Tenant\Mission\PointsFollowUp	No errors.
App\Entity\Tenant\Mission\ReviewNote	The mappings App\Entity\Tenant\Mission\ReviewNote#toCollaborator and App\Entity\Tenant\Collaborateur#reviewNotes are inconsistent with each other.
App\Entity\Tenant\Notification	No errors.
App\Entity\Tenant\Mission\TimeBudget	The mappings App\Entity\Tenant\Mission\TimeBudget#task and App\Entity\Tenant\TaskAvailable#timeBudgets are inconsistent with each other.
App\Entity\Tenant\MissionEtatsFinanciers	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\Mission\WorkProgram	No errors.
App\Entity\Tenant\Seuil	No errors.
App\Entity\Tenant\DocumentRequestEmail	No errors.
App\Entity\Tenant\MissionExtraCharge	No errors.
App\Entity\Tenant\Facture	No errors.
App\Entity\Tenant\MissionEtfDocs	No errors.
App\Entity\Tenant\Logs	No errors.
App\Entity\Tenant\Balance	No errors.
App\Entity\Tenant\Compte	No errors.
App\Entity\Tenant\Mission\ProcessControlTest	No errors.
App\Entity\Tenant\CycleDossierType	No errors.
App\Entity\Tenant\Mission\InherentRisk	No errors.
App\Entity\Tenant\Mission\ControlRisk	No errors.
App\Entity\Tenant\Mission\FraudRisk	No errors.
App\Entity\Tenant\Assertion	No errors.
App\Entity\Tenant\Adresse	No errors.
App\Entity\Tenant\Mission\ReviewNoteResponse	No errors.
App\Entity\Tenant\Participant	No errors.
App\Entity\Tenant\Message	No errors.
App\Entity\Tenant\RegleCycle	No errors.
App\Entity\Tenant\TestAssertion	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/api/workspace/mission/29/findings

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