{{title}}

{{message}}

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

Total Time:
0.5527680
PHP General Time:
0.4589353
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.0938327
SQL Queries:
116
SQL Memory Usage:
726.57 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
4.26 Mb
Total Memory Usage (Including Debug):
4.53 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
185.55.227.64


Server Time Stamp:
January 22, 2018, 12:32 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.0001879 | 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 ('1689f659d46f20bb07f4ef316e1a691a', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516581153', '/advancedphoto/show_24/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0002482 | 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.0041919 | 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.0022871 | Memory Before: 1.38 Mb | Memory After: 1.4 Mb | Memory Used: 24.51 kb | Rows: 24 | 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 24
/* 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 122Using 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.0026379 | Memory Before: 1.7 Mb | Memory After: 1.72 Mb | Memory Used: 21.55 kb | Rows: 24 | Slave: Yes
SELECT v.*, 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 v
     JOIN phpfox_user AS u
            ON(u.user_id = v.user_id)

WHERE v.is_featured = 1 && v.module_id IS NULL && v.privacy = 0
ORDER BY time_stamp DESC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEvALLprivacy,user_idMISSING KEY   5552Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.v.user_id1 
0.0029509 | Memory Before: 2.47 Mb | Memory After: 2.49 Mb | Memory Used: 21.54 kb | Rows: 24 | Slave: Yes
SELECT v.*, 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 v
     JOIN phpfox_user AS u
            ON(u.user_id = v.user_id)

WHERE v.is_featured = 1 && v.module_id IS NULL && v.privacy = 0
ORDER BY time_stamp DESC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEvALLprivacy,user_idMISSING KEY   5552Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.v.user_id1 
0.0029919 | Memory Before: 2.71 Mb | Memory After: 2.72 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS p
WHERE p.privacy = 0 AND p.module_id IS NULL
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpindexprivacyview_id_584 5552Using where; Using index
0.0065699 | Memory Before: 2.72 Mb | Memory After: 2.74 Mb | Memory Used: 23.52 kb | Rows: 15 | 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, p.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p.album_id)

WHERE p.privacy = 0 AND p.module_id IS NULL
ORDER BY p.total_view DESC
LIMIT 15
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpALLprivacy,user_idMISSING KEY   5552Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p.user_id1 
1SIMPLEpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p.album_id1 
1SIMPLEpieq_refphoto_idphoto_id4majmaih1_majma.p.photo_id1 
0.0001400 | Memory Before: 2.86 Mb | Memory After: 2.86 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 172
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000951 | Memory Before: 2.88 Mb | Memory After: 2.88 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 471
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0002220 | Memory Before: 2.89 Mb | Memory After: 2.89 Mb | Memory Used: 3.2 kb | Rows: 1 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 28
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000961 | Memory Before: 2.89 Mb | Memory After: 2.9 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4951
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001140 | Memory Before: 2.9 Mb | Memory After: 2.9 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5165
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000918 | Memory Before: 2.91 Mb | Memory After: 2.91 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3999
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000880 | Memory Before: 2.92 Mb | Memory After: 2.92 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5246
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000930 | Memory Before: 2.92 Mb | Memory After: 2.93 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3653
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000880 | Memory Before: 2.93 Mb | Memory After: 2.93 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5431
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000870 | Memory Before: 2.94 Mb | Memory After: 2.94 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 142
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001030 | Memory Before: 2.95 Mb | Memory After: 2.95 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2685
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000861 | Memory Before: 2.95 Mb | Memory After: 2.96 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2874
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001030 | Memory Before: 2.96 Mb | Memory After: 2.96 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4919
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000851 | Memory Before: 2.97 Mb | Memory After: 2.97 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5306
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000830 | Memory Before: 2.98 Mb | Memory After: 2.98 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2425
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0028989 | Memory Before: 2.89 Mb | Memory After: 2.89 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS p
WHERE p.privacy = 0 AND p.module_id IS NULL
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpindexprivacyview_id_584 5552Using where; Using index
0.0059600 | Memory Before: 2.89 Mb | Memory After: 2.91 Mb | Memory Used: 21.47 kb | Rows: 15 | 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, p.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p.album_id)

WHERE p.privacy = 0 AND p.module_id IS NULL
ORDER BY p.total_comment DESC
LIMIT 15
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpALLprivacy,user_idMISSING KEY   5552Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p.user_id1 
1SIMPLEpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p.album_id1 
1SIMPLEpieq_refphoto_idphoto_id4majmaih1_majma.p.photo_id1 
0.0001459 | Memory Before: 3.04 Mb | Memory After: 3.04 Mb | Memory Used: 3.65 kb | Rows: 30 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5584
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const33 
0.0001070 | Memory Before: 3.08 Mb | Memory After: 3.08 Mb | Memory Used: 3.2 kb | Rows: 1 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1504
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000908 | Memory Before: 3.07 Mb | Memory After: 3.07 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4951
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000858 | Memory Before: 3.08 Mb | Memory After: 3.08 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3653
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000908 | Memory Before: 3.08 Mb | Memory After: 3.09 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1467
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000811 | Memory Before: 3.09 Mb | Memory After: 3.1 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4982
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000792 | Memory Before: 3.1 Mb | Memory After: 3.1 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3766
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000801 | Memory Before: 3.11 Mb | Memory After: 3.11 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5138
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000851 | Memory Before: 3.11 Mb | Memory After: 3.12 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5491
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000780 | Memory Before: 3.12 Mb | Memory After: 3.12 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5432
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000799 | Memory Before: 3.13 Mb | Memory After: 3.13 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5484
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000792 | Memory Before: 3.14 Mb | Memory After: 3.14 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 173
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000839 | Memory Before: 3.14 Mb | Memory After: 3.15 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 721
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000780 | Memory Before: 3.15 Mb | Memory After: 3.15 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 746
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000780 | Memory Before: 3.16 Mb | Memory After: 3.16 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1424
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0028191 | Memory Before: 3.07 Mb | Memory After: 3.08 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS p
WHERE p.privacy = 0 AND p.module_id IS NULL
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpindexprivacyview_id_584 5552Using where; Using index
0.0061960 | Memory Before: 3.07 Mb | Memory After: 3.1 Mb | Memory Used: 24.91 kb | Rows: 15 | 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, p.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p.album_id)

WHERE p.privacy = 0 AND p.module_id IS NULL
ORDER BY p.total_like DESC
LIMIT 15
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpALLprivacy,user_idMISSING KEY   5552Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p.user_id1 
1SIMPLEpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p.album_id1 
1SIMPLEpieq_refphoto_idphoto_id4majmaih1_majma.p.photo_id1 
0.0001190 | Memory Before: 3.23 Mb | Memory After: 3.23 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3895
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001030 | Memory Before: 3.25 Mb | Memory After: 3.25 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4016
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000989 | Memory Before: 3.26 Mb | Memory After: 3.26 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3173
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000961 | Memory Before: 3.27 Mb | Memory After: 3.27 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4685
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001030 | Memory Before: 3.27 Mb | Memory After: 3.28 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3953
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000992 | Memory Before: 3.28 Mb | Memory After: 3.28 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4036
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000992 | Memory Before: 3.29 Mb | Memory After: 3.29 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4773
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001030 | Memory Before: 3.3 Mb | Memory After: 3.3 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5439
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000970 | Memory Before: 3.3 Mb | Memory After: 3.31 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3766
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000970 | Memory Before: 3.31 Mb | Memory After: 3.31 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5031
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000961 | Memory Before: 3.32 Mb | Memory After: 3.32 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5138
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000980 | Memory Before: 3.33 Mb | Memory After: 3.33 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5735
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000961 | Memory Before: 3.33 Mb | Memory After: 3.34 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4184
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000961 | Memory Before: 3.34 Mb | Memory After: 3.34 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4432
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001020 | Memory Before: 3.35 Mb | Memory After: 3.35 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5017
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0015881 | Memory Before: 3.41 Mb | Memory After: 3.42 Mb | Memory Used: 3.14 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS p
WHERE p.privacy = 0 AND p.module_id IS NULL
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpindexprivacyview_id_584 5552Using where; Using index
0.0032871 | Memory Before: 3.41 Mb | Memory After: 3.44 Mb | Memory Used: 30.4 kb | Rows: 15 | 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, p.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p.album_id)

WHERE p.privacy = 0 AND p.module_id IS NULL
ORDER BY p.time_stamp DESC
LIMIT 15
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpALLprivacy,user_idMISSING KEY   5552Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p.user_id1 
1SIMPLEpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p.album_id1 
1SIMPLEpieq_refphoto_idphoto_id4majmaih1_majma.p.photo_id1 
0.0001090 | Memory Before: 3.57 Mb | Memory After: 3.58 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5885
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001030 | Memory Before: 3.6 Mb | Memory After: 3.6 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5884
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001001 | Memory Before: 3.61 Mb | Memory After: 3.61 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5883
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001070 | Memory Before: 3.61 Mb | Memory After: 3.62 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5882
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000980 | Memory Before: 3.62 Mb | Memory After: 3.63 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5881
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000992 | Memory Before: 3.63 Mb | Memory After: 3.63 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5880
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000968 | Memory Before: 3.64 Mb | Memory After: 3.64 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5879
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000980 | Memory Before: 3.64 Mb | Memory After: 3.65 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5878
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000980 | Memory Before: 3.65 Mb | Memory After: 3.66 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5876
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000961 | Memory Before: 3.66 Mb | Memory After: 3.66 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5875
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000961 | Memory Before: 3.67 Mb | Memory After: 3.67 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5874
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000970 | Memory Before: 3.67 Mb | Memory After: 3.68 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5873
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000942 | Memory Before: 3.68 Mb | Memory After: 3.68 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5872
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000958 | 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 = 5871
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001011 | Memory Before: 3.7 Mb | Memory After: 3.7 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5870
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0008039 | Memory Before: 3.61 Mb | Memory After: 3.63 Mb | Memory Used: 15.63 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 4628Using 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.0005319 | Memory Before: 3.62 Mb | Memory After: 3.64 Mb | Memory Used: 15.63 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 274Using index condition; Using where
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0005219 | 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 3545Using 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.0004292 | 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 1440Using 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.0004241 | 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 1848Using 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.0006411 | 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 116Using index condition; Using where
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004301 | Memory Before: 3.68 Mb | Memory After: 3.7 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 5306Using 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.0005949 | Memory Before: 3.7 Mb | Memory After: 3.71 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 3950Using 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.0004091 | Memory Before: 3.71 Mb | Memory After: 3.72 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 4592Using 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.0006840 | Memory Before: 3.72 Mb | Memory After: 3.74 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 5479Using 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.0004280 | Memory Before: 3.73 Mb | Memory After: 3.75 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 1947Using 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.0005400 | Memory Before: 3.75 Mb | Memory After: 3.76 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 275Using index condition; Using where
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004258 | Memory Before: 3.76 Mb | Memory After: 3.77 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 177Using index condition; Using where
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0005391 | Memory Before: 3.77 Mb | Memory After: 3.79 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_idphoto_id4 43Using index condition; Using where
1PRIMARYpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p1.album_id1 
1PRIMARYueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p1.user_id1 
1PRIMARYpieq_refphoto_idphoto_id4majmaih1_majma.p1.photo_id1 
2DERIVED   MISSING KEY    No tables used
3SUBQUERY   MISSING KEY    Select tables optimized away
0.0004251 | Memory Before: 3.78 Mb | Memory After: 3.8 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 5191Using 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.0001068 | 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 = 223
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000999 | 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 = 2966
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001009 | Memory Before: 3.81 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 = 2393
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000992 | 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 = 3064
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000980 | 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 = 2256
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000989 | 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 = 2088
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000970 | Memory Before: 3.84 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 = 3671
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000949 | Memory Before: 3.85 Mb | Memory After: 3.85 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 323
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000980 | Memory Before: 3.86 Mb | Memory After: 3.86 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2357
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000970 | Memory Before: 3.86 Mb | Memory After: 3.87 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4940
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000980 | Memory Before: 3.87 Mb | Memory After: 3.87 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5859
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000961 | Memory Before: 3.88 Mb | Memory After: 3.88 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2706
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001030 | Memory Before: 3.89 Mb | Memory After: 3.89 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1838
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001018 | Memory Before: 3.89 Mb | Memory After: 3.9 Mb | Memory Used: 3.2 kb | Rows: 1 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1018
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000958 | Memory Before: 3.9 Mb | Memory After: 3.9 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5497
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0090051 | Memory Before: 3.94 Mb | Memory After: 3.95 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS p
WHERE p.privacy = 0 AND p.module_id IS NULL AND (p.time_stamp >= '1516566600' AND p.time_stamp < '1516652940')
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefprivacyprivacy1const5531Using where
0.0070479 | Memory Before: 3.96 Mb | Memory After: 3.97 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS p
WHERE p.privacy = 0 AND p.module_id IS NULL AND p.time_stamp >= '1514748700'
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefprivacyprivacy1const5531Using where
0.0026851 | Memory Before: 3.97 Mb | Memory After: 3.98 Mb | Memory Used: 17.41 kb | Rows: 5 | 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, p.*, pa.name AS album_url, pi.*
FROM phpfox_photo AS p
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p.photo_id)
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p.album_id)

WHERE p.privacy = 0 AND p.module_id IS NULL AND p.time_stamp >= '1514748700'
ORDER BY p.total_vote DESC
LIMIT 15
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpALLprivacy,user_idMISSING KEY   5552Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.p.user_id1 
1SIMPLEpaeq_refPRIMARY,album_idPRIMARY4majmaih1_majma.p.album_id1 
1SIMPLEpieq_refphoto_idphoto_id4majmaih1_majma.p.photo_id1 
0.0001101 | Memory Before: 4.02 Mb | Memory After: 4.03 Mb | Memory Used: 3.19 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5881
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000989 | Memory Before: 4.03 Mb | Memory After: 4.03 Mb | Memory Used: 3.2 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5882
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000751 | Memory Before: 4.04 Mb | Memory After: 4.04 Mb | Memory Used: 3.2 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5883
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000689 | Memory Before: 4.05 Mb | Memory After: 4.05 Mb | Memory Used: 3.18 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5884
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0000792 | Memory Before: 4.05 Mb | Memory After: 4.06 Mb | Memory Used: 3.18 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5885
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0070910 | Memory Before: 4.03 Mb | Memory After: 4.04 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS p
WHERE p.privacy = 0 AND p.module_id IS NULL AND p.time_stamp >= '1516653000'
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefprivacyprivacy1const5531Using where
0.0050468 | Memory Before: 4.07 Mb | Memory After: 4.09 Mb | Memory Used: 14.85 kb | Rows: 15 | Slave: No
SELECT u.*, COUNT(*) as total_photos
FROM phpfox_photo AS p
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id && u.profile_page_id = 0)

GROUP BY p.user_id
ORDER BY total_photos DESC
LIMIT 15
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefPRIMARY,page_id,user_idpage_id4const256Using temporary; Using filesort
1SIMPLEprefview_id_3,user_iduser_id4majmaih1_majma.u.user_id25Using index
0.0023301 | Memory Before: 4.2 Mb | Memory After: 4.2 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: No
SELECT count(photo_id) as total_photo
FROM phpfox_photo
WHERE module_id IS NULL
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photoALL MISSING KEY   5552Using where
0.0001750 | Memory Before: 4.2 Mb | Memory After: 4.21 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] => 1689f659d46f20bb07f4ef316e1a691a
    [redirect] => /advancedphoto/show_24/
)