Code:
Array
(
[0] => Array
(
[0] => SELECT * FROM tl_session WHERE hash='5ef36aab5abea38cf77f10e00e942ba5ddd3258e' AND name='BE_USER_AUTH' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_session
[type] => system
[possible_keys] => hash
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[Extra] =>
)
)
[1] => Array
(
[0] => SELECT * FROM tl_page WHERE (id=0 OR alias='gipfeltreffen') AND (start='' OR start<1386148246) AND (stop='' OR stop>1386148246) AND published=1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[Extra] => Using union(PRIMARY,alias); Using where
)
)
[2] => Array
(
[0] => SELECT * FROM tl_page WHERE id='23' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[3] => Array
(
[0] => SELECT * FROM tl_page WHERE id='5' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[4] => Array
(
[0] => SELECT * FROM tl_page WHERE id='1' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[5] => Array
(
[0] => SELECT l.*, t.templates FROM tl_layout l LEFT JOIN tl_theme t ON l.pid=t.id WHERE l.id=0 LIMIT 0,1
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] =>
[type] =>
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Impossible WHERE noticed after reading const tables
)
)
[6] => Array
(
[0] => SELECT l.*, t.templates FROM tl_layout l LEFT JOIN tl_theme t ON l.pid=t.id WHERE l.fallback=1 LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => l
[type] => system
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[Extra] =>
)
)
[7] => Array
(
[0] => SELECT * FROM tl_module WHERE id='1' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[8] => Array
(
[0] => SELECT * FROM tl_layout WHERE id=0 LIMIT 0,1
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] =>
[type] =>
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Impossible WHERE noticed after reading const tables
)
)
[9] => Array
(
[0] => SELECT * FROM tl_layout WHERE fallback=1 LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_layout
[type] => system
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[Extra] =>
)
)
[10] => Array
(
[0] => SELECT * FROM tl_module WHERE id='2' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[11] => Array
(
[0] => 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!=1 AND (p2.start='' OR p2.start<1386148246) AND (p2.stop='' OR p2.stop>1386148246) 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!=1 AND (p1.start='' OR p1.start<1386148246) AND (p1.stop='' OR p1.stop>1386148246) AND p1.published=1 ORDER BY p1.sorting
[1] => 4 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 7
[Extra] => Using where; Using filesort
)
)
[12] => Array
(
[0] => 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!=1 AND (p2.start='' OR p2.start<1386148246) AND (p2.stop='' OR p2.stop>1386148246) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='2' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1386148246) AND (p1.stop='' OR p1.stop>1386148246) AND p1.published=1 ORDER BY p1.sorting
[1] => 2 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
)
[13] => Array
(
[0] => 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!=1 AND (p2.start='' OR p2.start<1386148246) AND (p2.stop='' OR p2.stop>1386148246) 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!=1 AND (p1.start='' OR p1.start<1386148246) AND (p1.stop='' OR p1.stop>1386148246) AND p1.published=1 ORDER BY p1.sorting
[1] => 5 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 6
[Extra] => Using where; Using filesort
)
)
[14] => Array
(
[0] => 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!=1 AND (p2.start='' OR p2.start<1386148246) AND (p2.stop='' OR p2.stop>1386148246) 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!=1 AND (p1.start='' OR p1.start<1386148246) AND (p1.stop='' OR p1.stop>1386148246) AND p1.published=1 ORDER BY p1.sorting
[1] => 3 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
)
[15] => Array
(
[0] => 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!=1 AND (p2.start='' OR p2.start<1386148246) AND (p2.stop='' OR p2.stop>1386148246) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='23' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1386148246) AND (p1.stop='' OR p1.stop>1386148246) AND p1.published=1 ORDER BY p1.sorting
[1] => 3 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
)
[16] => Array
(
[0] => SELECT id FROM tl_article WHERE pid='23' AND inColumn='right' AND (start='' OR start<1386148246) AND (stop='' OR stop>1386148246) AND published=1 ORDER BY sorting
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_article
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
)
[17] => Array
(
[0] => SELECT *, author AS authorId, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_article WHERE (id='40' OR alias='40') AND pid='23' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_article
[type] => ref
[possible_keys] => PRIMARY,pid,alias
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where
)
)
[18] => Array
(
[0] => SELECT id FROM tl_content WHERE pid='40' AND invisible='' ORDER BY sorting
[1] => 2 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
)
[19] => Array
(
[0] => SELECT * FROM tl_content WHERE id='61' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[20] => Array
(
[0] => SELECT * FROM tl_content WHERE id='95' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[21] => Array
(
[0] => SELECT * FROM tl_content WHERE id='95' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[22] => Array
(
[0] => SELECT id FROM tl_article WHERE pid='23' AND inColumn='main' AND (start='' OR start<1386148246) AND (stop='' OR stop>1386148246) AND published=1 ORDER BY sorting
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_article
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
)
[23] => Array
(
[0] => SELECT *, author AS authorId, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_article WHERE (id='20' OR alias='20') AND pid='23' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_article
[type] => ref
[possible_keys] => PRIMARY,pid,alias
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where
)
)
[24] => Array
(
[0] => SELECT id FROM tl_content WHERE pid='20' AND invisible='' ORDER BY sorting
[1] => 2 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)
)
[25] => Array
(
[0] => SELECT * FROM tl_content WHERE id='23' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[26] => Array
(
[0] => SELECT * FROM tl_content WHERE id='30' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_content
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[27] => Array
(
[0] => SELECT * FROM tl_module WHERE id='6' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[28] => Array
(
[0] => SELECT * FROM tl_page WHERE id='26' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1386148246) AND (stop='' OR stop>1386148246) AND published=1 LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[29] => Array
(
[0] => SELECT * FROM tl_page WHERE id='27' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1386148246) AND (stop='' OR stop>1386148246) AND published=1 LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[30] => Array
(
[0] => SELECT * FROM tl_page WHERE id='28' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1386148246) AND (stop='' OR stop>1386148246) AND published=1 LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[31] => Array
(
[0] => SELECT * FROM tl_module WHERE id='3' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[32] => Array
(
[0] => SELECT * FROM tl_page WHERE id=0 OR alias='kontakt' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[Extra] => Using union(PRIMARY,alias); Using where
)
)
[33] => Array
(
[0] => SELECT * FROM tl_page WHERE id=0 OR alias='impressum' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[Extra] => Using union(PRIMARY,alias); Using where
)
)
[34] => Array
(
[0] => SELECT id, checksum FROM tl_search WHERE url='index.php/gipfeltreffen.html' AND pid='23' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_search
[type] => ref
[possible_keys] => pid,url
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where
)
)
)
Lesezeichen