GET https://boaz-connect.fr/fr/place/site-de-grenelle/webcam/refresh

Query Metrics

3 Database Queries
3 Different statements
3.18 ms Query time
2 Invalid entities
8 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.23 ms
(38.70%)
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.slug = ? LIMIT 1
Parameters:
[
  "site-de-grenelle"
]
1.10 ms
(34.43%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.roles AS roles_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_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.created_by AS created_by_16, u0_.updated_by AS updated_by_17, u0_.function_id AS function_id_18, u0_.company_id AS company_id_19 FROM user u0_ WHERE u0_.email = ? OR u0_.username = ?
Parameters:
[
  "eric@caravanemedia.com"
  "eric@caravanemedia.com"
]
0.85 ms
(26.86%)
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:
[
  1
]

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\Webcam 5
App\Entity\Place 1
App\Entity\Client 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Place
  • The association App\Entity\Place#category refers to the inverse side field App\Entity\Taxonomy#places which does not exist.
App\Entity\Client No errors.
App\Entity\User No errors.
App\Entity\Report
  • The field App\Entity\Report#taskDones is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TaskDone#report does not contain the required 'inversedBy="taskDones"' attribute.
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\Message No errors.
App\Entity\Notification No errors.
App\Entity\Document No errors.
App\Entity\Taxonomy No errors.
App\Entity\Widget No errors.
App\Entity\Structure No errors.
App\Entity\Company No errors.