https://api-demo.web.milkiya.ma/api/internal/agents

Query Metrics

923 Database Queries
3 Different statements
408.63 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

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
  • The mappings App\Entity\Agent#prescriberProperties and App\Entity\Property#prescriber are inconsistent with each other.
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
  • The field App\Entity\Sector#collaborators is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Agent#sector does not contain the required 'inversedBy="collaborators"' attribute.
  • The field App\Entity\Sector#candidates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Candidate#sector does not contain the required 'inversedBy="candidates"' attribute.
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
  • The mappings App\Entity\Property#propertyFiles and App\Entity\CertificateOfOwnershipFile#property are inconsistent with each other.
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.