parse took 0.3475949764
mysql: 36 queries took 0.2422626019
Array ( [0] => Array ( [query] => select template from rot_pages where name = 'header'(db_link) [time] => 0.0002398490906 ) [1] => Array ( [query] => select template from rot_pages where name = 'bottom'(db_link) [time] => 4.601478577E-5 ) [2] => Array ( [query] => select * from rot_pages where name = 'content_list'(db_link) [time] => 5.006790161E-5 ) [3] => Array ( [query] => select id as category_id, name as category_name, description as category_description, rot_groups.* from rot_groups where id = '3' (db_link) [time] => 0.001508951187 ) [4] => Array ( [query] => SHOW FULL PROCESSLIST(db_link) [time] => 0.000118970871 ) [5] => Array ( [query] => SELECT SQL_CALC_FOUND_ROWS g.*, if (gs.total_shows < 500, 1, 0) as new_thumb from rot_galleries as g join rot_gallery_stats as gs on gs.thumb_id = g.id join rot_gal2group as g2gr on g.id = g2gr.gal_id WHERE g.status = 1 and g.rgroup != 0 and gs.best_thumb = 'yes' and g2gr.group_id = '3' ORDER BY gs.total_ctr DESC LIMIT 80, 23# queryitems_SELECT SQL_CALC_FOUND_ROWS g.*, if (gs.total_shows < 500, 1, 0) as new_thumb from rot_galleries as g join rot_gallery_stats as gs on gs.thumb_id = g.id join rot_gal2group as g2gr on g.id = g2gr.gal_id WHERE g.status = 1 and g.rgroup != 0 and gs.best_thumb = 'yes' and g2gr.group_id = '3' ORDER BY gs.total_ctr DESC LIMIT 80, 23 (db_link) [time] => 0.07508206367 ) [6] => Array ( [query] => SELECT FOUND_ROWS() as total(db_link) [time] => 0.0004251003265 ) [7] => Array ( [query] => SELECT show_place, cell_ctr FROM rot_cell_data WHERE page_id = '5' (db_link) [time] => 7.390975952E-5 ) [8] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 IN ( '90d926f9300e37eeb5181c16b140bc20', '968870df3a866fa81289c759f0b199ef', '240615f850459a376f1db9ff2ff097a6', 'ad4aa59fd99ea5d54b5772079472926b', '', '', '', '', '', '', '', '', '', '', '', '') GROUP BY gallery_md5 #process_page(db_link) [time] => 0.0005979537964 ) [9] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002728939056 ) [10] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '90d926f9300e37eeb5181c16b140bc20' (db_link) [time] => 0.09861302376 ) [11] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002593994141 ) [12] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '968870df3a866fa81289c759f0b199ef' (db_link) [time] => 0.0007429122925 ) [13] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002370119095 ) [14] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '240615f850459a376f1db9ff2ff097a6' (db_link) [time] => 0.0007331371307 ) [15] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002470016479 ) [16] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'ad4aa59fd99ea5d54b5772079472926b' (db_link) [time] => 0.001763105392 ) [17] => Array ( [query] => SELECT g.id, g.gallery_md5, g.rgroup FROM rot_galleries as g join rot_gallery_stats as gs on gs.thumb_id = g.id WHERE g.status = 1 and g.rgroup != 0 and gs.total_shows < '500' and g.rgroup = '3' and g.gallery_md5 NOT IN ('90d926f9300e37eeb5181c16b140bc20','968870df3a866fa81289c759f0b199ef','240615f850459a376f1db9ff2ff097a6','ad4aa59fd99ea5d54b5772079472926b','') group by g.gallery_md5 LIMIT 0, 12 # 15(db_link) [time] => 0.04227805138 ) [18] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '059fe57ed02527e50646dd3f356cc365' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0004210472107 ) [19] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '0bbb1010ab33711482bec12e49b2a8d5' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0003428459167 ) [20] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '0fa4d27dc668739d02795afd6b1d9a36' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0002310276031 ) [21] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '110d419e176768c3b0e69b2108ef0f8e' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0002689361572 ) [22] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '12c4068c5c74ee1cf1010cba96e75cb6' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001888275146 ) [23] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '135d906c1eab04a9d92755058a0b8a8d' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001609325409 ) [24] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '14bd62001fcb273cb18758bf5d24be6b' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0003728866577 ) [25] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '16b6c8d88d7a1534cc21b360ef30d93d' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.001548051834 ) [26] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '1919352dddea72de587a3e3a9f426475' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0002570152283 ) [27] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '19862acb58233e29ec85acf475a880d2' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001780986786 ) [28] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '21cdbc5187f10a7077e8ffabc0d2f4af' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001602172852 ) [29] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '24399d2ceaf6ea53c92f8218924be674' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0003159046173 ) [30] => Array ( [query] => prep done (r_gr3) 12 ) [31] => Array ( [query] => got item 059fe57ed02527e50646dd3f356cc365 ) [32] => Array ( [query] => SELECT * FROM rot_galleries WHERE id = '2900' #process_tag(db_link) [time] => 0.001463890076 ) [33] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002372980118 ) [34] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '059fe57ed02527e50646dd3f356cc365' (db_link) [time] => 0.000305891037 ) [35] => Array ( [query] => INSERT into rot_page_items SET page_id = '5', page_crc = '-1755927027', items = 'a:6:{i:0;i:5821;i:1;i:5851;i:2;i:5881;i:3;i:5886;i:4;i:0;i:5;i:2900;}', date = '2012-05-20' ON DUPLICATE KEY UPDATE items = 'a:6:{i:0;i:5821;i:1;i:5851;i:2;i:5881;i:3;i:5886;i:4;i:0;i:5;i:2900;}', date = '2012-05-20' (db_link) [time] => 0.001101970673 ) [36] => Array ( [query] => SHOW FULL PROCESSLIST(db_link) [time] => 9.083747864E-5 ) [37] => Array ( [query] => SELECT gt.tag_id, LOWER(t.tag_name) as tag_name, count(*) as hits FROM rot_gal2tag AS gt LEFT JOIN rot_tags AS t ON gt.tag_id = t.tag_id WHERE t.status = 'active' GROUP BY gt.tag_id order by t.tag_name (db_link) [time] => 4.506111145E-5 ) )