Query Metrics
5
Database Queries
5
Different statements
1.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.51 ms (27.11%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
Parameters:
[
1580
]
|
|
0.47 ms (25.05%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.date AS date_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone_number AS phone_number_6, t0.address AS address_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.position_approximate AS position_approximate_10, t0.close_to_sensitive_site AS close_to_sensitive_site_11, t0.other_nest_support AS other_nest_support_12, t0.nest_height AS nest_height_13, t0.nest_diameter_centimeters AS nest_diameter_centimeters_14, t0.nest_access_by_vehicle AS nest_access_by_vehicle_15, t0.nest_active AS nest_active_16, t0.property_owner AS property_owner_17, t0.property_owner_email AS property_owner_email_18, t0.property_owner_first_name AS property_owner_first_name_19, t0.property_owner_last_name AS property_owner_last_name_20, t0.property_owner_phone_number AS property_owner_phone_number_21, t0.fenced_property AS fenced_property_22, t0.distance_from_road AS distance_from_road_23, t0.additional_info AS additional_info_24, t0.hives AS hives_25, t0.followup_note AS followup_note_26, t0.intervention_date AS intervention_date_27, t0.processing_date AS processing_date_28, t0.other_nest_destruction_method AS other_nest_destruction_method_29, t0.destroyed_with_insecticide AS destroyed_with_insecticide_30, t0.insecticide_name AS insecticide_name_31, t0.nest_removed AS nest_removed_32, t0.nest_removal_date AS nest_removal_date_33, t0.nest_non_removal_reason AS nest_non_removal_reason_34, t0.nest_disposal_date AS nest_disposal_date_35, t0.other_nest_disposal_method_without_insecticide AS other_nest_disposal_method_without_insecticide_36, t0.other_nest_disposal_method_with_insecticide AS other_nest_disposal_method_with_insecticide_37, t0.community_label AS community_label_38, t0.exterminator_accepted_report AS exterminator_accepted_report_39, t0.exterminator_affectation_date AS exterminator_affectation_date_40, t0.archived AS archived_41, t0.created_at AS created_at_42, t0.updated_at AS updated_at_43, t0.city_id AS city_id_44, t0.nest_destruction_method_id AS nest_destruction_method_id_45, t0.nest_disposal_method_id AS nest_disposal_method_id_46, t0.nest_support_category_id AS nest_support_category_id_47, t0.original_report_id AS original_report_id_48, t0.report_category_id AS report_category_id_49, t0.report_status_id AS report_status_id_50, t0.report_substatus_id AS report_substatus_id_51, t0.author_id AS author_id_52, t0.advisor_id AS advisor_id_53, t0.exterminator_id AS exterminator_id_54, t0.funding_status_id AS funding_status_id_55 FROM report t0 WHERE t0.id = ?
Parameters:
[
70372
]
|
|
0.41 ms (21.95%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.report_id AS report_id_5 FROM photo t0 WHERE t0.id = ?
Parameters:
[
"107347"
]
|
|
0.28 ms (14.83%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug AS slug_4, t0.region_id AS region_id_5 FROM department t0 INNER JOIN user_department ON t0.id = user_department.department_id WHERE user_department.user_id = ?
Parameters:
[
1580
]
|
|
0.21 ms (11.05%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
27632
]
|
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\Photo | No errors. |
| App\Entity\Report | No errors. |
| App\Entity\User | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Administrator | No errors. |
| App\Entity\Advisor | No errors. |
| App\Entity\SectorManager | No errors. |
| App\Entity\Declarant | No errors. |
| App\Entity\Exterminator | No errors. |
| App\Entity\Supervisor | No errors. |
| App\Entity\Viewer | No errors. |
| App\Entity\ViewerCategory | No errors. |
| App\Entity\Department | No errors. |
| App\Entity\NestDestructionMethod | No errors. |
| App\Entity\NestDisposalMethod | No errors. |
| App\Entity\NestSupportCategory | No errors. |
| App\Entity\ReportCategory | No errors. |
| App\Entity\ReportStatus | No errors. |
| App\Entity\ReportSubstatus | No errors. |
| App\Entity\FundingStatus | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\InternalPhoto | No errors. |
| App\Entity\Community | No errors. |
| App\Entity\Sector | No errors. |
| App\Entity\Region | No errors. |