{{title}}

{{message}}

عضویت
مجمعی ها
phpFox Developers Debug Toggle JavaScript Console
Version:
3.7.7
Product Code Name:
Nebula

Total Time:
0.3523839
PHP General Time:
0.3402707
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.0121132
SQL Queries:
35
SQL Memory Usage:
315.19 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
3.76 Mb
Total Memory Usage (Including Debug):
3.91 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
185.55.227.64


Server Time Stamp:
January 22, 2018, 12:30 am
PHP Version:
5.6.33
PHP Sapi:
cgi-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux

Cache:
file
SQL Queries
0.0022700 | Memory Before: 751.57 kb | Memory After: 752.92 kb | Memory Used: 1.35 kb | Rows: - | Slave: No
INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('8ca3239c02bd4f902e62465de6a228a4', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516581032', '/advancedphoto/when_all-time/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0002680 | Memory Before: 920.46 kb | Memory After: 925.77 kb | Memory Used: 5.31 kb | Rows: 1 | Slave: No
SELECT s.style_id, s.parent_id AS style_parent_id, s.folder AS style_folder_name, t.folder AS theme_folder_name, t.parent_id AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style AS s
     JOIN phpfox_theme AS t
            ON(t.theme_id = s.theme_id)

WHERE s.is_default = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefis_defaultis_default1const1 
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2majmaih1_majma.s.theme_id1 
0.0003700 | Memory Before: 1.42 Mb | Memory After: 1.42 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS photo
WHERE photo.view_id = 0 AND photo.group_id = 0 AND photo.type_id = 0 AND photo.privacy IN(0)
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotorefview_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5view_id_27const,const,const,const545Using index
0.0009539 | Memory Before: 1.43 Mb | Memory After: 1.45 Mb | Memory Used: 19.8 kb | Rows: 12 | Slave: Yes
SELECT pa.name AS album_name, pa.profile_id AS album_profile_id, ppc.name as category_name, ppc.category_id, l.like_id as is_liked, adisliked.action_id as is_disliked, photo.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)
     LEFT JOIN phpfox_photo_category_data AS ppcd
            ON(ppcd.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_category AS ppc
            ON(ppc.category_id = ppcd.category_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = "photo" AND l.item_id = photo.photo_id AND l.user_id = 0)
     LEFT JOIN phpfox_action AS adisliked
            ON(adisliked.action_type_id = 2 AND adisliked.item_id = photo.photo_id AND adisliked.user_id = 0)
     JOIN phpfox_user AS u
            ON(u.user_id = photo.user_id)

WHERE photo.view_id = 0 AND photo.group_id = 0 AND photo.type_id = 0 AND photo.privacy IN(0)
GROUP BY photo.photo_id
ORDER BY photo.photo_id DESC
LIMIT 12
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoindexPRIMARY,photo_id,view_id_2,photo_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5,user_idPRIMARY4 61Using where
1SIMPLEpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.photo.album_id1 
1SIMPLEppcdrefphoto_idphoto_id4majmaih1_majma.photo.photo_id1 
1SIMPLEppceq_refPRIMARYPRIMARY3majmaih1_majma.ppcd.category_id1Using where
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.photo.photo_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.photo.user_id1 
1SIMPLEadislikedrefitem_iditem_id4majmaih1_majma.photo.photo_id2Using where
0.0009859 | Memory Before: 3.2 Mb | Memory After: 3.22 Mb | Memory Used: 16.34 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 846Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0006242 | Memory Before: 3.22 Mb | Memory After: 3.23 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 1352Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004270 | Memory Before: 3.23 Mb | Memory After: 3.24 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 4547Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004201 | Memory Before: 3.24 Mb | Memory After: 3.26 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 1885Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004930 | Memory Before: 3.25 Mb | Memory After: 3.27 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 2009Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0003982 | Memory Before: 3.27 Mb | Memory After: 3.28 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 5092Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004098 | Memory Before: 3.28 Mb | Memory After: 3.29 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 1877Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0003860 | Memory Before: 3.29 Mb | Memory After: 3.31 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 694Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004270 | Memory Before: 3.3 Mb | Memory After: 3.32 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 2512Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004060 | Memory Before: 3.32 Mb | Memory After: 3.33 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 1205Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0002871 | Memory Before: 3.33 Mb | Memory After: 3.34 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 2758Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0003920 | Memory Before: 3.34 Mb | Memory After: 3.36 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 854Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004041 | Memory Before: 3.35 Mb | Memory After: 3.37 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 598Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0003750 | Memory Before: 3.36 Mb | Memory After: 3.38 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 370Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004330 | Memory Before: 3.38 Mb | Memory After: 3.39 Mb | Memory Used: 15.61 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, p1.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p1
     JOIN ( SELECT (RAND() *
( SELECT MAX(photo_id)
FROM phpfox_photo)) AS photo_id) AS p2
            ON(p1.photo_id >= p2.photo_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p1.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p1.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p1 .album_id)

WHERE p1.module_id IS NULL
ORDER BY p1.photo_id ASC
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>system MISSING KEY   1 
1PRIMARYp1rangePRIMARY,photo_id,photo_id_2,user_idPRIMARY4 5465Using index condition; Using where
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0000989 | Memory Before: 3.39 Mb | Memory After: 3.39 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1186
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000880 | Memory Before: 3.4 Mb | Memory After: 3.4 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1099
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000870 | Memory Before: 3.41 Mb | Memory After: 3.41 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1941
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000930 | Memory Before: 3.41 Mb | Memory After: 3.42 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 526
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000908 | Memory Before: 3.42 Mb | Memory After: 3.42 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2688
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000870 | Memory Before: 3.43 Mb | Memory After: 3.43 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 89
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000920 | Memory Before: 3.44 Mb | Memory After: 3.44 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4153
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000651 | Memory Before: 3.44 Mb | Memory After: 3.45 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2842
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000629 | Memory Before: 3.45 Mb | Memory After: 3.45 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1751
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000799 | Memory Before: 3.46 Mb | Memory After: 3.46 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 223
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000789 | Memory Before: 3.47 Mb | Memory After: 3.47 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1751
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000682 | Memory Before: 3.47 Mb | Memory After: 3.48 Mb | Memory Used: 3.2 kb | Rows: 1 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2197
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000632 | Memory Before: 3.48 Mb | Memory After: 3.48 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5728
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000610 | Memory Before: 3.49 Mb | Memory After: 3.49 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4397
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000620 | Memory Before: 3.5 Mb | Memory After: 3.5 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4799
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0002050 | Memory Before: 3.72 Mb | Memory After: 3.72 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: No
SELECT count(album_id) as total_album
FROM phpfox_photo_album
WHERE module_id IS NULL
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_albumALL MISSING KEY   263Using where
Array
(
    [session] => 8ca3239c02bd4f902e62465de6a228a4
    [redirect] => /advancedphoto/when_all-time/
)