GET https://events.ffns.es/?searchstatus=2

Query Metrics

19 Database Queries
9 Different statements
2.69 ms Query time
1 Invalid entities
38 Managed entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.datesignup AS datesignup_2, t0.administrator AS administrator_3, t0.speaker AS speaker_4, t0.user_id AS user_id_5, t0.event_id AS event_id_6 FROM userevent t0 WHERE t0.user_id IS NULL
Parameters:
[]
2 0.23 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.fromdate AS fromdate_2, e0_.roomopenminutesbefore AS roomopenminutesbefore_3, e0_.todate AS todate_4, e0_.description AS description_5, e0_.content AS content_6, e0_.platform AS platform_7, e0_.status AS status_8, e0_.descriptioninterna AS descriptioninterna_9 FROM event e0_ WHERE e0_.status LIKE ?) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 4
Parameters:
[
  "%2%"
]
3 0.14 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.fromdate AS fromdate_2, e0_.roomopenminutesbefore AS roomopenminutesbefore_3, e0_.todate AS todate_4, e0_.description AS description_5, e0_.content AS content_6, e0_.platform AS platform_7, e0_.status AS status_8, e0_.descriptioninterna AS descriptioninterna_9 FROM event e0_ WHERE e0_.status LIKE ? AND e0_.id IN (?, ?, ?) ORDER BY e0_.id DESC
Parameters:
[
  "%2%"
  3
  2
  1
]
4 0.12 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.fromdate AS fromdate_2, e0_.roomopenminutesbefore AS roomopenminutesbefore_3, e0_.todate AS todate_4, e0_.description AS description_5, e0_.content AS content_6, e0_.platform AS platform_7, e0_.status AS status_8, e0_.descriptioninterna AS descriptioninterna_9 FROM event e0_ WHERE e0_.status LIKE ? ORDER BY e0_.id DESC) dctrn_result) dctrn_table
Parameters:
[
  "%2%"
]
5 0.10 ms
SELECT t0.id AS id_1, t0.nameoffile AS nameoffile_2, t0.typeofimage AS typeofimage_3, t0.event_id AS event_id_4 FROM imagelinked t0 WHERE t0.event_id = ?
Parameters:
[
  3
]
6 0.10 ms
SELECT t0.id AS id_1, t0.originalnameoffile AS originalnameoffile_2, t0.nameoffile AS nameoffile_3, t0.extension AS extension_4, t0.descriptionoffile AS descriptionoffile_5, t0.showinpresentation AS showinpresentation_6, t0.showinevent AS showinevent_7, t0.showinpostevent AS showinpostevent_8, t0.showinhook AS showinhook_9, t0.pdfshowasslider AS pdfshowasslider_10, t0.event_id AS event_id_11 FROM filelinked t0 WHERE t0.event_id = ?
Parameters:
[
  3
]
7 0.08 ms
SELECT t0.id AS id_1, t0.mailtype AS mailtype_2, t0.subject AS subject_3, t0.body AS body_4, t0.senddate AS senddate_5, t0.event_id AS event_id_6 FROM maillinked t0 WHERE t0.event_id = ?
Parameters:
[
  3
]
8 0.09 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.code_youtube AS code_youtube_3, t0.show_in_presentation AS show_in_presentation_4, t0.show_in_event AS show_in_event_5, t0.show_in_post_event AS show_in_post_event_6, t0.show_in_hook AS show_in_hook_7, t0.event_id AS event_id_8 FROM youtubelinked t0 WHERE t0.event_id = ?
Parameters:
[
  3
]
9 0.08 ms
SELECT t0.id AS id_1, t0.datesignup AS datesignup_2, t0.administrator AS administrator_3, t0.speaker AS speaker_4, t0.user_id AS user_id_5, t0.event_id AS event_id_6 FROM userevent t0 WHERE t0.event_id = ?
Parameters:
[
  3
]
10 0.14 ms
SELECT t0.id AS id_1, t0.nameoffile AS nameoffile_2, t0.typeofimage AS typeofimage_3, t0.event_id AS event_id_4 FROM imagelinked t0 WHERE t0.event_id = ?
Parameters:
[
  2
]
11 0.14 ms
SELECT t0.id AS id_1, t0.originalnameoffile AS originalnameoffile_2, t0.nameoffile AS nameoffile_3, t0.extension AS extension_4, t0.descriptionoffile AS descriptionoffile_5, t0.showinpresentation AS showinpresentation_6, t0.showinevent AS showinevent_7, t0.showinpostevent AS showinpostevent_8, t0.showinhook AS showinhook_9, t0.pdfshowasslider AS pdfshowasslider_10, t0.event_id AS event_id_11 FROM filelinked t0 WHERE t0.event_id = ?
Parameters:
[
  2
]
12 0.12 ms
SELECT t0.id AS id_1, t0.mailtype AS mailtype_2, t0.subject AS subject_3, t0.body AS body_4, t0.senddate AS senddate_5, t0.event_id AS event_id_6 FROM maillinked t0 WHERE t0.event_id = ?
Parameters:
[
  2
]
13 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.code_youtube AS code_youtube_3, t0.show_in_presentation AS show_in_presentation_4, t0.show_in_event AS show_in_event_5, t0.show_in_post_event AS show_in_post_event_6, t0.show_in_hook AS show_in_hook_7, t0.event_id AS event_id_8 FROM youtubelinked t0 WHERE t0.event_id = ?
Parameters:
[
  2
]
14 0.11 ms
SELECT t0.id AS id_1, t0.datesignup AS datesignup_2, t0.administrator AS administrator_3, t0.speaker AS speaker_4, t0.user_id AS user_id_5, t0.event_id AS event_id_6 FROM userevent t0 WHERE t0.event_id = ?
Parameters:
[
  2
]
15 0.11 ms
SELECT t0.id AS id_1, t0.nameoffile AS nameoffile_2, t0.typeofimage AS typeofimage_3, t0.event_id AS event_id_4 FROM imagelinked t0 WHERE t0.event_id = ?
Parameters:
[
  1
]
16 0.13 ms
SELECT t0.id AS id_1, t0.originalnameoffile AS originalnameoffile_2, t0.nameoffile AS nameoffile_3, t0.extension AS extension_4, t0.descriptionoffile AS descriptionoffile_5, t0.showinpresentation AS showinpresentation_6, t0.showinevent AS showinevent_7, t0.showinpostevent AS showinpostevent_8, t0.showinhook AS showinhook_9, t0.pdfshowasslider AS pdfshowasslider_10, t0.event_id AS event_id_11 FROM filelinked t0 WHERE t0.event_id = ?
Parameters:
[
  1
]
17 0.15 ms
SELECT t0.id AS id_1, t0.mailtype AS mailtype_2, t0.subject AS subject_3, t0.body AS body_4, t0.senddate AS senddate_5, t0.event_id AS event_id_6 FROM maillinked t0 WHERE t0.event_id = ?
Parameters:
[
  1
]
18 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.code_youtube AS code_youtube_3, t0.show_in_presentation AS show_in_presentation_4, t0.show_in_event AS show_in_event_5, t0.show_in_post_event AS show_in_post_event_6, t0.show_in_hook AS show_in_hook_7, t0.event_id AS event_id_8 FROM youtubelinked t0 WHERE t0.event_id = ?
Parameters:
[
  1
]
19 0.12 ms
SELECT t0.id AS id_1, t0.datesignup AS datesignup_2, t0.administrator AS administrator_3, t0.speaker AS speaker_4, t0.user_id AS user_id_5, t0.event_id AS event_id_6 FROM userevent t0 WHERE t0.event_id = ?
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\Maillinked 13
App\Entity\Youtubelinked 7
App\Entity\Imagelinked 6
App\Entity\Userevent 5
App\Entity\Event 3
App\Entity\User 2
App\Entity\Filelinked 2

Entities Mapping

Class Mapping errors
App\Entity\Userevent No errors.
App\Entity\User
  • The association App\Entity\User#country refers to the inverse side field App\Entity\Country#users which does not exist.
App\Entity\Event No errors.
App\Entity\Imagelinked No errors.
App\Entity\Filelinked No errors.
App\Entity\Maillinked No errors.
App\Entity\Youtubelinked No errors.