Query Metrics
2556
Database Queries
13
Different statements
1711.92 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
465.16 ms (27.17%) |
460 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.rank AS rank_5, t0.country_id AS country_id_6 FROM city t0 INNER JOIN sector_city ON t0.id = sector_city.city_id WHERE sector_city.sector_id = ?
Parameters:
[
10357
]
|
323.78 ms (18.91%) |
461 |
SELECT t0.id AS id_1, t0.option_value AS option_value_2, t0.agent_id AS agent_id_3, t0.option_id AS option_id_4 FROM agents_options t0 WHERE t0.agent_id = ?
Parameters:
[
3093
]
|
301.96 ms (17.64%) |
460 |
SELECT t0.id AS id_1, t0.main_city_id AS main_city_id_2 FROM sector t0 WHERE t0.id = ?
Parameters:
[
10357
]
|
222.20 ms (12.98%) |
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
]
|
206.57 ms (12.07%) |
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
]
|
92.05 ms (5.38%) |
160 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.city_id AS city_id_5 FROM neighborhood t0 WHERE t0.city_id = ?
Parameters:
[
1945
]
|
83.30 ms (4.87%) |
77 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.city_id AS city_id_5 FROM neighborhood t0 INNER JOIN sector_neighborhood ON t0.id = sector_neighborhood.neighborhood_id WHERE sector_neighborhood.sector_id = ?
Parameters:
[
10357
]
|
5.18 ms (0.30%) |
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:
[] |
4.32 ms (0.25%) |
6 |
SELECT t0.id AS id_1, t0.level AS level_2, t0.recurrence AS recurrence_3, t0.label AS label_4, t0.qualification_level_goal AS qualification_level_goal_5, t0.max_sponsorship_request AS max_sponsorship_request_6 FROM qualification_level t0 WHERE t0.id = ?
Parameters:
[
76
]
|
2.73 ms (0.16%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.values AS values_4, t0.default_value AS default_value_5, t0.code AS code_6 FROM OPTION t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.82 ms (0.11%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.rank AS rank_5, t0.country_id AS country_id_6 FROM city t0 WHERE t0.id = ?
Parameters:
[
1945
]
|
1.61 ms (0.09%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM gender t0 WHERE t0.id = ?
Parameters:
[
37
]
|
1.23 ms (0.07%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.currency_id AS currency_id_4 FROM country t0 WHERE t0.id = ?
Parameters:
[
2365
]
|
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. |
App\Entity\Option | No errors. |
App\Entity\Neighborhood | No errors. |
App\Entity\Country | No errors. |
App\Entity\PropertyAddress | No errors. |
App\Entity\Language | No errors. |
App\Entity\Currency | No errors. |