Ihr
Redaktionsportal
für kostenfreie Text- und Bildbeiträge
Execution time: 1.485 msMemory usage: 23,5 MiBDatabase queries: 207Rows: 1971 returned, 0 affectedRegistered models: 230
Array
(
[classes_aliased] => Array
(
[0] => Input (Contao\Input)
[1] => RequestToken (Contao\RequestToken)
[2] => Environment (Contao\Environment)
[3] => Frontend (Contao\Frontend)
[4] => Controller (Contao\Controller)
[5] => System (Contao\System)
[6] => FrontendUser (Contao\FrontendUser)
[7] => User (Contao\User)
[8] => Session (Contao\Session)
[9] => Database (Contao\Database)
[10] => Database\Mysqli (Contao\Database\Mysqli)
[11] => PageModel (Contao\PageModel)
[12] => Model (Contao\Model)
[13] => Model\QueryBuilder (Contao\Model\QueryBuilder)
[14] => DcaExtractor (Contao\DcaExtractor)
[15] => Backend (Contao\Backend)
[16] => BackendUser (Contao\BackendUser)
[17] => Database\Installer (Contao\Database\Installer)
[18] => Database\Mysqli\Statement (Contao\Database\Mysqli\Statement)
[19] => Database\Statement (Contao\Database\Statement)
[20] => Database\Mysqli\Result (Contao\Database\Mysqli\Result)
[21] => Database\Result (Contao\Database\Result)
[22] => Model\Collection (Contao\Model\Collection)
[23] => Model\Registry (Contao\Model\Registry)
[24] => String (Contao\String)
[25] => PageRegular (Contao\PageRegular)
[26] => LayoutModel (Contao\LayoutModel)
[27] => ThemeModel (Contao\ThemeModel)
[28] => FrontendTemplate (Contao\FrontendTemplate)
[29] => Template (Contao\Template)
[30] => ModuleModel (Contao\ModuleModel)
[31] => Module (Contao\Module)
[32] => ModuleRandomImage (Contao\ModuleRandomImage)
[33] => FilesModel (Contao\FilesModel)
[34] => Validator (Contao\Validator)
[35] => File (Contao\File)
[36] => Files (Contao\Files)
[37] => Files\Php (Contao\Files\Php)
[38] => Image (Contao\Image)
[39] => ModuleCustomnav (Contao\ModuleCustomnav)
[40] => Cache (Contao\Cache)
[41] => ModuleHtml (Contao\ModuleHtml)
[42] => ArticleModel (Contao\ArticleModel)
[43] => UserModel (Contao\UserModel)
[44] => ModuleArticle (Aurealis\ModuleArticle)
[45] => Date (Contao\Date)
[46] => ContentModel (Contao\ContentModel)
[47] => ContentElement (Contao\ContentElement)
[48] => ContentHeadlineTags (Contao\ContentHeadlineTags)
[49] => ContentHeadline (Contao\ContentHeadline)
[50] => ContentModule (Contao\ContentModule)
[51] => ModuleNavigation (Contao\ModuleNavigation)
[52] => ModuleNewsList (Contao\ModuleNewsList)
[53] => ModuleNews (Contao\ModuleNews)
[54] => NewsArchiveModel (Contao\NewsArchiveModel)
[55] => LocalizedTagsNewsModel (Contao\LocalizedTagsNewsModel)
[56] => NewsModel (Contao\NewsModel)
[57] => Pagination (Contao\Pagination)
[58] => ContentText (Contao\ContentText)
[59] => ContentDownloads (Contao\ContentDownloads)
[60] => ContentImage (Contao\ContentImage)
[61] => TagHelper (Contao\TagHelper)
[62] => mmenu\ModuleMmenu (Dirch\mmenu\ModuleMmenu)
[63] => StyleSheetModel (Contao\StyleSheetModel)
[64] => FormdataProcessor (Efg\FormdataProcessor)
[65] => Combiner (Contao\Combiner)
)
[classes_set] => Array
(
[0] => RepositoryBackendTheme
[1] => AvisotaRegistrationDCA
[2] => MetaPalettes
[3] => DomainLink
[4] => Contao\ModuleArticle
[5] => SimpleColumnsHook
[6] => Txn\ModuleNewsListTags
[7] => Dirch\mmenu\Mmenu
[8] => amisso
[9] => slideItStart
[10] => slideItHelper
[11] => slideItMoo
[12] => slideItEnd
)
[database_queries] => Array
(
[0] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id=0 OR tl_page.alias='bauen-sanieren') AND (tl_page.start='' OR tl_page.start<1770933389) AND (tl_page.stop='' OR tl_page.stop>1770933389) 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] => 3
[Extra] => Using union(PRIMARY,alias); Using where
)
[returned] => 2 row(s) returned
)
[1] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='3' 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
)
[2] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='1' 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
)
[3] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='133' 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
)
[4] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='131' 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
)
[5] => 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='5' 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
)
[6] => Array
(
[query] => SELECT * FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` LIKE 'd02d9d68' AND `TABLE_NAME` LIKE 'tl_module'
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => COLUMNS
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Using where; Open_frm_only; Scanned all databases
)
[returned] => 291 row(s) returned
)
[7] => Array
(
[query] => SHOW INDEXES FROM `tl_module`
[returned] => 1 row(s) returned
)
[8] => 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.jumpBack AS jumpTo__jumpBack, j1.secureDNS AS jumpTo__secureDNS FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id IN(166,175,174,169,167,200,0,172,173,170,171,0,177) ORDER BY FIND_IN_SET(tl_module.id, '166,175,174,169,167,200,0,172,173,170,171,0,177')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 12
[Extra] => Using index condition; Using filesort
)
[returned] => 11 row(s) returned
)
[9] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('540b808ccad311e7941aa2e18f78cc81')) ORDER BY tl_files.uuid!=UNHEX('540b808ccad311e7941aa2e18f78cc81')
[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
)
[10] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(95) 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<1770933389) AND (tl_page.stop='' OR tl_page.stop>1770933389) AND tl_page.published=1 ORDER BY FIND_IN_SET(tl_page.id, '95')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY,type
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[11] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[12] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='95' 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
)
[13] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,95)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=95
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => PRIMARY,type
[key] => type
[key_len] => 98
[ref] => const
[rows] => 2
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 0 row(s) returned
)
[14] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,95)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=95
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => PRIMARY,type
[key] => type
[key_len] => 98
[ref] => const
[rows] => 2
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 0 row(s) returned
)
[15] => 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.avisota_recipient_lists AS author__avisota_recipient_lists, j1.avisota_recipient_list_permissions AS author__avisota_recipient_list_permissions, j1.avisota_recipient_permissions AS author__avisota_recipient_permissions, j1.avisota_newsletter_categories AS author__avisota_newsletter_categories, j1.avisota_newsletter_category_permissions AS author__avisota_newsletter_category_permissions, j1.avisota_newsletter_permissions AS author__avisota_newsletter_permissions, j1.calendars AS author__calendars, j1.calendarp AS author__calendarp, j1.calendarfeeds AS author__calendarfeeds, j1.calendarfeedp AS author__calendarfeedp, j1.faqs AS author__faqs, j1.faqp AS author__faqp, j1.news AS author__news, j1.newp AS author__newp, j1.newsfeeds AS author__newsfeeds, j1.newsfeedp AS author__newsfeedp, j1.newsletters AS author__newsletters, j1.newsletterp AS author__newsletterp FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='7' AND tl_article.inColumn='main' AND (tl_article.start='' OR tl_article.start<1770933389) AND (tl_article.stop='' OR tl_article.stop>1770933389) 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
)
[16] => Array
(
[query] => SELECT * FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` LIKE 'd02d9d68' AND `TABLE_NAME` LIKE 'tl_content'
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => COLUMNS
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Using where; Open_frm_only; Scanned all databases
)
[returned] => 183 row(s) returned
)
[17] => Array
(
[query] => SHOW INDEXES FROM `tl_content`
[returned] => 2 row(s) returned
)
[18] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='5' AND (tl_content.ptable='tl_article' OR tl_content.ptable='') AND (tl_content.start='' OR tl_content.start<1770933389) AND (tl_content.stop='' OR tl_content.stop>1770933389) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 4
[Extra] => Using where; Using filesort
)
[returned] => 3 row(s) returned
)
[19] => 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.jumpBack AS jumpTo__jumpBack, j1.secureDNS AS jumpTo__secureDNS FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='191' 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
)
[20] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='7' 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
)
[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<1770933389) AND (p2.stop='' OR p2.stop>1770933389) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='7' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1770933389) AND (p1.stop='' OR p1.stop>1770933389) 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] => 12
[Extra] => Using where; Using filesort
)
[returned] => 15 row(s) returned
)
[22] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='7' 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
)
[23] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,30)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=30
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[24] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,30)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=30
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[25] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,31)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=31
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[26] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,31)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=31
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[27] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,32)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=32
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[28] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,32)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=32
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[29] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,33)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=33
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[30] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,33)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=33
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[31] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,34)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=34
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[32] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,34)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=34
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[33] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,35)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=35
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[34] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,35)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=35
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[35] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,36)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=36
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[36] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,36)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=36
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[37] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,37)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=37
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[38] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,37)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=37
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[39] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,39)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=39
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[40] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,39)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=39
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[41] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,40)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=40
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[42] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,40)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=40
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[43] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,41)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=41
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[44] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,41)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=41
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[45] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,43)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=43
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[46] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,43)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=43
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[47] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,44)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=44
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[48] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,44)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=44
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[49] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,45)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=45
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[50] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,45)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=45
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[51] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,48)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=48
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[52] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7,48)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7,`id`=48
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[53] => 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.jumpBack AS jumpTo__jumpBack, j1.secureDNS AS jumpTo__secureDNS 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
)
[54] => 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.jumpBack AS jumpTo__jumpBack, j1.secureDNS AS jumpTo__secureDNS FROM tl_news_archive LEFT JOIN tl_page j1 ON tl_news_archive.jumpTo=j1.id WHERE tl_news_archive.id IN(2) ORDER BY FIND_IN_SET(tl_news_archive.id, '2')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_news_archive
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
[returned] => 1 row(s) returned
)
[55] => Array
(
[query] => SELECT tid FROM tl_tag WHERE tag IN ('bauen','bauen-badezimmer','bauen-baustoffe','bauen-carportgaragen','bauen-dach','bauen-energiepass','bauen-fassaden','bauenfenstertueren','bauen-finanzierung','bauen-gesundheit','bauen-hausbaufertigbau','bauen-heimwerker','bauen-innenausbau','bauen-keller','bauen-rolllaedenjalousien') AND from_table = 'tl_news' ORDER BY tag ASC
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_tag
[type] => ALL
[possible_keys] => tag,from_table
[key] =>
[key_len] =>
[ref] =>
[rows] => 5413
[Extra] => Using where; Using filesort
)
[returned] => 1187 row(s) returned
)
[56] => Array
(
[query] => SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.pid IN(2) AND tl_news.id IN(3660,2843,5022,2551,3363,2552,2553,2554,5019,5020,5021,3362,4904,4905,4868,4870,4871,4869,2842,3816,3645,3578,4087,4086,4085,4084,2797,2800,2799,2798,3220,3406,3222,3407,4794,2844,2841,3813,3814,4431,2141,2140,2139,2138,2200,2199,2198,2197,2196,3479,3488,3489,3490,3904,3905,3906,3224,2349,3903,4796,4797,4795,1963,4665,4666,4667,4668,4658,2037,2036,2034,2033,2346,2347,2348,3491,3815,2761,3360,2758,5387,5386,4015,3361,2760,4012,4014,4013,2035,2759,3221,2020,4533,2751,3348,3134,4581,4612,4613,4656,5481,2685,2019,2018,4377,2364,2362,3138,2363,2361,4507,4506,4505,4504,3135,4510,5526,4512,5482,2017,4376,3093,3473,4706,4705,2478,2686,4229,2477,1929,3316,3000,2999,2998,3935,2502,2512,3936,4707,4701,3749,3748,3379,2443,3090,2447,2446,2445,2444,3378,2480,2479,4694,4695,4693,4700,2511,4378,2351,2730,3643,5527,3990,5525,2319,4325,4353,4354,4355,4352,4357,4356,4366,4364,4365,4363,4326,2204,4308,2733,2732,2705,2731,4328,2683,5850,5849,3475,2322,2201,2321,2202,4327,2203,2320,4372,4375,3474,3224,2137,2131,4187,2132,5524,2133,3190,2134,2752,2115,4437,4436,2113,4435,2750,2350,4438,2136,3470,2138,3991,4434,2139,2753,4433,2140,4708,4432,2141,3514,2684,4283,2135,4431,3433,2096,3319,5262,4190,4191,4186,5291,3220,2784,5292,3948,5293,3471,5294,2606,2605,4092,4093,4094,4095,4189,4188,4262,2587,5289,2828,4227,4228,3816,4230,4225,4226,5290,2829,4035,4307,3222,2651,4261,2771,3168,5295,5423,4075,5424,5334,2653,5350,5349,5348,3580,5347,5353,3581,5354,2781,5352,2783,4074,4073,2782,5332,2652,2629,5296,3562,3553,2630,3552,4076,2787,2788,2786,2654,2785,5313,5315,3754,5314,5351,3321,2544,2920,2889,2890,2543,5587,2882,2881,4937,5406,4031,2880,4280,5404,4281,3221,4030,2927,3980,2928,2956,2546,3814,5426,3813,4019,4018,4017,4016,5425,2955,5586,2954,3642,2953,2545,2929,4282,4243,4038,4037,2842,4036,2841,2588,4245,2827,5259,4246,5260,4247,4248,5261,4241,4242,4244,2843,2858,2855,2856,4267,2857,4268,4269,2853,4270,4422,4028,2844,4260,2772,2854,4029,2295,2293,2294,2385,2384,2382,2383,2296,2253,1991,1993,1994,1992,2089,2091,2090,2250,2252,2251,2088,4931,5214,4935,2727,4280,4281,5136,4283,4282,5135,4267,4268,4269,4932,4933,2480,2479,2478,2477,4848,3319,3317,3935,3936,2512,3321,2511,4845,3942,4847,4934,4270,5215,3643,5525,5526,5524,5527,5453,5454,2651,3642,2730,3510,2726,2729,2732,3511,2733,3512,2731,2652,5360,3416,3417,3316,2587,5361,5217,5216,2588,3553,3552,2653,5328,5312,5306,2654,5308,5307,5305,2728,2360,4534,2136,4536,3386,2135,2133,3379,1975,1976,2137,2131,2359,2358,2357,2351,2350,2134,2132,4537,4535,2447,2319,2320,4846,2443,2321,2446,4396,2322,4936,2444,4395,1977,1978,2445,3450,3387,2816,3180,2809,3875,3179,2815,3862,3408,3860,2810,3403,2814,3405,2813,3861,2811,3146,4056,4055,4054,3450,3173,3584,4057,3182,3181,4089,4090,4091,4088,2812,2580,3178,3081,3671,3983,3984,4935,3982,3981,3174,3402,4508,3135,3673,3125,3083,4672,3381,4673,3583,4675,3316,3099,3134,3092,3175,3177,3151,3136,2579,5205,2582,2581,4249,4250,4251,4252,4674,3150,2874,2875,3176,2873,2872,3399,3138,4502,4327,2731,2732,4501,3077,3078,3069,3066,4500,2730,4326,4503,5400,2963,2965,5423,5424,5425,2964,2966,4325,5426,5401,2733,3378,4074,3548,2348,3549,3379,2157,4328,1968,1969,1970,1971,2346,2347,2349,4073,4075,3642,3643,4014,4013,4015,4012,4076,2254,3885,4335,5350,2263,3889,2261,2334,2333,3887,2335,2301,2264,2262,3835,2256,3833,3832,4337,3830,3886,2255,2332,3445,3443,2466,3065,4741,3010,2502,2956,2533,2955,2546,2954,2953,2946,2467,2468,3442,2181,2351,2350,2364,2362,2363,2361,3279,3278,3444,3081,2545,5527,5295,5294,5293,5296,3403,5261,5260,5259,5262,5091,5090,5089,3551,3549,3548,3990,5525,3991,5526,5524,5481,3360,5347,5348,5349,5354,3547,5092,5079,3399,2096,2112,2109,2110,2111,4336,4334,2156,2155,2154,2153,2071,2072,2073,5080,5081,5078,5847,1958,1957,1956,1955,4656,4512,2074,4510,2157,2928,2725,2855,2570,2786,2856,2569,2731,2654,2857,2753,2555,2752,2653,2681,2683,2556,2558,2785,2557,2788,2630,2787,2843,2840,2844,2577,2588,2929,2841,2687,2587,2606,2568,2842,2629,2858,2575,2578,2576,2605,2730,2729,2732,2751,2927,2920,2685,2544,2771,2912,2652,2733,2911,2910,2909,2651,2686,2726,2682,2770,2684,2543,2750,2567,2728,2772,2727,2683,3473,2787,5028,3887,4432,4433,3886,3471,3885,3948,3889,2784,2783,2751,2753,3793,3582,2785,2750,2684,2782,2781,4848,3932,3580,2685,5025,5026,2788,5027,3379,2786,4537,2686,3350,4534,4682,2752,2545,3474,2544,2543,3475,3479,3378,5505,3091,5523,2546,2654,1971,4655,3582,3780,4657,1970,3581,2785,2364,2362,1969,2855,2361,4623,1968,3580,2350,4624,2856,4536,4076,2020,2019,2351,4535,2018,4073,3643,4075,4625,4622,4074,4613,5351,5352,5353,4612,2017,3093,2545,2772,2651,2771,2511,2652,2512,3642,4281,3433,3168,3407,3406,2546,5148,5147,5146,5145,3471,4280,4327,5563,3754,3090,5329,3091,2653,2543,3092,4742,2363,4898,5565,5562,5564,2544,5310,5311,4896,4897,4743,2857,4326,2178,4014,2179,2843,4328,4386,4385,2841,5404,4895,2138,4397,4012,2177,2176,2203,2204,4325,5406,2201,2587,3474,5328,2588,3475,2844,2202,3473,2139,2140,4013,2788,2115,2113,2858,4384,2787,3400,4282,2842,5505,3514,4283,3389,4015,2141,5506,3486,2135,2136,4383,2786,2137,3483,2927,2263,2920,2965,2264,2929,4422,2261,5148,4260,2262,3953,2588,3481,2963,3480,5199,3517,3520,2966,3519,3630,3736,3737,3515,4031,2630,4505,4261,4777,4262,5329,3735,2629,2928,4504,2587,4506,4507,4029,2964,4030,3734,3742,2748,2688,2746,5430,5432,2405,4183,5428,2749,2689,2747,2690,5579,5580,2691,3741,5582,5299,5581,5298,4025,3739,4027,4024,5300,5297,4181,5427,4182,4026,2007,3857,2583,2585,2586,2300,2299,2298,2297,3454,3453,3452,3856,3855,2623,4392,4394,2621,2620,2193,2192,2191,2190,2584,3854,3451,3235,2906,2907,3052,3053,3054,3055,2908,2485,2484,2483,2482,2905,3083,3234,3233,3277,3276,3275,2406,2404,2403,3084,3088,3087,2622,4248,3976,4180,3334,3738,4899,4900,4901,4902,4393,4894,4890,3977,3978,4247,4246,4245,3333,5130,5129,5128,5127,3332,3331,3979,4891,4893,4664,2004,2003,3236,2010,4617,4616,4615,4614,2009,2008,4662,4660,3102,3104,1965,1964,1967,1966,3099,3100,2006,2005,4661,4391) AND (tl_news.start='' OR tl_news.start<1770933389) AND (tl_news.stop='' OR tl_news.stop>1770933389) AND tl_news.published=1 AND ((tl_news.txn_language & 1) <> 0 )
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_news
[type] => ALL
[possible_keys] => PRIMARY,pid
[key] =>
[key_len] =>
[ref] =>
[rows] => 2836
[Extra] => Using where
)
[returned] => 1 row(s) returned
)
[57] => 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.avisota_recipient_lists AS author__avisota_recipient_lists, j2.avisota_recipient_list_permissions AS author__avisota_recipient_list_permissions, j2.avisota_recipient_permissions AS author__avisota_recipient_permissions, j2.avisota_newsletter_categories AS author__avisota_newsletter_categories, j2.avisota_newsletter_category_permissions AS author__avisota_newsletter_category_permissions, j2.avisota_newsletter_permissions AS author__avisota_newsletter_permissions, 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.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 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(2) AND tl_news.id IN(3660,2843,5022,2551,3363,2552,2553,2554,5019,5020,5021,3362,4904,4905,4868,4870,4871,4869,2842,3816,3645,3578,4087,4086,4085,4084,2797,2800,2799,2798,3220,3406,3222,3407,4794,2844,2841,3813,3814,4431,2141,2140,2139,2138,2200,2199,2198,2197,2196,3479,3488,3489,3490,3904,3905,3906,3224,2349,3903,4796,4797,4795,1963,4665,4666,4667,4668,4658,2037,2036,2034,2033,2346,2347,2348,3491,3815,2761,3360,2758,5387,5386,4015,3361,2760,4012,4014,4013,2035,2759,3221,2020,4533,2751,3348,3134,4581,4612,4613,4656,5481,2685,2019,2018,4377,2364,2362,3138,2363,2361,4507,4506,4505,4504,3135,4510,5526,4512,5482,2017,4376,3093,3473,4706,4705,2478,2686,4229,2477,1929,3316,3000,2999,2998,3935,2502,2512,3936,4707,4701,3749,3748,3379,2443,3090,2447,2446,2445,2444,3378,2480,2479,4694,4695,4693,4700,2511,4378,2351,2730,3643,5527,3990,5525,2319,4325,4353,4354,4355,4352,4357,4356,4366,4364,4365,4363,4326,2204,4308,2733,2732,2705,2731,4328,2683,5850,5849,3475,2322,2201,2321,2202,4327,2203,2320,4372,4375,3474,3224,2137,2131,4187,2132,5524,2133,3190,2134,2752,2115,4437,4436,2113,4435,2750,2350,4438,2136,3470,2138,3991,4434,2139,2753,4433,2140,4708,4432,2141,3514,2684,4283,2135,4431,3433,2096,3319,5262,4190,4191,4186,5291,3220,2784,5292,3948,5293,3471,5294,2606,2605,4092,4093,4094,4095,4189,4188,4262,2587,5289,2828,4227,4228,3816,4230,4225,4226,5290,2829,4035,4307,3222,2651,4261,2771,3168,5295,5423,4075,5424,5334,2653,5350,5349,5348,3580,5347,5353,3581,5354,2781,5352,2783,4074,4073,2782,5332,2652,2629,5296,3562,3553,2630,3552,4076,2787,2788,2786,2654,2785,5313,5315,3754,5314,5351,3321,2544,2920,2889,2890,2543,5587,2882,2881,4937,5406,4031,2880,4280,5404,4281,3221,4030,2927,3980,2928,2956,2546,3814,5426,3813,4019,4018,4017,4016,5425,2955,5586,2954,3642,2953,2545,2929,4282,4243,4038,4037,2842,4036,2841,2588,4245,2827,5259,4246,5260,4247,4248,5261,4241,4242,4244,2843,2858,2855,2856,4267,2857,4268,4269,2853,4270,4422,4028,2844,4260,2772,2854,4029,2295,2293,2294,2385,2384,2382,2383,2296,2253,1991,1993,1994,1992,2089,2091,2090,2250,2252,2251,2088,4931,5214,4935,2727,4280,4281,5136,4283,4282,5135,4267,4268,4269,4932,4933,2480,2479,2478,2477,4848,3319,3317,3935,3936,2512,3321,2511,4845,3942,4847,4934,4270,5215,3643,5525,5526,5524,5527,5453,5454,2651,3642,2730,3510,2726,2729,2732,3511,2733,3512,2731,2652,5360,3416,3417,3316,2587,5361,5217,5216,2588,3553,3552,2653,5328,5312,5306,2654,5308,5307,5305,2728,2360,4534,2136,4536,3386,2135,2133,3379,1975,1976,2137,2131,2359,2358,2357,2351,2350,2134,2132,4537,4535,2447,2319,2320,4846,2443,2321,2446,4396,2322,4936,2444,4395,1977,1978,2445,3450,3387,2816,3180,2809,3875,3179,2815,3862,3408,3860,2810,3403,2814,3405,2813,3861,2811,3146,4056,4055,4054,3450,3173,3584,4057,3182,3181,4089,4090,4091,4088,2812,2580,3178,3081,3671,3983,3984,4935,3982,3981,3174,3402,4508,3135,3673,3125,3083,4672,3381,4673,3583,4675,3316,3099,3134,3092,3175,3177,3151,3136,2579,5205,2582,2581,4249,4250,4251,4252,4674,3150,2874,2875,3176,2873,2872,3399,3138,4502,4327,2731,2732,4501,3077,3078,3069,3066,4500,2730,4326,4503,5400,2963,2965,5423,5424,5425,2964,2966,4325,5426,5401,2733,3378,4074,3548,2348,3549,3379,2157,4328,1968,1969,1970,1971,2346,2347,2349,4073,4075,3642,3643,4014,4013,4015,4012,4076,2254,3885,4335,5350,2263,3889,2261,2334,2333,3887,2335,2301,2264,2262,3835,2256,3833,3832,4337,3830,3886,2255,2332,3445,3443,2466,3065,4741,3010,2502,2956,2533,2955,2546,2954,2953,2946,2467,2468,3442,2181,2351,2350,2364,2362,2363,2361,3279,3278,3444,3081,2545,5527,5295,5294,5293,5296,3403,5261,5260,5259,5262,5091,5090,5089,3551,3549,3548,3990,5525,3991,5526,5524,5481,3360,5347,5348,5349,5354,3547,5092,5079,3399,2096,2112,2109,2110,2111,4336,4334,2156,2155,2154,2153,2071,2072,2073,5080,5081,5078,5847,1958,1957,1956,1955,4656,4512,2074,4510,2157,2928,2725,2855,2570,2786,2856,2569,2731,2654,2857,2753,2555,2752,2653,2681,2683,2556,2558,2785,2557,2788,2630,2787,2843,2840,2844,2577,2588,2929,2841,2687,2587,2606,2568,2842,2629,2858,2575,2578,2576,2605,2730,2729,2732,2751,2927,2920,2685,2544,2771,2912,2652,2733,2911,2910,2909,2651,2686,2726,2682,2770,2684,2543,2750,2567,2728,2772,2727,2683,3473,2787,5028,3887,4432,4433,3886,3471,3885,3948,3889,2784,2783,2751,2753,3793,3582,2785,2750,2684,2782,2781,4848,3932,3580,2685,5025,5026,2788,5027,3379,2786,4537,2686,3350,4534,4682,2752,2545,3474,2544,2543,3475,3479,3378,5505,3091,5523,2546,2654,1971,4655,3582,3780,4657,1970,3581,2785,2364,2362,1969,2855,2361,4623,1968,3580,2350,4624,2856,4536,4076,2020,2019,2351,4535,2018,4073,3643,4075,4625,4622,4074,4613,5351,5352,5353,4612,2017,3093,2545,2772,2651,2771,2511,2652,2512,3642,4281,3433,3168,3407,3406,2546,5148,5147,5146,5145,3471,4280,4327,5563,3754,3090,5329,3091,2653,2543,3092,4742,2363,4898,5565,5562,5564,2544,5310,5311,4896,4897,4743,2857,4326,2178,4014,2179,2843,4328,4386,4385,2841,5404,4895,2138,4397,4012,2177,2176,2203,2204,4325,5406,2201,2587,3474,5328,2588,3475,2844,2202,3473,2139,2140,4013,2788,2115,2113,2858,4384,2787,3400,4282,2842,5505,3514,4283,3389,4015,2141,5506,3486,2135,2136,4383,2786,2137,3483,2927,2263,2920,2965,2264,2929,4422,2261,5148,4260,2262,3953,2588,3481,2963,3480,5199,3517,3520,2966,3519,3630,3736,3737,3515,4031,2630,4505,4261,4777,4262,5329,3735,2629,2928,4504,2587,4506,4507,4029,2964,4030,3734,3742,2748,2688,2746,5430,5432,2405,4183,5428,2749,2689,2747,2690,5579,5580,2691,3741,5582,5299,5581,5298,4025,3739,4027,4024,5300,5297,4181,5427,4182,4026,2007,3857,2583,2585,2586,2300,2299,2298,2297,3454,3453,3452,3856,3855,2623,4392,4394,2621,2620,2193,2192,2191,2190,2584,3854,3451,3235,2906,2907,3052,3053,3054,3055,2908,2485,2484,2483,2482,2905,3083,3234,3233,3277,3276,3275,2406,2404,2403,3084,3088,3087,2622,4248,3976,4180,3334,3738,4899,4900,4901,4902,4393,4894,4890,3977,3978,4247,4246,4245,3333,5130,5129,5128,5127,3332,3331,3979,4891,4893,4664,2004,2003,3236,2010,4617,4616,4615,4614,2009,2008,4662,4660,3102,3104,1965,1964,1967,1966,3099,3100,2006,2005,4661,4391) AND (tl_news.start='' OR tl_news.start<1770933389) AND (tl_news.stop='' OR tl_news.stop>1770933389) AND tl_news.published=1 AND ((tl_news.txn_language & 1) <> 0 ) ORDER BY tl_news.date DESC LIMIT 648,12
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] =>
[type] => ALL
[possible_keys] => distinct_key
[key] =>
[key_len] =>
[ref] =>
[rows] => 1187
[Extra] => Using temporary; Using filesort
)
[returned] => 12 row(s) returned
)
[58] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='98' 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
)
[59] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,98)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=98
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => PRIMARY,type
[key] => type
[key_len] => 98
[ref] => const
[rows] => 2
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 0 row(s) returned
)
[60] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,98)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=98
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => PRIMARY,type
[key] => type
[key_len] => 98
[ref] => const
[rows] => 2
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 0 row(s) returned
)
[61] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='2203' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933389) AND (tl_content.stop='' OR tl_content.stop>1770933389) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 7
[Extra] => Using where; Using filesort
)
[returned] => 8 row(s) returned
)
[62] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('c35f8436068711e4903a177403af64e9'),UNHEX('c35f841d068711e4903a177403af64e9'),UNHEX('c35f8403068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('c35f8436068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('c35f841d068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('c35f8403068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[63] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('d15f7d99068711e4903a177403af64e9') 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 IN(UNHEX('c35f8392068711e4903a177403af64e9'),UNHEX('d15f7dad068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('c35f8392068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('d15f7dad068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[65] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('d15f7d8f068711e4903a177403af64e9') 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 * FROM tl_files WHERE tl_files.uuid IN(UNHEX('c35f83e3068711e4903a177403af64e9'),UNHEX('d15f7db9068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('c35f83e3068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('d15f7db9068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[67] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('d15f7d99068711e4903a177403af64e9') 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 tl_page.* FROM tl_page WHERE tl_page.id='98' 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
)
[69] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='2200' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933389) AND (tl_content.stop='' OR tl_content.stop>1770933389) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[70] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('aa1e4d00068711e4903a177403af64e9'),UNHEX('aa1e4ce9068711e4903a177403af64e9'),UNHEX('aa1e4cd0068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('aa1e4d00068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('aa1e4ce9068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('aa1e4cd0068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[71] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('aa1e4c88068711e4903a177403af64e9') 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 * FROM tl_files WHERE tl_files.uuid IN(UNHEX('9c49c8e1068711e4903a177403af64e9'),UNHEX('aa1e4cba068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('9c49c8e1068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('aa1e4cba068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[73] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('aa1e4c88068711e4903a177403af64e9') 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 tl_content.* FROM tl_content WHERE tl_content.pid='2199' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933389) AND (tl_content.stop='' OR tl_content.stop>1770933389) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[75] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('9c49c9dc068711e4903a177403af64e9'),UNHEX('9c49c9c5068711e4903a177403af64e9'),UNHEX('9c49c9aa068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('9c49c9dc068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('9c49c9c5068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('9c49c9aa068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[76] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('9c49c957068711e4903a177403af64e9') 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
)
[77] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('9c49c9f3068711e4903a177403af64e9'),UNHEX('9c49c990068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('9c49c9f3068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('9c49c990068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[78] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('9c49c957068711e4903a177403af64e9') 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 tl_content.* FROM tl_content WHERE tl_content.pid='2201' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933389) AND (tl_content.stop='' OR tl_content.stop>1770933389) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[80] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('aa1e4bdc068711e4903a177403af64e9'),UNHEX('b6c71a1d068711e4903a177403af64e9'),UNHEX('b6c71a11068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('aa1e4bdc068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('b6c71a1d068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('b6c71a11068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[81] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('b6c71955068711e4903a177403af64e9') 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 IN(UNHEX('aa1e4c2e068711e4903a177403af64e9'),UNHEX('b6c719a0068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('aa1e4c2e068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('b6c719a0068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[83] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('b6c71955068711e4903a177403af64e9') 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
)
[84] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='2198' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933390) AND (tl_content.stop='' OR tl_content.stop>1770933390) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[85] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('91899f8a068711e4903a177403af64e9'),UNHEX('91899f72068711e4903a177403af64e9'),UNHEX('91899f59068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('91899f8a068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('91899f72068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('91899f59068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[86] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('91899f14068711e4903a177403af64e9') 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
)
[87] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('83c5b084068711e4903a177403af64e9'),UNHEX('91899f43068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('83c5b084068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('91899f43068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[88] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('91899f14068711e4903a177403af64e9') 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='2197' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933390) AND (tl_content.stop='' OR tl_content.stop>1770933390) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[90] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('83c5b171068711e4903a177403af64e9'),UNHEX('83c5b15a068711e4903a177403af64e9'),UNHEX('83c5b141068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('83c5b171068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('83c5b15a068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('83c5b141068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[91] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('83c5b0f0068711e4903a177403af64e9') 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
)
[92] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('83c5b189068711e4903a177403af64e9'),UNHEX('83c5b127068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('83c5b189068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('83c5b127068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[93] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('83c5b0f0068711e4903a177403af64e9') 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='2196' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933390) AND (tl_content.stop='' OR tl_content.stop>1770933390) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[95] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('787b666c068711e4903a177403af64e9'),UNHEX('787b6653068711e4903a177403af64e9'),UNHEX('787b663b068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('787b666c068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('787b6653068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('787b663b068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[96] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('787b6599068711e4903a177403af64e9') 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 * FROM tl_files WHERE tl_files.uuid IN(UNHEX('787b6682068711e4903a177403af64e9'),UNHEX('787b6621068711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('787b6682068711e4903a177403af64e9'), tl_files.uuid!=UNHEX('787b6621068711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[98] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('787b6599068711e4903a177403af64e9') 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 tl_content.* FROM tl_content WHERE tl_content.pid='2193' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933390) AND (tl_content.stop='' OR tl_content.stop>1770933390) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[100] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('a2b559ef02a711e4903a177403af64e9'),UNHEX('a2b5599f02a711e4903a177403af64e9'),UNHEX('b115629f02a711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('a2b559ef02a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('a2b5599f02a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('b115629f02a711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[101] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('b115625302a711e4903a177403af64e9') 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
)
[102] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('a2b55a0f02a711e4903a177403af64e9'),UNHEX('b115628502a711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('a2b55a0f02a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('b115628502a711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[103] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('b115625302a711e4903a177403af64e9') 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='2192' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933390) AND (tl_content.stop='' OR tl_content.stop>1770933390) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[105] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('a2b55ac302a711e4903a177403af64e9'),UNHEX('a2b55aaa02a711e4903a177403af64e9'),UNHEX('a2b55a9202a711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('a2b55ac302a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('a2b55aaa02a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('a2b55a9202a711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[106] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('a2b55a4502a711e4903a177403af64e9') 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 IN(UNHEX('94467fe002a711e4903a177403af64e9'),UNHEX('a2b55a7802a711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('94467fe002a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('a2b55a7802a711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[108] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('a2b55a4502a711e4903a177403af64e9') 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
)
[109] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='2191' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933390) AND (tl_content.stop='' OR tl_content.stop>1770933390) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[110] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('9446805a02a711e4903a177403af64e9'),UNHEX('9446804f02a711e4903a177403af64e9'),UNHEX('9446804402a711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('9446805a02a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('9446804f02a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('9446804402a711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[111] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('9446802102a711e4903a177403af64e9') 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
)
[112] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('9446806502a711e4903a177403af64e9'),UNHEX('9446803a02a711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('9446806502a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('9446803a02a711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[113] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('9446802102a711e4903a177403af64e9') 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 tl_content.* FROM tl_content WHERE tl_content.pid='2190' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933390) AND (tl_content.stop='' OR tl_content.stop>1770933390) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[115] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('7f9b938e02a711e4903a177403af64e9'),UNHEX('7f9b936d02a711e4903a177403af64e9'),UNHEX('7f9b931e02a711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('7f9b938e02a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('7f9b936d02a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('7f9b931e02a711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[116] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('8cbfdee602a711e4903a177403af64e9') 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
)
[117] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('7f9b93a902a711e4903a177403af64e9'),UNHEX('8cbfdf0802a711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('7f9b93a902a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('8cbfdf0802a711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[118] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('8cbfdee602a711e4903a177403af64e9') 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
)
[119] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='2181' AND tl_content.ptable='tl_news' AND (tl_content.start='' OR tl_content.start<1770933390) AND (tl_content.stop='' OR tl_content.stop>1770933390) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)
[returned] => 6 row(s) returned
)
[120] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1fcf7ec602a711e4903a177403af64e9'),UNHEX('1fcf7ebb02a711e4903a177403af64e9'),UNHEX('1fcf7eb002a711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('1fcf7ec602a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('1fcf7ebb02a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('1fcf7eb002a711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
[returned] => 3 row(s) returned
)
[121] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('1fcf7e8e02a711e4903a177403af64e9') 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
)
[122] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1fcf7ed202a711e4903a177403af64e9'),UNHEX('1fcf7ea502a711e4903a177403af64e9')) ORDER BY tl_files.uuid!=UNHEX('1fcf7ed202a711e4903a177403af64e9'), tl_files.uuid!=UNHEX('1fcf7ea502a711e4903a177403af64e9')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_files
[type] => range
[possible_keys] => uuid
[key] => uuid
[key_len] => 17
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
[returned] => 2 row(s) returned
)
[123] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('1fcf7e8e02a711e4903a177403af64e9') 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
)
[124] => 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<1770933390) AND (p2.stop='' OR p2.stop>1770933390) 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<1770933390) AND (p1.stop='' OR p1.stop>1770933390) 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] => 15
[Extra] => Using where; Using filesort
)
[returned] => 18 row(s) returned
)
[125] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='3' 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
)
[126] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,5)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=5
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[127] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,5)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=5
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[128] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,6)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=6
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[129] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,6)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=6
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[130] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,7)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=7
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[131] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,9)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=9
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[132] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,9)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=9
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[133] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,42)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=42
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[134] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,42)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=42
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[135] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,10)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=10
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[136] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,10)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=10
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[137] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,11)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=11
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[138] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,11)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=11
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[139] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,124)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=124
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[140] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,124)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=124
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[141] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,12)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=12
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[142] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,12)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=12
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[143] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,13)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=13
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[144] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,13)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=13
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[145] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,15)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=15
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[146] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,15)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=15
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[147] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,16)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=16
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[148] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,16)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=16
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[149] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,17)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=17
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[150] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,17)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=17
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[151] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,18)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=18
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[152] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,18)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=18
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[153] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,19)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=19
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[154] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,19)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=19
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[155] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,20)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=20
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[156] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,20)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=20
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[157] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,242)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=242
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[158] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,242)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=242
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[159] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,21)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=21
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[160] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,3,21)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=3,`id`=21
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[161] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(2,82,84,85,86,87,238) 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<1770933390) AND (tl_page.stop='' OR tl_page.stop>1770933390) AND tl_page.published=1 ORDER BY FIND_IN_SET(tl_page.id, '2,82,84,85,86,87,238')
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => range
[possible_keys] => PRIMARY,type
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 7
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 7 row(s) returned
)
[162] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='80' 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
)
[163] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='2' 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
)
[164] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,2)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=2
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => PRIMARY,type
[key] => type
[key_len] => 98
[ref] => const
[rows] => 2
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 0 row(s) returned
)
[165] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,2)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=2
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => PRIMARY,type
[key] => type
[key_len] => 98
[ref] => const
[rows] => 2
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 0 row(s) returned
)
[166] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='82' 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
)
[167] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,80,82)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=80,`id`=82
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[168] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,80,82)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=80,`id`=82
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[169] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='84' 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
)
[170] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,80,84)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=80,`id`=84
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[171] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,80,84)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=80,`id`=84
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[172] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='85' 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
)
[173] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,80,85)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=80,`id`=85
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[174] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,80,85)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=80,`id`=85
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[175] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='86' 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
)
[176] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,80,86)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=80,`id`=86
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[177] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,80,86)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=80,`id`=86
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[178] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='87' 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
)
[179] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,80,87)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=80,`id`=87
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[180] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,80,87)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=80,`id`=87
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[181] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='238' 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
)
[182] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,238)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=238
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => PRIMARY,type
[key] => type
[key_len] => 98
[ref] => const
[rows] => 2
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 0 row(s) returned
)
[183] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,238)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=238
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => PRIMARY,type
[key] => type
[key_len] => 98
[ref] => const
[rows] => 2
[Extra] => Using index condition; Using where; Using filesort
)
[returned] => 0 row(s) returned
)
[184] => 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<1770933390) AND (p2.stop='' OR p2.stop>1770933390) 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<1770933390) AND (p1.stop='' OR p1.stop>1770933390) 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] => 6 row(s) returned
)
[185] => 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<1770933390) AND (p2.stop='' OR p2.stop>1770933390) 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<1770933390) AND (p1.stop='' OR p1.stop>1770933390) 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] => 15
[Extra] => Using where; Using filesort
)
[returned] => 18 row(s) returned
)
[186] => 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<1770933390) AND (p2.stop='' OR p2.stop>1770933390) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='247' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1770933390) AND (p1.stop='' OR p1.stop>1770933390) 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] => 1 row(s) returned
)
[187] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,247,248)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=247,`id`=248
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[188] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,247,248)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=247,`id`=248
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[189] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='2' 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
)
[190] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='90' 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
)
[191] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='89' 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
)
[192] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='90' 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
)
[193] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,89,90)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=89,`id`=90
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[194] => Array
(
[query] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (1,89,90)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=1,`id`=89,`id`=90
LIMIT
1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 2 (1%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
[returned] => 0 row(s) returned
)
[195] => 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.avisota_recipient_lists AS author__avisota_recipient_lists, j1.avisota_recipient_list_permissions AS author__avisota_recipient_list_permissions, j1.avisota_recipient_permissions AS author__avisota_recipient_permissions, j1.avisota_newsletter_categories AS author__avisota_newsletter_categories, j1.avisota_newsletter_category_permissions AS author__avisota_newsletter_category_permissions, j1.avisota_newsletter_permissions AS author__avisota_newsletter_permissions, j1.calendars AS author__calendars, j1.calendarp AS author__calendarp, j1.calendarfeeds AS author__calendarfeeds, j1.calendarfeedp AS author__calendarfeedp, j1.faqs AS author__faqs, j1.faqp AS author__faqp, j1.news AS author__news, j1.newp AS author__newp, j1.newsfeeds AS author__newsfeeds, j1.newsfeedp AS author__newsfeedp, j1.newsletters AS author__newsletters, j1.newsletterp AS author__newsletterp FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='7' AND tl_article.inColumn='zeile1' AND (tl_article.start='' OR tl_article.start<1770933390) AND (tl_article.stop='' OR tl_article.stop>1770933390) 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
)
[196] => 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 (3,7,5,14,4,13,12,11,10,9,8) ORDER BY FIND_IN_SET(id, '3,7,5,14,4,13,12,11,10,9,8')
[explain] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_style_sheet
[type] => ALL
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 14
[Extra] => Using where; Using filesort
)
[returned] => 11 row(s) returned
)
[197] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='1' 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
)
[198] => Array
(
[query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id='1' 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
)
[199] => 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.avisota_recipient_lists AS author__avisota_recipient_lists, j1.avisota_recipient_list_permissions AS author__avisota_recipient_list_permissions, j1.avisota_recipient_permissions AS author__avisota_recipient_permissions, j1.avisota_newsletter_categories AS author__avisota_newsletter_categories, j1.avisota_newsletter_category_permissions AS author__avisota_newsletter_category_permissions, j1.avisota_newsletter_permissions AS author__avisota_newsletter_permissions, j1.calendars AS author__calendars, j1.calendarp AS author__calendarp, j1.calendarfeeds AS author__calendarfeeds, j1.calendarfeedp AS author__calendarfeedp, j1.faqs AS author__faqs, j1.faqp AS author__faqp, j1.news AS author__news, j1.newp AS author__newp, j1.newsfeeds AS author__newsfeeds, j1.newsfeedp AS author__newsfeedp, j1.newsletters AS author__newsletters, j1.newsletterp AS author__newsletterp FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE (tl_article.id='232' OR tl_article.alias='232') LIMIT 0,1
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_article
[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
)
[200] => Array
(
[query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='232' AND (tl_content.ptable='tl_article' OR tl_content.ptable='') AND (tl_content.start='' OR tl_content.start<1770933390) AND (tl_content.stop='' OR tl_content.stop>1770933390) AND tl_content.invisible='' ORDER BY tl_content.sorting
[explain] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 8
[Extra] => Using where; Using filesort
)
[returned] => 9 row(s) returned
)
[201] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('8f5656f4f23b11e88c71e0d55e59099f') 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
)
[202] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('ec8b7dd5f23c11e88c71e0d55e59099f') 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
)
[203] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('a6cda6e0f23d11e88c71e0d55e59099f') 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
)
[204] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('cbd6d055f23d11e88c71e0d55e59099f') 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
)
[205] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('b30d8993f23d11e88c71e0d55e59099f') 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
)
[206] => Array
(
[query] => SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('c4ef7e3ff23d11e88c71e0d55e59099f') 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
)
)
)