GET https://events.ffns.es/

Query Metrics

9 Database Queries
9 Different statements
1.39 ms Query time
1 Invalid entities
15 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.45 ms
(32.26%)
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.21 ms
(15.43%)
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:
[
  "%1%"
]
0.13 ms
(9.53%)
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:
[
  "%1%"
]
0.12 ms
(8.65%)
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:
[
  "%1%"
  4
]
0.10 ms
(7.57%)
1
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:
[
  4
]
0.10 ms
(7.28%)
1
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:
[
  4
]
0.09 ms
(6.57%)
1
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:
[
  4
]
0.09 ms
(6.35%)
1
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:
[
  4
]
0.09 ms
(6.35%)
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.event_id = ?
Parameters:
[
  4
]

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 6
App\Entity\Imagelinked 2
App\Entity\Userevent 2
App\Entity\User 2
App\Entity\Event 1
App\Entity\Filelinked 1
App\Entity\Youtubelinked 1

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.