0.45 ms (32.07%)
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
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 ;
Copy
0.22 ms (15.50%)
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
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 '%1%' ) dctrn_result_inner ORDER BY id_0 DESC ) dctrn_result LIMIT 4 ;
Copy
0.13 ms (9.25%)
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
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 '%1%' ORDER BY e0_ . id DESC ) dctrn_result ) dctrn_table ;
Copy
0.12 ms (8.83%)
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
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 '%1%' AND e0_ . id IN (4 ) ORDER BY e0_ . id DESC ;
Copy
0.10 ms (7.53%)
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 = ?
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 = 4 ;
Copy
0.10 ms (7.18%)
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 = ?
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 = 4 ;
Copy
0.10 ms (6.96%)
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 = ?
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 = 4 ;
Copy
0.09 ms (6.38%)
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 = ?
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 = 4 ;
Copy
0.09 ms (6.31%)
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 = ?
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 = 4 ;
Copy