Array
(
[classes_aliased] => Array
(
[0] => Input (Contao\Input)
[1] => RequestToken (Contao\RequestToken)
[2] => Environment (Contao\Environment)
[3] => Frontend (Contao\Frontend)
[4] => Controller (Contao\Controller)
[5] => System (Contao\System)
[6] => FrontendUser (Contao\FrontendUser)
[7] => User (Contao\User)
[8] => Session (Contao\Session)
[9] => Database (Contao\Database)
[10] => Database\Mysql (Contao\Database\Mysql)
[11] => PageModel (Contao\PageModel)
[12] => Model (Contao\Model)
[13] => Model\QueryBuilder (Contao\Model\QueryBuilder)
[14] => DcaExtractor (Contao\DcaExtractor)
[15] => Backend (Contao\Backend)
[16] => Database\Mysql\Statement (Contao\Database\Mysql\Statement)
[17] => Database\Statement (Contao\Database\Statement)
[18] => Database\Mysql\Result (Contao\Database\Mysql\Result)
[19] => Database\Result (Contao\Database\Result)
[20] => Model\Collection (Contao\Model\Collection)
[21] => String (Contao\String)
[22] => PageRegular (Contao\PageRegular)
[23] => LayoutModel (Contao\LayoutModel)
[24] => ThemeModel (Contao\ThemeModel)
[25] => FrontendTemplate (Contao\FrontendTemplate)
[26] => Template (Contao\Template)
[27] => ModuleModel (Contao\ModuleModel)
[28] => ArticleModel (Contao\ArticleModel)
[29] => BackendUser (Contao\BackendUser)
[30] => UserModel (Contao\UserModel)
[31] => ModuleArticle (Contao\ModuleArticle)
[32] => Module (Contao\Module)
[33] => Date (Contao\Date)
[34] => ContentModel (Contao\ContentModel)
[35] => ContentElement (Contao\ContentElement)
[36] => ContentText (Contao\ContentText)
[37] => ModuleNavigation (Contao\ModuleNavigation)
[38] => ModuleNewsList (Contao\ModuleNewsList)
[39] => ModuleNews (Contao\ModuleNews)
[40] => NewsArchiveModel (Contao\NewsArchiveModel)
[41] => NewsModel (Contao\NewsModel)
[42] => ModuleBreadcrumb (Contao\ModuleBreadcrumb)
[43] => Combiner (Contao\Combiner)
[44] => File (Contao\File)
[45] => Files (Contao\Files)
[46] => Files\Php (Contao\Files\Php)
[47] => Search (Contao\Search)
)
[classes_set] => Array
(
[0] => RepositoryBackendTheme
)
[database_queries] => Array
(
[0] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id=0 OR tl_page.alias='metiers-de-la-securite') AND (tl_page.start='' OR tl_page.start<1713864236) AND (tl_page.stop='' OR tl_page.stop>1713864236) AND tl_page.published=1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 2.50
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[1] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='12' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 3 row(s) returned
)
[2] => Array
(
[query] => SELECT tl_layout.*, j1.id AS pid__id, j1.tstamp AS pid__tstamp, j1.name AS pid__name, j1.author AS pid__author, j1.folders AS pid__folders, j1.screenshot AS pid__screenshot, j1.templates AS pid__templates, j1.vars AS pid__vars FROM tl_layout LEFT JOIN tl_theme j1 ON tl_layout.pid=j1.id WHERE tl_layout.id='4' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_layout
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[3] => Array
(
[query] => SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id IN(0) ORDER BY FIND_IN_SET(tl_module.id, '0')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] =>
[partitions] =>
[type] =>
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[filtered] =>
[Extra] => no matching row in const table
)
[returned] => 0 row(s) returned
)
[4] => Array
(
[query] => SELECT tl_article.*, j1.id AS author__id, j1.tstamp AS author__tstamp, j1.username AS author__username, j1.name AS author__name, j1.email AS author__email, j1.language AS author__language, j1.backendTheme AS author__backendTheme, j1.uploader AS author__uploader, j1.showHelp AS author__showHelp, j1.thumbnails AS author__thumbnails, j1.useRTE AS author__useRTE, j1.useCE AS author__useCE, j1.password AS author__password, j1.pwChange AS author__pwChange, j1.admin AS author__admin, j1.groups AS author__groups, j1.inherit AS author__inherit, j1.modules AS author__modules, j1.themes AS author__themes, j1.pagemounts AS author__pagemounts, j1.alpty AS author__alpty, j1.filemounts AS author__filemounts, j1.fop AS author__fop, j1.forms AS author__forms, j1.formp AS author__formp, j1.disable AS author__disable, j1.start AS author__start, j1.stop AS author__stop, j1.session AS author__session, j1.dateAdded AS author__dateAdded, j1.lastLogin AS author__lastLogin, j1.currentLogin AS author__currentLogin, j1.loginCount AS author__loginCount, j1.locked AS author__locked, j1.calendars AS author__calendars, j1.calendarp AS author__calendarp, j1.calendarfeeds AS author__calendarfeeds, j1.calendarfeedp AS author__calendarfeedp, j1.faqs AS author__faqs, j1.faqp AS author__faqp, j1.news AS author__news, j1.newp AS author__newp, j1.newsfeeds AS author__newsfeeds, j1.newsfeedp AS author__newsfeedp, j1.newsletters AS author__newsletters, j1.newsletterp AS author__newsletterp FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='38' AND tl_article.inColumn='main' AND (tl_article.start='' OR tl_article.start<1713864236) AND (tl_article.stop='' OR tl_article.stop>1713864236) AND tl_article.published=1 ORDER BY tl_article.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_article
[partitions] =>
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 4
[filtered] => 1.25
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[5] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='33' AND (ptable='tl_article' OR ptable='') AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[partitions] =>
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 9.79
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[6] => Array
(
[query] => SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='7' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[7] => Array
(
[query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1713864236) AND (p2.stop='' OR p2.stop>1713864236) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='2' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1713864236) AND (p1.stop='' OR p1.stop>1713864236) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 6
[filtered] => 0.90
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[8] => Array
(
[query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1713864236) AND (p2.stop='' OR p2.stop>1713864236) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='4' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1713864236) AND (p1.stop='' OR p1.stop>1713864236) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[filtered] => 1.67
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 5 row(s) returned
)
[9] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='29' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[10] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='6' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 3 row(s) returned
)
[11] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='64' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[12] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='63' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 2 row(s) returned
)
[13] => Array
(
[query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1713864236) AND (p2.stop='' OR p2.stop>1713864236) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='11' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1713864236) AND (p1.stop='' OR p1.stop>1713864236) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[filtered] => 1.67
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 4 row(s) returned
)
[14] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.pid='14' AND tl_page.type='regular' AND (tl_page.start='' OR tl_page.start<1713864236) AND (tl_page.stop='' OR tl_page.stop>1713864236) AND tl_page.published=1 ORDER BY tl_page.sorting LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[filtered] => 2.50
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[15] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='14' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 3 row(s) returned
)
[16] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='146' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[17] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='11' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 2 row(s) returned
)
[18] => Array
(
[query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1713864236) AND (p2.stop='' OR p2.stop>1713864236) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='15' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1713864236) AND (p1.stop='' OR p1.stop>1713864236) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 5.00
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[19] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.pid='15' AND tl_page.type='regular' AND (tl_page.start='' OR tl_page.start<1713864237) AND (tl_page.stop='' OR tl_page.stop>1713864237) AND tl_page.published=1 ORDER BY tl_page.sorting LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 5.00
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[20] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='15' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 2 row(s) returned
)
[21] => Array
(
[query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1713864237) AND (p2.stop='' OR p2.stop>1713864237) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='16' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1713864237) AND (p1.stop='' OR p1.stop>1713864237) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 5.00
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[22] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='24' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[23] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='16' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 2 row(s) returned
)
[24] => Array
(
[query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1713864237) AND (p2.stop='' OR p2.stop>1713864237) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='19' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1713864237) AND (p1.stop='' OR p1.stop>1713864237) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[filtered] => 2.50
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 4 row(s) returned
)
[25] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='26' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[26] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='19' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 2 row(s) returned
)
[27] => Array
(
[query] => SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='8' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[28] => Array
(
[query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1713864237) AND (p2.stop='' OR p2.stop>1713864237) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='11' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1713864237) AND (p1.stop='' OR p1.stop>1713864237) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[filtered] => 1.67
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 4 row(s) returned
)
[29] => Array
(
[query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1713864237) AND (p2.stop='' OR p2.stop>1713864237) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='12' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1713864237) AND (p1.stop='' OR p1.stop>1713864237) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[filtered] => 2.50
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 4 row(s) returned
)
[30] => Array
(
[query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1713864237) AND (p2.stop='' OR p2.stop>1713864237) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='14' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1713864237) AND (p1.stop='' OR p1.stop>1713864237) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[filtered] => 2.50
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[31] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.pid='14' AND tl_page.type='regular' AND (tl_page.start='' OR tl_page.start<1713864237) AND (tl_page.stop='' OR tl_page.stop>1713864237) AND tl_page.published=1 ORDER BY tl_page.sorting LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[filtered] => 2.50
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[32] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='14' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 3 row(s) returned
)
[33] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='56' OR tl_page.alias='56') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 0 row(s) returned
)
[34] => Array
(
[query] => SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='15' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[35] => Array
(
[query] => SELECT tl_news_archive.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop FROM tl_news_archive LEFT JOIN tl_page j1 ON tl_news_archive.jumpTo=j1.id WHERE tl_news_archive.id IN(1) ORDER BY FIND_IN_SET(tl_news_archive.id, '1')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_news_archive
[partitions] =>
[type] => system
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[36] => Array
(
[query] => SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start='' OR tl_news.start<1713864237) AND (tl_news.stop='' OR tl_news.stop>1713864237) AND tl_news.published=1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_news
[partitions] =>
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 89
[filtered] => 1.60
[Extra] => Using where
)
[returned] => 1 row(s) returned
)
[37] => Array
(
[query] => SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='2' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[38] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='12' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 3 row(s) returned
)
[39] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.pid='2' AND tl_page.type!='root' AND tl_page.type!='error_403' AND tl_page.type!='error_404' AND (tl_page.start='' OR tl_page.start<1713864237) AND (tl_page.stop='' OR tl_page.stop>1713864237) AND tl_page.published=1 ORDER BY tl_page.sorting LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 6
[filtered] => 1.60
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[40] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='146' AND (tl_page.start='' OR tl_page.start<1713864237) AND (tl_page.stop='' OR tl_page.stop>1713864237) AND tl_page.published=1 LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[41] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='187' OR tl_page.alias='187') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[42] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='38' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 4 row(s) returned
)
[43] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='187' OR tl_page.alias='187') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[44] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='38' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 4 row(s) returned
)
[45] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='188' OR tl_page.alias='188') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[46] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='38' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 4 row(s) returned
)
[47] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='188' OR tl_page.alias='188') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[48] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='38' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 4 row(s) returned
)
[49] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='189' OR tl_page.alias='189') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[50] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='38' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 4 row(s) returned
)
[51] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='189' OR tl_page.alias='189') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[52] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='38' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 4 row(s) returned
)
[53] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='190' OR tl_page.alias='190') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[54] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='38' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 4 row(s) returned
)
[55] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='190' OR tl_page.alias='190') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[56] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='38' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 4 row(s) returned
)
[57] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='19' OR tl_page.alias='19') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[58] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='26' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[59] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='19' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 2 row(s) returned
)
[60] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='20' OR tl_page.alias='20') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[61] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='2' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[62] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='21' OR tl_page.alias='21') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[partitions] =>
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[filtered] => 100.00
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[63] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='2' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_page
[partitions] =>
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[filtered] => 100.00
[Extra] =>
)
[returned] => 1 row(s) returned
)
[64] => Array
(
[query] => SELECT id, checksum FROM tl_search WHERE url='index.php/metiers-de-la-securite.html' AND pid='38' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_search
[partitions] =>
[type] => ref
[possible_keys] => pid,url
[key] => url
[key_len] => 767
[ref] => const
[rows] => 1
[filtered] => 5.00
[Extra] => Using where
)
[returned] => 1 row(s) returned
)
)
)
