• Pages:

  • 1
  • 2
  • 3
parse took 0.402354002
mysql: 36 queries took 0.06288695335
Array ( [0] => Array ( [query] => select template from rot_pages where name = 'header'(db_link) [time] => 0.0002229213715 ) [1] => Array ( [query] => select template from rot_pages where name = 'bottom'(db_link) [time] => 4.911422729E-5 ) [2] => Array ( [query] => select * from rot_pages where name = 'content_list'(db_link) [time] => 5.602836609E-5 ) [3] => Array ( [query] => select id as category_id, name as category_name, description as category_description, rot_groups.* from rot_groups where id = '114' (db_link) [time] => 0.001322031021 ) [4] => Array ( [query] => SHOW FULL PROCESSLIST(db_link) [time] => 0.0001828670502 ) [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 = '114' ORDER BY gs.total_ctr DESC LIMIT 32, 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 = '114' ORDER BY gs.total_ctr DESC LIMIT 32, 23 (db_link) [time] => 0.02818989754 ) [6] => Array ( [query] => SELECT FOUND_ROWS() as total(db_link) [time] => 0.000128030777 ) [7] => Array ( [query] => SELECT show_place, cell_ctr FROM rot_cell_data WHERE page_id = '5' (db_link) [time] => 7.605552673E-5 ) [8] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 IN ( '9fe078328bf5ee55dabeaeb1b7e5a650', 'df2c87339dbc04629c885820c10d72c6', '6822b105228dc430265b68690d46d1f1', 'fab2c0f1908f8b7368fb4dd1af6542d5', '', '', '', '', '', '', '', '', '', '', '', '') GROUP BY gallery_md5 #process_page(db_link) [time] => 0.001800060272 ) [9] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002397060394 ) [10] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '9fe078328bf5ee55dabeaeb1b7e5a650' (db_link) [time] => 0.001080989838 ) [11] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002241134644 ) [12] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'df2c87339dbc04629c885820c10d72c6' (db_link) [time] => 0.0009379386902 ) [13] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002367019653 ) [14] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '6822b105228dc430265b68690d46d1f1' (db_link) [time] => 0.0007450580597 ) [15] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002247095108 ) [16] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = 'fab2c0f1908f8b7368fb4dd1af6542d5' (db_link) [time] => 0.0006020069122 ) [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 = '114' and g.gallery_md5 NOT IN ('9fe078328bf5ee55dabeaeb1b7e5a650','df2c87339dbc04629c885820c10d72c6','6822b105228dc430265b68690d46d1f1','fab2c0f1908f8b7368fb4dd1af6542d5','') group by g.gallery_md5 LIMIT 0, 12 # 14(db_link) [time] => 0.008437871933 ) [18] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '0690d1491a97edc681cece6f122a28d3' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.00040102005 ) [19] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '09e6cd66e77c02087f4408b48d5c8c43' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.000128030777 ) [20] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '117eeba6366d64bb4fdce0259d3f8268' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.001304864883 ) [21] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '155672f99da820bb590d29333598042e' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0002899169922 ) [22] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '22d511aa1cef219f690a25ca16840144' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0003569126129 ) [23] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '2a35387bd214869ea54a8115b8f0fc2b' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001368522644 ) [24] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '30c1b5b764d60a1ec9ec56a510b84454' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001108646393 ) [25] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '37f770d50ee1f75b104a1f5e26137fbf' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001339912415 ) [26] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '44dc640a4303bc0040d3e582cc83ba4e' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.000107049942 ) [27] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '46b696ebd653f697bb61cda87e078645' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0001318454742 ) [28] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '4711388f53007d472022f7e96bfc262c' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0009260177612 ) [29] => Array ( [query] => SELECT gallery_md5, (sum(rating)/count(*)) as rating FROM rot_comments WHERE gallery_md5 = '48019e7937936156a0311282cf9acd50' GROUP BY gallery_md5 #rot_funct(db_link) [time] => 0.0002698898315 ) [30] => Array ( [query] => prep done (r_gr114) 12 ) [31] => Array ( [query] => got item 0690d1491a97edc681cece6f122a28d3 ) [32] => Array ( [query] => SELECT * FROM rot_galleries WHERE id = '8645' #process_tag(db_link) [time] => 0.0002892017365 ) [33] => Array ( [query] => show fields from rot_galleries(db_link) [time] => 0.002245903015 ) [34] => Array ( [query] => SELECT thumb_url FROM rot_galleries WHERE gallery_md5 = '0690d1491a97edc681cece6f122a28d3' (db_link) [time] => 0.001418113708 ) [35] => Array ( [query] => INSERT into rot_page_items SET page_id = '5', page_crc = '564216834', items = 'a:6:{i:0;i:8764;i:1;i:8889;i:2;i:8899;i:3;i:9069;i:4;i:0;i:5;i:8645;}', date = '2012-05-20' ON DUPLICATE KEY UPDATE items = 'a:6:{i:0;i:8764;i:1;i:8889;i:2;i:8899;i:3;i:9069;i:4;i:0;i:5;i:8645;}', date = '2012-05-20' (db_link) [time] => 0.001368999481 ) [36] => Array ( [query] => SHOW FULL PROCESSLIST(db_link) [time] => 0.0001192092896 ) [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] => 6.508827209E-5 ) )