High CPU Load

[Danaldinho]

Hey,

On my gallery, I have a really high CPU load with over 170 queries.

It is making my website really slow and making it keep crashing.

I have tried to reduce the queries by removing the views, statistics and random boxes such as the "most viewed", "latets uploads" and "random pics" etc, but still no luck.

Is there a way for me to reduce it?

Thanks alot

Here is my gallery: http://www.lilwaynehq.com/gallery and the queries are below:

Code Select Expand

Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0.004s)
    [1] => select * from cpg14x_plugins order by priority asc; (0.002s)
    [2] => delete from `dannym_gallery`.cpg14x_sessions where time<1239647919 and remember=0; (0.001s)
    [3] => delete from `dannym_gallery`.cpg14x_sessions where time<1238441919; (0.001s)
    [4] => select user_id from `dannym_gallery`.cpg14x_sessions where session_id = '4bbe1b1f56954f0b1abb7739c18b2ea7' (0.001s)
    [5] => select user_id as id, user_password as password from `dannym_gallery`.cpg14x_users where user_id=1 (0s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `dannym_gallery`.cpg14x_users AS u INNER JOIN `dannym_gallery`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `dannym_gallery`.cpg14x_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
    [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg14x_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
    [10] => update `dannym_gallery`.cpg14x_sessions set time='1239651519' where session_id = '4bbe1b1f56954f0b1abb7739c18b2ea7' (0s)
    [11] => SELECT description from cpg14x_albums WHERE aid='' (0s)
    [12] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0s)
    [13] => DELETE FROM cpg14x_banned WHERE expiry < '2009-04-13 19:38:39' (0s)
    [14] => SELECT * FROM cpg14x_banned WHERE (ip_addr='86.29.18.137' OR ip_addr='86.29.18.137' OR user_id=1) AND brute_force=0 (0s)
    [15] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = ''  ORDER BY name (0.001s)
    [16] => SELECT aid FROM cpg14x_albums WHERE category = 2 (0s)
    [17] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0.001s)
    [18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='46' (0.001s)
    [19] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '2' (0s)
    [20] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=2 ORDER BY a.pos LIMIT 0,11 (0.001s)
    [21] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (145, 1, 2, 3, 4, 5, 6, 9, 10, 8, 7)GROUP BY a.aid (0s)
    [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3606' (0s)
    [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='23' (0s)
    [24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3314' (0s)
    [25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='40' (0s)
    [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='34' (0s)
    [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='65' (0s)
    [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='56' (0s)
    [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='67' (0s)
    [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='70' (0s)
    [31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='78' (0s)
    [32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='87' (0s)
    [33] => SELECT aid FROM cpg14x_albums WHERE category = 3 (0s)
    [34] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0s)
    [35] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='148' (0s)
    [36] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '3' (0s)
    [37] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.pos LIMIT 0,3 (0.001s)
    [38] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (11, 12, 13)GROUP BY a.aid (0.001s)
    [39] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='138' (0s)
    [40] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3661' (0s)
    [41] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='148' (0s)
    [42] => SELECT aid FROM cpg14x_albums WHERE category = 4 (0s)
    [43] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 4 (0.001s)
    [44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2099' (0s)
    [45] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '4' (0s)
    [46] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=4 ORDER BY a.pos LIMIT 0,12 (0.002s)
    [47] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (119, 99, 116, 117, 118, 113, 111, 115, 100, 101, 137, 102)GROUP BY a.aid (0.003s)
    [48] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3785' (0s)
    [49] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2664' (0s)
    [50] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2672' (0s)
    [51] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2682' (0s)
    [52] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2723' (0.001s)
    [53] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2704' (0.001s)
    [54] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2725' (0.001s)
    [55] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3136' (0.001s)
    [56] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3137' (0.001s)
    [57] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2858' (0.001s)
    [58] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3851' (0.001s)
    [59] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3608' (0.001s)
    [60] => SELECT aid FROM cpg14x_albums WHERE category = 5 (0s)
    [61] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0s)
    [62] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='157' (0s)
    [63] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '5' (0s)
    [64] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=5 ORDER BY a.pos LIMIT 0,1 (0s)
    [65] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (16)GROUP BY a.aid (0.001s)
    [66] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3712' (0s)
    [67] => SELECT aid FROM cpg14x_albums WHERE category = 6 (0s)
    [68] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0s)
    [69] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2113' (0s)
    [70] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '6' (0s)
    [71] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=6 ORDER BY a.pos LIMIT 0,3 (0s)
    [72] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (17, 18, 19)GROUP BY a.aid (0.001s)
    [73] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2176' (0s)
    [74] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3856' (0s)
    [75] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3857' (0s)
    [76] => SELECT aid FROM cpg14x_albums WHERE category = 7 (0s)
    [77] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0s)
    [78] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='14' (0s)
    [79] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '7' (0s)
    [80] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=7 ORDER BY a.pos LIMIT 0,2 (0s)
    [81] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (20, 104)GROUP BY a.aid (0s)
    [82] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3855' (0s)
    [83] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3609' (0.001s)
    [84] => SELECT aid FROM cpg14x_albums WHERE category = 8 (0s)
    [85] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 8 (0s)
    [86] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1801' (0s)
    [87] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '8' (0s)
    [88] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=8 ORDER BY a.pos LIMIT 0,12 (0s)
    [89] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (61, 103, 144, 142, 62, 60, 64, 65, 88, 84, 85, 83)GROUP BY a.aid (0s)
    [90] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2253' (0s)
    [91] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2154' (0s)
    [92] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3633' (0s)
    [93] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3532' (0s)
    [94] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1262' (0s)
    [95] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1353' (0s)
    [96] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1309' (0s)
    [97] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1343' (0s)
    [98] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1771' (0.001s)
    [99] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2044' (0s)
    [100] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2064' (0s)
    [101] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1778' (0s)
    [102] => SELECT aid FROM cpg14x_albums WHERE category = 9 (0s)
    [103] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 9 (0s)
    [104] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='204' (0s)
    [105] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '9' (0s)
    [106] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=9 ORDER BY a.pos LIMIT 0,1 (0s)
    [107] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (21)GROUP BY a.aid (0s)
    [108] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3988' (0s)
    [109] => SELECT aid FROM cpg14x_albums WHERE category = 10 (0s)
    [110] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 10 (0s)
    [111] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='279' (0s)
    [112] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '10' (0s)
    [113] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=10 ORDER BY a.pos LIMIT 0,1 (0s)
    [114] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (22)GROUP BY a.aid (0s)
    [115] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3984' (0s)
    [116] => SELECT aid FROM cpg14x_albums WHERE category = 11 (0s)
    [117] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 11 (0s)
    [118] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2196' (0s)
    [119] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '11' (0s)
    [120] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=11 ORDER BY a.pos LIMIT 0,4 (0s)
    [121] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (42, 43, 44, 152)GROUP BY a.aid (0s)
    [122] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3991' (0s)
    [123] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3853' (0s)
    [124] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2167' (0s)
    [125] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3823' (0s)
    [126] => SELECT aid FROM cpg14x_albums WHERE category = 12 (0s)
    [127] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 12 (0s)
    [128] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1054' (0s)
    [129] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '12' (0s)
    [130] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=12 ORDER BY a.pos LIMIT 0,12 (0s)
    [131] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (147, 105, 45, 47, 57, 46, 48, 49, 143, 138, 50, 141)GROUP BY a.aid (0s)
    [132] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3657' (0s)
    [133] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3242' (0s)
    [134] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='960' (0s)
    [135] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='966' (0.001s)
    [136] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1141' (0.001s)
    [137] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2220' (0.001s)
    [138] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2178' (0s)
    [139] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='980' (0s)
    [140] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3562' (0s)
    [141] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3756' (0s)
    [142] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='998' (0s)
    [143] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3716' (0s)
    [144] => SELECT aid FROM cpg14x_albums WHERE category = 13 (0s)
    [145] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 13 (0s)
    [146] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2078' (0s)
    [147] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '13' (0s)
    [148] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=13 ORDER BY a.pos LIMIT 0,2 (0s)
    [149] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (23, 24)GROUP BY a.aid (0s)
    [150] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3811' (0s)
    [151] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='302' (0.002s)
    [152] => SELECT aid FROM cpg14x_albums as a WHERE category>=10000 (0s)
    [153] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
    [154] => SELECT aid FROM cpg14x_albums WHERE category = 14 (0s)
    [155] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 14 (0s)
    [156] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='907' (0s)
    [157] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '14' (0s)
    [158] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=14 ORDER BY a.pos LIMIT 0,12 (0s)
    [159] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (25, 27, 32, 127, 146, 38, 30, 35, 31, 39, 28, 36)GROUP BY a.aid (0s)
    [160] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2797' (0s)
    [161] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='723' (0s)
    [162] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='751' (0s)
    [163] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3030' (0s)
    [164] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3645' (0.001s)
    [165] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='772' (0s)
    [166] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='790' (0s)
    [167] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2480' (0s)
    [168] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='847' (0s)
    [169] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='851' (0.001s)
    [170] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='882' (0.001s)
    [171] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='904' (0s)
    [172] => SELECT aid FROM cpg14x_albums as a WHERE category = '0' (0.001s)
    [173] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0.008s)
    [174] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '0' (0s)
)

[Nibbler]

All of those database queries are fast. Are you sure it's MySQL that's causing high load?

[Danaldinho]

Ok, thanks

[Joachim Müller]

OK what? Could you answer Nibbler's question?

Additionally, you're running an outdated version. You have been told in the past already about the consequences of running outdated app, so I won't repeat this...