parse took 0.3730251789
mysql: 46 queries took 0.1654851437
Array ( [0] => Array ( [query] => select template from rot_pages where name = 'header'(db_link) [time] => 0.0002388954163 ) [1] => Array ( [query] => select template from rot_pages where name = 'bottom'(db_link) [time] => 4.982948303E-5 ) [2] => Array ( [query] => select * from rot_pages where name = 'content_list'(db_link) [time] => 5.912780762E-5 ) [3] => Array ( [query] => select id as category_id, name as category_name, description as category_description, rot_groups.* from rot_groups where id = '26' (db_link) [time] => 0.001121997833 ) [4] => Array ( [query] => SHOW FULL PROCESSLIST(db_link) [time] => 0.0001730918884 ) [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 = '26' ORDER BY gs.total_ctr DESC LIMIT 224, 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 = '26' ORDER BY gs.total_ctr DESC LIMIT 224, 23 (db_link) [time] => 0.09901404381 ) [6] => Array ( [query] => SELECT FOUND_ROWS() as total(db_link) [time] => 0.002901077271 ) [7] => Array ( [query] => SELECT show_place, cell_ctr FROM rot_cell_data WHERE page_id = '5' (db_link) [time] => 0.000109910965 ) [8] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 IN ( 'cdf373e491cc161053bb3df073d7cb96', '9c48564a18dfefeece48682857db82a8', 'd386a9d6e1fb056fac6f1a602f1387b9', '178ad29cecf9edc930c5a36bd5ce3c31', 'b3fd876c0c0b55d45799341b4b0fab1e', '9f1452ebb90f2cda99894a9f585ce0a5', '80902091d026f2e95f24152408fcbc22', '13d2cb9fe6c8a2a3d720b9f890fe89e1', 'ae5a66cdebef90b541679d3eb04a02d3', '', '', '', '', '', '', '') GROUP BY gallery_md5 #process_page(db_link) [time] => 0.002722978592 ) [9] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002873182297 ) [10] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'cdf373e491cc161053bb3df073d7cb96' (db_link) [time] => 0.00527715683 ) [11] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.004385948181 ) [12] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '9c48564a18dfefeece48682857db82a8' (db_link) [time] => 0.001415967941 ) [13] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.00251698494 ) [14] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'd386a9d6e1fb056fac6f1a602f1387b9' (db_link) [time] => 0.000804901123 ) [15] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002254962921 ) [16] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '178ad29cecf9edc930c5a36bd5ce3c31' (db_link) [time] => 0.0007531642914 ) [17] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002295017242 ) [18] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'b3fd876c0c0b55d45799341b4b0fab1e' (db_link) [time] => 0.0007441043854 ) [19] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002661943436 ) [20] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '9f1452ebb90f2cda99894a9f585ce0a5' (db_link) [time] => 0.003853797913 ) [21] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.003098964691 ) [22] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '80902091d026f2e95f24152408fcbc22' (db_link) [time] => 0.001576900482 ) [23] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002646207809 ) [24] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '13d2cb9fe6c8a2a3d720b9f890fe89e1' (db_link) [time] => 0.0008108615875 ) [25] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002815961838 ) [26] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'ae5a66cdebef90b541679d3eb04a02d3' (db_link) [time] => 0.0009620189667 ) [27] => 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 = '26' and g.gallery_md5 NOT IN ('cdf373e491cc161053bb3df073d7cb96','9c48564a18dfefeece48682857db82a8','d386a9d6e1fb056fac6f1a602f1387b9','178ad29cecf9edc930c5a36bd5ce3c31','b3fd876c0c0b55d45799341b4b0fab1e','9f1452ebb90f2cda99894a9f585ce0a5','80902091d026f2e95f24152408fcbc22','13d2cb9fe6c8a2a3d720b9f890fe89e1','ae5a66cdebef90b541679d3eb04a02d3','') group by g.gallery_md5 LIMIT 0, 12 # 15(db_link) [time] => 0.01134514809 ) [28] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '00803cde060c93fd238917b76748f6d6' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 5.793571472E-5 ) [29] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '01c0c9138301528e6f2c8af040d57a72' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 3.504753113E-5 ) [30] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '0208c429b955dff3d718a6c4ec204fae' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 3.19480896E-5 ) [31] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '031ac40af83d25dcd7b754d02ec2b240' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 3.19480896E-5 ) [32] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '0348c7f573c5c0c139ee3209e224f187' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 3.218650818E-5 ) [33] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '03cdd74c7e91adff734968ca7d0945ad' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 3.695487976E-5 ) [34] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '043ad005f8257e2028e29e787c428e8f' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0003740787506 ) [35] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '04d4a305a73629f3918a5deed66f0538' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001490116119 ) [36] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '05c0f1dd744fd24cc213e2e69008457f' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001449584961 ) [37] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '061cc6062cd9b54d25f965c478cbc399' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001749992371 ) [38] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '071514fc0a99af5c822edfee909eb25d' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001230239868 ) [39] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '075a53ece67cd9ee47693e3dd2743ec1' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0009479522705 ) [40] => Array ( [query] => prep done (r_gr26) 12 ) [41] => Array ( [query] => got item 00803cde060c93fd238917b76748f6d6 ) [42] => Array ( [query] => SELECT * FROM rot_galleries WHERE id = '4237' #process_tag(db_link) [time] => 7.390975952E-5 ) [43] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002362012863 ) [44] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '00803cde060c93fd238917b76748f6d6' (db_link) [time] => 6.294250488E-5 ) [45] => Array ( [query] => INSERT into rot_page_items SET page_id = '5', page_crc = '-406733711', items = 'a:11:{i:0;i:5796;i:1;i:5806;i:2;i:5811;i:3;i:5831;i:4;i:5846;i:5;i:5866;i:6;i:5871;i:7;i:5896;i:8;i:5901;i:9;i:0;i:10;i:4237;}', date = '2012-05-20' ON DUPLICATE KEY UPDATE items = 'a:11:{i:0;i:5796;i:1;i:5806;i:2;i:5811;i:3;i:5831;i:4;i:5846;i:5;i:5866;i:6;i:5871;i:7;i:5896;i:8;i:5901;i:9;i:0;i:10;i:4237;}', date = '2012-05-20' (db_link) [time] => 0.001230955124 ) [46] => Array ( [query] => SHOW FULL PROCESSLIST(db_link) [time] => 9.01222229E-5 ) [47] => 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.100799561E-5 ) )