Execution time: 2,132 msMemory usage: 20.1 MoDatabase queries: 178Rows: 407 returned, 0 affectedRegistered models: 228
Array
(
[classes_aliased] => Array
(
[0] => Model (Contao\Model)
[1] => Input (Contao\Input)
[2] => RequestToken (Contao\RequestToken)
[3] => Environment (Contao\Environment)
[4] => System (Contao\System)
[5] => Session (Contao\Session)
[6] => Frontend (Contao\Frontend)
[7] => Controller (Contao\Controller)
[8] => FrontendUser (Contao\FrontendUser)
[9] => User (Contao\User)
[10] => Database (Contao\Database)
[11] => Database\Mysql (Contao\Database\Mysql)
[12] => PageModel (Contao\PageModel)
[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] => Model\Registry (Contao\Model\Registry)
[22] => String (Contao\String)
[23] => PageRegular (Contao\PageRegular)
[24] => LayoutModel (Contao\LayoutModel)
[25] => ThemeModel (Contao\ThemeModel)
[26] => FrontendTemplate (Contao\FrontendTemplate)
[27] => Template (Contao\Template)
[28] => ModuleModel (Contao\ModuleModel)
[29] => Module (Contao\Module)
[30] => ModuleNavigation (Contao\ModuleNavigation)
[31] => ModuleBreadcrumb (Contao\ModuleBreadcrumb)
[32] => ArticleModel (Contao\ArticleModel)
[33] => BackendUser (Contao\BackendUser)
[34] => Database\Installer (Contao\Database\Installer)
[35] => UserModel (Contao\UserModel)
[36] => ModuleArticle (Contao\ModuleArticle)
[37] => Date (Contao\Date)
[38] => ContentModel (Contao\ContentModel)
[39] => ContentElement (Contao\ContentElement)
[40] => ContentModule (Contao\ContentModule)
[41] => ModuleNewsList (Contao\ModuleNewsList)
[42] => ModuleNews (Contao\ModuleNews)
[43] => NewsArchiveModel (Contao\NewsArchiveModel)
[44] => NewsModel (Contao\NewsModel)
[45] => ContentText (Contao\ContentText)
[46] => FilesModel (Contao\FilesModel)
[47] => Image (Contao\Image)
[48] => File (Contao\File)
[49] => Files (Contao\Files)
[50] => Files\Php (Contao\Files\Php)
[51] => ContentDownload (Contao\ContentDownload)
[52] => ContentHyperlink (Contao\ContentHyperlink)
[53] => ModuleHtml (Contao\ModuleHtml)
[54] => ModuleCustomnav (Contao\ModuleCustomnav)
[55] => ModuleRandomImage (Contao\ModuleRandomImage)
[56] => StyleSheetModel (Contao\StyleSheetModel)
[57] => ModuleMailJetSubscribe (Contao\ModuleMailJetSubscribe)
[58] => Combiner (Contao\Combiner)
[59] => Search (Contao\Search)
)
[classes_set] => Array
(
[0] => RepositoryBackendTheme
[1] => MultiColumnWizardHelper
)
[database_queries] => Array
(
[0] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id=0 OR tl_page.alias='actualites') AND (tl_page.start='' OR tl_page.start<1540125586) AND (tl_page.stop='' OR tl_page.stop>1540125586) AND tl_page.published=1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,386
[ref] =>
[rows] => 2
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[1] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 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='7' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_layout
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[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, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id IN(24,19,0,9,0,15,22,5,28) ORDER BY FIND_IN_SET(tl_module.id, '24,19,0,9,0,15,22,5,28')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => ALL
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 23
[Extra] => Using where; Using filesort
)
[returned] => 7 row(s) returned
)
[4] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='1' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 19
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[5] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='28' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 6
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[6] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='100' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='106' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='104' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[9] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='108' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[10] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='97' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[11] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='102' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[12] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='30' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 3 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='48' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[14] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='128' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[15] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='49' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[16] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='3' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 7
[Extra] => Using where; Using filesort
)
[returned] => 5 row(s) returned
)
[17] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='5' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='132' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[19] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='9' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[20] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='21' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='134' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[22] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='31' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[23] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='58' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='29' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 9
[Extra] => Using where; Using filesort
)
[returned] => 8 row(s) returned
)
[25] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='62' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 6
[Extra] => Using where; Using filesort
)
[returned] => 5 row(s) returned
)
[26] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='64' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 5 row(s) returned
)
[27] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='65' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 4 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='63' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='60' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 1 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='61' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[31] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='121' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[32] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='32' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[33] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='54' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[34] => 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<1540125586) AND (p2.stop='' OR p2.stop>1540125586) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='55' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125586) AND (p1.stop='' OR p1.stop>1540125586) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[35] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[36] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.pid='1' 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<1540125586) AND (tl_page.stop='' OR tl_page.stop>1540125586) AND tl_page.published=1 ORDER BY tl_page.sorting LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 19
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[37] => 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.google AS author__google, 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.galleria AS author__galleria, j1.galleria_permission AS author__galleria_permission, 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, j1.iso_modules AS author__iso_modules, j1.iso_product_types AS author__iso_product_types, j1.iso_product_typep AS author__iso_product_typep, j1.iso_payment_modules AS author__iso_payment_modules, j1.iso_payment_modulep AS author__iso_payment_modulep, j1.iso_shipping_modules AS author__iso_shipping_modules, j1.iso_shipping_modulep AS author__iso_shipping_modulep, j1.iso_tax_classes AS author__iso_tax_classes, j1.iso_tax_classp AS author__iso_tax_classp, j1.iso_tax_rates AS author__iso_tax_rates, j1.iso_tax_ratep AS author__iso_tax_ratep, j1.iso_configs AS author__iso_configs, j1.iso_configp AS author__iso_configp, j1.iso_groups AS author__iso_groups, j1.iso_groupp AS author__iso_groupp, j1.iso_reports AS author__iso_reports FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='44' AND tl_article.inColumn='main' AND (tl_article.start='' OR tl_article.start<1540125586) AND (tl_article.stop='' OR tl_article.stop>1540125586) AND tl_article.published=1 ORDER BY tl_article.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_article
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[38] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='39' 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
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[39] => 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, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='12' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[40] => 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, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo 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
[type] => system
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[41] => Array
(
[query] => SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start='' OR tl_news.start<1540125586) AND (tl_news.stop='' OR tl_news.stop>1540125586) AND tl_news.published=1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_news
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 26
[Extra] => Using where
)
[returned] => 1 row(s) returned
)
[42] => Array
(
[query] => SELECT tl_news.*, j1.id AS pid__id, j1.tstamp AS pid__tstamp, j1.title AS pid__title, j1.jumpTo AS pid__jumpTo, j1.protected AS pid__protected, j1.groups AS pid__groups, j1.allowComments AS pid__allowComments, j1.notify AS pid__notify, j1.sortOrder AS pid__sortOrder, j1.perPage AS pid__perPage, j1.moderate AS pid__moderate, j1.bbcode AS pid__bbcode, j1.requireLogin AS pid__requireLogin, j1.disableCaptcha AS pid__disableCaptcha, j2.id AS author__id, j2.tstamp AS author__tstamp, j2.username AS author__username, j2.name AS author__name, j2.email AS author__email, j2.google AS author__google, j2.language AS author__language, j2.backendTheme AS author__backendTheme, j2.uploader AS author__uploader, j2.showHelp AS author__showHelp, j2.thumbnails AS author__thumbnails, j2.useRTE AS author__useRTE, j2.useCE AS author__useCE, j2.password AS author__password, j2.pwChange AS author__pwChange, j2.admin AS author__admin, j2.groups AS author__groups, j2.inherit AS author__inherit, j2.modules AS author__modules, j2.themes AS author__themes, j2.pagemounts AS author__pagemounts, j2.alpty AS author__alpty, j2.filemounts AS author__filemounts, j2.fop AS author__fop, j2.forms AS author__forms, j2.formp AS author__formp, j2.disable AS author__disable, j2.start AS author__start, j2.stop AS author__stop, j2.session AS author__session, j2.dateAdded AS author__dateAdded, j2.lastLogin AS author__lastLogin, j2.currentLogin AS author__currentLogin, j2.loginCount AS author__loginCount, j2.locked AS author__locked, j2.calendars AS author__calendars, j2.calendarp AS author__calendarp, j2.calendarfeeds AS author__calendarfeeds, j2.calendarfeedp AS author__calendarfeedp, j2.faqs AS author__faqs, j2.faqp AS author__faqp, j2.galleria AS author__galleria, j2.galleria_permission AS author__galleria_permission, j2.news AS author__news, j2.newp AS author__newp, j2.newsfeeds AS author__newsfeeds, j2.newsfeedp AS author__newsfeedp, j2.newsletters AS author__newsletters, j2.newsletterp AS author__newsletterp, j2.iso_modules AS author__iso_modules, j2.iso_product_types AS author__iso_product_types, j2.iso_product_typep AS author__iso_product_typep, j2.iso_payment_modules AS author__iso_payment_modules, j2.iso_payment_modulep AS author__iso_payment_modulep, j2.iso_shipping_modules AS author__iso_shipping_modules, j2.iso_shipping_modulep AS author__iso_shipping_modulep, j2.iso_tax_classes AS author__iso_tax_classes, j2.iso_tax_classp AS author__iso_tax_classp, j2.iso_tax_rates AS author__iso_tax_rates, j2.iso_tax_ratep AS author__iso_tax_ratep, j2.iso_configs AS author__iso_configs, j2.iso_configp AS author__iso_configp, j2.iso_groups AS author__iso_groups, j2.iso_groupp AS author__iso_groupp, j2.iso_reports AS author__iso_reports FROM tl_news LEFT JOIN tl_news_archive j1 ON tl_news.pid=j1.id LEFT JOIN tl_user j2 ON tl_news.author=j2.id WHERE tl_news.pid IN(1) AND (tl_news.start='' OR tl_news.start<1540125586) AND (tl_news.stop='' OR tl_news.stop>1540125586) AND tl_news.published=1 ORDER BY tl_news.date DESC
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_news
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 26
[Extra] => Using where; Using filesort
)
[returned] => 24 row(s) returned
)
[43] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='45' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[44] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='30' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[45] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('f48106fa53f411e6b67edbca61888401') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[46] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('f4974017e16011e6baa530d9b0e3654e') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[47] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='29' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[48] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('44a47949d26711e6baa530d9b0e3654e') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[49] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('5158560dd26711e6baa530d9b0e3654e') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[50] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='28' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[51] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('689f7280d26711e6baa530d9b0e3654e') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[52] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('689f7280d26711e6baa530d9b0e3654e') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[53] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='27' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[54] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('bdfcc214bb9e11e6baa530d9b0e3654e') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[55] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('bdfcc214bb9e11e6baa530d9b0e3654e') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[56] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='25' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[57] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('545f858b8c7611e5816a442f2012fbb7') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[58] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('545f858b8c7611e5816a442f2012fbb7') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[59] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='24' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[60] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('62b65797976711e69acdb0db3989047a') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[61] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('62b65789976711e69acdb0db3989047a') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[62] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='23' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[63] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('65d42c417c1011e69acdb0db3989047a') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[64] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('65d42c337c1011e69acdb0db3989047a') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[65] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('65d42c417c1011e69acdb0db3989047a') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[66] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='22' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[67] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('f48106fa53f411e6b67edbca61888401') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[68] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('e132633e53f411e6b67edbca61888401') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[69] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='21' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[70] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('545f858b8c7611e5816a442f2012fbb7') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[71] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('545f858b8c7611e5816a442f2012fbb7') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[72] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='20' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[73] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('2f5baf338c7411e5816a442f2012fbb7') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[74] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('2f5baf418c7411e5816a442f2012fbb7') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[75] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('8991b1078a1811e5816a442f2012fbb7') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[76] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='19' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 6
[Extra] => Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[77] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('f9d0ddeb77f411e5964d365a209178a5') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[78] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('bba45e6c77f311e5964d365a209178a5') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[79] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('fac20afa77f111e5964d365a209178a5') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[80] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='18' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[81] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('68dc3a2b613111e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[82] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('f2bbb813613111e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[83] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='17' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[84] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('0d6779a45deb11e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[85] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('9b58315c5deb11e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[86] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='16' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[87] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('87c475dc5de711e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[88] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('2304970c5de811e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[89] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='15' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 0 row(s) returned
)
[90] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('2caadea82c7411e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[91] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='13' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[92] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('4a9c2239218311e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[93] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('441b2c7c218411e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[94] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='12' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[95] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('67de8bc4218211e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[96] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('e82acdc9217e11e5bad331dbb90f1c60') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[97] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='11' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[98] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('037368e0e1e511e48ccbf6746499d253') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[99] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('80a90194df8411e48ccbf6746499d253') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[100] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('a038385ce1e111e48ccbf6746499d253') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[101] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='10' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[102] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('8ec4422edf8411e48ccbf6746499d253') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[103] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('8ec4422edf8411e48ccbf6746499d253') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[104] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='9' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[105] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('395c8e08c7d911e48ccbf6746499d253') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[106] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('6b6f3ff8c7d711e48ccbf6746499d253') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[107] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('395c8e08c7d911e48ccbf6746499d253') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[108] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='7' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[109] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('ed448621abb311e4b3a9ae3911a81986') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[110] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('ed448621abb311e4b3a9ae3911a81986') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[111] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='6' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[112] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('7387a0c8abb111e4b3a9ae3911a81986') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[113] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('8309b020611311e4aa72b933d2882f54') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[114] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('7387a0c8abb111e4b3a9ae3911a81986') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[115] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='5' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[116] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='4' AND ptable='tl_news' AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid,ptable
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[117] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('de3a12c8174511e4aa72b933d2882f54') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[118] => 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.google AS author__google, 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.galleria AS author__galleria, j1.galleria_permission AS author__galleria_permission, 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, j1.iso_modules AS author__iso_modules, j1.iso_product_types AS author__iso_product_types, j1.iso_product_typep AS author__iso_product_typep, j1.iso_payment_modules AS author__iso_payment_modules, j1.iso_payment_modulep AS author__iso_payment_modulep, j1.iso_shipping_modules AS author__iso_shipping_modules, j1.iso_shipping_modulep AS author__iso_shipping_modulep, j1.iso_tax_classes AS author__iso_tax_classes, j1.iso_tax_classp AS author__iso_tax_classp, j1.iso_tax_rates AS author__iso_tax_rates, j1.iso_tax_ratep AS author__iso_tax_ratep, j1.iso_configs AS author__iso_configs, j1.iso_configp AS author__iso_configp, j1.iso_groups AS author__iso_groups, j1.iso_groupp AS author__iso_groupp, j1.iso_reports AS author__iso_reports FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='44' AND tl_article.inColumn='TOP pleine largeur' AND (tl_article.start='' OR tl_article.start<1540125587) AND (tl_article.stop='' OR tl_article.stop>1540125587) AND tl_article.published=1 ORDER BY tl_article.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_article
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 0 row(s) returned
)
[119] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(81,82,86,44,14,53) 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<1540125587) AND (tl_page.stop='' OR tl_page.stop>1540125587) AND tl_page.published=1 ORDER BY FIND_IN_SET(tl_page.id, '81,82,86,44,14,53')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => range
[possible_keys] => PRIMARY,type
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 6
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[120] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[121] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[122] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[123] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[124] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[125] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[126] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='1' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 19
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[127] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='28' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 6
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[128] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='100' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[129] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='106' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[130] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='104' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[131] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='108' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[132] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='97' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[133] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='102' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[134] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='30' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[135] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='48' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[136] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='128' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[137] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='49' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[138] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='3' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 7
[Extra] => Using where; Using filesort
)
[returned] => 5 row(s) returned
)
[139] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='5' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[140] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='132' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[141] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='9' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[142] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='21' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[143] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='134' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[144] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='31' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[145] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='58' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[146] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='29' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 9
[Extra] => Using where; Using filesort
)
[returned] => 8 row(s) returned
)
[147] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='62' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 6
[Extra] => Using where; Using filesort
)
[returned] => 5 row(s) returned
)
[148] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='64' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 5 row(s) returned
)
[149] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='65' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 4 row(s) returned
)
[150] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='63' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[151] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='60' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[152] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='61' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[153] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='121' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[154] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='32' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
[returned] => 2 row(s) returned
)
[155] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='54' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[156] => 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<1540125587) AND (p2.stop='' OR p2.stop>1540125587) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='55' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1540125587) AND (p1.stop='' OR p1.stop>1540125587) AND p1.published=1 ORDER BY p1.sorting
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
[returned] => 1 row(s) returned
)
[157] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('4f69bc6c73ca11e4aa72b933d2882f54')) ORDER BY tl_files.uuid!=UNHEX('4f69bc6c73ca11e4aa72b933d2882f54')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => const
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[158] => Array
(
[query] =>
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 17
[ref] => const
[rows] => 3
[Extra] => Using index condition
)
[returned] => 4 row(s) returned
)
[159] => Array
(
[query] => SELECT *, (SELECT tstamp FROM tl_theme WHERE tl_theme.id=tl_style_sheet.pid) AS tstamp3, (SELECT MAX(tstamp) FROM tl_style WHERE tl_style.pid=tl_style_sheet.id) AS tstamp2, (SELECT COUNT(*) FROM tl_style WHERE tl_style.selector='@font-face' AND tl_style.invisible='' AND tl_style.pid=tl_style_sheet.id) AS hasFontFace FROM tl_style_sheet WHERE id IN (1,2,3) ORDER BY FIND_IN_SET(id, '1,2,3')
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_style_sheet
[type] => ALL
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 3
[Extra] => Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[160] => 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, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='6' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[161] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[162] => 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, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='13' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[163] => Array
(
[query] => SHOW TABLES FROM `tvins20141`
[returned] => 75 row(s) returned
)
[164] => Array
(
[query] => SELECT * FROM tl_iso_attribute WHERE tl_iso_attribute.type!=''
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_iso_attribute
[type] => ALL
[possible_keys] => type
[key] =>
[key_len] =>
[ref] =>
[rows] => 17
[Extra] => Using where
)
[returned] => 17 row(s) returned
)
[165] => Array
(
[query] => SELECT * FROM tl_iso_label WHERE tl_iso_label.language='fr'
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] =>
[type] =>
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Impossible WHERE noticed after reading const tables
)
[returned] => 0 row(s) returned
)
[166] => 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, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='14' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[167] => Array
(
[query] => SELECT tl_iso_product_collection.* FROM tl_iso_product_collection WHERE uniqid='3a7cecf0c42d99dba0c4588bba1483bb03a320cc' AND store_id=0 AND 1=1 HAVING type='cart' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] =>
[type] =>
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Impossible WHERE noticed after reading const tables
)
[returned] => 0 row(s) returned
)
[168] => Array
(
[query] => SELECT tl_iso_config.* FROM tl_iso_config WHERE (tl_iso_config.id=(SELECT iso_config FROM tl_page WHERE id='1') OR tl_iso_config.fallback='1') ORDER BY fallback
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_iso_config
[type] => system
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[169] => Array
(
[query] => SELECT * FROM tl_iso_requestcache WHERE id=NULL AND store_id=0 LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] =>
[type] =>
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Impossible WHERE noticed after reading const tables
)
[returned] => 0 row(s) returned
)
[170] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.id='5' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[171] => 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, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='16' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[172] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(81,82,86,44,14,53) 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<1540125588) AND (tl_page.stop='' OR tl_page.stop>1540125588) AND tl_page.published=1 ORDER BY FIND_IN_SET(tl_page.id, '81,82,86,44,14,53')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => range
[possible_keys] => PRIMARY,type
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 6
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[173] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='47' OR tl_page.alias='47') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,386
[ref] =>
[rows] => 2
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[174] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[175] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='46' OR tl_page.alias='46') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,386
[ref] =>
[rows] => 2
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 1 row(s) returned
)
[176] => Array
(
[query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' 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
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[177] => Array
(
[query] => SELECT id, checksum FROM tl_search WHERE url='actualites.html' AND pid='44' LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_search
[type] => ref
[possible_keys] => pid,url
[key] => url
[key_len] => 767
[ref] => const
[rows] => 1
[Extra] => Using index condition; Using where
)
[returned] => 1 row(s) returned
)
)
)