forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: NTP on March 06, 2015, 12:46:28 pm
-
Idk, for some reason my admin.php settings page is quite slow loading. Any ideas?
http://degrassi.pl/gallery/index.php
USER:
------------------
Array
(
[ID] => 7e70ed263bb76ac07963df0589255cf5
[am] => 1
[lang] => polish
[liv_a] => Array
(
[0] => 829
[1] => 971
[2] => 210
[3] => 973
[4] => 969
)
[liv] => Array
(
[0] => 2841
[1] => 32218
[2] => 32183
[3] => 32140
[4] => 17777
)
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => PA_BLO
[groups] => Array
(
[0] => 1
)
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[has_admin_access] => 1
[access_level] => 3
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[group_name] => Administrators
[can_create_public_albums] => 0
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
[allowed_albums] => Array
(
)
)
==========================
Queries:
------------------
Array
(
[0] => SET NAMES 'utf8' [include/functions.inc.php:194] (0.11 ms)
[1] => SELECT name, value FROM cpg14x_config [include/init.inc.php:179] (0.33 ms)
[2] => SELECT * FROM cpg14x_plugins ORDER BY priority [include/plugin_api.inc.php:52] (0.09 ms)
[3] => SELECT user_id, time FROM `degrassi_gallery`.cpg14x_sessions WHERE session_id = '341eba09c42ec821579bbdb6e46bbfde' [bridge/coppermine.inc.php:267] (0.1 ms)
[4] => SELECT user_id, user_password FROM `degrassi_gallery`.cpg14x_users WHERE user_id = 1 [bridge/coppermine.inc.php:279] (0.07 ms)
[5] => SELECT u.user_id AS id, u.user_name AS username, user_password AS password, u.user_group AS group_id FROM `degrassi_gallery`.cpg14x_users AS u LEFT JOIN `degrassi_gallery`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' [bridge/udb_base.inc.php:70] (0.1 ms)
[6] => SELECT user_group_list FROM `degrassi_gallery`.cpg14x_users AS u WHERE user_id='1' AND user_group_list <> '' [bridge/coppermine.inc.php:205] (0.08 ms)
[7] => 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(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, MAX(access_level) AS access_level, 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) [bridge/udb_base.inc.php:323] (0.1 ms)
[8] => SELECT group_name FROM cpg14x_usergroups WHERE group_id= 1 [bridge/udb_base.inc.php:327] (0.07 ms)
[9] => SELECT COUNT(*) FROM cpg14x_categorymap WHERE group_id in (1) [bridge/udb_base.inc.php:340] (0.05 ms)
[10] => UPDATE `degrassi_gallery`.cpg14x_sessions SET time = 1425641993 WHERE session_id = '341eba09c42ec821579bbdb6e46bbfde' [bridge/coppermine.inc.php:324] (0.09 ms)
[11] => UPDATE `degrassi_gallery`.cpg14x_users SET user_lastvisit = NOW() WHERE user_id = '1' [bridge/coppermine.inc.php:328] (0.07 ms)
[12] => SELECT lang_id FROM cpg14x_languages WHERE enabled='YES' [include/init.inc.php:330] (0.14 ms)
[13] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 [include/init.inc.php:388] (0.07 ms)
[14] => DELETE FROM cpg14x_banned WHERE expiry < '2015-03-06 12:39:53' [include/init.inc.php:444] (0.06 ms)
[15] => SELECT null FROM cpg14x_banned WHERE (user_id=1 OR '188.112.38.90' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:460] (0.07 ms)
[16] => DELETE FROM cpg14x_temp_messages WHERE time < 1425638393 [include/functions.inc.php:4924] (0.08 ms)
[17] => SELECT cid, lft, rgt, name, description, thumb, depth AS level, '0' AS alb_count
FROM cpg14x_categories
WHERE depth BETWEEN 0 + 1 AND 0 + 1
ORDER BY lft [index.php:303] (0.19 ms)
[18] => SELECT COUNT(DISTINCT(p.aid)) AS alb_count, COUNT(*) AS pic_count
FROM cpg14x_albums AS r
INNER JOIN cpg14x_pictures AS p ON p.aid = r.aid
WHERE r.category > 10000
AND approved = 'YES'
[index.php:317] (0.16 ms)
[19] => SELECT aid, title, r.description, keyword, alb_hits, category, visibility, r.thumb, r.owner, depth AS level, lft, '0' AS pic_count
FROM cpg14x_categories AS c
INNER JOIN cpg14x_albums AS r ON r.category = c.cid
WHERE c.depth >= 0 + 1
ORDER BY r.pos, r.aid [index.php:338] (6.34 ms)
[20] => SELECT c.cid, r.aid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload, depth AS level, lft
FROM cpg14x_categories AS c
INNER JOIN cpg14x_albums AS r ON r.category = c.cid
INNER JOIN cpg14x_pictures AS p ON p.aid = r.aid
WHERE c.depth >= 0 + 1
AND approved = 'YES'
GROUP BY r.aid
ORDER BY NULL [index.php:365] (56.57 ms)
[21] => SELECT COUNT(*) FROM cpg14x_albums AS a WHERE 1 [index.php:487] (0.18 ms)
[22] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'YES' [index.php:500] (7.52 ms)
[23] => SELECT COUNT(*) FROM cpg14x_comments [index.php:519] (0.09 ms)
[24] => SELECT COUNT(*) FROM cpg14x_categories [index.php:525] (0.09 ms)
[25] => SELECT SUM(hits) FROM cpg14x_pictures WHERE approved = 'YES' [index.php:538] (13.4 ms)
[26] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' [include/functions.inc.php:2421] (5.92 ms)
[27] => SELECT lang_id, abbr FROM cpg14x_languages WHERE available='YES' AND enabled='YES' [themes/cpg-2014-12/theme.php:2289] (0.14 ms)
[28] => SELECT COUNT(*)
FROM cpg14x_pictures AS r
INNER JOIN cpg14x_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
GROUP BY r.aid [include/functions.inc.php:1844] (14.71 ms)
[29] => SELECT r.aid, a.thumb, a.keyword, a.alb_hits, a.title, MAX(ctime) AS ctime
FROM cpg14x_pictures AS r
INNER JOIN cpg14x_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
GROUP BY r.aid
ORDER BY ctime DESC
LIMIT 0 ,5 [include/functions.inc.php:1856] (33.64 ms)
[30] => SELECT pid FROM cpg14x_pictures WHERE ((aid = '974' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:1902] (0.33 ms)
[31] => SELECT pid FROM cpg14x_pictures WHERE ((aid = '971' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:1902] (0.29 ms)
[32] => SELECT pid FROM cpg14x_pictures WHERE ((aid = '973' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:1902] (0.17 ms)
[33] => SELECT pid FROM cpg14x_pictures WHERE ((aid = '972' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:1902] (0.17 ms)
[34] => SELECT pid FROM cpg14x_pictures WHERE ((aid = '970' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:1902] (0.17 ms)
[35] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip
FROM cpg14x_pictures AS r
WHERE approved = 'YES'
AND r.pid IN (32275,32257,32198,32180,32160) [include/functions.inc.php:1918] (0.18 ms)
[36] => SELECT extension, mime, content, player FROM cpg14x_filetypes [include/functions.inc.php:5779] (0.22 ms)
[37] => SELECT count(aid) FROM cpg14x_albums as a WHERE category = '0' [index.php:673] (0.12 ms)
[38] => SELECT COUNT(*)
FROM cpg14x_pictures AS r
INNER JOIN cpg14x_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES' [include/functions.inc.php:1487] (10.84 ms)
[39] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip
FROM cpg14x_pictures AS r
INNER JOIN cpg14x_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
ORDER BY ctime DESC, pid DESC
LIMIT 0 ,10 [include/functions.inc.php:1504] (17.2 ms)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
COOKIE :
------------------
Array
(
[__utma] => 76047360.2144765039.1423581768.1425634033.1425636656.178
[__utmz] => 76047360.1424984031.124.2.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not provided)
[__gfp_64b] => dCO8Qx8__9Xri3PbGgC2X2DXZrngZ_kMQbcL1SMsOQP.n7
[_ga] => GA1.2.2144765039.1423581768
[DegrassiPL_1_r] => t
[catAccCookies] => true
[wp-settings-1] => m4=o&m3=c&m8=c&m5=o&editor=html&m2=c&m7=c&m6=c&m1=o&m0=o&m9=c&m10=c&m11=c&urlbutton=custom&imgsize=full&libraryContent=browse&align=none&mfold=o
[wp-settings-time-1] => 1425492963
[coppermine_data] => YTo1OntzOjI6IklEIjtzOjMyOiI3ZTcwZWQyNjNiYjc2YWMwNzk2M2RmMDU4OTI1NWNmNSI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo2OiJwb2xpc2giO3M6NToibGl2X2EiO2E6NTp7aTowO2k6ODI5O2k6MTtpOjk3MTtpOjI7aToyMTA7aTozO2k6OTczO2k6NDtpOjk2OTt9czozOiJsaXYiO2E6NTp7aTowO3M6NDoiMjg0MSI7aToxO3M6NToiMzIyMTgiO2k6MjtzOjU6IjMyMTgzIjtpOjM7czo1OiIzMjE0MCI7aTo0O3M6NToiMTc3NzciO319
[2215c0d3606a4b7ff4976fa0780daaa8] => 4a7241aa9a00c3e8ed590c2dafb00b49
[2f5bf1d52aac20a06ac0d44cd958a916] => a8ca5fcfff120f823517312361c83f1a
[DegrassiPL_1] => t
[__utmb] => 76047360.6.10.1425636656
[PHPSESSID] => f60e9ea908c92907eeec1d1d8c09adf6
[__utmc] => 76047360
[mycrawler] => 2408px:-1450px:left
[__utmt] => 1
)
==========================
SESSION :
------------------
Array
(
[wp-power-stats] => 1
)
==========================
VERSION INFO :
------------------
PHP version 5.2.17 OK
MySQL version 5.1.70 OK
Coppermine version 1.5.30 stable
==========================
Module: GD
------------------
Exact version 2.0.34
GD Version bundled (2.0.34 compatible)
FreeType Support 1
FreeType Linkage with freetype
T1Lib Support
GIF Read Support 1
GIF Create Support 1
JPG Support 1
PNG Support 1
WBMP Support 1
XPM Support
XBM Support 1
JIS-mapped Japanese Font Support
==========================
Key config settings
------------------
site_url http://degrassi.pl/gallery/
charset utf-8
allow_private_albums 1
cookie_name coppermine
cookie_path /
impath
lang polish
main_page_layout lastalb,1/breadcrumb/catlist/alblist/lastup,2
silly_safe_mode 0
smtp_host
theme cpg-2014-12
thumb_method gd2
==========================
Plugins
------------------
Name HTML5 Slideshow
Actions plugin_install, plugin_uninstall, plugin_cleanup
Filters gallery_header, theme_thumbnails_title, file_data
--------------
==========================
Server restrictions
------------------
safe_mode
safe_mode_exec_dir
safe_mode_gid
safe_mode_include_dir
sql.safe_mode
disable_functions system,passthru,shell_exec,escapeshellarg,escapeshellcmd,proc_close,proc_open,dl,popen,show_source,allow_url_fopen
file_uploads 1
include_path .:/usr/local/lib/php
open_basedir
allow_url_fopen 1
max_execution_time 1500
max_input_time 180
upload_max_filesize 100M
post_max_size 100M
memory_limit 192M
suhosin.post.max_vars
suhosin.request.max_vars
==========================
Page (performance)
------------------
Parameter Current Peak
Memory usage 5.62 MiB 7.66 MiB
Page generation 217.89 ms 217.89 ms
Page query time 170.34 ms 170.34 ms
Page query count 40 40
==========================
-
What do you mean with "slow"? Does the page itself loads "normal" and when Coppermine starts to hide the menu groups it takes some time? If so, you probably have a quite weak CPU, as the hide effect is done via JavaScript, which is a resource hog.