Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: admin.php very slow to load  (Read 3217 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.063 seconds with 21 queries.