56 Musikgruppen bzw. Solisten entsprechen der aktuellen Filter-Auswahl
Debug information
Array
(
[0] => Array
(
[0] => SELECT id FROM tl_page WHERE alias=''
[1] => 5 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => alias
[key] => alias
[key_len] => 130
[ref] => const
[rows] => 3
[Extra] => Using index condition
)
)
[1] => Array
(
[0] => SELECT id, dns, language, fallback FROM tl_page WHERE type='root' AND (dns='x.volxmusik.de' OR dns='') AND fallback=1 AND (start='' OR start<1746528160) AND (stop='' OR stop>1746528160) AND published=1 ORDER BY dns DESC, sorting LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => type
[key] => type
[key_len] => 98
[ref] => const
[rows] => 15
[Extra] => Using index condition; Using where; Using filesort
)
)
[2] => Array
(
[0] => SELECT id, alias, language FROM tl_page WHERE pid='53' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1746528160) AND (stop='' OR stop>1746528160) AND published=1 ORDER BY sorting LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => pid,type
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 8
[Extra] => Using where; Using filesort
)
)
[3] => Array
(
[0] => SELECT * FROM tl_page WHERE (id='1532' OR alias='1532') AND (start='' OR start<1746528160) AND (stop='' OR stop>1746528160) 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
)
)
[4] => Array
(
[0] => SELECT * FROM tl_page WHERE id='1532' 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 * FROM tl_page WHERE id='53' 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] =>
)
)
[6] => Array
(
[0] => SELECT l.*, t.templates FROM tl_layout l LEFT JOIN tl_theme t ON l.pid=t.id WHERE l.id='71' OR l.fallback=1 ORDER BY l.id='71' DESC LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => l
[type] => ALL
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 28
[Extra] => Using where; Using filesort
)
)
[7] => Array
(
[0] => SELECT * FROM tl_module WHERE id='349' 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 tl_visitors.id AS id, visitors_name, visitors_startdate, visitors_average FROM tl_visitors LEFT JOIN tl_visitors_category ON (tl_visitors_category.id=tl_visitors.pid) WHERE pid='2' AND published=1 ORDER BY id, visitors_name LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_visitors
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
)
[9] => Array
(
[0] => SELECT l.*, t.templates FROM tl_layout l LEFT JOIN tl_theme t ON l.pid=t.id WHERE l.id='71' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => l
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[10] => Array
(
[0] => SELECT * FROM tl_module WHERE id='313' 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 id FROM tl_article WHERE pid='1532' AND inColumn='main' AND (start='' OR start<1746528160) AND (stop='' OR stop>1746528160) 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] => 1
[Extra] => Using where; Using filesort
)
)
[12] => Array
(
[0] => SELECT *, author AS authorId, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_article WHERE (id='2289' OR alias='2289') AND pid='1532' 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] => 1
[Extra] => Using where
)
)
[13] => Array
(
[0] => SELECT id FROM tl_content WHERE pid='2289' 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
)
)
[14] => Array
(
[0] => SELECT * FROM tl_content WHERE id='6856' 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] =>
)
)
[15] => Array
(
[0] => SELECT * FROM tl_module WHERE id='834' 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] =>
)
)
[16] => Array
(
[0] => SELECT * FROM tl_content WHERE id='6857' 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] =>
)
)
[17] => Array
(
[0] => SELECT * FROM tl_module WHERE id='637' 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] =>
)
)
[18] => Array
(
[0] => SELECT * FROM tl_content WHERE id='6858' 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] =>
)
)
[19] => Array
(
[0] => SELECT * FROM tl_module WHERE id='736' 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] =>
)
)
[20] => Array
(
[0] => SELECT * FROM tl_catalog_types WHERE id='1' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_catalog_types
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[21] => Array
(
[0] => SELECT * FROM tl_catalog_fields WHERE pid='1' ORDER BY sorting
[1] => 36 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_catalog_fields
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 31
[Extra] => Using where; Using filesort
)
)
[22] => Array
(
[0] => SHOW COLUMNS FROM `tl_taxonomy`
[1] => 7 rows affected
)
[23] => Array
(
[0] => SHOW INDEXES FROM `tl_taxonomy`
[1] => 3 rows affected
)
[24] => Array
(
[0] => SELECT tableName FROM tl_catalog_types WHERE tableName='tl_taxonomy' LIMIT 0,1
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_catalog_types
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 21
[Extra] => Using where
)
)
[25] => Array
(
[0] => SELECT id, (SELECT COUNT(*) FROM tl_taxonomy i WHERE i.pid=o.id) AS childCount, name FROM tl_taxonomy o WHERE pid IN (146) ORDER BY sorting
[1] => 3 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => o
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)
)
[26] => Array
(
[0] => SELECT id, (SELECT COUNT(*) FROM tl_taxonomy i WHERE i.pid=o.id) AS childCount, name FROM tl_taxonomy o WHERE id IN (111,112,113,114,115,121,125,129,131,132,133,134,135,136,137,138,141,142,143,144) ORDER BY id
[1] => 20 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => o
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 20
[Extra] => Using index condition
)
)
[27] => Array
(
[0] => SELECT id, (SELECT COUNT(*) FROM tl_taxonomy i WHERE i.pid=o.id) AS childCount, name FROM tl_taxonomy o WHERE id IN (332,333,330,337,60,331,57,345,66,62,64,145,63,65,58,59,54,61,55,56) ORDER BY sorting
[1] => 20 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => o
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 20
[Extra] => Using index condition; Using filesort
)
)
[28] => Array
(
[0] => SELECT id, (SELECT COUNT(*) FROM tl_taxonomy i WHERE i.pid=o.id) AS childCount, name FROM tl_taxonomy o WHERE pid IN (53) ORDER BY sorting
[1] => 4 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => o
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 4
[Extra] => Using where; Using filesort
)
)
[29] => Array
(
[0] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (53,1532)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=53,`id`=1532
LIMIT
1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => range|filter
[possible_keys] => PRIMARY,type
[key] => PRIMARY|type
[key_len] => 4|98
[ref] =>
[rows] => 2 (2%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
)
[30] => Array
(
[0] => SELECT * FROM tl_page WHERE id=NULL
[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
)
)
[31] => Array
(
[0] => SELECT COUNT(id) AS count FROM cat_Musikanten WHERE pid='1' AND aktiv=1 AND offline='' AND geloescht='' AND `regioncode` IN (135,131,112,143,138,142,129,125,141)
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => cat_Musikanten
[type] => index_merge
[possible_keys] => aktiv,pid,offline,geloescht
[key] => offline,geloescht
[key_len] => 3,3
[ref] =>
[rows] => 261
[Extra] => Using intersect(offline,geloescht); Using where
)
)
[32] => Array
(
[0] => SELECT * FROM tl_catalog_fields f WHERE f.pid=(SELECT c.id FROM tl_catalog_types c WHERE c.tableName='cat_Musikanten')
[1] => 36 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => f
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 31
[Extra] => Using where
)
)
[33] => Array
(
[0] => SELECT id,pid,sorting,tstamp,aktiv,new_entry,offline,geloescht,frontend_edit,partnerstatus,webRadio,edatum,time_stamp_cron,userid,time_stamp_date,time_stamp,vermerke,Ansprechpartner,Adresse,Ort,Telefon,Mobil,eMail,Gruppenname,suchbegriff,regioncode,Homepage,kontakt_url,google_cal,foto,Portrait,Besetzung,Einsatzgebiete,repertoire,sonstiges,medien,url_hoerbsp1,url_hoerbsp2,url_hoerbsp3, (SELECT name FROM tl_catalog_types WHERE tl_catalog_types.id=cat_Musikanten.pid) AS catalog_name, (SELECT jumpTo FROM tl_catalog_types WHERE tl_catalog_types.id=cat_Musikanten.pid) AS parentJumpTo FROM cat_Musikanten WHERE pid='1' AND aktiv=1 AND offline='' AND geloescht='' AND `regioncode` IN (135,131,112,143,138,142,129,125,141) ORDER BY new_entry DESC, ROUND(partnerstatus/150) DESC, time_stamp DESC LIMIT 0,10
[1] => 10 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => cat_Musikanten
[type] => index_merge
[possible_keys] => aktiv,pid,offline,geloescht
[key] => offline,geloescht
[key_len] => 3,3
[ref] =>
[rows] => 261
[Extra] => Using intersect(offline,geloescht); Using where; Using filesort
)
)
[34] => Array
(
[0] => SELECT aliasField FROM tl_catalog_types where id='1' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_catalog_types
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[35] => Array
(
[0] => SELECT * FROM tl_page WHERE id='1019'
[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] =>
)
)
[36] => Array
(
[0] => SHOW COLUMNS FROM `cat_Musikanten`
[1] => 40 rows affected
)
[37] => Array
(
[0] => SHOW INDEXES FROM `cat_Musikanten`
[1] => 13 rows affected
)
[38] => Array
(
[0] => SELECT * FROM tl_page WHERE id='1019' 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] =>
)
)
[39] => Array
(
[0] => SELECT * FROM tl_page WHERE id='669' 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] =>
)
)
[40] => Array
(
[0] => SELECT * FROM tl_page WHERE id='612' 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] =>
)
)
[41] => Array
(
[0] => SELECT * FROM tl_page WHERE id='610' 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] =>
)
)
[42] => Array
(
[0] => SELECT
*
FROM
`tl_page`
WHERE
`id` IN (610,612,669,1019)
AND `type`='root'
AND `dns`!=''
ORDER BY
`id`=610,`id`=612,`id`=669,`id`=1019
LIMIT
1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref|filter
[possible_keys] => PRIMARY,type
[key] => type|PRIMARY
[key_len] => 98|4
[ref] => const
[rows] => 15 (0%)
[Extra] => Using index condition; Using where; Using filesort; Using rowid filter
)
)
[43] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (148) ORDER BY sorting
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[44] => Array
(
[0] => SELECT tableName, aliasField, jumpTo FROM tl_catalog_types WHERE tableName='tl_taxonomy' LIMIT 0,1
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_catalog_types
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 21
[Extra] => Using where
)
)
[45] => Array
(
[0] => SELECT * FROM tl_member WHERE id='2354'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_member
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[46] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (112) ORDER BY id
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[47] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (345,59,54,55) ORDER BY sorting
[1] => 4 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 4
[Extra] => Using index condition; Using filesort
)
)
[48] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (69,70) ORDER BY sorting
[1] => 2 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
)
[49] => Array
(
[0] => SELECT * FROM tl_member WHERE id='1269'
[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
)
)
[50] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (60,57,66,65,58,61,56) ORDER BY sorting
[1] => 7 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 7
[Extra] => Using index condition; Using filesort
)
)
[51] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (0) ORDER BY sorting
[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
)
)
[52] => Array
(
[0] => SELECT * FROM tl_member WHERE id='1248'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_member
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[53] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (145,58,54) ORDER BY sorting
[1] => 3 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
)
[54] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (67,68,69,70) ORDER BY sorting
[1] => 4 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 4
[Extra] => Using index condition; Using filesort
)
)
[55] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (332,57,145,63,58,61,56) ORDER BY sorting
[1] => 7 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 7
[Extra] => Using index condition; Using filesort
)
)
[56] => Array
(
[0] => SELECT * FROM tl_member WHERE id='4611'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_member
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[57] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (57,345,64,59,54) ORDER BY sorting
[1] => 5 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 5
[Extra] => Using index condition; Using filesort
)
)
[58] => Array
(
[0] => SELECT * FROM tl_member WHERE id='1312'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_member
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[59] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (131) ORDER BY id
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[60] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (333,60,57,345,64,63,65,59,54,61,55,56) ORDER BY sorting
[1] => 12 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 12
[Extra] => Using index condition; Using filesort
)
)
[61] => Array
(
[0] => SELECT * FROM tl_member WHERE id='2932'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_member
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[62] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (129) ORDER BY id
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[63] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (57,64,63,65,58,59,54,61,55,56) ORDER BY sorting
[1] => 10 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 10
[Extra] => Using index condition; Using filesort
)
)
[64] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (67,70) ORDER BY sorting
[1] => 2 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 2
[Extra] => Using index condition; Using filesort
)
)
[65] => Array
(
[0] => SELECT * FROM tl_member WHERE id='866'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_member
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[66] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (64,63,58,59,54,55,56) ORDER BY sorting
[1] => 7 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 7
[Extra] => Using index condition; Using filesort
)
)
[67] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (67) ORDER BY sorting
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[68] => Array
(
[0] => SELECT * FROM tl_member WHERE id='1417'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_member
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[69] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (64,58,56) ORDER BY sorting
[1] => 3 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
)
[70] => Array
(
[0] => SELECT * FROM tl_member WHERE id='1342'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_member
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[71] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (142) ORDER BY id
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[72] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (57,63,65,59,54,55,56) ORDER BY sorting
[1] => 7 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 7
[Extra] => Using index condition; Using filesort
)
)
[73] => Array
(
[0] => SELECT * FROM tl_taxonomy WHERE id IN (67,69,70) ORDER BY sorting
[1] => 3 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 3
[Extra] => Using index condition; Using filesort
)
)
[74] => Array
(
[0] => SELECT COUNT(*) AS anzahl FROM tl_comments WHERE source='cat_Musikanten' AND published=1 AND parent='941'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_comments
[type] => ref|filter
[possible_keys] => source,parent
[key] => parent|source
[key_len] => 4|98
[ref] => const
[rows] => 1 (6%)
[Extra] => Using where; Using rowid filter
)
)
[75] => Array
(
[0] => SELECT COUNT(*) AS anzahl FROM tl_comments WHERE source='cat_Musikanten' AND published=1 AND parent='281'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_comments
[type] => ref|filter
[possible_keys] => source,parent
[key] => parent|source
[key_len] => 4|98
[ref] => const
[rows] => 1 (6%)
[Extra] => Using where; Using rowid filter
)
)
[76] => Array
(
[0] => SELECT COUNT(*) AS anzahl FROM tl_comments WHERE source='cat_Musikanten' AND published=1 AND parent='818'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_comments
[type] => ref|filter
[possible_keys] => source,parent
[key] => parent|source
[key_len] => 4|98
[ref] => const
[rows] => 1 (6%)
[Extra] => Using where; Using rowid filter
)
)
[77] => Array
(
[0] => SELECT COUNT(*) AS anzahl FROM tl_comments WHERE source='cat_Musikanten' AND published=1 AND parent='578'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_comments
[type] => ref|filter
[possible_keys] => source,parent
[key] => parent|source
[key_len] => 4|98
[ref] => const
[rows] => 1 (6%)
[Extra] => Using where; Using rowid filter
)
)
[78] => Array
(
[0] => SELECT COUNT(*) AS anzahl FROM tl_comments WHERE source='cat_Musikanten' AND published=1 AND parent='953'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_comments
[type] => ref|filter
[possible_keys] => source,parent
[key] => parent|source
[key_len] => 4|98
[ref] => const
[rows] => 1 (6%)
[Extra] => Using where; Using rowid filter
)
)
[79] => Array
(
[0] => SELECT COUNT(*) AS anzahl FROM tl_comments WHERE source='cat_Musikanten' AND published=1 AND parent='486'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_comments
[type] => ref|filter
[possible_keys] => source,parent
[key] => parent|source
[key_len] => 4|98
[ref] => const
[rows] => 1 (6%)
[Extra] => Using where; Using rowid filter
)
)
[80] => Array
(
[0] => SELECT COUNT(*) AS anzahl FROM tl_comments WHERE source='cat_Musikanten' AND published=1 AND parent='66'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_comments
[type] => ref|filter
[possible_keys] => source,parent
[key] => parent|source
[key_len] => 4|98
[ref] => const
[rows] => 1 (6%)
[Extra] => Using where; Using rowid filter
)
)
[81] => Array
(
[0] => SELECT COUNT(*) AS anzahl FROM tl_comments WHERE source='cat_Musikanten' AND published=1 AND parent='353'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_comments
[type] => ref|filter
[possible_keys] => source,parent
[key] => parent|source
[key_len] => 4|98
[ref] => const
[rows] => 1 (6%)
[Extra] => Using where; Using rowid filter
)
)
[82] => Array
(
[0] => SELECT COUNT(*) AS anzahl FROM tl_comments WHERE source='cat_Musikanten' AND published=1 AND parent='830'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_comments
[type] => ref|filter
[possible_keys] => source,parent
[key] => parent|source
[key_len] => 4|98
[ref] => const
[rows] => 1 (6%)
[Extra] => Using where; Using rowid filter
)
)
[83] => Array
(
[0] => SELECT COUNT(*) AS anzahl FROM tl_comments WHERE source='cat_Musikanten' AND published=1 AND parent='220'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_comments
[type] => ref|filter
[possible_keys] => source,parent
[key] => parent|source
[key_len] => 4|98
[ref] => const
[rows] => 1 (6%)
[Extra] => Using where; Using rowid filter
)
)
[84] => Array
(
[0] => SELECT id, pid, type FROM tl_page WHERE id='1532'
[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] =>
)
)
[85] => Array
(
[0] => SELECT id, pid, type FROM tl_page WHERE id='53'
[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] =>
)
)
[86] => Array
(
[0] => SELECT * FROM tl_page WHERE id='53'
[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] =>
)
)
[87] => Array
(
[0] => SELECT * FROM tl_layout WHERE id='71' 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] =>
)
)
[88] => Array
(
[0] => SELECT * FROM tl_external_stylesheets WHERE id IN (8)
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_external_stylesheets
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[89] => Array
(
[0] => SELECT * FROM tl_page where id='53' 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] =>
)
)
[90] => Array
(
[0] => 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.pid=tl_style_sheet.id) AS hasFontFace FROM tl_style_sheet WHERE id IN (183, 273, 271, 274, 180, 182, 147, 190, 191, 156, 3) ORDER BY FIELD(id, 183, 273, 271, 274, 180, 182, 147, 190, 191, 156, 3)
[1] => 11 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_style_sheet
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 11
[Extra] => Using index condition; Using filesort
)
)
[91] => Array
(
[0] => SELECT g.id, g.glossarylinks_disallowintags AS disallow, g.glossarylinks_allowtagsindesc AS allow FROM tl_glossary AS g WHERE g.glossarylinks=1 AND FIND_IN_SET('1532', g.glossarylinks_pages) ORDER BY g.glossarylinks_template
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => g
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 8
[Extra] => Using where; Using filesort
)
)
[92] => Array
(
[0] => SELECT gt.*, g.glossarylinks_template FROM tl_glossary AS g RIGHT JOIN tl_glossary_term AS gt ON (gt.pid=g.id) WHERE g.glossarylinks=1 AND FIND_IN_SET('1532', g.glossarylinks_pages) ORDER BY g.glossarylinks_template, LENGTH(term) DESC
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => g
[type] => ALL
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 8
[Extra] => Using where; Using temporary; Using filesort
)
)
[93] => Array
(
[0] => SELECT tl_visitors.id AS id, visitors_block_time, visitors_cache_mode FROM tl_visitors LEFT JOIN tl_visitors_category ON (tl_visitors_category.id=tl_visitors.pid) WHERE pid=2 AND published=1 ORDER BY id, visitors_name LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_visitors
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)
)
)
