Query Metrics
3
Database Queries
3
Different statements
2.64 ms
Query time
2
Invalid entities
4
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.00 ms (37.97%) |
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.role AS role_3, u0_.password AS password_4, u0_.firstname AS firstname_5, u0_.lastname AS lastname_6, u0_.position AS position_7, u0_.user AS user_8, u0_.active AS active_9, u0_.phone AS phone_10, u0_.picture AS picture_11, u0_.plain_password AS plain_password_12, u0_.deleted AS deleted_13, u0_.language AS language_14, u0_.type AS type_15, u0_.created_at AS created_at_16, u0_.updated_at AS updated_at_17, u0_.created_by AS created_by_18, u0_.updated_by AS updated_by_19, u0_.function_id AS function_id_20, u0_.company_id AS company_id_21 FROM user u0_ WHERE u0_.email = ? OR u0_.username = ?
Parameters:
[ "hello@charlined.fr" "hello@charlined.fr" ] |
||||||||||||||||||||||||||||
|
0.89 ms (33.81%) |
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.control_code AS control_code_20, t0.link AS link_21, t0.boazcreate AS boazcreate_22, t0.pict3d AS pict3d_23, t0.drive_directory AS drive_directory_24, t0.opening_days AS opening_days_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.created_by AS created_by_28, t0.updated_by AS updated_by_29, t0.client_id AS client_id_30 FROM place t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"demo-baignade"
]
|
||||||||||||||||||||||||||||
|
0.75 ms (28.22%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.image AS image_3, t0.place_id AS place_id_4 FROM webcam t0 WHERE t0.place_id = ? ORDER BY t0.id DESC LIMIT 5
Parameters:
[
10
]
|
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\User | 1 |
| 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\News | No errors. |