https://preprod-api.milkiya.ma/api/genders

Query Metrics

5 Database Queries
5 Different statements
4.03 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 2.21 ms
SELECT t0.id AS id_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.professional_email AS professional_email_9, t0.birth_day AS birth_day_10, t0.phone AS phone_11, t0.main_phone AS main_phone_12, t0.roles AS roles_13, t0.password AS password_14, t0.last_connection AS last_connection_15, t0.person_type AS person_type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.address_id AS address_id_19, t0.gender_id AS gender_id_20, t0.reference_status_id AS reference_status_id_21, t0.reference_marital_status_id AS reference_marital_status_id_22, t0.type, t1.cin AS cin_23, t1.is_recommender AS is_recommender_24, t1.cnss AS cnss_25, t1.rc AS rc_26, t1.professional_status AS professional_status_27, t1.subject_to_vat AS subject_to_vat_28, t1.created_qualifiqaution_date AS created_qualifiqaution_date_29, t1.company_name AS company_name_30, t1.common_company_identifier AS common_company_identifier_31, t1.qualification_level_id AS qualification_level_id_32, t1.sector_id AS sector_id_33, t1.manager_id AS manager_id_34, t1.status_id AS status_id_35, t1.sponsor_id AS sponsor_id_36, t1.nationality_id AS nationality_id_37, t2.count_agent_assignment_number AS count_agent_assignment_number_38 FROM abstract_collaborator t0 LEFT JOIN agent t1 ON t0.id = t1.id LEFT JOIN manager t2 ON t0.id = t2.id LEFT JOIN manager_back_office t3 ON t0.id = t3.id LEFT JOIN manager_it t4 ON t0.id = t4.id WHERE t0.professional_email = ? LIMIT 1
Parameters:
[
  "manager.20@milkiya.ma"
]
2 0.45 ms
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:
[
  20
]
3 0.39 ms
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:
[
  20
]
4 0.59 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2 FROM gender g0_ ORDER BY g0_.id ASC LIMIT 10
Parameters:
[]
5 0.38 ms
SELECT COUNT(g0_.id) AS sclr_0 FROM gender g0_
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
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No 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\Manager No errors.
App\Entity\ManagerBackOffice No errors.
App\Entity\ManagerIt No errors.
App\Entity\Address 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\Reference\ReferenceCollaboratorState No errors.
App\Entity\Nationality No errors.
App\Entity\Avatar No errors.
App\Entity\Cgu 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.