GET https://gmc.tadkik.online/app/api/mission/29/EtatsFinanciers/show

Query Metrics

351 Database Queries
10 Different statements
196.97 ms Query time
9 Invalid entities
795 Managed entities

Grouped Statements

Show all queries

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
  • 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 No errors.
App\Entity\Tenant\Participant No errors.
App\Entity\Tenant\Message No errors.
App\Entity\Tenant\TasksMission No errors.
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\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#discount' 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.
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\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.