GET https://boaz-connect.fr/api/report/list?limit=20&page=1&placeId=2

Response
200 OK
Browse referrer URL
IP
192.178.15.68
Profiled on
Token
6040d2

Query Metrics

64 Database Queries
7 Different statements
38.34 ms Query time
2 Invalid entities
34 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.83 ms 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.93 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 4.22 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 1.56 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.81 ms 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.79 ms 
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: 
[
  925
]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.87 ms 
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: 
[
  924
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.82 ms 
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: 
[
  921
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.64 ms 
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: 
[
  920
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.60 ms 
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: 
[
  919
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.49 ms 
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: 
[
  918
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.46 ms 
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: 
[
  914
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.50 ms 
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: 
[
  913
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.44 ms 
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: 
[
  911
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.37 ms 
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: 
[
  908
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.51 ms 
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: 
[
  907
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.46 ms 
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: 
[
  906
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.47 ms 
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: 
[
  905
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.48 ms 
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: 
[
  902
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.48 ms 
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: 
[
  896
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.61 ms 
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: 
[
  895
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.48 ms 
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: 
[
  893
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.42 ms 
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: 
[
  892
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.41 ms 
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: 
[
  891
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.74 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.76 ms 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.56 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.49 ms 
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: 
[
  925
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.58 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.48 ms 
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: 
[
  924
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.51 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.64 ms 
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: 
[
  921
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.39 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.34 ms 
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: 
[
  920
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.38 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.52 ms 
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: 
[
  919
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.44 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.38 ms 
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: 
[
  918
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.44 ms 
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: 
[
  "yannforet.contact@gmail.com"
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.46 ms 
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: 
[
  914
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.45 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.38 ms 
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: 
[
  913
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.35 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.43 ms 
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: 
[
  911
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.40 ms 
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: 
[
  "mamou_frederic@yahoo.fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.39 ms 
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: 
[
  908
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.43 ms 
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: 
[
  "mamou_frederic@yahoo.fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.38 ms 
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: 
[
  907
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.46 ms 
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: 
[
  "mamou_frederic@yahoo.fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.42 ms 
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: 
[
  906
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.45 ms 
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: 
[
  "mamou_frederic@yahoo.fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.42 ms 
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: 
[
  905
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.52 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.50 ms 
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: 
[
  902
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.45 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.46 ms 
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: 
[
  896
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.51 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.46 ms 
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: 
[
  895
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.45 ms 
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: 
[
  "mamou_frederic@yahoo.fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.47 ms 
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: 
[
  893
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.49 ms 
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: 
[
  "mamou_frederic@yahoo.fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.43 ms 
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: 
[
  892
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.48 ms 
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: 
[
  "mamou_frederic@yahoo.fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.43 ms 
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: 
[
  891
]
View formatted query    View runnable query    Explain query    View query backtrace

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
  • The association App\Entity\Place#category refers to the inverse side field App\Entity\Taxonomy#places which does not exist.
App\Entity\Message No errors.
App\Entity\Notification No errors.
App\Entity\Document No errors.
App\Entity\Client 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\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.