Query Metrics
64
Database Queries
7
Different statements
38.34 ms
Query time
2
Invalid entities
34
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
12.12 ms (31.61%) |
20 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.raw AS raw_3, t0.source AS source_4, t0.timestamp AS timestamp_5, t0.forecast AS forecast_6, t0.strymo_id AS strymo_id_7, t0.kind AS kind_8, t0.day AS day_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.place_id AS place_id_12, t0.parameter_id AS parameter_id_13, t0.document_id AS document_id_14, t0.report_id AS report_id_15 FROM metric t0 WHERE t0.report_id = ?
Parameters:
[
926
]
|
||||||||||||||||||||||||||||
|
9.46 ms (24.66%) |
20 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.role AS role_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.position AS position_8, t0.user AS user_9, t0.active AS active_10, t0.phone AS phone_11, t0.picture AS picture_12, t0.plain_password AS plain_password_13, t0.deleted AS deleted_14, t0.language AS language_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19, t0.function_id AS function_id_20, t0.company_id AS company_id_21 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"Bounoua.mohamed.rayan@gmail.com"
]
|
||||||||||||||||||||||||||||
|
9.22 ms (24.06%) |
20 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.google_id AS google_id_6, t0.google_dir_id AS google_dir_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.client_id AS client_id_12, t0.place_id AS place_id_13, t0.report_id AS report_id_14, t0.chat_id AS chat_id_15 FROM document t0 WHERE t0.report_id = ?
Parameters:
[
926
]
|
||||||||||||||||||||||||||||
|
4.22 ms (11.01%) |
1 |
SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM report r0_ LEFT JOIN taxonomy t1_ ON r0_.event_type_id = t1_.id INNER JOIN report_place r3_ ON r0_.id = r3_.report_id INNER JOIN place p2_ ON p2_.id = r3_.place_id WHERE p2_.id = ? ORDER BY r0_.id DESC
Parameters:
[
"2"
]
|
||||||||||||||||||||||||||||
|
1.56 ms (4.07%) |
1 |
SELECT r0_.id AS id_0, r0_.subject AS subject_1, r0_.content AS content_2, r0_.images AS images_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.created_by AS created_by_6, r0_.updated_by AS updated_by_7, t1_.id AS id_8, t1_.name AS name_9, t1_.slug AS slug_10, t1_.active AS active_11, t1_.description AS description_12, t1_.role AS role_13, r0_.event_type_id AS event_type_id_14, t1_.parent_id AS parent_id_15 FROM report r0_ LEFT JOIN taxonomy t1_ ON r0_.event_type_id = t1_.id INNER JOIN report_place r3_ ON r0_.id = r3_.report_id INNER JOIN place p2_ ON p2_.id = r3_.place_id WHERE p2_.id = ? ORDER BY r0_.id DESC LIMIT 20
Parameters:
[
"2"
]
|
||||||||||||||||||||||||||||
|
0.93 ms (2.42%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.city AS city_4, t0.country AS country_5, t0.postalcode AS postalcode_6, t0.address AS address_7, t0.active AS active_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.webcam_url AS webcam_url_11, t0.weather_station_id AS weather_station_id_12, t0.water_station_id AS water_station_id_13, t0.opening_hours AS opening_hours_14, t0.max_people AS max_people_15, t0.picture AS picture_16, t0.strymo_station_id AS strymo_station_id_17, t0.jauge_url AS jauge_url_18, t0.preview_code AS preview_code_19, t0.link AS link_20, t0.boazcreate AS boazcreate_21, t0.pict3d AS pict3d_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26, t0.client_id AS client_id_27 FROM place t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
||||||||||||||||||||||||||||
|
0.83 ms (2.18%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.role AS role_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.position AS position_8, t0.user AS user_9, t0.active AS active_10, t0.phone AS phone_11, t0.picture AS picture_12, t0.plain_password AS plain_password_13, t0.deleted AS deleted_14, t0.language AS language_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19, t0.function_id AS function_id_20, t0.company_id AS company_id_21 FROM user t0 WHERE t0.id = ?
Parameters:
[
84
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Report | 20 |
| App\Entity\Taxonomy | 5 |
| App\Entity\User | 4 |
| App\Entity\Document | 2 |
| App\Entity\Company | 1 |
| App\Entity\Place | 1 |
| App\Entity\Client | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Taxonomy | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Place |
|
| App\Entity\Message | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\Report |
|
| App\Entity\Water | No errors. |
| App\Entity\Weather | No errors. |
| App\Entity\Status | No errors. |
| App\Entity\Webcam | No errors. |
| App\Entity\Metric | No errors. |
| App\Entity\Widget | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\Parameter | No errors. |
| App\Entity\TaskDone | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\Tutorial | No errors. |
| App\Entity\Chat | No errors. |