Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: admin.php very slow to load  (Read 3279 times)

0 Members and 1 Guest are viewing this topic.

NTP

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
admin.php very slow to load
« 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

Code: [Select]
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       


==========================
               
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: admin.php very slow to load
« Reply #1 on: March 31, 2015, 10:25:48 am »

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.
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.