Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

133 Database Queries

59 Different statements

191.80 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT DATABASE()
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?)
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?)
SELECT templates FROM tl_theme
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(4,1,3,9,0,6,12,5) ORDER BY FIND_IN_SET(`tl_module`.`id`, '4,1,3,9,0,6,12,5')
SELECT tl_node.* FROM tl_node WHERE id IN (2) AND type=? ORDER BY FIND_IN_SET(`id`, ?)
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(3,60,5,6) ORDER BY FIND_IN_SET(`tl_page`.`id`, '3,60,5,6')
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(59,64,65,76,63) ORDER BY FIND_IN_SET(`tl_page`.`id`, '59,64,65,76,63')
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(61,98,99) ORDER BY FIND_IN_SET(`tl_page`.`id`, '61,98,99')
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(106,107,108,109,110,111) ORDER BY FIND_IN_SET(`tl_page`.`id`, '106,107,108,109,110,111')
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(48,47,57,58) ORDER BY FIND_IN_SET(`tl_page`.`id`, '48,47,57,58')
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(23,17,24,19) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') ORDER BY FIND_IN_SET(`tl_page`.`id`, '23,17,24,19')
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT tl_article.* FROM tl_article WHERE tl_article.pid=? AND tl_article.inColumn=? AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1727670540') AND (tl_article.stop='' OR tl_article.stop>'1727670540') ORDER BY tl_article.sorting
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND (tl_content.ptable=? OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' ORDER BY sorting ASC
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.id IN(2) ORDER BY FIND_IN_SET(`tl_news_archive`.`id`, '2')
SELECT * FROM tl_news_category WHERE tl_news_category.`published`=? ORDER BY tl_news_category.sorting
SELECT * FROM tl_news_category WHERE tl_news_category.alias=? AND tl_news_category.published=? LIMIT 0,1
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT news_id FROM tl_news_categories
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=?
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT news_id FROM tl_news_categories WHERE category_id IN ('5')
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (11,12,20) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=?
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT news_id FROM tl_news_categories WHERE category_id IN ('6')
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (4,6,14,19) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=?
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT news_id FROM tl_news_categories WHERE category_id IN ('10')
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (1,17) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=?
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT news_id FROM tl_news_categories WHERE category_id IN ('11')
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (18) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=?
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT news_id FROM tl_news_categories WHERE category_id IN ('12')
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (5,10,13) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=?
SELECT news_id FROM tl_news_categories WHERE category_id IN ('7')
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (1,2,5,10,13,17,18) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=?
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT news_id FROM tl_news_categories WHERE category_id IN ('8')
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (9,16) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=?
SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT news_id FROM tl_news_categories WHERE category_id IN ('9')
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (3,7,8,15) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=?
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT * FROM tl_news_category WHERE tl_news_category.alias=? AND tl_news_category.published=? LIMIT 0,1
SELECT news_id FROM tl_news_categories WHERE category_id IN ('10')
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? AND tl_news.id IN(1,17)
SELECT * FROM tl_news_category WHERE tl_news_category.alias=? AND tl_news_category.published=? LIMIT 0,1
SELECT news_id FROM tl_news_categories WHERE category_id IN ('10')
SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? AND tl_news.id IN(1,17) ORDER BY tl_news.date DESC LIMIT 0,2
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('36b7f892dae911e9849f8275119b9998')) ORDER BY tl_files.uuid!=UNHEX('36b7f892dae911e9849f8275119b9998')
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' ORDER BY sorting ASC
SELECT category_id FROM tl_news_categories WHERE news_id IN ('17')
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0
SELECT category_id FROM tl_news_categories WHERE news_id IN ('1')
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0
SELECT * FROM tl_news_category WHERE tl_news_category.alias=? AND tl_news_category.published=? LIMIT 0,1
SELECT news_id FROM tl_news_categories WHERE category_id IN ('10')
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? AND tl_news.id IN(1,17)
SELECT * FROM tl_news_category WHERE tl_news_category.alias=? AND tl_news_category.published=? LIMIT 0,1
SELECT news_id FROM tl_news_categories WHERE category_id IN ('10')
SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? AND tl_news.id IN(1,17) ORDER BY tl_news.date DESC LIMIT 0,2
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('36b7f892dae911e9849f8275119b9998')) ORDER BY tl_files.uuid!=UNHEX('36b7f892dae911e9849f8275119b9998')
SELECT category_id FROM tl_news_categories WHERE news_id IN ('17')
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0
SELECT category_id FROM tl_news_categories WHERE news_id IN ('1')
SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT tl_news.* FROM tl_news WHERE BINARY tl_news.alias=? AND tl_news.pid IN(2) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<='1727670540') AND (tl_news.stop='' OR tl_news.stop>'1727670540') LIMIT 0,1
SELECT tl_node.* FROM tl_node WHERE id IN (3) AND type=? ORDER BY FIND_IN_SET(`id`, ?)
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(22,25,26) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') ORDER BY FIND_IN_SET(`tl_page`.`id`, '22,25,26')
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('15c25f44d7bb11e9a2e78275119b9998')) ORDER BY tl_files.uuid!=UNHEX('15c25f44d7bb11e9a2e78275119b9998')
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('5941f6ca246211eb84328275119b9998')) ORDER BY tl_files.uuid!=UNHEX('5941f6ca246211eb84328275119b9998')

#▲	Time	Info
1	0.49 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	1.41 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
3	1.15 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?) Parameters: [`-1 => "news/category/erben-und-schenken" 0 => "news/category" 1 => "news"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?, ?, ?) SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('news/category','news',?);
4	1.27 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`-1 => "21"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1;
5	1.86 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`-1 => "1"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1;
6	0.85 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?) Parameters: [`-1 => "news/category/erben-und-schenken" 0 => "news/category" 1 => "news"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?, ?, ?) SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('news/category','news',?);
7	0.58 ms	SELECT templates FROM tl_theme Parameters: [] View formatted query View runnable query Explain query SELECT templates FROM tl_theme SELECT templates FROM tl_theme;
8	1.90 ms	SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1 Parameters: [`-1 => "3"`] View formatted query View runnable query Explain query SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id` = ? LIMIT 0, 1 SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1;
9	0.59 ms	SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1 Parameters: [`-1 => "1"`] View formatted query View runnable query Explain query SELECT * FROM tl_theme WHERE tl_theme.`id` = ? LIMIT 0, 1 SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1;
10	5.75 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(4,1,3,9,0,6,12,5) ORDER BY FIND_IN_SET(`tl_module`.`id`, '4,1,3,9,0,6,12,5') Parameters: [] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(4, 1, 3, 9, 0, 6, 12, 5) ORDER BY FIND_IN_SET( `tl_module`.`id`, '4,1,3,9,0,6,12,5' ) SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(4,1,3,9,0,6,12,5) ORDER BY FIND_IN_SET(`tl_module`.`id`, '4,1,3,9,0,6,12,5');
11	1.40 ms	SELECT tl_node.* FROM tl_node WHERE id IN (2) AND type=? ORDER BY FIND_IN_SET(`id`, ?) Parameters: [`-1 => "content" 0 => "2"`] View formatted query View runnable query Explain query SELECT tl_node.* FROM tl_node WHERE id IN (2) AND type = ? ORDER BY FIND_IN_SET(`id`, ?) SELECT tl_node.* FROM tl_node WHERE id IN (2) AND type='2' ORDER BY FIND_IN_SET(`id`, ?);
12	8.99 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`-1 => "2" 0 => "tl_node"`] View formatted query View runnable query Explain query SELECT tl_content.* FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid='tl_node' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
13	5.00 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`-1 => "a5082434db1f11e9849f8275119b9998"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1;
14	21.17 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting Parameters: [`-1 => "1"`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = '' AND p2.published = '1' AND ( p2.start = '' OR p2.start <= '1727670540' ) AND ( p2.stop = '' OR p2.stop > '1727670540' ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = '' AND p1.published = '1' AND ( p1.start = '' OR p1.start <= '1727670540' ) AND ( p1.stop = '' OR p1.stop > '1727670540' ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting;
15	1.00 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(3,60,5,6) ORDER BY FIND_IN_SET(`tl_page`.`id`, '3,60,5,6') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(3, 60, 5, 6) ORDER BY FIND_IN_SET(`tl_page`.`id`, '3,60,5,6') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(3,60,5,6) ORDER BY FIND_IN_SET(`tl_page`.`id`, '3,60,5,6');
16	1.02 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting Parameters: [`-1 => "3"`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = '' AND p2.published = '1' AND ( p2.start = '' OR p2.start <= '1727670540' ) AND ( p2.stop = '' OR p2.stop > '1727670540' ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = '' AND p1.published = '1' AND ( p1.start = '' OR p1.start <= '1727670540' ) AND ( p1.stop = '' OR p1.stop > '1727670540' ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting;
17	0.87 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(59,64,65,76,63) ORDER BY FIND_IN_SET(`tl_page`.`id`, '59,64,65,76,63') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(59, 64, 65, 76, 63) ORDER BY FIND_IN_SET( `tl_page`.`id`, '59,64,65,76,63' ) SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(59,64,65,76,63) ORDER BY FIND_IN_SET(`tl_page`.`id`, '59,64,65,76,63');
18	0.95 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting Parameters: [`-1 => "60"`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = '' AND p2.published = '1' AND ( p2.start = '' OR p2.start <= '1727670540' ) AND ( p2.stop = '' OR p2.stop > '1727670540' ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = '' AND p1.published = '1' AND ( p1.start = '' OR p1.start <= '1727670540' ) AND ( p1.stop = '' OR p1.stop > '1727670540' ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting;
19	0.58 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(61,98,99) ORDER BY FIND_IN_SET(`tl_page`.`id`, '61,98,99') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(61, 98, 99) ORDER BY FIND_IN_SET(`tl_page`.`id`, '61,98,99') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(61,98,99) ORDER BY FIND_IN_SET(`tl_page`.`id`, '61,98,99');
20	0.99 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting Parameters: [`-1 => "5"`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = '' AND p2.published = '1' AND ( p2.start = '' OR p2.start <= '1727670540' ) AND ( p2.stop = '' OR p2.stop > '1727670540' ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = '' AND p1.published = '1' AND ( p1.start = '' OR p1.start <= '1727670540' ) AND ( p1.stop = '' OR p1.stop > '1727670540' ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting;
21	0.60 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(106,107,108,109,110,111) ORDER BY FIND_IN_SET(`tl_page`.`id`, '106,107,108,109,110,111') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(106, 107, 108, 109, 110, 111) ORDER BY FIND_IN_SET( `tl_page`.`id`, '106,107,108,109,110,111' ) SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(106,107,108,109,110,111) ORDER BY FIND_IN_SET(`tl_page`.`id`, '106,107,108,109,110,111');
22	1.00 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting Parameters: [`-1 => "6"`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = '' AND p2.published = '1' AND ( p2.start = '' OR p2.start <= '1727670540' ) AND ( p2.stop = '' OR p2.stop > '1727670540' ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = '' AND p1.published = '1' AND ( p1.start = '' OR p1.start <= '1727670540' ) AND ( p1.stop = '' OR p1.stop > '1727670540' ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1727670540') AND (p2.stop='' OR p2.stop>'1727670540')) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1727670540') AND (p1.stop='' OR p1.stop>'1727670540') ORDER BY p1.sorting;
23	0.46 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(48,47,57,58) ORDER BY FIND_IN_SET(`tl_page`.`id`, '48,47,57,58') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(48, 47, 57, 58) ORDER BY FIND_IN_SET(`tl_page`.`id`, '48,47,57,58') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(48,47,57,58) ORDER BY FIND_IN_SET(`tl_page`.`id`, '48,47,57,58');
24	1.49 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(23,17,24,19) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') ORDER BY FIND_IN_SET(`tl_page`.`id`, '23,17,24,19') Parameters: [`-1 => null`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(23, 17, 24, 19) AND tl_page.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) ORDER BY FIND_IN_SET(`tl_page`.`id`, '23,17,24,19') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(23,17,24,19) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') ORDER BY FIND_IN_SET(`tl_page`.`id`, '23,17,24,19');
25	1.54 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`-1 => "15"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1;
26	1.09 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "18"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
27	2.33 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "11"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
28	2.31 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.pid=? AND tl_article.inColumn=? AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1727670540') AND (tl_article.stop='' OR tl_article.stop>'1727670540') ORDER BY tl_article.sorting Parameters: [`-1 => "18" 0 => "main"`] View formatted query View runnable query Explain query SELECT tl_article.* FROM tl_article WHERE tl_article.pid = ? AND tl_article.inColumn = ? AND tl_article.published = '1' AND ( tl_article.start = '' OR tl_article.start <= '1727670540' ) AND ( tl_article.stop = '' OR tl_article.stop > '1727670540' ) ORDER BY tl_article.sorting SELECT tl_article.* FROM tl_article WHERE tl_article.pid='main' AND tl_article.inColumn=? AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1727670540') AND (tl_article.stop='' OR tl_article.stop>'1727670540') ORDER BY tl_article.sorting;
29	6.83 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND (tl_content.ptable=? OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`-1 => "13" 0 => "tl_article"`] View formatted query View runnable query Explain query SELECT tl_content.* FROM tl_content WHERE tl_content.pid = ? AND ( tl_content.ptable = ? OR tl_content.ptable = '' ) AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid='tl_article' AND (tl_content.ptable=? OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
30	1.22 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`-1 => "1439e08ce08c11e9849f8275119b9998"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1;
31	2.83 ms	SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1 Parameters: [`-1 => "3"`] View formatted query View runnable query Explain query SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id` = ? LIMIT 0, 1 SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1;
32	5.41 ms	SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' ORDER BY sorting ASC Parameters: [`-1 => 3`] View formatted query View runnable query Explain query SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid = ? AND tl_image_size_item.invisible = '' ORDER BY sorting ASC SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' ORDER BY sorting ASC;
33	1.48 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`-1 => "13"`] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = ? LIMIT 0, 1 SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1;
34	0.97 ms	SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.id IN(2) ORDER BY FIND_IN_SET(`tl_news_archive`.`id`, '2') Parameters: [] View formatted query View runnable query Explain query SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.id IN(2) ORDER BY FIND_IN_SET(`tl_news_archive`.`id`, '2') SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.id IN(2) ORDER BY FIND_IN_SET(`tl_news_archive`.`id`, '2');
35	1.61 ms	SELECT * FROM tl_news_category WHERE tl_news_category.`published`=? ORDER BY tl_news_category.sorting Parameters: [`-1 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.`published` = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.`published`=? ORDER BY tl_news_category.sorting;
36	0.62 ms	SELECT * FROM tl_news_category WHERE tl_news_category.alias=? AND tl_news_category.published=? LIMIT 0,1 Parameters: [`-1 => "erben-und-schenken" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.alias = ? AND tl_news_category.published = ? LIMIT 0, 1 SELECT * FROM tl_news_category WHERE tl_news_category.alias=1 AND tl_news_category.published=? LIMIT 0,1;
37	12.66 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "5"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
38	0.85 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "10"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
39	1.24 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "6"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
40	0.76 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "11"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
41	0.86 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "7"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
42	0.92 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "12"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
43	0.40 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "8"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
44	0.41 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "9"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
45	0.37 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => 0 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5, 10, 7, 6, 11, 12, 8, 9) AND tl_news_category.pid = ? AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=1 AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
46	0.79 ms	SELECT news_id FROM tl_news_categories Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories SELECT news_id FROM tl_news_categories;
47	2.18 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 ) AND tl_news.pid IN (2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20) AND tl_news.pid IN (2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=?;
48	0.67 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "5"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
49	0.53 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "10"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
50	0.45 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => "5" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5, 10, 7, 6, 11, 12, 8, 9) AND tl_news_category.pid = ? AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=1 AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
51	0.33 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('5') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('5') SELECT news_id FROM tl_news_categories WHERE category_id IN ('5');
52	1.14 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (11,12,20) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (11, 12, 20) AND tl_news.pid IN (2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (11,12,20) AND tl_news.pid IN (2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=?;
53	0.73 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "6"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
54	0.72 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => "6" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5, 10, 7, 6, 11, 12, 8, 9) AND tl_news_category.pid = ? AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=1 AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
55	0.27 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('6') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('6') SELECT news_id FROM tl_news_categories WHERE category_id IN ('6');
56	0.41 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (4,6,14,19) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (4, 6, 14, 19) AND tl_news.pid IN (2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (4,6,14,19) AND tl_news.pid IN (2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=?;
57	0.56 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "7"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
58	9.79 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => "7" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5, 10, 7, 6, 11, 12, 8, 9) AND tl_news_category.pid = ? AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=1 AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
59	0.86 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => "10" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5, 10, 7, 6, 11, 12, 8, 9) AND tl_news_category.pid = ? AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=1 AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
60	0.31 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('10') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('10') SELECT news_id FROM tl_news_categories WHERE category_id IN ('10');
61	0.46 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (1,17) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (1, 17) AND tl_news.pid IN (2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (1,17) AND tl_news.pid IN (2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=?;
62	0.54 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "11"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
63	0.50 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => "11" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5, 10, 7, 6, 11, 12, 8, 9) AND tl_news_category.pid = ? AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=1 AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
64	4.04 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('11') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('11') SELECT news_id FROM tl_news_categories WHERE category_id IN ('11');
65	1.61 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (18) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (18) AND tl_news.pid IN (2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (18) AND tl_news.pid IN (2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=?;
66	0.85 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "12"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
67	0.89 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => "12" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5, 10, 7, 6, 11, 12, 8, 9) AND tl_news_category.pid = ? AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=1 AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
68	2.88 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('12') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('12') SELECT news_id FROM tl_news_categories WHERE category_id IN ('12');
69	2.10 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (5,10,13) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (5, 10, 13) AND tl_news.pid IN (2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (5,10,13) AND tl_news.pid IN (2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=?;
70	0.47 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('7') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('7') SELECT news_id FROM tl_news_categories WHERE category_id IN ('7');
71	0.43 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (1,2,5,10,13,17,18) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (1, 2, 5, 10, 13, 17, 18) AND tl_news.pid IN (2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (1,2,5,10,13,17,18) AND tl_news.pid IN (2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=?;
72	0.51 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "8"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
73	0.46 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => "8" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5, 10, 7, 6, 11, 12, 8, 9) AND tl_news_category.pid = ? AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=1 AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
74	0.22 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('8') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('8') SELECT news_id FROM tl_news_categories WHERE category_id IN ('8');
75	0.32 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (9,16) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (9, 16) AND tl_news.pid IN (2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (9,16) AND tl_news.pid IN (2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=?;
76	0.37 ms	SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid Parameters: [`-1 => "9"`] View formatted query View runnable query Explain query SELECT id, @pid := pid FROM tl_news_category WHERE id = ? UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid UNION SELECT id, @pid := pid FROM tl_news_category WHERE id = @pid SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;
77	3.29 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=? AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => "9" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5, 10, 7, 6, 11, 12, 8, 9) AND tl_news_category.pid = ? AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=1 AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
78	0.38 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('9') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('9') SELECT news_id FROM tl_news_categories WHERE category_id IN ('9');
79	0.33 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (3,7,8,15) AND tl_news.pid IN (2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.id IN (3, 7, 8, 15) AND tl_news.pid IN (2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (3,7,8,15) AND tl_news.pid IN (2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=?;
80	0.73 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`-1 => "10"`] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = ? LIMIT 0, 1 SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1;
81	0.35 ms	SELECT * FROM tl_news_category WHERE tl_news_category.alias=? AND tl_news_category.published=? LIMIT 0,1 Parameters: [`-1 => "erben-und-schenken" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.alias = ? AND tl_news_category.published = ? LIMIT 0, 1 SELECT * FROM tl_news_category WHERE tl_news_category.alias=1 AND tl_news_category.published=? LIMIT 0,1;
82	0.18 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('10') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('10') SELECT news_id FROM tl_news_categories WHERE category_id IN ('10');
83	0.30 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? AND tl_news.id IN(1,17) Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.pid IN(2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? AND tl_news.id IN(1, 17) SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=? AND tl_news.id IN(1,17);
84	0.46 ms	SELECT * FROM tl_news_category WHERE tl_news_category.alias=? AND tl_news_category.published=? LIMIT 0,1 Parameters: [`-1 => "erben-und-schenken" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.alias = ? AND tl_news_category.published = ? LIMIT 0, 1 SELECT * FROM tl_news_category WHERE tl_news_category.alias=1 AND tl_news_category.published=? LIMIT 0,1;
85	0.24 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('10') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('10') SELECT news_id FROM tl_news_categories WHERE category_id IN ('10');
86	0.67 ms	SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? AND tl_news.id IN(1,17) ORDER BY tl_news.date DESC LIMIT 0,2 Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? AND tl_news.id IN(1, 17) ORDER BY tl_news.date DESC LIMIT 0, 2 SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=? AND tl_news.id IN(1,17) ORDER BY tl_news.date DESC LIMIT 0,2;
87	0.58 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('36b7f892dae911e9849f8275119b9998')) ORDER BY tl_files.uuid!=UNHEX('36b7f892dae911e9849f8275119b9998') Parameters: [`-1 => null`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( '36b7f892dae911e9849f8275119b9998' ) ) ORDER BY tl_files.uuid != UNHEX( '36b7f892dae911e9849f8275119b9998' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('36b7f892dae911e9849f8275119b9998')) ORDER BY tl_files.uuid!=UNHEX('36b7f892dae911e9849f8275119b9998');
88	0.55 ms	SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1 Parameters: [`-1 => "4"`] View formatted query View runnable query Explain query SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id` = ? LIMIT 0, 1 SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1;
89	0.46 ms	SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' ORDER BY sorting ASC Parameters: [`-1 => 4`] View formatted query View runnable query Explain query SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid = ? AND tl_image_size_item.invisible = '' ORDER BY sorting ASC SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' ORDER BY sorting ASC;
90	1.25 ms	SELECT category_id FROM tl_news_categories WHERE news_id IN ('17') Parameters: [] View formatted query View runnable query Explain query SELECT category_id FROM tl_news_categories WHERE news_id IN ('17') SELECT category_id FROM tl_news_categories WHERE news_id IN ('17');
91	0.46 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7, 10) AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
92	0.55 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "18"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
93	0.54 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "18"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
94	0.34 ms	SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 Parameters: [`-1 => "17" 0 => "tl_news"`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='tl_news' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0;
95	0.30 ms	SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 Parameters: [`-1 => "17" 0 => "tl_news"`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='tl_news' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0;
96	0.28 ms	SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 Parameters: [`-1 => "17" 0 => "tl_news"`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='tl_news' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0;
97	0.24 ms	SELECT category_id FROM tl_news_categories WHERE news_id IN ('1') Parameters: [] View formatted query View runnable query Explain query SELECT category_id FROM tl_news_categories WHERE news_id IN ('1') SELECT category_id FROM tl_news_categories WHERE news_id IN ('1');
98	0.32 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7, 10) AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
99	0.41 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "18"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
100	0.42 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "18"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
101	0.36 ms	SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 Parameters: [`-1 => "1" 0 => "tl_news"`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='tl_news' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0;
102	0.31 ms	SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 Parameters: [`-1 => "1" 0 => "tl_news"`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='tl_news' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0;
103	0.32 ms	SELECT * FROM tl_news_category WHERE tl_news_category.alias=? AND tl_news_category.published=? LIMIT 0,1 Parameters: [`-1 => "erben-und-schenken" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.alias = ? AND tl_news_category.published = ? LIMIT 0, 1 SELECT * FROM tl_news_category WHERE tl_news_category.alias=1 AND tl_news_category.published=? LIMIT 0,1;
104	0.23 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('10') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('10') SELECT news_id FROM tl_news_categories WHERE category_id IN ('10');
105	0.39 ms	SELECT COUNT() AS count FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? AND tl_news.id IN(1,17) Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_news WHERE tl_news.pid IN(2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? AND tl_news.id IN(1, 17) SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=? AND tl_news.id IN(1,17);
106	0.32 ms	SELECT * FROM tl_news_category WHERE tl_news_category.alias=? AND tl_news_category.published=? LIMIT 0,1 Parameters: [`-1 => "erben-und-schenken" 0 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.alias = ? AND tl_news_category.published = ? LIMIT 0, 1 SELECT * FROM tl_news_category WHERE tl_news_category.alias=1 AND tl_news_category.published=? LIMIT 0,1;
107	0.32 ms	SELECT news_id FROM tl_news_categories WHERE category_id IN ('10') Parameters: [] View formatted query View runnable query Explain query SELECT news_id FROM tl_news_categories WHERE category_id IN ('10') SELECT news_id FROM tl_news_categories WHERE category_id IN ('10');
108	0.59 ms	SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=? OR tl_news.start<=?) AND (tl_news.stop=? OR tl_news.stop>?) AND tl_news.published=? AND tl_news.id IN(1,17) ORDER BY tl_news.date DESC LIMIT 0,2 Parameters: [`-1 => "" 0 => 1727670540 1 => "" 2 => 1727670600 3 => 1`] View formatted query View runnable query Explain query SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(2) AND ( tl_news.start = ? OR tl_news.start <= ? ) AND ( tl_news.stop = ? OR tl_news.stop > ? ) AND tl_news.published = ? AND tl_news.id IN(1, 17) ORDER BY tl_news.date DESC LIMIT 0, 2 SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=1727670540 OR tl_news.start<='') AND (tl_news.stop=1727670600 OR tl_news.stop>1) AND tl_news.published=? AND tl_news.id IN(1,17) ORDER BY tl_news.date DESC LIMIT 0,2;
109	0.40 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('36b7f892dae911e9849f8275119b9998')) ORDER BY tl_files.uuid!=UNHEX('36b7f892dae911e9849f8275119b9998') Parameters: [`-1 => null`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( '36b7f892dae911e9849f8275119b9998' ) ) ORDER BY tl_files.uuid != UNHEX( '36b7f892dae911e9849f8275119b9998' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('36b7f892dae911e9849f8275119b9998')) ORDER BY tl_files.uuid!=UNHEX('36b7f892dae911e9849f8275119b9998');
110	0.53 ms	SELECT category_id FROM tl_news_categories WHERE news_id IN ('17') Parameters: [] View formatted query View runnable query Explain query SELECT category_id FROM tl_news_categories WHERE news_id IN ('17') SELECT category_id FROM tl_news_categories WHERE news_id IN ('17');
111	3.43 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7, 10) AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
112	0.60 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "18"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
113	0.66 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "18"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
114	0.52 ms	SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 Parameters: [`-1 => "17" 0 => "tl_news"`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='tl_news' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0;
115	0.54 ms	SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 Parameters: [`-1 => "17" 0 => "tl_news"`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='tl_news' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0;
116	0.96 ms	SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 Parameters: [`-1 => "17" 0 => "tl_news"`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='tl_news' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0;
117	0.40 ms	SELECT category_id FROM tl_news_categories WHERE news_id IN ('1') Parameters: [] View formatted query View runnable query Explain query SELECT category_id FROM tl_news_categories WHERE news_id IN ('1') SELECT category_id FROM tl_news_categories WHERE news_id IN ('1');
118	0.72 ms	SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting Parameters: [`-1 => 1`] View formatted query View runnable query Explain query SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7, 10) AND tl_news_category.published = ? ORDER BY tl_news_category.sorting SELECT * FROM tl_news_category WHERE tl_news_category.id IN (7,10) AND tl_news_category.published=? ORDER BY tl_news_category.sorting;
119	0.51 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "18"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
120	0.59 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "18"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
121	0.52 ms	SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 Parameters: [`-1 => "1" 0 => "tl_news"`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='tl_news' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0;
122	0.26 ms	SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 Parameters: [`-1 => "1" 0 => "tl_news"`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='tl_news' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0;
123	0.94 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`-1 => "19"`] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = ? LIMIT 0, 1 SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1;
124	0.80 ms	SELECT tl_news.* FROM tl_news WHERE BINARY tl_news.alias=? AND tl_news.pid IN(2) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<='1727670540') AND (tl_news.stop='' OR tl_news.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => null`] View formatted query View runnable query Explain query SELECT tl_news.* FROM tl_news WHERE BINARY tl_news.alias = ? AND tl_news.pid IN(2) AND tl_news.published = '1' AND ( tl_news.start = '' OR tl_news.start <= '1727670540' ) AND ( tl_news.stop = '' OR tl_news.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_news.* FROM tl_news WHERE BINARY tl_news.alias=? AND tl_news.pid IN(2) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<='1727670540') AND (tl_news.stop='' OR tl_news.stop>'1727670540') LIMIT 0,1;
125	0.57 ms	SELECT tl_node.* FROM tl_node WHERE id IN (3) AND type=? ORDER BY FIND_IN_SET(`id`, ?) Parameters: [`-1 => "content" 0 => "3"`] View formatted query View runnable query Explain query SELECT tl_node.* FROM tl_node WHERE id IN (3) AND type = ? ORDER BY FIND_IN_SET(`id`, ?) SELECT tl_node.* FROM tl_node WHERE id IN (3) AND type='3' ORDER BY FIND_IN_SET(`id`, ?);
126	12.14 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`-1 => "3" 0 => "tl_node"`] View formatted query View runnable query Explain query SELECT tl_content.* FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= '1727670540' ) AND ( tl_content.stop = '' OR tl_content.stop > '1727670540' ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid='tl_node' AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1727670540') AND (tl_content.stop='' OR tl_content.stop>'1727670540') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
127	1.42 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(22,25,26) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') ORDER BY FIND_IN_SET(`tl_page`.`id`, '22,25,26') Parameters: [`-1 => null`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(22, 25, 26) AND tl_page.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) ORDER BY FIND_IN_SET(`tl_page`.`id`, '22,25,26') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(22,25,26) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') ORDER BY FIND_IN_SET(`tl_page`.`id`, '22,25,26');
128	0.69 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`-1 => "14"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1;
129	0.83 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "11"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
130	0.82 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "9"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
131	0.70 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1 Parameters: [`-1 => "10"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= '1727670540' ) AND ( tl_page.stop = '' OR tl_page.stop > '1727670540' ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1727670540') AND (tl_page.stop='' OR tl_page.stop>'1727670540') LIMIT 0,1;
132	0.88 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('15c25f44d7bb11e9a2e78275119b9998')) ORDER BY tl_files.uuid!=UNHEX('15c25f44d7bb11e9a2e78275119b9998') Parameters: [`-1 => null`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( '15c25f44d7bb11e9a2e78275119b9998' ) ) ORDER BY tl_files.uuid != UNHEX( '15c25f44d7bb11e9a2e78275119b9998' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('15c25f44d7bb11e9a2e78275119b9998')) ORDER BY tl_files.uuid!=UNHEX('15c25f44d7bb11e9a2e78275119b9998');
133	0.48 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('5941f6ca246211eb84328275119b9998')) ORDER BY tl_files.uuid!=UNHEX('5941f6ca246211eb84328275119b9998') Parameters: [`-1 => null`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( '5941f6ca246211eb84328275119b9998' ) ) ORDER BY tl_files.uuid != UNHEX( '5941f6ca246211eb84328275119b9998' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('5941f6ca246211eb84328275119b9998')) ORDER BY tl_files.uuid!=UNHEX('5941f6ca246211eb84328275119b9998');

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.

Entities Mapping

Class	Mapping errors
Contao\CoreBundle\Entity\RememberMe	No errors.

Symfony Profiler

https://buetow.romeni.eu/de/news/category/erben-und-schenken.html

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping