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

Grouped Statements

Show all queries

Time Count Info
0.46 ms
(17.15%)
1
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:
[]
0.37 ms
(13.74%)
3
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
]
0.36 ms
(13.36%)
3
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
]
0.35 ms
(13.10%)
3
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
]
0.35 ms
(12.95%)
3
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
]
0.31 ms
(11.65%)
3
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
]
0.23 ms
(8.38%)
1
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%"
]
0.14 ms
(5.06%)
1
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
]
0.12 ms
(4.61%)
1
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%"
]

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.