• Pages:

  • 1
  • 2
parse took 0.223968029
mysql: 38 queries took 0.08337020874
Array ( [0] => Array ( [query] => select template from rot_pages where name = 'header'(db_link) [time] => 0.0001978874207 ) [1] => Array ( [query] => select template from rot_pages where name = 'bottom'(db_link) [time] => 4.506111145E-5 ) [2] => Array ( [query] => select * from rot_pages where name = 'content_list'(db_link) [time] => 5.698204041E-5 ) [3] => Array ( [query] => select id as category_id, name as category_name, description as category_description, rot_groups.* from rot_groups where id = '113' (db_link) [time] => 0.001361131668 ) [4] => Array ( [query] => SHOW FULL PROCESSLIST(db_link) [time] => 0.0002331733704 ) [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 = '113' ORDER BY gs.total_ctr DESC LIMIT 16, 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 = '113' ORDER BY gs.total_ctr DESC LIMIT 16, 23 (db_link) [time] => 0.029515028 ) [6] => Array ( [query] => SELECT FOUND_ROWS() as total(db_link) [time] => 0.0001690387726 ) [7] => Array ( [query] => SELECT show_place, cell_ctr FROM rot_cell_data WHERE page_id = '5' (db_link) [time] => 0.0001101493835 ) [8] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 IN ( 'fc0994c1225cf2b0d45dc89f8089aa81', 'd4b09ba139148551a769bab608e01952', '756fdf971ad55b38d65855484db1ba92', 'b3aa25e089936fac3843a1dd381c9e2e', '2edce2a289a46a89d0aa972e19ccb1ff', '', '', '', '', '', '', '', '', '', '', '') GROUP BY gallery_md5 #process_page(db_link) [time] => 0.0007860660553 ) [9] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.004170894623 ) [10] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'fc0994c1225cf2b0d45dc89f8089aa81' (db_link) [time] => 0.0009498596191 ) [11] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.004051923752 ) [12] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'd4b09ba139148551a769bab608e01952' (db_link) [time] => 0.0009889602661 ) [13] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.004723072052 ) [14] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '756fdf971ad55b38d65855484db1ba92' (db_link) [time] => 0.001399040222 ) [15] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.003911972046 ) [16] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'b3aa25e089936fac3843a1dd381c9e2e' (db_link) [time] => 0.001391887665 ) [17] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002588033676 ) [18] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '2edce2a289a46a89d0aa972e19ccb1ff' (db_link) [time] => 0.0008139610291 ) [19] => 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 = '113' and g.gallery_md5 NOT IN ('fc0994c1225cf2b0d45dc89f8089aa81','d4b09ba139148551a769bab608e01952','756fdf971ad55b38d65855484db1ba92','b3aa25e089936fac3843a1dd381c9e2e','2edce2a289a46a89d0aa972e19ccb1ff','') group by g.gallery_md5 LIMIT 0, 12 # 14(db_link) [time] => 0.01339292526 ) [20] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '197c95ea72c977db27400cff28efde2f' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0004160404205 ) [21] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '29d3df0cdc430f82831c64a291b9cefc' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.00040102005 ) [22] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '378d1624c23b2e0c0ebbbe4f4465b8c5' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0002250671387 ) [23] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '436e1303f5a661de787dac1bcd192365' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.001394987106 ) [24] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '46973dc39e505490d3a0dae2b1dda1cb' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0006241798401 ) [25] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '559057b3cf88be1b3b6e508427387bd4' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0002520084381 ) [26] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '5a50cbd030c80790e3c02c17269cc05d' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0003049373627 ) [27] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '5e0677469c548a647dd2014c923eb880' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0002369880676 ) [28] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '7b2b9fe4be8eb5282cd8d9ab4e06226a' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0002748966217 ) [29] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '7d84903c27420cd7c9180f90fbd95e66' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0003070831299 ) [30] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '81dc314fa2f9a122ffabaf1e78f8d433' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0004208087921 ) [31] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '89dbb3c2d1f45d2fb146c7e858093130' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0004999637604 ) [32] => Array ( [query] => prep done (r_gr113) 12 ) [33] => Array ( [query] => got item 197c95ea72c977db27400cff28efde2f ) [34] => Array ( [query] => SELECT * FROM rot_galleries WHERE id = '6293' #process_tag(db_link) [time] => 0.0004119873047 ) [35] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.004214048386 ) [36] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '197c95ea72c977db27400cff28efde2f' (db_link) [time] => 0.0009229183197 ) [37] => Array ( [query] => INSERT into rot_page_items SET page_id = '5', page_crc = '1173195278', items = 'a:7:{i:0;i:6367;i:1;i:6387;i:2;i:6407;i:3;i:6412;i:4;i:6472;i:5;i:0;i:6;i:6293;}', date = '2012-05-20' ON DUPLICATE KEY UPDATE items = 'a:7:{i:0;i:6367;i:1;i:6387;i:2;i:6407;i:3;i:6412;i:4;i:6472;i:5;i:0;i:6;i:6293;}', date = '2012-05-20' (db_link) [time] => 0.001432180405 ) [38] => Array ( [query] => SHOW FULL PROCESSLIST(db_link) [time] => 0.000118970871 ) [39] => 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] => 5.507469177E-5 ) )