Query Metrics
351
Database Queries
10
Different statements
196.97 ms
Query time
9
Invalid entities
795
Managed entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
0.89 ms (0.45%) |
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 = ? LIMIT 1
Parameters:
[
"gmc.tadkik.online"
]
|
0.49 ms (0.25%) |
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 = ? LIMIT 1
Parameters:
[
"1"
]
|
0.46 ms (0.23%) |
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 = ? LIMIT 1
Parameters:
[
"gmc"
]
|
tenant connection
Time▼ | Count | Info |
---|---|---|
88.34 ms (44.85%) |
69 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.RefFolder AS RefFolder_4, t0.status AS status_5, t0.progress AS progress_6, t0.inWp AS inWp_7, t0.echeanceDate AS echeanceDate_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deleted AS deleted_11, t0.deletedAt AS deletedAt_12, t0.mission_id AS mission_id_13, t0.collaborateur_id AS collaborateur_id_14, t0.collaborateurRemplacant_id AS collaborateurRemplacant_id_15, t0.handOff_id AS handOff_id_16, t0.task_id AS task_id_17, t0.cycle_id AS cycle_id_18, t0.section_id AS section_id_19, t0.process_id AS process_id_20, t0.accountTest_id AS accountTest_id_21, t0.test_id AS test_id_22, t0.reviewedby_id AS reviewedby_id_23 FROM tasksmission t0 WHERE t0.mission_id = ? ORDER BY t0.id ASC
Parameters:
[
29
]
|
36.91 ms (18.74%) |
69 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.signe AS signe_4, t0.indexRub AS indexRub_5, t0.customeEquation AS customeEquation_6, t0.level AS level_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deleted AS deleted_10, t0.deletedAt AS deletedAt_11, t0.etatFinancier_id AS etatFinancier_id_12, t0.rubRef_id AS rubRef_id_13 FROM Rubrique t0 WHERE t0.id = ?
Parameters:
[
123
]
|
25.65 ms (13.02%) |
70 |
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 FROM mission t0 LEFT JOIN leadcomptable t18 ON t18.mission_id = t0.id WHERE t0.id = ?
Parameters:
[
29
]
|
23.31 ms (11.83%) |
69 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.soldeN AS soldeN_3, t0.soldeI AS soldeI_4, t0.soldeN1 AS soldeN1_5, t0.soldeNAfter AS soldeNAfter_6, t0.soldeIAfter AS soldeIAfter_7, t0.soldeN1After AS soldeN1After_8, t0.type AS type_9, t0.reference AS reference_10, t0.period AS period_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.deleted AS deleted_14, t0.deletedAt AS deletedAt_15, t0.etatFinancier_id AS etatFinancier_id_16, t0.mission_id AS mission_id_17, t0.rubrique_id AS rubrique_id_18 FROM missionetatsfinanciers t0 WHERE t0.id = ?
Parameters:
[
4258
]
|
19.07 ms (9.68%) |
69 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_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 etatfinancier t0 WHERE t0.id = ?
Parameters:
[
6
]
|
0.95 ms (0.48%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.soldeN AS soldeN_3, t0.soldeI AS soldeI_4, t0.soldeN1 AS soldeN1_5, t0.soldeNAfter AS soldeNAfter_6, t0.soldeIAfter AS soldeIAfter_7, t0.soldeN1After AS soldeN1After_8, t0.type AS type_9, t0.reference AS reference_10, t0.period AS period_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.deleted AS deleted_14, t0.deletedAt AS deletedAt_15, t0.etatFinancier_id AS etatFinancier_id_16, t0.mission_id AS mission_id_17, t0.rubrique_id AS rubrique_id_18 FROM missionetatsfinanciers t0 WHERE t0.mission_id = ?
Parameters:
[
29
]
|
0.90 ms (0.46%) |
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 = ? LIMIT 1
Parameters:
[
"gmac@mail.com"
]
|
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\TasksMission | 295 |
App\Entity\Tenant\TestAssertion | 208 |
App\Entity\Tenant\MissionEtatsFinanciers | 69 |
App\Entity\Tenant\Rubrique | 69 |
App\Entity\Tenant\Task | 51 |
App\Entity\Tenant\SectionsMission | 39 |
App\Entity\Tenant\AccountControlTest | 19 |
App\Entity\Tenant\Process | 18 |
App\Entity\Tenant\CycleDossierType | 14 |
App\Entity\Tenant\Collaborateur | 3 |
App\Entity\Tenant\EtatFinancier | 3 |
App\Entity\Tenant\User | 1 |
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 | No errors. |
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 |
|
App\Entity\Tenant\ReviewNoteResponse | No errors. |
App\Entity\Tenant\Notification | No errors. |
App\Entity\Tenant\TimeBudget |
|
App\Entity\Tenant\Documents | No errors. |
App\Entity\Tenant\Participant | No errors. |
App\Entity\Tenant\Message | No errors. |
App\Entity\Tenant\TasksMission | No errors. |
App\Entity\Tenant\Logs |
|
App\Entity\Tenant\DocumentRequestEmail | No errors. |
App\Entity\Tenant\Mission |
|
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\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 |
|
App\Entity\Tenant\WorkProgram | No errors. |
App\Entity\Tenant\Seuil | No errors. |
App\Entity\Tenant\MissionExtraCharge |
|
App\Entity\Tenant\Facture |
|
App\Entity\Tenant\MissionEtfDocs | No errors. |
App\Entity\Tenant\Conversation | No errors. |
App\Entity\Tenant\Balance |
|
App\Entity\Tenant\Compte |
|
App\Entity\Tenant\EtatFinancier | No errors. |
App\Entity\Tenant\Rubrique | No errors. |
App\Entity\Tenant\SeuilGlobal | No errors. |
App\Entity\Tenant\Task | No errors. |
App\Entity\Tenant\CycleDossierType | No errors. |
App\Entity\Tenant\TestAssertion | No errors. |
App\Entity\Tenant\TaskFomFieldAnswers | No errors. |
App\Entity\Tenant\RegleCycle | No errors. |
default entity manager
Class | Mapping errors |
---|---|
App\Entity\Main\Tenant | No errors. |
App\Entity\Main\Support | No errors. |