Kamptal
Découvrez les domaines du Kamptal.
Découvrez les domaines du Kamptal.
Execution time: 1,587 msMemory usage: 16.8 MoDatabase queries: 130Rows: 320 returned, 0 affectedRegistered models: 146
Array ( [classes_aliased] => Array ( [0] => Model (Contao\Model) [1] => Input (Contao\Input) [2] => RequestToken (Contao\RequestToken) [3] => Environment (Contao\Environment) [4] => System (Contao\System) [5] => Session (Contao\Session) [6] => Frontend (Contao\Frontend) [7] => Controller (Contao\Controller) [8] => FrontendUser (Contao\FrontendUser) [9] => User (Contao\User) [10] => Database (Contao\Database) [11] => Database\Mysql (Contao\Database\Mysql) [12] => PageModel (Contao\PageModel) [13] => Model\QueryBuilder (Contao\Model\QueryBuilder) [14] => DcaExtractor (Contao\DcaExtractor) [15] => Backend (Contao\Backend) [16] => Database\Mysql\Statement (Contao\Database\Mysql\Statement) [17] => Database\Statement (Contao\Database\Statement) [18] => Database\Mysql\Result (Contao\Database\Mysql\Result) [19] => Database\Result (Contao\Database\Result) [20] => Model\Collection (Contao\Model\Collection) [21] => Model\Registry (Contao\Model\Registry) [22] => String (Contao\String) [23] => PageRegular (Contao\PageRegular) [24] => LayoutModel (Contao\LayoutModel) [25] => ThemeModel (Contao\ThemeModel) [26] => FrontendTemplate (Contao\FrontendTemplate) [27] => Template (Contao\Template) [28] => ModuleModel (Contao\ModuleModel) [29] => Module (Contao\Module) [30] => ModuleNavigation (Contao\ModuleNavigation) [31] => ModuleBreadcrumb (Contao\ModuleBreadcrumb) [32] => BackendUser (Contao\BackendUser) [33] => Database\Installer (Contao\Database\Installer) [34] => MemberGroupModel (Contao\MemberGroupModel) [35] => ArticleModel (Contao\ArticleModel) [36] => UserModel (Contao\UserModel) [37] => ModuleArticle (Contao\ModuleArticle) [38] => Date (Contao\Date) [39] => ContentModel (Contao\ContentModel) [40] => ContentElement (Contao\ContentElement) [41] => ContentText (Contao\ContentText) [42] => ModuleHtml (Contao\ModuleHtml) [43] => ModuleCustomnav (Contao\ModuleCustomnav) [44] => StyleSheetModel (Contao\StyleSheetModel) [45] => ModuleMailJetSubscribe (Contao\ModuleMailJetSubscribe) [46] => Combiner (Contao\Combiner) [47] => File (Contao\File) [48] => Files (Contao\Files) [49] => Files\Php (Contao\Files\Php) [50] => Search (Contao\Search) ) [classes_set] => Array ( [0] => RepositoryBackendTheme [1] => MultiColumnWizardHelper ) [database_queries] => Array ( [0] => Array ( [query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id=0 OR tl_page.alias='kamptal') AND (tl_page.start='' OR tl_page.start<1615082953) AND (tl_page.stop='' OR tl_page.stop>1615082953) AND tl_page.published=1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_page [type] => index_merge [possible_keys] => PRIMARY,alias [key] => PRIMARY,alias [key_len] => 4,386 [ref] => [rows] => 2 [Extra] => Using union(PRIMARY,alias); Using where ) [returned] => 1 row(s) returned ) [1] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='3' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 2 row(s) returned ) [2] => Array ( [query] => SELECT tl_layout.*, j1.id AS pid__id, j1.tstamp AS pid__tstamp, j1.name AS pid__name, j1.author AS pid__author, j1.folders AS pid__folders, j1.screenshot AS pid__screenshot, j1.templates AS pid__templates, j1.vars AS pid__vars FROM tl_layout LEFT JOIN tl_theme j1 ON tl_layout.pid=j1.id WHERE tl_layout.id='1' LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_layout [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [3] => Array ( [query] => SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id IN(24,19,1,0,0,9,0,15,22,5) ORDER BY FIND_IN_SET(tl_module.id, '24,19,1,0,0,9,0,15,22,5') [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_module [type] => ALL [possible_keys] => PRIMARY [key] => [key_len] => [ref] => [rows] => 23 [Extra] => Using where; Using filesort ) [returned] => 7 row(s) returned ) [4] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) 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<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 11 [Extra] => Using where; Using filesort ) [returned] => 6 row(s) returned ) [5] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='28' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 3 [Extra] => Using where; Using filesort ) [returned] => 6 row(s) returned ) [6] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='100' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [7] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='106' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [8] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='104' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [9] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='108' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 6 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [10] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='97' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [11] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='102' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [12] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='30' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 2 [Extra] => Using where; Using filesort ) [returned] => 4 row(s) returned ) [13] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='48' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 2 [Extra] => Using where; Using filesort ) [returned] => 3 row(s) returned ) [14] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='128' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 10 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [15] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='49' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [16] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='142' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 3 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [17] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) 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<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 4 [Extra] => Using where; Using filesort ) [returned] => 5 row(s) returned ) [18] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='5' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [19] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='132' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 5 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [20] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='9' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [21] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='21' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [22] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='134' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 4 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [23] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='31' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [24] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='58' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [25] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='29' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 5 [Extra] => Using where; Using filesort ) [returned] => 8 row(s) returned ) [26] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='62' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 3 [Extra] => Using where; Using filesort ) [returned] => 5 row(s) returned ) [27] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='64' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 4 [Extra] => Using where; Using filesort ) [returned] => 5 row(s) returned ) [28] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='65' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 2 [Extra] => Using where; Using filesort ) [returned] => 4 row(s) returned ) [29] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='63' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [30] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='60' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [31] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='61' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [32] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='121' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 4 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [33] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='91' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 2 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [34] => Array ( [query] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND (p2.start='' OR p2.start<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='32' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [35] => Array ( [query] => SELECT 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='54' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [36] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='3' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 2 row(s) returned ) [37] => Array ( [query] => SELECT tl_page.* FROM tl_page WHERE tl_page.pid='1' AND tl_page.type!='root' AND tl_page.type!='error_403' AND tl_page.type!='error_404' AND (tl_page.start='' OR tl_page.start<1615082954) AND (tl_page.stop='' OR tl_page.stop>1615082954) AND tl_page.published=1 ORDER BY tl_page.sorting LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_page [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 11 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [38] => Array ( [query] => SHOW TABLES FROM `tvins20141` [returned] => 75 row(s) returned ) [39] => Array ( [query] => SELECT * FROM tl_iso_attribute WHERE tl_iso_attribute.type!='' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_attribute [type] => ALL [possible_keys] => type [key] => [key_len] => [ref] => [rows] => 17 [Extra] => Using where ) [returned] => 17 row(s) returned ) [40] => Array ( [query] => SELECT * FROM tl_iso_label WHERE tl_iso_label.language='fr' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => [type] => [possible_keys] => [key] => [key_len] => [ref] => [rows] => [Extra] => Impossible WHERE noticed after reading const tables ) [returned] => 0 row(s) returned ) [41] => Array ( [query] => SELECT tl_iso_product_collection.* FROM tl_iso_product_collection WHERE uniqid='50b7a6b26ebca42c68871613fd90b29809dfd5d2' AND store_id=0 AND 1=1 HAVING type='cart' LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => [type] => [possible_keys] => [key] => [key_len] => [ref] => [rows] => [Extra] => Impossible WHERE noticed after reading const tables ) [returned] => 0 row(s) returned ) [42] => Array ( [query] => SELECT tl_iso_config.* FROM tl_iso_config WHERE (tl_iso_config.id=(SELECT iso_config FROM tl_page WHERE id='1') OR tl_iso_config.fallback='1') ORDER BY fallback [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_iso_config [type] => system [possible_keys] => PRIMARY [key] => [key_len] => [ref] => [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [43] => Array ( [query] => SELECT * FROM tl_iso_requestcache WHERE id=NULL AND store_id=0 LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => [type] => [possible_keys] => [key] => [key_len] => [ref] => [rows] => [Extra] => Impossible WHERE noticed after reading const tables ) [returned] => 0 row(s) returned ) [44] => Array ( [query] => SELECT id, pid FROM tl_page WHERE pid IN(5) [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_page [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [45] => Array ( [query] => SELECT id, pid FROM tl_page WHERE pid IN(15) [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_page [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 0 row(s) returned ) [46] => Array ( [query] => SELECT tl_iso_product.*, IF(tl_iso_product.pid>0, parent.type, tl_iso_product.type) AS type, 'fr' AS language, IFNULL(translation.name, tl_iso_product.name) AS name, IFNULL(translation.teaser, tl_iso_product.teaser) AS teaser, IFNULL(translation.description, tl_iso_product.description) AS description, IFNULL(translation.meta_title, tl_iso_product.meta_title) AS meta_title, IFNULL(translation.meta_description, tl_iso_product.meta_description) AS meta_description, IFNULL(translation.meta_keywords, tl_iso_product.meta_keywords) AS meta_keywords, IFNULL(translation.images, tl_iso_product.images) AS images, IFNULL(translation.provenance, tl_iso_product.provenance) AS provenance, IFNULL(translation.millesime, tl_iso_product.millesime) AS millesime, IFNULL(translation.cepage, tl_iso_product.cepage) AS cepage, tl_iso_product.images AS images_fallback, c.sorting, t.id AS type__id, t.tstamp AS type__tstamp, t.name AS type__name, t.class AS type__class, t.fallback AS type__fallback, t.description AS type__description, t.prices AS type__prices, t.show_price_tiers AS type__show_price_tiers, t.list_template AS type__list_template, t.reader_template AS type__reader_template, t.list_gallery AS type__list_gallery, t.reader_gallery AS type__reader_gallery, t.attributes AS type__attributes, t.variants AS type__variants, t.variant_attributes AS type__variant_attributes, t.force_variant_options AS type__force_variant_options, t.shipping_exempt AS type__shipping_exempt, t.downloads AS type__downloads FROM tl_iso_product LEFT OUTER JOIN tl_iso_product_category c ON tl_iso_product.id=c.pid LEFT OUTER JOIN tl_iso_product translation ON tl_iso_product.id=translation.pid AND translation.language='fr' LEFT OUTER JOIN tl_iso_product parent ON tl_iso_product.pid=parent.id LEFT JOIN tl_iso_producttype t ON tl_iso_product.type=t.id WHERE tl_iso_product.language='' AND tl_iso_product.published='1' AND (tl_iso_product.start='' OR tl_iso_product.start<1615082954) AND (tl_iso_product.stop='' OR tl_iso_product.stop>1615082954) AND c.page_id IN (15,5) GROUP BY tl_iso_product.id ORDER BY c.sorting [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => c [type] => ALL [possible_keys] => pid [key] => [key_len] => [ref] => [rows] => 85 [Extra] => Using where; Using temporary; Using filesort ) [returned] => 12 row(s) returned ) [47] => Array ( [query] => SELECT * FROM tl_iso_producttype WHERE tl_iso_producttype.id='1' LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_producttype [type] => system [possible_keys] => PRIMARY [key] => [key_len] => [ref] => [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [48] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='75' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [49] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='5' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 3 row(s) returned ) [50] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=75 [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 ) [51] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='76' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [52] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=76 [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 ) [53] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='77' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [54] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=77 [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 ) [55] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='78' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [56] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=78 [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 ) [57] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='79' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [58] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=79 [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 ) [59] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='81' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [60] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=81 [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 ) [61] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='82' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [62] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=82 [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 ) [63] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='83' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [64] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=83 [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 ) [65] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='84' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [66] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=84 [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 ) [67] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='85' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [68] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=85 [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 ) [69] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='86' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [70] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=86 [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 ) [71] => Array ( [query] => SELECT tl_iso_product_category.* FROM tl_iso_product_category WHERE tl_iso_product_category.pid='87' [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product_category [type] => ref [possible_keys] => pid [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [72] => Array ( [query] => SELECT tl_iso_product_price.* FROM tl_iso_product_price WHERE config_id=0 AND member_group=0 AND start='' AND stop='' AND pid=87 [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 ) [73] => Array ( [query] => SELECT tl_iso_product.*, IF(tl_iso_product.pid>0, parent.type, tl_iso_product.type) AS type, 'fr' AS language, IFNULL(translation.name, tl_iso_product.name) AS name, IFNULL(translation.teaser, tl_iso_product.teaser) AS teaser, IFNULL(translation.description, tl_iso_product.description) AS description, IFNULL(translation.meta_title, tl_iso_product.meta_title) AS meta_title, IFNULL(translation.meta_description, tl_iso_product.meta_description) AS meta_description, IFNULL(translation.meta_keywords, tl_iso_product.meta_keywords) AS meta_keywords, IFNULL(translation.images, tl_iso_product.images) AS images, IFNULL(translation.provenance, tl_iso_product.provenance) AS provenance, IFNULL(translation.millesime, tl_iso_product.millesime) AS millesime, IFNULL(translation.cepage, tl_iso_product.cepage) AS cepage, tl_iso_product.images AS images_fallback, c.sorting, t.id AS type__id, t.tstamp AS type__tstamp, t.name AS type__name, t.class AS type__class, t.fallback AS type__fallback, t.description AS type__description, t.prices AS type__prices, t.show_price_tiers AS type__show_price_tiers, t.list_template AS type__list_template, t.reader_template AS type__reader_template, t.list_gallery AS type__list_gallery, t.reader_gallery AS type__reader_gallery, t.attributes AS type__attributes, t.variants AS type__variants, t.variant_attributes AS type__variant_attributes, t.force_variant_options AS type__force_variant_options, t.shipping_exempt AS type__shipping_exempt, t.downloads AS type__downloads FROM tl_iso_product LEFT OUTER JOIN tl_iso_product_category c ON tl_iso_product.id=c.pid LEFT OUTER JOIN tl_iso_product translation ON tl_iso_product.id=translation.pid AND translation.language='fr' LEFT OUTER JOIN tl_iso_product parent ON tl_iso_product.pid=parent.id LEFT JOIN tl_iso_producttype t ON tl_iso_product.type=t.id WHERE tl_iso_product.language='' AND tl_iso_product.published='1' AND (tl_iso_product.start='' OR tl_iso_product.start<1615082954) AND (tl_iso_product.stop='' OR tl_iso_product.stop>1615082954) AND (tl_iso_product.id=0 OR tl_iso_product.alias=NULL) GROUP BY tl_iso_product.id LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_iso_product [type] => index [possible_keys] => PRIMARY,language_published_start_stop_pid,start [key] => PRIMARY [key_len] => 4 [ref] => [rows] => 1 [Extra] => Using where ) [returned] => 0 row(s) returned ) [74] => Array ( [query] => SELECT tl_article.*, j1.id AS author__id, j1.tstamp AS author__tstamp, j1.username AS author__username, j1.name AS author__name, j1.email AS author__email, j1.google AS author__google, j1.language AS author__language, j1.backendTheme AS author__backendTheme, j1.uploader AS author__uploader, j1.showHelp AS author__showHelp, j1.thumbnails AS author__thumbnails, j1.useRTE AS author__useRTE, j1.useCE AS author__useCE, j1.password AS author__password, j1.pwChange AS author__pwChange, j1.admin AS author__admin, j1.groups AS author__groups, j1.inherit AS author__inherit, j1.modules AS author__modules, j1.themes AS author__themes, j1.pagemounts AS author__pagemounts, j1.alpty AS author__alpty, j1.filemounts AS author__filemounts, j1.fop AS author__fop, j1.forms AS author__forms, j1.formp AS author__formp, j1.disable AS author__disable, j1.start AS author__start, j1.stop AS author__stop, j1.session AS author__session, j1.dateAdded AS author__dateAdded, j1.lastLogin AS author__lastLogin, j1.currentLogin AS author__currentLogin, j1.loginCount AS author__loginCount, j1.locked AS author__locked, j1.calendars AS author__calendars, j1.calendarp AS author__calendarp, j1.calendarfeeds AS author__calendarfeeds, j1.calendarfeedp AS author__calendarfeedp, j1.faqs AS author__faqs, j1.faqp AS author__faqp, j1.galleria AS author__galleria, j1.galleria_permission AS author__galleria_permission, j1.news AS author__news, j1.newp AS author__newp, j1.newsfeeds AS author__newsfeeds, j1.newsfeedp AS author__newsfeedp, j1.newsletters AS author__newsletters, j1.newsletterp AS author__newsletterp, j1.iso_modules AS author__iso_modules, j1.iso_product_types AS author__iso_product_types, j1.iso_product_typep AS author__iso_product_typep, j1.iso_payment_modules AS author__iso_payment_modules, j1.iso_payment_modulep AS author__iso_payment_modulep, j1.iso_shipping_modules AS author__iso_shipping_modules, j1.iso_shipping_modulep AS author__iso_shipping_modulep, j1.iso_tax_classes AS author__iso_tax_classes, j1.iso_tax_classp AS author__iso_tax_classp, j1.iso_tax_rates AS author__iso_tax_rates, j1.iso_tax_ratep AS author__iso_tax_ratep, j1.iso_configs AS author__iso_configs, j1.iso_configp AS author__iso_configp, j1.iso_groups AS author__iso_groups, j1.iso_groupp AS author__iso_groupp, j1.iso_reports AS author__iso_reports FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='5' AND tl_article.inColumn='right' AND (tl_article.start='' OR tl_article.start<1615082954) AND (tl_article.stop='' OR tl_article.stop>1615082954) 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 ) [75] => Array ( [query] => SELECT tl_article.*, j1.id AS author__id, j1.tstamp AS author__tstamp, j1.username AS author__username, j1.name AS author__name, j1.email AS author__email, j1.google AS author__google, j1.language AS author__language, j1.backendTheme AS author__backendTheme, j1.uploader AS author__uploader, j1.showHelp AS author__showHelp, j1.thumbnails AS author__thumbnails, j1.useRTE AS author__useRTE, j1.useCE AS author__useCE, j1.password AS author__password, j1.pwChange AS author__pwChange, j1.admin AS author__admin, j1.groups AS author__groups, j1.inherit AS author__inherit, j1.modules AS author__modules, j1.themes AS author__themes, j1.pagemounts AS author__pagemounts, j1.alpty AS author__alpty, j1.filemounts AS author__filemounts, j1.fop AS author__fop, j1.forms AS author__forms, j1.formp AS author__formp, j1.disable AS author__disable, j1.start AS author__start, j1.stop AS author__stop, j1.session AS author__session, j1.dateAdded AS author__dateAdded, j1.lastLogin AS author__lastLogin, j1.currentLogin AS author__currentLogin, j1.loginCount AS author__loginCount, j1.locked AS author__locked, j1.calendars AS author__calendars, j1.calendarp AS author__calendarp, j1.calendarfeeds AS author__calendarfeeds, j1.calendarfeedp AS author__calendarfeedp, j1.faqs AS author__faqs, j1.faqp AS author__faqp, j1.galleria AS author__galleria, j1.galleria_permission AS author__galleria_permission, j1.news AS author__news, j1.newp AS author__newp, j1.newsfeeds AS author__newsfeeds, j1.newsfeedp AS author__newsfeedp, j1.newsletters AS author__newsletters, j1.newsletterp AS author__newsletterp, j1.iso_modules AS author__iso_modules, j1.iso_product_types AS author__iso_product_types, j1.iso_product_typep AS author__iso_product_typep, j1.iso_payment_modules AS author__iso_payment_modules, j1.iso_payment_modulep AS author__iso_payment_modulep, j1.iso_shipping_modules AS author__iso_shipping_modules, j1.iso_shipping_modulep AS author__iso_shipping_modulep, j1.iso_tax_classes AS author__iso_tax_classes, j1.iso_tax_classp AS author__iso_tax_classp, j1.iso_tax_rates AS author__iso_tax_rates, j1.iso_tax_ratep AS author__iso_tax_ratep, j1.iso_configs AS author__iso_configs, j1.iso_configp AS author__iso_configp, j1.iso_groups AS author__iso_groups, j1.iso_groupp AS author__iso_groupp, j1.iso_reports AS author__iso_reports FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='5' AND tl_article.inColumn='main' AND (tl_article.start='' OR tl_article.start<1615082954) AND (tl_article.stop='' OR tl_article.stop>1615082954) 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 ) [76] => Array ( [query] => SELECT tl_content.* FROM tl_content WHERE tl_content.pid='3' AND (ptable='tl_article' OR ptable='') AND tl_content.invisible='' ORDER BY tl_content.sorting [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_content [type] => ref [possible_keys] => pid,ptable [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [77] => Array ( [query] => SELECT tl_article.*, j1.id AS author__id, j1.tstamp AS author__tstamp, j1.username AS author__username, j1.name AS author__name, j1.email AS author__email, j1.google AS author__google, j1.language AS author__language, j1.backendTheme AS author__backendTheme, j1.uploader AS author__uploader, j1.showHelp AS author__showHelp, j1.thumbnails AS author__thumbnails, j1.useRTE AS author__useRTE, j1.useCE AS author__useCE, j1.password AS author__password, j1.pwChange AS author__pwChange, j1.admin AS author__admin, j1.groups AS author__groups, j1.inherit AS author__inherit, j1.modules AS author__modules, j1.themes AS author__themes, j1.pagemounts AS author__pagemounts, j1.alpty AS author__alpty, j1.filemounts AS author__filemounts, j1.fop AS author__fop, j1.forms AS author__forms, j1.formp AS author__formp, j1.disable AS author__disable, j1.start AS author__start, j1.stop AS author__stop, j1.session AS author__session, j1.dateAdded AS author__dateAdded, j1.lastLogin AS author__lastLogin, j1.currentLogin AS author__currentLogin, j1.loginCount AS author__loginCount, j1.locked AS author__locked, j1.calendars AS author__calendars, j1.calendarp AS author__calendarp, j1.calendarfeeds AS author__calendarfeeds, j1.calendarfeedp AS author__calendarfeedp, j1.faqs AS author__faqs, j1.faqp AS author__faqp, j1.galleria AS author__galleria, j1.galleria_permission AS author__galleria_permission, j1.news AS author__news, j1.newp AS author__newp, j1.newsfeeds AS author__newsfeeds, j1.newsfeedp AS author__newsfeedp, j1.newsletters AS author__newsletters, j1.newsletterp AS author__newsletterp, j1.iso_modules AS author__iso_modules, j1.iso_product_types AS author__iso_product_types, j1.iso_product_typep AS author__iso_product_typep, j1.iso_payment_modules AS author__iso_payment_modules, j1.iso_payment_modulep AS author__iso_payment_modulep, j1.iso_shipping_modules AS author__iso_shipping_modules, j1.iso_shipping_modulep AS author__iso_shipping_modulep, j1.iso_tax_classes AS author__iso_tax_classes, j1.iso_tax_classp AS author__iso_tax_classp, j1.iso_tax_rates AS author__iso_tax_rates, j1.iso_tax_ratep AS author__iso_tax_ratep, j1.iso_configs AS author__iso_configs, j1.iso_configp AS author__iso_configp, j1.iso_groups AS author__iso_groups, j1.iso_groupp AS author__iso_groupp, j1.iso_reports AS author__iso_reports FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='5' AND tl_article.inColumn='TOP pleine largeur' AND (tl_article.start='' OR tl_article.start<1615082954) AND (tl_article.stop='' OR tl_article.stop>1615082954) 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 ) [78] => Array ( [query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(81,82,86,44,14,53) AND tl_page.type!='root' AND tl_page.type!='error_403' AND tl_page.type!='error_404' AND (tl_page.start='' OR tl_page.start<1615082954) AND (tl_page.stop='' OR tl_page.stop>1615082954) AND tl_page.published=1 ORDER BY FIND_IN_SET(tl_page.id, '81,82,86,44,14,53') [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_page [type] => range [possible_keys] => PRIMARY,type [key] => PRIMARY [key_len] => 4 [ref] => [rows] => 6 [Extra] => Using index condition; Using where; Using filesort ) [returned] => 6 row(s) returned ) [79] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [80] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [81] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [82] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [83] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [84] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [85] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) 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<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 11 [Extra] => Using where; Using filesort ) [returned] => 6 row(s) returned ) [86] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='28' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 3 [Extra] => Using where; Using filesort ) [returned] => 6 row(s) returned ) [87] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='100' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [88] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='106' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [89] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='104' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [90] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='108' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 6 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [91] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='97' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [92] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='102' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [93] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='30' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 2 [Extra] => Using where; Using filesort ) [returned] => 4 row(s) returned ) [94] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='48' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 2 [Extra] => Using where; Using filesort ) [returned] => 3 row(s) returned ) [95] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='128' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 10 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [96] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='49' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [97] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='142' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 3 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [98] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) 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<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 4 [Extra] => Using where; Using filesort ) [returned] => 5 row(s) returned ) [99] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='5' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [100] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='132' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 5 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [101] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='9' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [102] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='21' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [103] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='134' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 4 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [104] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='31' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [105] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='58' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [106] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='29' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 5 [Extra] => Using where; Using filesort ) [returned] => 8 row(s) returned ) [107] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='62' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 3 [Extra] => Using where; Using filesort ) [returned] => 5 row(s) returned ) [108] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='64' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 4 [Extra] => Using where; Using filesort ) [returned] => 5 row(s) returned ) [109] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='65' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 2 [Extra] => Using where; Using filesort ) [returned] => 4 row(s) returned ) [110] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='63' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 2 row(s) returned ) [111] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='60' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [112] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='61' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [113] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='121' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) 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] => 4 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [114] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='91' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 2 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [115] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='32' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [116] => 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<1615082954) AND (p2.stop='' OR p2.stop>1615082954) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='54' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND (p1.start='' OR p1.start<1615082954) AND (p1.stop='' OR p1.stop>1615082954) AND p1.published=1 ORDER BY p1.sorting [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => p1 [type] => ref [possible_keys] => pid,type [key] => pid [key_len] => 4 [ref] => const [rows] => 1 [Extra] => Using where; Using filesort ) [returned] => 1 row(s) returned ) [117] => Array ( [query] => SELECT *, (SELECT tstamp FROM tl_theme WHERE tl_theme.id=tl_style_sheet.pid) AS tstamp3, (SELECT MAX(tstamp) FROM tl_style WHERE tl_style.pid=tl_style_sheet.id) AS tstamp2, (SELECT COUNT(*) FROM tl_style WHERE tl_style.selector='@font-face' AND tl_style.invisible='' AND tl_style.pid=tl_style_sheet.id) AS hasFontFace FROM tl_style_sheet WHERE id IN (1,2,3) ORDER BY FIND_IN_SET(id, '1,2,3') [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_style_sheet [type] => ALL [possible_keys] => PRIMARY [key] => [key_len] => [ref] => [rows] => 3 [Extra] => Using where; Using filesort ) [returned] => 3 row(s) returned ) [118] => Array ( [query] => SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='6' LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_module [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [119] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [120] => Array ( [query] => SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='13' LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_module [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [121] => Array ( [query] => SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='14' LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_module [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [122] => Array ( [query] => SELECT tl_content.* FROM tl_content WHERE tl_content.id='5' LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_content [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [123] => Array ( [query] => SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop, j1.iso_config AS jumpTo__iso_config, j1.iso_store_id AS jumpTo__iso_store_id, j1.iso_setReaderJumpTo AS jumpTo__iso_setReaderJumpTo, j1.iso_readerJumpTo AS jumpTo__iso_readerJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id='16' LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_module [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [124] => Array ( [query] => SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(81,82,86,44,14,53) AND tl_page.type!='root' AND tl_page.type!='error_403' AND tl_page.type!='error_404' AND (tl_page.start='' OR tl_page.start<1615082954) AND (tl_page.stop='' OR tl_page.stop>1615082954) AND tl_page.published=1 ORDER BY FIND_IN_SET(tl_page.id, '81,82,86,44,14,53') [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_page [type] => range [possible_keys] => PRIMARY,type [key] => PRIMARY [key_len] => 4 [ref] => [rows] => 6 [Extra] => Using index condition; Using where; Using filesort ) [returned] => 6 row(s) returned ) [125] => Array ( [query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='47' OR tl_page.alias='47') LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_page [type] => index_merge [possible_keys] => PRIMARY,alias [key] => PRIMARY,alias [key_len] => 4,386 [ref] => [rows] => 2 [Extra] => Using union(PRIMARY,alias); Using where ) [returned] => 1 row(s) returned ) [126] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [127] => Array ( [query] => SELECT tl_page.* FROM tl_page WHERE (tl_page.id='46' OR tl_page.alias='46') LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_page [type] => index_merge [possible_keys] => PRIMARY,alias [key] => PRIMARY,alias [key_len] => 4,386 [ref] => [rows] => 2 [Extra] => Using union(PRIMARY,alias); Using where ) [returned] => 1 row(s) returned ) [128] => Array ( [query] => SELECT *, @pid:=pid FROM tl_page WHERE id='1' UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid UNION SELECT *, @pid:=pid FROM tl_page WHERE id=@pid [explain] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tl_page [type] => const [possible_keys] => PRIMARY [key] => PRIMARY [key_len] => 4 [ref] => const [rows] => 1 [Extra] => ) [returned] => 1 row(s) returned ) [129] => Array ( [query] => SELECT id, checksum FROM tl_search WHERE url='kamptal.html' AND pid='5' LIMIT 0,1 [explain] => Array ( [id] => 1 [select_type] => SIMPLE [table] => tl_search [type] => ref [possible_keys] => pid,url [key] => url [key_len] => 767 [ref] => const [rows] => 1 [Extra] => Using index condition; Using where ) [returned] => 1 row(s) returned ) ) [unknown_insert_tags] => Array ( [0] => product::id ) )