Kostenlos anrufen ...

Bitte klicken Sie hier, wenn Sie uns kostenlos anrufen möchten.

 

powerd by stadtbranchenbuch

Array
(
    [0] => Array
        (
            [0] => SELECT * FROM tl_page WHERE (id=0 OR alias='Kontakt') AND (start='' OR start<1743452943) AND (stop='' OR stop>1743452943) 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='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] => 
                )

        )

    [2] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='7' 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='11' 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<1743452944) AND (p2.stop='' OR p2.stop>1743452944) 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<1743452944) AND (p1.stop='' OR p1.stop>1743452944) 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='30' 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<1743452944) AND (p2.stop='' OR p2.stop>1743452944) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='7' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1743452944) AND (p1.stop='' OR p1.stop>1743452944) AND p1.published=1 ORDER BY p1.sorting
            [1] => 2 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] => 2
                    [filtered] => 2.50
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [14] => Array
        (
            [0] => SELECT id FROM tl_article WHERE pid='22' AND inColumn='left' AND (start='' OR start<1743452944) AND (stop='' OR stop>1743452944) 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='46' OR alias='46') AND pid='22' 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='46' 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='54' 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='22' AND inColumn='right' AND (start='' OR start<1743452944) AND (stop='' OR stop>1743452944) 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='49' OR alias='49') AND pid='22' 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='49' 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='58' 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='22' AND inColumn='main' AND (start='' OR start<1743452944) AND (stop='' OR stop>1743452944) 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='48' OR alias='48') AND pid='22' 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='48' 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
                )

        )

    [25] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='147' 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='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
                )

        )

    [29] => 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
                )

        )

    [30] => 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
                )

        )

    [31] => Array
        (
            [0] => SELECT id, checksum FROM tl_search WHERE url='index.php/Kontakt.html' AND pid='22' 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
                )

        )

)