{{title}}

{{message}}

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

Total Time:
2.0851569
PHP General Time:
1.8312304
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.2539265
SQL Queries:
169
SQL Memory Usage:
978.79 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
5.63 Mb
Total Memory Usage (Including Debug):
5.97 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.0028191 | 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 ('8302d5a691260e999c2585f7ff173d95', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516581010', '/advancedphoto/show_96/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0004630 | 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.0001922 | Memory Before: 1.41 Mb | Memory After: 1.41 Mb | Memory Used: 4.81 kb | Rows: 0 | Slave: Yes
SELECT i.*, io.phrase_var as option_phrase_var
FROM phpfox_input_field AS i
     LEFT JOIN phpfox_input_option AS io
            ON(io.field_id = i.field_id)

WHERE module_id = "advancedphoto"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0030181 | Memory Before: 1.59 Mb | Memory After: 1.6 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.0318859 | Memory Before: 1.6 Mb | Memory After: 1.65 Mb | Memory Used: 53.27 kb | Rows: 96 | 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 96
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotorefPRIMARY,photo_id,view_id_2,photo_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5,user_idview_id_27const,const,const,const545Using where; Using temporary; Using filesort
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.0036650 | Memory Before: 2.64 Mb | Memory After: 2.66 Mb | Memory Used: 21.48 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.0008721 | Memory Before: 2.89 Mb | Memory After: 2.89 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'controller' AND module_id = 'advancedphoto' AND name = 'homepage.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0037549 | Memory Before: 2.95 Mb | Memory After: 2.95 Mb | Memory Used: 5.09 kb | Rows: 1 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'advancedphoto.homepage' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefPRIMARY,product_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28majmaih1_majma.m.product_id,const1Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_id77majmaih1_majma.m.module_id1Using where
0.0002899 | Memory Before: 2.9 Mb | Memory After: 2.91 Mb | Memory Used: 4.96 kb | Rows: 0 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'advancedphoto' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefPRIMARY,product_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28majmaih1_majma.m.product_id,const1Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_id77majmaih1_majma.m.module_id1Using where
0.0006320 | Memory Before: 2.9 Mb | Memory After: 2.91 Mb | Memory Used: 5.22 kb | Rows: 7 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrangeproduct_id,parent_idparent_id3 8Using index condition; Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28majmaih1_majma.m.product_id,const1Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_id77majmaih1_majma.m.module_id1Using where
0.0106220 | Memory Before: 3.6 Mb | Memory After: 3.6 Mb | Memory Used: 3.79 kb | Rows: 18 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 0
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const17Using where; Using filesort
0.0002780 | Memory Before: 3.61 Mb | Memory After: 3.61 Mb | Memory Used: 3.38 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 42
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0002170 | Memory Before: 3.61 Mb | Memory After: 3.61 Mb | Memory Used: 3.65 kb | Rows: 12 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 26
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const12Using where; Using filesort
0.0002251 | Memory Before: 3.62 Mb | Memory After: 3.63 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 25
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001409 | Memory Before: 3.63 Mb | Memory After: 3.63 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 24
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001431 | Memory Before: 3.63 Mb | Memory After: 3.63 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 23
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001340 | Memory Before: 3.63 Mb | Memory After: 3.63 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 1
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001841 | Memory Before: 3.63 Mb | Memory After: 3.64 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 3
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001259 | Memory Before: 3.63 Mb | Memory After: 3.64 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 4
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001330 | Memory Before: 3.64 Mb | Memory After: 3.64 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 6
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001249 | Memory Before: 3.64 Mb | Memory After: 3.64 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 7
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001910 | Memory Before: 3.64 Mb | Memory After: 3.65 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 8
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001302 | Memory Before: 3.64 Mb | Memory After: 3.65 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 9
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001218 | Memory Before: 3.65 Mb | Memory After: 3.65 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 11
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001302 | Memory Before: 3.65 Mb | Memory After: 3.65 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 16
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001349 | Memory Before: 3.65 Mb | Memory After: 3.65 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 17
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001311 | Memory Before: 3.65 Mb | Memory After: 3.66 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 19
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001292 | Memory Before: 3.66 Mb | Memory After: 3.66 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 20
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0001309 | Memory Before: 3.66 Mb | Memory After: 3.66 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.parent_id = 21
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_idparent_id3const1Using where; Using filesort
0.0002012 | Memory Before: 3.65 Mb | Memory After: 3.66 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001769 | Memory Before: 3.66 Mb | Memory After: 3.66 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'category.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0038230 | Memory Before: 3.66 Mb | Memory After: 3.67 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'category.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0129111 | Memory Before: 3.8 Mb | Memory After: 3.8 Mb | Memory Used: 9.43 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "advancedphoto|category"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0051129 | Memory Before: 3.72 Mb | Memory After: 3.74 Mb | Memory Used: 21.53 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.0002918 | Memory Before: 3.98 Mb | Memory After: 3.98 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001740 | Memory Before: 3.98 Mb | Memory After: 3.99 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'featured.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002580 | Memory Before: 3.99 Mb | Memory After: 3.99 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'featured.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0003040 | Memory Before: 4.12 Mb | Memory After: 4.13 Mb | Memory Used: 9.45 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "advancedphoto|featured"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0054321 | Memory Before: 4.04 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
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpindexprivacyview_id_584 5552Using where; Using index
0.0081549 | Memory Before: 4.04 Mb | Memory After: 4.06 Mb | Memory Used: 23.58 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.0002139 | Memory Before: 4.19 Mb | Memory After: 4.19 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.0001340 | Memory Before: 4.21 Mb | Memory After: 4.21 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.0002029 | Memory Before: 4.21 Mb | Memory After: 4.22 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.0001121 | Memory Before: 4.22 Mb | Memory After: 4.22 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.0002232 | Memory Before: 4.23 Mb | Memory After: 4.23 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.0001960 | Memory Before: 4.24 Mb | Memory After: 4.24 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.0001121 | Memory Before: 4.24 Mb | Memory After: 4.25 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.0001261 | Memory Before: 4.25 Mb | Memory After: 4.25 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.0001111 | Memory Before: 4.26 Mb | Memory After: 4.26 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.0001049 | Memory Before: 4.26 Mb | Memory After: 4.27 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.0001180 | Memory Before: 4.27 Mb | Memory After: 4.28 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.0001061 | Memory Before: 4.28 Mb | Memory After: 4.28 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.0001070 | Memory Before: 4.29 Mb | Memory After: 4.29 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.0001051 | Memory Before: 4.29 Mb | Memory After: 4.3 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.0001068 | Memory Before: 4.3 Mb | Memory After: 4.3 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.0032861 | Memory Before: 4.22 Mb | Memory After: 4.22 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
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpindexprivacyview_id_584 5552Using where; Using index
0.0072610 | Memory Before: 4.22 Mb | Memory After: 4.24 Mb | Memory Used: 21.45 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.0002429 | Memory Before: 4.37 Mb | Memory After: 4.37 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.0001330 | Memory Before: 4.4 Mb | Memory After: 4.4 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.0001192 | Memory Before: 4.4 Mb | Memory After: 4.4 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.0001750 | Memory Before: 4.4 Mb | Memory After: 4.41 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.0001080 | Memory Before: 4.41 Mb | Memory After: 4.41 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.0001221 | Memory Before: 4.42 Mb | Memory After: 4.42 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.0001070 | Memory Before: 4.42 Mb | Memory After: 4.43 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.0001171 | Memory Before: 4.43 Mb | Memory After: 4.44 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.0001271 | Memory Before: 4.44 Mb | Memory After: 4.44 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.0001161 | Memory Before: 4.45 Mb | Memory After: 4.45 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.0001061 | Memory Before: 4.45 Mb | Memory After: 4.46 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.0001252 | Memory Before: 4.46 Mb | Memory After: 4.47 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.0001080 | Memory Before: 4.47 Mb | Memory After: 4.47 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.0001199 | Memory Before: 4.48 Mb | Memory After: 4.48 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.0001049 | Memory Before: 4.48 Mb | Memory After: 4.49 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.0046802 | Memory Before: 4.4 Mb | Memory After: 4.4 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.0073960 | Memory Before: 4.4 Mb | Memory After: 4.42 Mb | Memory Used: 24.9 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.0002120 | Memory Before: 4.55 Mb | Memory After: 4.56 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.0002060 | Memory Before: 4.58 Mb | Memory After: 4.58 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.0001180 | Memory Before: 4.58 Mb | Memory After: 4.59 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.0001111 | Memory Before: 4.59 Mb | Memory After: 4.6 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.0001109 | Memory Before: 4.6 Mb | Memory After: 4.6 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.0001180 | Memory Before: 4.61 Mb | Memory After: 4.61 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.0001171 | Memory Before: 4.61 Mb | Memory After: 4.62 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.0001321 | Memory Before: 4.62 Mb | Memory After: 4.62 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.0001180 | Memory Before: 4.63 Mb | Memory After: 4.63 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.0001180 | Memory Before: 4.64 Mb | Memory After: 4.64 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.0002060 | Memory Before: 4.64 Mb | Memory After: 4.65 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.0001140 | Memory Before: 4.65 Mb | Memory After: 4.65 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.0001240 | Memory Before: 4.66 Mb | Memory After: 4.66 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.0001178 | Memory Before: 4.67 Mb | Memory After: 4.67 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.0001168 | Memory Before: 4.67 Mb | Memory After: 4.68 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.0001988 | Memory Before: 4.6 Mb | Memory After: 4.6 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001769 | Memory Before: 4.6 Mb | Memory After: 4.61 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'viewcommentshare.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001638 | Memory Before: 4.61 Mb | Memory After: 4.61 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'viewcommentshare.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0124922 | Memory Before: 4.69 Mb | Memory After: 4.7 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'small-photo.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002899 | Memory Before: 4.79 Mb | Memory After: 4.8 Mb | Memory Used: 9.43 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "advancedphoto|viewcommentshare"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0033619 | Memory Before: 4.72 Mb | Memory After: 4.73 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.0076859 | Memory Before: 4.72 Mb | Memory After: 4.75 Mb | Memory Used: 30.19 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.0001640 | Memory Before: 4.88 Mb | Memory After: 4.88 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.0001259 | Memory Before: 4.9 Mb | Memory After: 4.91 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.0001180 | Memory Before: 4.91 Mb | Memory After: 4.91 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.0001080 | Memory Before: 4.92 Mb | Memory After: 4.92 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.0001309 | Memory Before: 4.93 Mb | Memory After: 4.93 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.0001209 | Memory Before: 4.93 Mb | Memory After: 4.94 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.0001202 | Memory Before: 4.94 Mb | Memory After: 4.94 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.0001070 | Memory Before: 4.95 Mb | Memory After: 4.95 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.0001092 | Memory Before: 4.96 Mb | Memory After: 4.96 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.0003431 | Memory Before: 4.96 Mb | Memory After: 4.97 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.0001180 | Memory Before: 4.97 Mb | Memory After: 4.97 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.0001202 | Memory Before: 4.98 Mb | Memory After: 4.98 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.0001018 | Memory Before: 4.98 Mb | Memory After: 4.99 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.0001040 | Memory Before: 4.99 Mb | Memory After: 5 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.0002069 | Memory Before: 5 Mb | Memory After: 5 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.0059831 | Memory Before: 4.91 Mb | Memory After: 4.93 Mb | Memory Used: 15.66 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 4797Using 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.0021279 | Memory Before: 4.93 Mb | Memory After: 4.94 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 4646Using 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.0016770 | Memory Before: 4.94 Mb | Memory After: 4.95 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 3144Using 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.0008650 | Memory Before: 4.95 Mb | Memory After: 4.97 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 2834Using 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.0012212 | Memory Before: 4.96 Mb | Memory After: 4.98 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 232Using 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.0008628 | Memory Before: 4.98 Mb | Memory After: 4.99 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 2106Using 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.0010309 | Memory Before: 4.99 Mb | Memory After: 5.01 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 483Using 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.0012891 | Memory Before: 5 Mb | Memory After: 5.02 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 565Using 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.0007520 | Memory Before: 5.02 Mb | Memory After: 5.03 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 1322Using 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.0005388 | Memory Before: 5.03 Mb | Memory After: 5.04 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 5503Using 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.0005691 | Memory Before: 5.04 Mb | Memory After: 5.06 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 951Using 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.0006349 | Memory Before: 5.05 Mb | Memory After: 5.07 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 5157Using 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.0007250 | Memory Before: 5.06 Mb | Memory After: 5.08 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 675Using 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.0007131 | Memory Before: 5.08 Mb | Memory After: 5.09 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 4646Using 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.0005701 | Memory Before: 5.09 Mb | Memory After: 5.1 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 4718Using 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.0001819 | Memory Before: 5.1 Mb | Memory After: 5.1 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 360
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001340 | Memory Before: 5.11 Mb | Memory After: 5.11 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1349
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001121 | Memory Before: 5.12 Mb | Memory After: 5.12 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5665
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001180 | Memory Before: 5.13 Mb | Memory After: 5.13 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.0001130 | Memory Before: 5.13 Mb | Memory After: 5.14 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4338
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001080 | Memory Before: 5.14 Mb | Memory After: 5.14 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.0001199 | Memory Before: 5.15 Mb | Memory After: 5.15 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 2013
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001061 | Memory Before: 5.15 Mb | Memory After: 5.16 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4578
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0003300 | Memory Before: 5.16 Mb | Memory After: 5.17 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5083
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001171 | Memory Before: 5.17 Mb | Memory After: 5.17 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 5795
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001101 | Memory Before: 5.18 Mb | Memory After: 5.18 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 1954
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001190 | Memory Before: 5.18 Mb | Memory After: 5.19 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 4155
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001061 | Memory Before: 5.19 Mb | Memory After: 5.2 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3142
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001152 | Memory Before: 5.2 Mb | Memory After: 5.2 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 3245
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001070 | Memory Before: 5.21 Mb | Memory After: 5.21 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category_data
WHERE photo_id = 916
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_category_datarefphoto_idphoto_id4const1 
0.0001850 | Memory Before: 5.12 Mb | Memory After: 5.13 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0003481 | Memory Before: 5.13 Mb | Memory After: 5.13 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'newrandom.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001969 | Memory Before: 5.14 Mb | Memory After: 5.14 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'newrandom.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0003350 | Memory Before: 5.27 Mb | Memory After: 5.28 Mb | Memory Used: 9.43 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "advancedphoto|newrandom"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0141301 | Memory Before: 5.26 Mb | Memory After: 5.27 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 >= '1516566600' AND p.time_stamp < '1516652940')
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefprivacyprivacy1const5531Using where
0.0133240 | Memory Before: 5.28 Mb | Memory After: 5.29 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 >= '1514748700'
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefprivacyprivacy1const5531Using where
0.0050931 | Memory Before: 5.29 Mb | Memory After: 5.3 Mb | Memory Used: 17.76 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.0003090 | Memory Before: 5.34 Mb | Memory After: 5.34 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.0001330 | Memory Before: 5.35 Mb | Memory After: 5.35 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.0001171 | Memory Before: 5.35 Mb | Memory After: 5.36 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.0001321 | Memory Before: 5.36 Mb | Memory After: 5.36 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.0001271 | Memory Before: 5.37 Mb | Memory After: 5.37 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.0131960 | Memory Before: 5.35 Mb | Memory After: 5.35 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 >= '1516653000'
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefprivacyprivacy1const5531Using where
0.0003521 | Memory Before: 5.35 Mb | Memory After: 5.36 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001762 | Memory Before: 5.36 Mb | Memory After: 5.36 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'weekmonthtoday.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0022230 | Memory Before: 5.37 Mb | Memory After: 5.37 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'weekmonthtoday.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0062220 | Memory Before: 5.46 Mb | Memory After: 5.47 Mb | Memory Used: 9.43 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "advancedphoto|weekmonthtoday"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0099900 | Memory Before: 5.4 Mb | Memory After: 5.42 Mb | Memory Used: 15 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.0002820 | Memory Before: 5.5 Mb | Memory After: 5.5 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0003669 | Memory Before: 5.51 Mb | Memory After: 5.51 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'topmembers.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001600 | Memory Before: 5.51 Mb | Memory After: 5.52 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'topmembers.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002580 | Memory Before: 5.59 Mb | Memory After: 5.6 Mb | Memory Used: 9.43 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "advancedphoto|topmembers"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0042791 | Memory Before: 5.54 Mb | Memory After: 5.54 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.0003181 | Memory Before: 5.54 Mb | Memory After: 5.54 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
0.0002050 | Memory Before: 5.54 Mb | Memory After: 5.55 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001700 | Memory Before: 5.55 Mb | Memory After: 5.56 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'statistic.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0006502 | Memory Before: 5.56 Mb | Memory After: 5.56 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'advancedphoto' AND name = 'statistic.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0060890 | Memory Before: 5.64 Mb | Memory After: 5.65 Mb | Memory Used: 9.43 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "advancedphoto|statistic"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
Array
(
    [session] => 8302d5a691260e999c2585f7ff173d95
    [redirect] => /advancedphoto/show_96/
)