Query Metrics
923
Database Queries
3
Different statements
408.63 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
208.82 ms (51.10%) |
461 |
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.collaborator_id AS collaborator_id_3 FROM avatar t0 WHERE t0.collaborator_id = ?
Parameters:
[
3093
]
|
|
191.60 ms (46.89%) |
461 |
SELECT t0.id AS id_1, t0.ip_address AS ip_address_2, t0.browser AS browser_3, t0.is_accepted AS is_accepted_4, t0.accepted_at AS accepted_at_5, t0.collaborator_id AS collaborator_id_6 FROM cgu t0 WHERE t0.collaborator_id = ?
Parameters:
[
3093
]
|
|
8.22 ms (2.01%) |
1 |
SELECT a0_.id AS id_0, a0_.first_name AS first_name_1, a0_.last_name AS last_name_2, a0_.email AS email_3, a0_.professional_email AS professional_email_4, a0_.birth_day AS birth_day_5, a0_.phone AS phone_6, a0_.main_phone AS main_phone_7, a0_.roles AS roles_8, a0_.password AS password_9, a0_.last_connection AS last_connection_10, a0_.person_type AS person_type_11, a0_.created_at AS created_at_12, a0_.updated_at AS updated_at_13, a1_.cin AS cin_14, a1_.is_recommender AS is_recommender_15, a1_.cnss AS cnss_16, a1_.rc AS rc_17, a1_.professional_status AS professional_status_18, a1_.subject_to_vat AS subject_to_vat_19, a1_.created_qualifiqaution_date AS created_qualifiqaution_date_20, a1_.company_name AS company_name_21, a1_.common_company_identifier AS common_company_identifier_22, a0_.type AS type_23, a0_.address_id AS address_id_24, a0_.gender_id AS gender_id_25, a0_.reference_status_id AS reference_status_id_26, a0_.reference_marital_status_id AS reference_marital_status_id_27, a1_.qualification_level_id AS qualification_level_id_28, a1_.sector_id AS sector_id_29, a1_.manager_id AS manager_id_30, a1_.status_id AS status_id_31, a1_.sponsor_id AS sponsor_id_32, a1_.nationality_id AS nationality_id_33 FROM agent a1_ INNER JOIN abstract_collaborator a0_ ON a1_.id = a0_.id ORDER BY a0_.id ASC
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\AbstractCollaborator | No errors. |
| App\Entity\Agent |
|
| App\Entity\Reference\ReferenceCollaboratorState | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Gender | No errors. |
| App\Entity\Reference\ReferenceCollaboratorStatus | No errors. |
| App\Entity\Reference\ReferencePersonMaritalStatus | No errors. |
| App\Entity\QualificationLevel | No errors. |
| App\Entity\Sector |
|
| App\Entity\Manager | No errors. |
| App\Entity\Nationality | No errors. |
| App\Entity\Avatar | No errors. |
| App\Entity\Cgu | No errors. |
| App\Entity\Genealogy | No errors. |
| App\Entity\Property |
|
| App\Entity\AbstractPeople | No errors. |
| App\Entity\Candidate | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Prescriber | No errors. |
| App\Entity\IdentityVerificationImage | No errors. |
| App\Entity\AgentsOptions | No errors. |