• Pages:

  • 1
parse took 0.1328189373
mysql: 29 queries took 0.06229305267
Array ( [0] => Array ( [query] => select template from rot_pages where name = 'header'(db_link) [time] => 0.0001549720764 ) [1] => Array ( [query] => select template from rot_pages where name = 'bottom'(db_link) [time] => 4.196166992E-5 ) [2] => Array ( [query] => select * from rot_pages where name = 'content_list'(db_link) [time] => 4.696846008E-5 ) [3] => Array ( [query] => select id as category_id, name as category_name, description as category_description, rot_groups.* from rot_groups where id = '9' (db_link) [time] => 0.0004730224609 ) [4] => Array ( [query] => SHOW FULL PROCESSLIST(db_link) [time] => 0.0001540184021 ) [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 = '9' ORDER BY gs.total_ctr DESC LIMIT 0, 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 = '9' ORDER BY gs.total_ctr DESC LIMIT 0, 23 (db_link) [time] => 0.01722598076 ) [6] => Array ( [query] => SELECT FOUND_ROWS() as total(db_link) [time] => 0.000109910965 ) [7] => Array ( [query] => SELECT show_place, cell_ctr FROM rot_cell_data WHERE page_id = '5' (db_link) [time] => 7.510185242E-5 ) [8] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 IN ( 'e1256f18b0ceffc98b3183a83617bbe0', '6b50043a845acbbad238098071066b7a', 'e424e80168025df534e12ae1144a0216', '39de96ea5876bb57859a9f7ab1bc7142', '59637cf0c59279e9857eb96c8de1d5f5', 'e8aa4c655c3ee1498066648c59974f98', '0ea1ab289658cc94abc75e8a2da4a04f', 'b6f6f206cee2bd7e6fc3e4e998ebcb61', '', '', '', '', '', '', '', '') GROUP BY gallery_md5 #process_page(db_link) [time] => 0.0009789466858 ) [9] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.003483057022 ) [10] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'e1256f18b0ceffc98b3183a83617bbe0' (db_link) [time] => 0.0003409385681 ) [11] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002532958984 ) [12] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '6b50043a845acbbad238098071066b7a' (db_link) [time] => 0.0003719329834 ) [13] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.003422021866 ) [14] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'e424e80168025df534e12ae1144a0216' (db_link) [time] => 0.001068115234 ) [15] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.003428936005 ) [16] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '39de96ea5876bb57859a9f7ab1bc7142' (db_link) [time] => 0.0005249977112 ) [17] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002604007721 ) [18] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '59637cf0c59279e9857eb96c8de1d5f5' (db_link) [time] => 0.0007109642029 ) [19] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.009202003479 ) [20] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'e8aa4c655c3ee1498066648c59974f98' (db_link) [time] => 0.00258898735 ) [21] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002712965012 ) [22] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '0ea1ab289658cc94abc75e8a2da4a04f' (db_link) [time] => 0.001217126846 ) [23] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.003349781036 ) [24] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'b6f6f206cee2bd7e6fc3e4e998ebcb61' (db_link) [time] => 0.0008771419525 ) [25] => 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 = '9' and g.gallery_md5 NOT IN ('e1256f18b0ceffc98b3183a83617bbe0','6b50043a845acbbad238098071066b7a','e424e80168025df534e12ae1144a0216','39de96ea5876bb57859a9f7ab1bc7142','59637cf0c59279e9857eb96c8de1d5f5','e8aa4c655c3ee1498066648c59974f98','0ea1ab289658cc94abc75e8a2da4a04f','b6f6f206cee2bd7e6fc3e4e998ebcb61','') group by g.gallery_md5 LIMIT 0, 12 # 13(db_link) [time] => 0.004276990891 ) [26] => Array ( [query] => add base ) [27] => Array ( [query] => INSERT into rot_page_items SET page_id = '5', page_crc = '1540390882', items = 'a:9:{i:0;i:6012;i:1;i:6019;i:2;i:6023;i:3;i:6028;i:4;i:6033;i:5;i:6038;i:6;i:6043;i:7;i:6048;i:8;i:0;}', date = '2012-02-22' ON DUPLICATE KEY UPDATE items = 'a:9:{i:0;i:6012;i:1;i:6019;i:2;i:6023;i:3;i:6028;i:4;i:6033;i:5;i:6038;i:6;i:6043;i:7;i:6048;i:8;i:0;}', date = '2012-02-22' (db_link) [time] => 0.0001821517944 ) [28] => Array ( [query] => SHOW FULL PROCESSLIST(db_link) [time] => 9.393692017E-5 ) [29] => 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.315376282E-5 ) )