{{title}}

{{message}}

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

Total Time:
0.4780200
PHP General Time:
0.4626583
GZIP:
enabled

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

Total Memory Usage:
4.15 Mb
Total Memory Usage (Including Debug):
4.3 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.0004561 | Memory Before: 751.63 kb | Memory After: 752.98 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 ('dd5f28aa533269f53f213347e83fb848', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516581026', '/advancedphoto/show_48/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0003028 | Memory Before: 920.19 kb | Memory After: 925.48 kb | Memory Used: 5.3 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.0005431 | Memory Before: 1.37 Mb | Memory After: 1.38 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.0023069 | Memory Before: 1.38 Mb | Memory After: 1.41 Mb | Memory Used: 34.07 kb | Rows: 48 | 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 48
/* 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 244Using 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.0009198 | Memory Before: 3.5 Mb | Memory After: 3.52 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 3985Using 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.0007491 | Memory Before: 3.51 Mb | Memory After: 3.53 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 581Using 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.0004139 | Memory Before: 3.52 Mb | Memory After: 3.54 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 1451Using 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.0036850 | Memory Before: 3.54 Mb | Memory After: 3.55 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 645Using 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.0005610 | Memory Before: 3.55 Mb | Memory After: 3.56 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 4033Using 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.0004010 | Memory Before: 3.56 Mb | Memory After: 3.58 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 1962Using 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.0005231 | Memory Before: 3.57 Mb | Memory After: 3.59 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 4046Using 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.0003741 | Memory Before: 3.59 Mb | Memory After: 3.6 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 2770Using 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.0003650 | Memory Before: 3.6 Mb | Memory After: 3.61 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 2903Using 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.0005159 | Memory Before: 3.61 Mb | Memory After: 3.63 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 1285Using 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.0003810 | Memory Before: 3.62 Mb | Memory After: 3.64 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 2241Using 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.0004749 | Memory Before: 3.64 Mb | Memory After: 3.65 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 2998Using 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.0003529 | Memory Before: 3.65 Mb | Memory After: 3.66 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 3095Using 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.0004849 | Memory Before: 3.66 Mb | Memory After: 3.68 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 1430Using 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.0003481 | Memory Before: 3.67 Mb | Memory After: 3.69 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 2650Using 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.0001001 | Memory Before: 3.69 Mb | Memory After: 3.69 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4186
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000880 | Memory Before: 3.74 Mb | Memory After: 3.74 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2489
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000639 | Memory Before: 3.75 Mb | Memory After: 3.75 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5771
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000608 | Memory Before: 3.75 Mb | Memory After: 3.76 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3735
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000679 | Memory Before: 3.76 Mb | Memory After: 3.76 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1360
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000610 | Memory Before: 3.77 Mb | Memory After: 3.77 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1479
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000589 | Memory Before: 3.77 Mb | Memory After: 3.78 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3317
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000620 | Memory Before: 3.78 Mb | Memory After: 3.79 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 381
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000591 | Memory Before: 3.79 Mb | Memory After: 3.79 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3697
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000579 | Memory Before: 3.8 Mb | Memory After: 3.8 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5590
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000582 | Memory Before: 3.8 Mb | Memory After: 3.81 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5081
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000579 | Memory Before: 3.81 Mb | Memory After: 3.81 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2753
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000591 | Memory Before: 3.82 Mb | Memory After: 3.82 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4406
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000572 | Memory Before: 3.83 Mb | Memory After: 3.83 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2001
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000570 | Memory Before: 3.83 Mb | Memory After: 3.84 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2674
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0002341 | Memory Before: 4.1 Mb | Memory After: 4.11 Mb | Memory Used: 3.12 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] => dd5f28aa533269f53f213347e83fb848
    [redirect] => /advancedphoto/show_48/
)