Faces

1
Renate A. Simone M. Britta H. Rita H. Claudia F.
2
Sabine F. Marianne W. Jutta G. Anette W. Heidi T.
Ernst-Georg N. Manfred A. Kai-Michael M. Christoph S. Manfred H. Klaus B. Werner P. Albrecht M. 
Array
(
    [0] => Array
        (
            [0] => SELECT * FROM tl_page WHERE (id=0 OR alias='models/faces') AND (start='' OR start<1283825914) AND (stop='' OR stop>1283825914) 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
                )

        )

    [1] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='30' 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] => 
                )

        )

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

        )

    [3] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='17' 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_layout WHERE id='3' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_layout
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [5] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='12' 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] => 
                )

        )

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

        )

    [7] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='5' 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 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<1283825914) AND (p2.stop='' OR p2.stop>1283825914) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='17' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1283825914) AND (p1.stop='' OR p1.stop>1283825914) 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] => 8
                    [Extra] => Using where; Using filesort
                )

        )

    [9] => Array
        (
            [0] => SELECT id, (SELECT COUNT(*) FROM tl_page t2 WHERE t1.id=t2.pid) AS hasChilds FROM tl_page t1 WHERE t1.pid='19' AND t1.id!='19' ORDER BY t1.sorting
            [1] => 6 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => t1
                    [type] => ref
                    [possible_keys] => PRIMARY,pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 6
                    [Extra] => Using where; Using filesort
                )

        )

    [10] => Array
        (
            [0] => SELECT id, (SELECT COUNT(*) FROM tl_page t2 WHERE t1.id=t2.pid) AS hasChilds FROM tl_page t1 WHERE t1.pid='27' AND t1.id!='27' ORDER BY t1.sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => t1
                    [type] => ref
                    [possible_keys] => PRIMARY,pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => Using where; Using filesort
                )

        )

    [11] => Array
        (
            [0] => SELECT id, (SELECT COUNT(*) FROM tl_page t2 WHERE t1.id=t2.pid) AS hasChilds FROM tl_page t1 WHERE t1.pid='28' AND t1.id!='28' ORDER BY t1.sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => t1
                    [type] => ref
                    [possible_keys] => PRIMARY,pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => Using where; Using filesort
                )

        )

    [12] => Array
        (
            [0] => SELECT id, (SELECT COUNT(*) FROM tl_page t2 WHERE t1.id=t2.pid) AS hasChilds FROM tl_page t1 WHERE t1.pid='29' AND t1.id!='29' ORDER BY t1.sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => t1
                    [type] => ref
                    [possible_keys] => PRIMARY,pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => Using where; Using filesort
                )

        )

    [13] => Array
        (
            [0] => SELECT id, (SELECT COUNT(*) FROM tl_page t2 WHERE t1.id=t2.pid) AS hasChilds FROM tl_page t1 WHERE t1.pid='30' AND t1.id!='30' ORDER BY t1.sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => t1
                    [type] => ref
                    [possible_keys] => PRIMARY,pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => Using where; Using filesort
                )

        )

    [14] => Array
        (
            [0] => SELECT id, (SELECT COUNT(*) FROM tl_page t2 WHERE t1.id=t2.pid) AS hasChilds FROM tl_page t1 WHERE t1.pid='31' AND t1.id!='31' ORDER BY t1.sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => t1
                    [type] => ref
                    [possible_keys] => PRIMARY,pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [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<1283825914) AND (p2.stop='' OR p2.stop>1283825914) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='19' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1283825914) AND (p1.stop='' OR p1.stop>1283825914) 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
                )

        )

    [16] => Array
        (
            [0] => SELECT id, (SELECT COUNT(*) FROM tl_page t2 WHERE t1.id=t2.pid) AS hasChilds FROM tl_page t1 WHERE t1.pid='21' AND t1.id!='21' ORDER BY t1.sorting
            [1] => 2 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => t1
                    [type] => ref
                    [possible_keys] => PRIMARY,pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 2
                    [Extra] => Using where; Using filesort
                )

        )

    [17] => Array
        (
            [0] => SELECT id FROM tl_article WHERE pid='30' AND inColumn='main' AND (start='' OR start<1283825914) AND (stop='' OR stop>1283825914) 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
                )

        )

    [18] => Array
        (
            [0] => SELECT *, author AS authorId, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_article WHERE (id='39' OR alias='39') AND pid='30' 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
                )

        )

    [19] => Array
        (
            [0] => SELECT id FROM tl_content WHERE pid='39' AND invisible='' ORDER BY sorting
            [1] => 3 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] => 3
                    [Extra] => Using where; Using filesort
                )

        )

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

        )

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

        )

    [23] => Array
        (
            [0] => SELECT tl_models.id AS id, pid, tl_mo_nickname, tl_mo_number, tl_mo_height, tl_mo_hairColor, tl_mo_eyeColor, tl_mo_size1,tl_mo_size2,tl_mo_size3, tl_mo_shoeSize, tl_mo_specials, tl_mo_image, tl_mo_image1, tl_mo_image2, tl_mo_preimage, jumpTo, title, headline FROM tl_models LEFT JOIN tl_model_category ON(tl_model_category.id=tl_models.pid) WHERE pid IN(4) AND published=1 ORDER BY sorting
            [1] => 10 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_models
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 8
                    [Extra] => Using where; Using filesort
                )

        )

    [24] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='35' 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] => 
                )

        )

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

        )

    [26] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='82' 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='25' 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 tl_models.id AS id, pid, tl_mo_nickname, tl_mo_number, tl_mo_height, tl_mo_hairColor, tl_mo_eyeColor, tl_mo_size1,tl_mo_size2,tl_mo_size3, tl_mo_shoeSize, tl_mo_specials, tl_mo_image, tl_mo_image1, tl_mo_image2, tl_mo_preimage, jumpTo, title, headline FROM tl_models LEFT JOIN tl_model_category ON(tl_model_category.id=tl_models.pid) WHERE pid IN(24) AND published=1 ORDER BY sorting
            [1] => 8 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_models
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 6
                    [Extra] => Using where; Using filesort
                )

        )

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

        )

    [30] => Array
        (
            [0] => SELECT name, cc, media FROM tl_style_sheet WHERE id IN (1, 3, 9, 2, 10) ORDER BY FIELD(id, 1, 3, 9, 2, 10)
            [1] => 5 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_style_sheet
                    [type] => ALL
                    [possible_keys] => PRIMARY
                    [key] => 
                    [key_len] => 
                    [ref] => 
                    [rows] => 10
                    [Extra] => Using where; Using filesort
                )

        )

    [31] => Array
        (
            [0] => SELECT *, author AS authorId, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_article WHERE (id='45' OR alias='45') LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_article
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [32] => Array
        (
            [0] => SELECT id FROM tl_content WHERE pid='45' AND invisible='' ORDER BY sorting
            [1] => 1 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] => 1
                    [Extra] => Using where; Using filesort
                )

        )

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

        )

    [34] => Array
        (
            [0] => SELECT id, checksum FROM tl_search WHERE url='models/faces' AND pid='30' 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
                )

        )

)