{{title}}

{{message}}

عضویت
مجمعی ها

150118_10152835466789939_3444931369334282306_n (1)

18 آبان, 1393 توسط
تنها به بند معرفتش متحد شوند...
محمد علیخاصی
8گریه
من تو این عکس نیسم
  • 19 آبان, 1393
  • ·
  • احسنت!
اشکان بهرامی
منم!
  • 20 آبان, 1393
  • ·
  • احسنت!
سید جواد حسینی
خوب بیبین 10
  • 20 آبان, 1393
  • ·
  • احسنت!
امیرحسین لطفی
او هم!
  • 20 آبان, 1393
  • ·
  • احسنت!
محمد امين زماني
من که نیستم پس.. اون عکسه رو میذاشتین که منم هستممم..78
  • 20 آبان, 1393
  • ·
  • احسنت!
مصطفی کمالی
هستممم؟هستَمَمَم؟
  • 20 آبان, 1393
  • ·
  • احسنت!
phpFox Developers Debug Toggle JavaScript Console
Version:
3.7.7
Product Code Name:
Nebula

Total Time:
0.2693248
PHP General Time:
0.2331492
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.0361756
SQL Queries:
27
SQL Memory Usage:
1.48 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
3.19 Mb
Total Memory Usage (Including Debug):
3.28 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
185.55.227.64


Server Time Stamp:
January 22, 2018, 12:28 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.0005119 | Memory Before: 752.8 kb | Memory After: 754.15 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 ('1d20e006b342d4a4f781407dfb37e5c6', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516580933', '/advancedphoto/4919/150118_10152835466789939_3444931369334282306_n-1/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0002179 | Memory Before: 921.04 kb | Memory After: 926.39 kb | Memory Used: 5.35 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.0021532 | Memory Before: 1.27 Mb | Memory After: 1.29 Mb | Memory Used: 17.41 kb | Rows: 1 | Slave: Yes
SELECT lik.like_id AS is_liked, f.friend_id AS is_friend, 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.*, pi.*, pa.name AS album_url, pa.name AS album_title, pa.profile_id AS album_profile_id, pt.item_id AS is_viewed
FROM phpfox_photo AS p
     LEFT JOIN phpfox_like AS lik
            ON((lik.type_id = 'advancedphoto' OR lik.type_id = 'photo' ) AND lik.item_id = p.photo_id AND lik.user_id = 0)
     LEFT JOIN phpfox_friend AS f
            ON(f.user_id = p.user_id AND f.friend_user_id = 0)
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p.photo_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p.album_id)
     LEFT JOIN phpfox_photo_track AS pt
            ON(pt.item_id = p.photo_id AND pt.user_id = 0)

WHERE p.photo_id = 4919
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpconstPRIMARY,photo_id,photo_id_2,user_idPRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const unique row not found
1SIMPLEptrefitem_iditem_id8const,const1Using index
1SIMPLElikrangetype_id,type_id_2,type_id_3,item_idtype_id_285 2Using where; Using join buffer (Block Nested Loop)
1SIMPLEfconstuser_check,user_id,top_friend,friend_user_iduser_check8const,const1Using where
0.0002210 | Memory Before: 1.3 Mb | Memory After: 1.3 Mb | Memory Used: 3.83 kb | Rows: 0 | Slave: Yes
SELECT tag_id, item_id, tag_text, tag_url
FROM phpfox_tag
WHERE item_id = 4919 AND category_id = 'advancedphoto'
ORDER BY tag_id ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_tagrefitem_id,category_id,user_search,user_search_general,item_id_2,item_id_3,category_id_2item_id81const,const1Using index condition; Using where; Using filesort
0.0001919 | Memory Before: 1.3 Mb | Memory After: 1.3 Mb | Memory Used: 3.82 kb | Rows: 0 | Slave: Yes
SELECT tag_id, item_id, tag_text, tag_url
FROM phpfox_tag
WHERE item_id = 4919 AND category_id = 'photo'
ORDER BY tag_id ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_tagrefitem_id,category_id,user_search,user_search_general,item_id_2,item_id_3,category_id_2item_id81const,const1Using index condition; Using where; Using filesort
0.0001781 | Memory Before: 1.32 Mb | Memory After: 1.32 Mb | Memory Used: 3.59 kb | Rows: 0 | Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name
FROM phpfox_photo_category_data AS pcd
     JOIN phpfox_photo_category AS pc
            ON(pc.category_id = pcd.category_id)

WHERE pcd.photo_id = 4919
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcdrefphoto_id,category_idphoto_id4const1Using temporary; Using filesort
1SIMPLEpceq_refPRIMARYPRIMARY3majmaih1_majma.pcd.category_id1Using index condition
0.0001659 | Memory Before: 1.68 Mb | Memory After: 1.69 Mb | Memory Used: 11.16 kb | Rows: 1 | Slave: No
SELECT *
FROM phpfox_photo
WHERE photo_id = 4919
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
0.0006380 | Memory Before: 1.69 Mb | Memory After: 1.69 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS photo
WHERE photo.photo_id > 4919 AND photo.group_id = 0 AND ((photo.privacy = 0) AND photo.privacy = 0)
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotorangePRIMARY,photo_id,photo_id_2,privacyphoto_id4 1097Using where; Using index
0.0028400 | Memory Before: 1.69 Mb | Memory After: 1.92 Mb | Memory Used: 234.02 kb | Rows: 841 | Slave: Yes
SELECT photo.*
FROM phpfox_photo AS photo
WHERE photo.photo_id > 4919 AND photo.group_id = 0 AND ((photo.privacy = 0) AND photo.privacy = 0)
ORDER BY photo.photo_id ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotorangePRIMARY,photo_id,photo_id_2,privacyPRIMARY4 847Using index condition; Using where
0.0067611 | Memory Before: 1.7 Mb | Memory After: 1.7 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS photo
WHERE photo.photo_id < 4919 AND photo.group_id = 0 AND ((photo.privacy = 0) AND photo.privacy = 0)
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotorefPRIMARY,photo_id,photo_id_2,privacyprivacy1const5531Using where
0.0130470 | Memory Before: 1.7 Mb | Memory After: 2.78 Mb | Memory Used: 1.08 Mb | Rows: 4122 | Slave: Yes
SELECT photo.*
FROM phpfox_photo AS photo
WHERE photo.photo_id < 4919 AND photo.group_id = 0 AND ((photo.privacy = 0) AND photo.privacy = 0)
ORDER BY photo.photo_id DESC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoALLPRIMARY,photo_id,photo_id_2,privacyMISSING KEY   5552Using where; Using filesort
0.0002091 | Memory Before: 1.71 Mb | Memory After: 1.72 Mb | Memory Used: 7.27 kb | Rows: 0 | Slave: Yes
SELECT p.user_id AS photo_owner_id, pt.tag_id, pt.user_id AS post_user_id, pt.content, pt.position_x, pt.position_y, pt.width, pt.height, 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_tag AS pt
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = pt.tag_user_id)
     JOIN phpfox_photo AS p
            ON(p.photo_id = pt.photo_id)

WHERE pt.photo_id = 4919
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEptrefphoto_id,photo_id_2,photo_id_3,photo_id_4photo_id4const1 
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.pt.tag_user_id1 
0.0028260 | Memory Before: 2.47 Mb | Memory After: 2.48 Mb | Memory Used: 9.9 kb | Rows: 22 | Slave: Yes
SELECT l.*, 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, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "advancedphoto")

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4919
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const18Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0015900 | Memory Before: 2.57 Mb | Memory After: 2.58 Mb | Memory Used: 10.85 kb | Rows: 3 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, 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_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 12
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0006421 | Memory Before: 2.6 Mb | Memory After: 2.6 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19854 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003970 | Memory Before: 2.6 Mb | Memory After: 2.61 Mb | Memory Used: 10.19 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, 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_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19854 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0001979 | Memory Before: 2.61 Mb | Memory After: 2.61 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19852 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003970 | Memory Before: 2.61 Mb | Memory After: 2.62 Mb | Memory Used: 10.09 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, 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_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19852 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002460 | Memory Before: 2.62 Mb | Memory After: 2.62 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19844 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004249 | Memory Before: 2.62 Mb | Memory After: 2.63 Mb | Memory Used: 10.68 kb | Rows: 2 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, 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_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19844 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002489 | Memory Before: 2.64 Mb | Memory After: 2.64 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19847 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004189 | Memory Before: 2.64 Mb | Memory After: 2.65 Mb | Memory Used: 10.39 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, 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_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19847 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002308 | Memory Before: 2.66 Mb | Memory After: 2.66 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19850 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003939 | Memory Before: 2.66 Mb | Memory After: 2.67 Mb | Memory Used: 10.18 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, 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_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19850 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002398 | Memory Before: 2.66 Mb | Memory After: 2.66 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19848 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003641 | Memory Before: 2.66 Mb | Memory After: 2.67 Mb | Memory Used: 10.12 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, 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_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19848 AND c.type_id = 'advancedphoto' AND c.item_id = 4919 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0004232 | Memory Before: 2.65 Mb | Memory After: 2.66 Mb | Memory Used: 10.18 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, 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_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'photo' AND c.item_id = 4919 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 12
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
Array
(
    [session] => 1d20e006b342d4a4f781407dfb37e5c6
    [redirect] => /advancedphoto/4919/150118_10152835466789939_3444931369334282306_n-1/
)