Ihr Testprogramm für zuhause

13 Möglichkeiten, Nervenstörungen zu prüfen - ein Testprogramm

 >> weiter zum Test

Newsletter abonnieren

Aufgrund der neuen EU-Datenschutzgrundverordnung (DSGVO), die ab dem 25. Mai 2018 in Kraft tritt, setzen wir unseren Newsletterversand aus.

Array
(
    [0] => Array
        (
            [0] => SELECT * FROM tl_page WHERE (id=0 OR alias='Service') AND (start='' OR start<1743451400) AND (stop='' OR stop>1743451400) AND published=1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 2.50
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [1] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='19' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [2] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='27' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [3] => 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
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [4] => Array
        (
            [0] => SELECT l.*, t.templates FROM tl_layout l LEFT JOIN tl_theme t ON l.pid=t.id WHERE l.id='13' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => l
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [5] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='16' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [6] => 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<1743451400) AND (p2.stop='' OR p2.stop>1743451400) 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<1743451400) AND (p1.stop='' OR p1.stop>1743451400) AND p1.published=1 ORDER BY p1.sorting
            [1] => 8 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 15
                    [filtered] => 1.47
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [7] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='10' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [8] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='32' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [9] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='19' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [10] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='22' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [11] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='38' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [12] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='17' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [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<1743451400) AND (p2.stop='' OR p2.stop>1743451400) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='27' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1743451400) AND (p1.stop='' OR p1.stop>1743451400) AND p1.published=1 ORDER BY p1.sorting
            [1] => 3 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 5
                    [filtered] => 1.47
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [14] => Array
        (
            [0] => SELECT id FROM tl_article WHERE pid='19' AND inColumn='left' AND (start='' OR start<1743451400) AND (stop='' OR stop>1743451400) AND published=1 ORDER BY sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_article
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 1.67
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [15] => Array
        (
            [0] => SELECT *, author AS authorId, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_article WHERE (id='115' OR alias='115') AND pid='19' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_article
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => PRIMARY,pid,alias
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 11.03
                    [Extra] => Using where
                )

        )

    [16] => Array
        (
            [0] => SELECT id FROM tl_content WHERE pid='115' AND invisible='' ORDER BY sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 10.00
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [17] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='143' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [18] => Array
        (
            [0] => SELECT id FROM tl_article WHERE pid='19' AND inColumn='right' AND (start='' OR start<1743451400) AND (stop='' OR stop>1743451400) AND published=1 ORDER BY sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_article
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 1.67
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [19] => Array
        (
            [0] => SELECT *, author AS authorId, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_article WHERE (id='65' OR alias='65') AND pid='19' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_article
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => PRIMARY,pid,alias
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 11.03
                    [Extra] => Using where
                )

        )

    [20] => Array
        (
            [0] => SELECT id FROM tl_content WHERE pid='65' AND invisible='' ORDER BY sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 10.00
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [21] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='90' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [22] => Array
        (
            [0] => SELECT id FROM tl_article WHERE pid='19' AND inColumn='main' AND (start='' OR start<1743451400) AND (stop='' OR stop>1743451400) AND published=1 ORDER BY sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_article
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 1.67
                    [Extra] => Using index condition; 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='51' OR alias='51') AND pid='19' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_article
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => PRIMARY,pid,alias
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 11.03
                    [Extra] => Using where
                )

        )

    [24] => Array
        (
            [0] => SELECT id FROM tl_content WHERE pid='51' AND invisible='' ORDER BY sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 10.00
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [25] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='63' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [26] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='24' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [27] => Array
        (
            [0] => SELECT *, (SELECT MAX(tstamp) FROM tl_style WHERE tl_style.pid=tl_style_sheet.id) AS tstamp2 FROM tl_style_sheet WHERE id IN (1, 5) ORDER BY FIELD(id, 1, 5)
            [1] => 2 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_style_sheet
                    [partitions] => 
                    [type] => range
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using where; Using filesort
                )

        )

    [28] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='16' OR alias='16' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [29] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='3' OR alias='3' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [30] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='101' OR alias='101' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [31] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='26' OR alias='26' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [32] => Array
        (
            [0] => SELECT id, checksum FROM tl_search WHERE url='index.php/Service.html' AND pid='19' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_search
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid,url
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 5.00
                    [Extra] => Using where
                )

        )

)