{{title}}

{{message}}

عضویت
مجمعی ها
کد امنیتی
مهدی یزدانی
بعضی دوستان مجمعی با نظراتشون از همدیگر پذیرایی میکنند...
محمد حامد صادق زاده
بچه ها دقت کردید با دست راست میره تو ولی با دست چپ میزنه!!!!!!
  • 1 اسفند, 1393
  • ·
  • احسنت!
سیدمهدی مدینه آنلاین هست.
برای دیدن اسم عشق تان کمی با انگشتان دست تان گوشه های چشم تان را بکشید! (مثل ژاپنی ها)
ایمان حبیب اللهی
شاید حداقل 8 بار اینکارو تو سایتای مختلف کردم....
برا من که خییییییییییییییییلی تکراری بود
ولی بازم ممنونم......
  • 7 مهر, 1393
  • ·
  • احسنت!
سیدمهدی مدینه آنلاین هست.
شوت ترین رییس جمهور دنیا!


teste grooh haye karbari
.
  • 14 مهر, 1392
  • ·
  • احسنت!
teste grooh haye karbari
چرا هرچی نظر میذارم ، این پست نمیاد بالا؟؟؟
  • 14 مهر, 1392
  • ·
  • احسنت!
علی عباسی
کیه؟؟؟
  • 14 مهر, 1392
  • ·
  • احسنت!
علی کاغذگران
من از فرذا نمیام چیست؟
جمله ای که هر سال این موقع دانش آموزان به همدیگه قبل عید می گن
درحالی که فردا می بینی همشون اومدن!
امیر احمدیان
یا علــــــــــــــــــــی!هر سال این موقع؟!تقریبا 6 ماه تا عید مونده!
  • 11 مهر, 1392
  • ·
  • احسنت!
سیدمهدی مدینه آنلاین هست.
.
  • 13 مهر, 1392
  • ·
  • احسنت!
علی کاغذگران
یارو می ره دندون پزشکی،می گه:آقای دکتر همه دندونام را بکش به جز اونی که درد می کنه
دکتر می گه:چرا؟
یارو می گه بذار مثل سگ تنها بمونه!
محمد مهدی تحویلیان
بوووووووووووووووووووووووووووووووووووووووو
  • 11 مهر, 1392
  • ·
  • احسنت!
علی کاغذگران
اصفهانیه از تو جهنم سرشو می کنه تو بهشت،می گه:
ابجوش نمیخیند؟؟؟!
میگن:نه،میگه:باشه پس من یه موز ورداشتم.....!!!
علی کاغذگران
کارشناسان ایتالیایی اعلام کردند:سرعت حلزون قطع نخاع شده،15% از سرعت اینترت ایران بیشتر است!!!
خنده حلال
ﺷﺎﻋﺮ ﺩﺭ ﺟﺎﻳﯽ ﻣﻴﻔﺮﻣﺎﻳﺪ : ﺩﺭ ﻛﻠﺒﻪ ﻣﺎ ﺭﻭﻧﻖ ﺍﮔﺮ ﻧﯿﺴﺖ ، ﺻﻔﺎ ﻫﻢ ﻧﯿﺴﺖ ، ﻣﺎﺳﺖ ﻧﯿﺴﺖ ، ﺭﻭﻏﻦ ﻧﯿﺴﺖ ، ع.ن.م ﻧﻴﺴﺖ … ﺍﺻﻦ ﻫﯿﭽﯽ ﻧﯿﺴﺖ !!!
علی خاکباز
یک تـَن از خوبان گندمگون نصیب ما نشد
یک تـُن‎اش می‎شد اگر شاعر جماعت شانس داشت...

صائب تبریزی+روح الله احمدی
  • 1 شهریور, 1392
  • ·
  • احسنت!
نمایش 4 پست بیشتر از خنده حلال
خنده حلال
سال های ساله دارم پیتزا می خورم
ولی هنوز فرق بین پیتزا مخلوط و با پیتزا مخصوص نفهمیدم
محمد مهدی پویان فر
من هم!!
  • 28 مرداد, 1392
  • ·
  • احسنت!
خنده حلال
امروزتو خیابون یه بچه ۵ ساله به دوستش گفت پدسگ...
اونم برگشت گفت: نه که تو بابات آهوئه!
خنده حلال
برام اس ام اس اومده، از اتاق دویدم سمت گوشیم بابام تا منو دیده میگه:
اس ام اس اومده پسرم استخوون که نیست!
مهدی یزدانی
به این کار تمارض نمیگن چون هم تیمی اند هرکی اسمشو بلد بود بگه.
معین ناطقی
،به این دیگه میگن مرض داشتن!
خیلی ضایس!
شاید خوشحالی بعد ازگله،چون من خوشحالی تو این مایه ها دیدم!:D
  • 23 تیر, 1392
  • ·
  • احسنت!
محمد حامد صادق زاده
من هرجوری فکر میکنم میبینم این باید از اون طرف میوفتاد!!
  • 12 مرداد, 1392
  • ·
  • احسنت!
محمد مهدی پویان فر
هاشم زنداني
این دوستان که لایک کردن میدونن اصی قضیه چی چیه س؟
  • 19 تیر, 1392
  • ·
  • احسنت!
حسین اعتصامی
نه! شوما که لایک نکردی میدونی!
  • 19 تیر, 1392
  • ·
  • احسنت!
هاشم زنداني
منظورم شخص خاص لایک کوننده ها نبود.
گفتم اگه نمیدونن ذکر کونم
  • 19 تیر, 1392
  • ·
  • احسنت!
محمدصابر پسته
راس می گه ما که نفهمیدیم!
  • 19 تیر, 1392
  • ·
  • احسنت!
هاشم زنداني
آیفون5 برخلاف سنت آیفونا 4 اینچی شد و فقط از طول بزرگ شد.و عرضش همون قبلی موند.
حالا اگه رو این حساب پیش بره و فقط از طول دراز شه آیفون 20 شبیه ا ین تصویر میشه!
  • 19 تیر, 1392
  • ·
  • احسنت!
محمد مهدی پویان فر
ای بابا من فک کردم دوستان ملتفت هستن!!
  • 19 تیر, 1392
  • ·
  • احسنت!
محمد حامد صادق زاده
محمد محدی شده حکایت عروسه و زمین کج!!
  • 12 مرداد, 1392
  • ·
  • احسنت!
محمد مهدی پویان فر
حاج آقا تقبل الله !!
محمد حامد صادق زاده
نمازش اشکال داره
  • 12 مرداد, 1392
  • ·
  • احسنت!
محمد مهدی پویان فر
اول کلاس معلم برگه های امتحان بچه هارو که صحیح کرده بود بهشون داد.آخر کار یه برگه زیاد اومد.به بچه ها گفت :
این مال کیه 16 شده اسمم نداره؟
هیچ کس جواب نداد...
معلم : چقدرم دست خطش شبیه خودمه!این که کلید سوالاس که!
محمد مهدی پویان فر
!!!
هاشم زنداني
هاشم زنداني
"حداکثر سرعت"یه شهر بوده که هی تابلو فاصله تاشهر کم میشده این هم فک میکرده محدودیت سرعته!
  • 29 تیر, 1392
  • ·
  • احسنت!
محمدرضا بدیعی
خداوکیلی این چیزا را نذارید
آدم اشکش در میاد
  • 30 تیر, 1392
  • ·
  • احسنت!
هاشم زنداني
هاشم زنداني
فلفل نبین چه ریزه...!
  • 29 تیر, 1392
  • ·
  • احسنت!
محمدرضا بدیعی
چه قدر خونوک بود.
  • 30 تیر, 1392
  • ·
  • احسنت!
نمایش بیشتر
phpFox Developers Debug Toggle JavaScript Console
Version:
3.7.7
Product Code Name:
Nebula

Total Time:
1.3324230
PHP General Time:
1.1295935
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.2028295
SQL Queries:
189
SQL Memory Usage:
1.25 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
4.42 Mb
Total Memory Usage (Including Debug):
5.02 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
185.55.227.64


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

Cache:
file
SQL Queries
0.0154951 | Memory Before: 751.74 kb | Memory After: 753.09 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 ('a12d225c76cf758cdfe434f3c54becce', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516581160', '/pages/40/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0002570 | Memory Before: 920.23 kb | Memory After: 925.51 kb | Memory Used: 5.28 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.0026190 | Memory Before: 1.26 Mb | Memory After: 1.27 Mb | Memory Used: 4.21 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_pages_design_order
WHERE page_id = 40
ORDER BY ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_pages_design_orderrefpage_idpage_id4const1Using where; Using filesort
0.0123959 | Memory Before: 1.28 Mb | Memory After: 1.29 Mb | Memory Used: 16.53 kb | Rows: 1 | Slave: Yes
SELECT f.friend_id AS is_friend, l.like_id AS is_liked, p.*, u.user_image as image_path, p.image_path as pages_image_path, u.user_id as page_user_id, p.use_timeline, pc.claim_id, pu.vanity_url, pg.name AS category_name, pg.page_type, pt.text_parsed AS text, u.full_name, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id, u2.user_id AS owner_user_id, u2.profile_page_id AS owner_profile_page_id, u2.server_id AS owner_server_id, u2.user_name AS owner_user_name, u2.full_name AS owner_full_name, u2.gender AS owner_gender, u2.user_image AS owner_user_image, u2.is_invisible AS owner_is_invisible, u2.user_group_id AS owner_user_group_id, u2.language_id AS owner_language_id, u2.last_activity AS owner_last_activity
FROM phpfox_pages AS p
     LEFT JOIN phpfox_friend AS f
            ON(f.user_id = p.user_id AND f.friend_user_id = 0)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages' AND l.item_id = p.page_id AND l.user_id = 0)
     JOIN phpfox_pages_text AS pt
            ON(pt.page_id = p.page_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = p.page_id)
     JOIN phpfox_user AS u2
            ON(u2.user_id = p.user_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
            ON(pg.category_id = p.category_id)
     LEFT JOIN phpfox_theme_style AS ts
            ON(ts.style_id = p.designer_style_id)
     LEFT JOIN phpfox_theme AS t
            ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_pages_claim AS pc
            ON(pc.page_id = p.page_id AND pc.user_id = 0)

WHERE p.page_id = 40
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEfconstuser_check,user_id,top_friend,friend_user_iduser_check8const,const unique row not found
1SIMPLEptconstpage_idpage_id4const1 
1SIMPLEu2constPRIMARY,user_idPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLEpgconstPRIMARY,category_idPRIMARY3const1 
1SIMPLEtsrefstyle_id,style_id_2style_id2const1 
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2majmaih1_majma.ts.theme_id1 
1SIMPLEpcrefpage_idpage_id8const,const1 
0.0114591 | Memory Before: 1.3 Mb | Memory After: 1.3 Mb | Memory Used: 4.21 kb | Rows: 18 | Slave: Yes
SELECT *
FROM phpfox_pages_perm
WHERE page_id = 40
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_pages_permrefpage_idpage_id4const18 
0.0003622 | Memory Before: 1.31 Mb | Memory After: 1.32 Mb | Memory Used: 5.48 kb | Rows: 0 | Slave: Yes
SELECT pw.*, pwt.text_parsed AS text
FROM phpfox_pages_widget AS pw
     JOIN phpfox_pages_widget_text AS pwt
            ON(pwt.widget_id = pw.widget_id)

WHERE pw.page_id = 40
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0004129 | Memory Before: 2.65 Mb | Memory After: 2.66 Mb | Memory Used: 3.65 kb | Rows: 2 | Slave: No
SELECT r.url, r.replacement, r.rewrite_id
FROM phpfox_rewrite AS r
ORDER BY rewrite_id DESC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLErALL MISSING KEY   2Using filesort
0.0007238 | Memory Before: 2.66 Mb | Memory After: 2.67 Mb | Memory Used: 3.82 kb | Rows: 5 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 161
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_privacyrefuser_id,user_id_2user_id_24const5 
0.0009110 | Memory Before: 2.75 Mb | Memory After: 2.75 Mb | Memory Used: 3.64 kb | Rows: 0 | Slave: Yes
SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 178
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0010400 | Memory Before: 2.75 Mb | Memory After: 2.76 Mb | Memory Used: 12.48 kb | Rows: 22 | Slave: Yes
SELECT feed.*, 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, u.view_id
FROM phpfox_pages_feed AS feed
     JOIN phpfox_user AS u
            ON(u.user_id = feed.user_id)

WHERE feed.parent_user_id = 40
ORDER BY feed.time_update DESC
LIMIT 22
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfeedrefparent_user_idparent_user_id4const65Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.feed.user_id1 
0.0010459 | Memory Before: 2.97 Mb | Memory After: 2.98 Mb | Memory Used: 12.09 kb | Rows: 1 | Slave: Yes
SELECT photo.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 572)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 1868
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0034678 | Memory Before: 2.98 Mb | Memory After: 2.99 Mb | Memory Used: 9.48 kb | Rows: 19 | 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 = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 1868
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,const16Using 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.0002570 | Memory Before: 3.06 Mb | Memory After: 3.06 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 1868
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const16Using where; Using index
0.0010939 | Memory Before: 3.07 Mb | Memory After: 3.08 Mb | Memory Used: 10.33 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 = 0 AND c.type_id = 'photo' AND c.item_id = 1868 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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 
0.0004818 | Memory Before: 3.14 Mb | Memory After: 3.14 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 = 20778 AND c.type_id = 'photo' AND c.item_id = 1868 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004530 | Memory Before: 3.14 Mb | Memory After: 3.15 Mb | Memory Used: 10.16 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 = 20778 AND c.type_id = 'photo' AND c.item_id = 1868 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_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 
0.0002670 | Memory Before: 3.14 Mb | Memory After: 3.15 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 1868
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0002539 | Memory Before: 3.16 Mb | Memory After: 3.17 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 1868
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0044749 | Memory Before: 3.17 Mb | Memory After: 3.18 Mb | Memory Used: 12.8 kb | Rows: 1 | Slave: Yes
SELECT photo.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 1007)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4852
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0010021 | Memory Before: 3.17 Mb | Memory After: 3.18 Mb | Memory Used: 8.49 kb | Rows: 12 | 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 = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 4852
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,const11Using 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.0002708 | Memory Before: 3.21 Mb | Memory After: 3.22 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 4852
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const11Using where; Using index
0.0010500 | Memory Before: 3.21 Mb | Memory After: 3.22 Mb | Memory Used: 10.31 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 = 0 AND c.type_id = 'photo' AND c.item_id = 4852 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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.0026910 | Memory Before: 3.23 Mb | Memory After: 3.24 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 = 19544 AND c.type_id = 'photo' AND c.item_id = 4852 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.0004361 | Memory Before: 3.24 Mb | Memory After: 3.25 Mb | Memory Used: 10.17 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 = 19544 AND c.type_id = 'photo' AND c.item_id = 4852 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.0002809 | Memory Before: 3.24 Mb | Memory After: 3.24 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 4852
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0002351 | Memory Before: 3.24 Mb | Memory After: 3.25 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 4852
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0013161 | Memory Before: 3.26 Mb | Memory After: 3.27 Mb | Memory Used: 9.54 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 227
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0008900 | Memory Before: 3.25 Mb | Memory After: 3.26 Mb | Memory Used: 7.37 kb | Rows: 4 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 227
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 5Using index condition; 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.0003469 | Memory Before: 3.27 Mb | Memory After: 3.27 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 227
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 5Using where; Using index
0.0015490 | Memory Before: 3.27 Mb | Memory After: 3.28 Mb | Memory Used: 10.95 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 = 'pages' AND c.item_id = 227 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const2Using 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.0078568 | Memory Before: 3.3 Mb | Memory After: 3.3 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 = 11186 AND c.type_id = 'pages' AND c.item_id = 227 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.0004251 | Memory Before: 3.3 Mb | Memory After: 3.31 Mb | Memory Used: 10.17 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 = 11186 AND c.type_id = 'pages' AND c.item_id = 227 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.0002072 | Memory Before: 3.31 Mb | Memory After: 3.31 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 = 11183 AND c.type_id = 'pages' AND c.item_id = 227 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.0004461 | Memory Before: 3.31 Mb | Memory After: 3.32 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 = 11183 AND c.type_id = 'pages' AND c.item_id = 227 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.0002151 | Memory Before: 3.32 Mb | Memory After: 3.32 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 = 11182 AND c.type_id = 'pages' AND c.item_id = 227 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.0004871 | Memory Before: 3.32 Mb | Memory After: 3.33 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 = 11182 AND c.type_id = 'pages' AND c.item_id = 227 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: 3.31 Mb | Memory After: 3.32 Mb | Memory Used: 5.45 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 227
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003960 | Memory Before: 3.31 Mb | Memory After: 3.32 Mb | Memory Used: 5.85 kb | Rows: 4 | Slave: No
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
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'pages_comment' AND l.item_id = 227
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const4Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002429 | Memory Before: 3.32 Mb | Memory After: 3.32 Mb | Memory Used: 5.46 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 227
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0008090 | Memory Before: 3.33 Mb | Memory After: 3.34 Mb | Memory Used: 9.52 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 215
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0005710 | Memory Before: 3.33 Mb | Memory After: 3.33 Mb | Memory Used: 6.96 kb | Rows: 1 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 215
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using index condition; 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.0003412 | Memory Before: 3.33 Mb | Memory After: 3.34 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 215
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using where; Using index
0.0009840 | Memory Before: 3.34 Mb | Memory After: 3.35 Mb | Memory Used: 10.6 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 = 0 AND c.type_id = 'pages' AND c.item_id = 215 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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 
0.0002348 | Memory Before: 3.36 Mb | Memory After: 3.36 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 = 11008 AND c.type_id = 'pages' AND c.item_id = 215 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004051 | Memory Before: 3.36 Mb | Memory After: 3.37 Mb | Memory Used: 10.15 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 = 11008 AND c.type_id = 'pages' AND c.item_id = 215 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_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 
0.0047829 | Memory Before: 3.37 Mb | Memory After: 3.37 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 = 10835 AND c.type_id = 'pages' AND c.item_id = 215 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004730 | Memory Before: 3.37 Mb | Memory After: 3.38 Mb | Memory Used: 10.08 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 = 10835 AND c.type_id = 'pages' AND c.item_id = 215 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_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 
0.0002310 | Memory Before: 3.37 Mb | Memory After: 3.37 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 215
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003278 | Memory Before: 3.36 Mb | Memory After: 3.37 Mb | Memory Used: 5.53 kb | Rows: 1 | Slave: No
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
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'pages_comment' AND l.item_id = 215
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002699 | Memory Before: 3.37 Mb | Memory After: 3.37 Mb | Memory Used: 5.45 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 215
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0004270 | Memory Before: 3.39 Mb | Memory After: 3.39 Mb | Memory Used: 9.53 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 214
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0007379 | Memory Before: 3.38 Mb | Memory After: 3.39 Mb | Memory Used: 7.22 kb | Rows: 3 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 214
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 4Using index condition; 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.0003610 | Memory Before: 3.39 Mb | Memory After: 3.4 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 214
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 4Using where; Using index
0.0008121 | Memory Before: 3.4 Mb | Memory After: 3.41 Mb | Memory Used: 10.41 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 = 0 AND c.type_id = 'pages' AND c.item_id = 214 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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 
0.0002570 | Memory Before: 3.41 Mb | Memory After: 3.41 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 = 10849 AND c.type_id = 'pages' AND c.item_id = 214 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0005078 | Memory Before: 3.41 Mb | Memory After: 3.42 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 = 10849 AND c.type_id = 'pages' AND c.item_id = 214 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_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 
0.0002470 | Memory Before: 3.42 Mb | Memory After: 3.42 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 214
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003402 | Memory Before: 3.41 Mb | Memory After: 3.42 Mb | Memory Used: 5.73 kb | Rows: 3 | Slave: No
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
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'pages_comment' AND l.item_id = 214
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const3Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002670 | Memory Before: 3.42 Mb | Memory After: 3.42 Mb | Memory Used: 5.45 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 214
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0006909 | Memory Before: 3.43 Mb | Memory After: 3.44 Mb | Memory Used: 9.49 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 213
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0011110 | Memory Before: 3.43 Mb | Memory After: 3.44 Mb | Memory Used: 8.36 kb | Rows: 11 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 213
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 12Using index condition; 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.0003722 | Memory Before: 3.47 Mb | Memory After: 3.47 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 213
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 12Using where; Using index
0.0002460 | Memory Before: 3.47 Mb | Memory After: 3.48 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 213
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003839 | Memory Before: 3.48 Mb | Memory After: 3.48 Mb | Memory Used: 6.46 kb | Rows: 11 | Slave: No
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
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'pages_comment' AND l.item_id = 213
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const11Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002339 | Memory Before: 3.49 Mb | Memory After: 3.5 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 213
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003881 | Memory Before: 3.5 Mb | Memory After: 3.51 Mb | Memory Used: 9.58 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 212
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0007219 | Memory Before: 3.5 Mb | Memory After: 3.5 Mb | Memory Used: 7.78 kb | Rows: 7 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 212
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 8Using index condition; 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.0003688 | Memory Before: 3.52 Mb | Memory After: 3.52 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 212
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 8Using where; Using index
0.0002482 | Memory Before: 3.53 Mb | Memory After: 3.53 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 212
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003891 | Memory Before: 3.53 Mb | Memory After: 3.53 Mb | Memory Used: 6.09 kb | Rows: 7 | Slave: No
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
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'pages_comment' AND l.item_id = 212
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const7Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002520 | Memory Before: 3.54 Mb | Memory After: 3.55 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 212
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0009811 | Memory Before: 3.55 Mb | Memory After: 3.56 Mb | Memory Used: 9.56 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 180
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0004280 | Memory Before: 3.56 Mb | Memory After: 3.57 Mb | Memory Used: 10.86 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 177
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0014269 | Memory Before: 3.56 Mb | Memory After: 3.57 Mb | Memory Used: 7.78 kb | Rows: 7 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 177
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 8Using index condition; 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.0003951 | Memory Before: 3.59 Mb | Memory After: 3.59 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 177
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 8Using where; Using index
0.0002582 | Memory Before: 3.59 Mb | Memory After: 3.59 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 177
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0005510 | Memory Before: 3.61 Mb | Memory After: 3.62 Mb | Memory Used: 9.51 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 176
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0005989 | Memory Before: 3.6 Mb | Memory After: 3.61 Mb | Memory Used: 7.37 kb | Rows: 4 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 176
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 5Using index condition; 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.0003669 | Memory Before: 3.62 Mb | Memory After: 3.62 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 176
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 5Using where; Using index
0.0002360 | Memory Before: 3.62 Mb | Memory After: 3.63 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 176
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003998 | Memory Before: 3.64 Mb | Memory After: 3.65 Mb | Memory Used: 9.49 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 175
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0005660 | Memory Before: 3.64 Mb | Memory After: 3.65 Mb | Memory Used: 7.22 kb | Rows: 3 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 175
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 4Using index condition; 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.0004151 | Memory Before: 3.65 Mb | Memory After: 3.66 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 175
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 4Using where; Using index
0.0002661 | Memory Before: 3.66 Mb | Memory After: 3.66 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 175
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0004010 | Memory Before: 3.67 Mb | Memory After: 3.68 Mb | Memory Used: 9.51 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 174
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0005970 | Memory Before: 3.67 Mb | Memory After: 3.68 Mb | Memory Used: 7.09 kb | Rows: 2 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 174
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 3Using index condition; 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.0003381 | Memory Before: 3.68 Mb | Memory After: 3.68 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 174
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 3Using where; Using index
0.0002379 | Memory Before: 3.68 Mb | Memory After: 3.69 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 174
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0007031 | Memory Before: 3.69 Mb | Memory After: 3.69 Mb | Memory Used: 7.09 kb | Rows: 2 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 180
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_iditem_id4const3Using 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.0003831 | Memory Before: 3.7 Mb | Memory After: 3.7 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 180
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 3Using where; Using index
0.0014272 | Memory Before: 3.7 Mb | Memory After: 3.71 Mb | Memory Used: 10.31 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 = 0 AND c.type_id = 'pages' AND c.item_id = 180 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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 
0.0010281 | Memory Before: 3.71 Mb | Memory After: 3.72 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 = 8435 AND c.type_id = 'pages' AND c.item_id = 180 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004649 | Memory Before: 3.72 Mb | Memory After: 3.73 Mb | Memory Used: 10.14 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 = 8435 AND c.type_id = 'pages' AND c.item_id = 180 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_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 
0.0002441 | Memory Before: 3.72 Mb | Memory After: 3.72 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 180
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003340 | Memory Before: 3.72 Mb | Memory After: 3.72 Mb | Memory Used: 5.63 kb | Rows: 2 | Slave: No
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
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'pages_comment' AND l.item_id = 180
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const2Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002339 | Memory Before: 3.72 Mb | Memory After: 3.73 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 180
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0004101 | Memory Before: 3.74 Mb | Memory After: 3.74 Mb | Memory Used: 9.53 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 178
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0005801 | Memory Before: 3.73 Mb | Memory After: 3.74 Mb | Memory Used: 7.09 kb | Rows: 2 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 178
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 3Using index condition; 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.0003679 | Memory Before: 3.74 Mb | Memory After: 3.74 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 178
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 3Using where; Using index
0.0014451 | Memory Before: 3.74 Mb | Memory After: 3.75 Mb | Memory Used: 10.35 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 = 0 AND c.type_id = 'pages' AND c.item_id = 178 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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 
0.0002310 | Memory Before: 3.76 Mb | Memory After: 3.76 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 = 8286 AND c.type_id = 'pages' AND c.item_id = 178 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004489 | Memory Before: 3.76 Mb | Memory After: 3.77 Mb | Memory Used: 10.15 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 = 8286 AND c.type_id = 'pages' AND c.item_id = 178 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_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 
0.0002408 | Memory Before: 3.76 Mb | Memory After: 3.77 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 178
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003319 | Memory Before: 3.76 Mb | Memory After: 3.77 Mb | Memory Used: 5.63 kb | Rows: 2 | Slave: No
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
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'pages_comment' AND l.item_id = 178
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const2Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002279 | Memory Before: 3.76 Mb | Memory After: 3.77 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 178
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0005250 | Memory Before: 3.78 Mb | Memory After: 3.79 Mb | Memory Used: 9.57 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 181
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0005600 | Memory Before: 3.78 Mb | Memory After: 3.78 Mb | Memory Used: 7.37 kb | Rows: 4 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 181
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 5Using index condition; 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.0003729 | Memory Before: 3.79 Mb | Memory After: 3.79 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 181
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 5Using where; Using index
0.0002260 | Memory Before: 3.8 Mb | Memory After: 3.8 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 181
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003579 | Memory Before: 3.8 Mb | Memory After: 3.8 Mb | Memory Used: 5.81 kb | Rows: 4 | Slave: No
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
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'pages_comment' AND l.item_id = 181
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const4Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002460 | Memory Before: 3.81 Mb | Memory After: 3.81 Mb | Memory Used: 5.45 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 181
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003750 | Memory Before: 3.82 Mb | Memory After: 3.83 Mb | Memory Used: 9.5 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 179
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0076339 | Memory Before: 3.81 Mb | Memory After: 3.82 Mb | Memory Used: 8.21 kb | Rows: 10 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 179
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_iditem_id4const12Using 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.0004401 | Memory Before: 3.85 Mb | Memory After: 3.85 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 179
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 11Using where; Using index
0.0002530 | Memory Before: 3.85 Mb | Memory After: 3.86 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 179
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003922 | Memory Before: 3.86 Mb | Memory After: 3.87 Mb | Memory Used: 6.38 kb | Rows: 10 | Slave: No
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
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'pages_comment' AND l.item_id = 179
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const10Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002270 | Memory Before: 3.87 Mb | Memory After: 3.88 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 179
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003722 | Memory Before: 3.88 Mb | Memory After: 3.89 Mb | Memory Used: 12.1 kb | Rows: 1 | Slave: Yes
SELECT photo.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 573)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 1869
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0009992 | Memory Before: 3.88 Mb | Memory After: 3.89 Mb | Memory Used: 8.63 kb | Rows: 13 | 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 = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 1869
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,const12Using 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.0002432 | Memory Before: 3.92 Mb | Memory After: 3.93 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 1869
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const12Using where; Using index
0.0016940 | Memory Before: 3.93 Mb | Memory After: 3.94 Mb | Memory Used: 10.56 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 = 0 AND c.type_id = 'photo' AND c.item_id = 1869 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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.0004559 | Memory Before: 3.95 Mb | Memory After: 3.95 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 = 7283 AND c.type_id = 'photo' AND c.item_id = 1869 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.0003889 | Memory Before: 3.95 Mb | Memory After: 3.96 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 = 7283 AND c.type_id = 'photo' AND c.item_id = 1869 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.0003400 | Memory Before: 3.96 Mb | Memory After: 3.96 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 = 5459 AND c.type_id = 'photo' AND c.item_id = 1869 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.0004370 | Memory Before: 3.96 Mb | Memory After: 3.97 Mb | Memory Used: 10.08 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 = 5459 AND c.type_id = 'photo' AND c.item_id = 1869 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.0002561 | Memory Before: 3.96 Mb | Memory After: 3.97 Mb | Memory Used: 5.46 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 1869
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0002480 | Memory Before: 3.97 Mb | Memory After: 3.97 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 1869
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0005949 | Memory Before: 3.98 Mb | Memory After: 3.99 Mb | Memory Used: 12.2 kb | Rows: 1 | Slave: Yes
SELECT photo.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 519)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 1728
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0010948 | Memory Before: 3.98 Mb | Memory After: 3.99 Mb | Memory Used: 8.22 kb | Rows: 10 | 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 = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 1728
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,const9Using 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.0002370 | Memory Before: 4.01 Mb | Memory After: 4.02 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 1728
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const9Using where; Using index
0.0011771 | Memory Before: 4.01 Mb | Memory After: 4.03 Mb | Memory Used: 10.65 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 = 0 AND c.type_id = 'photo' AND c.item_id = 1728 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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.0002060 | Memory Before: 4.04 Mb | Memory After: 4.04 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 = 7281 AND c.type_id = 'photo' AND c.item_id = 1728 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.0003750 | Memory Before: 4.04 Mb | Memory After: 4.05 Mb | Memory Used: 10.14 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 = 7281 AND c.type_id = 'photo' AND c.item_id = 1728 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.0006280 | Memory Before: 4.05 Mb | Memory After: 4.05 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 = 4982 AND c.type_id = 'photo' AND c.item_id = 1728 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,const3Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0008421 | Memory Before: 4.05 Mb | Memory After: 4.06 Mb | Memory Used: 10.91 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 = 4982 AND c.type_id = 'photo' AND c.item_id = 1728 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,const3Using 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.0002248 | Memory Before: 4.07 Mb | Memory After: 4.08 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 = 5001 AND c.type_id = 'photo' AND c.item_id = 1728 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.0004468 | Memory Before: 4.08 Mb | Memory After: 4.09 Mb | Memory Used: 10.43 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 = 5001 AND c.type_id = 'photo' AND c.item_id = 1728 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.0002322 | Memory Before: 4.09 Mb | Memory After: 4.09 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 = 5012 AND c.type_id = 'photo' AND c.item_id = 1728 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.0003741 | Memory Before: 4.09 Mb | Memory After: 4.1 Mb | Memory Used: 10.17 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 = 5012 AND c.type_id = 'photo' AND c.item_id = 1728 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.0002060 | Memory Before: 4.1 Mb | Memory After: 4.1 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 = 5007 AND c.type_id = 'photo' AND c.item_id = 1728 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.0004430 | Memory Before: 4.1 Mb | Memory After: 4.11 Mb | Memory Used: 10.44 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 = 5007 AND c.type_id = 'photo' AND c.item_id = 1728 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.0001950 | Memory Before: 4.11 Mb | Memory After: 4.11 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 = 5010 AND c.type_id = 'photo' AND c.item_id = 1728 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: 4.11 Mb | Memory After: 4.12 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 = 5010 AND c.type_id = 'photo' AND c.item_id = 1728 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.0002072 | Memory Before: 4.12 Mb | Memory After: 4.12 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 = 5015 AND c.type_id = 'photo' AND c.item_id = 1728 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.0003929 | Memory Before: 4.12 Mb | Memory After: 4.13 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 = 5015 AND c.type_id = 'photo' AND c.item_id = 1728 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.0002668 | Memory Before: 4.11 Mb | Memory After: 4.11 Mb | Memory Used: 5.46 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 1728
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0002570 | Memory Before: 4.11 Mb | Memory After: 4.12 Mb | Memory Used: 5.46 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 1728
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0007830 | Memory Before: 4.13 Mb | Memory After: 4.14 Mb | Memory Used: 12.22 kb | Rows: 1 | Slave: Yes
SELECT photo.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 616)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 2094
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0039930 | Memory Before: 4.12 Mb | Memory After: 4.13 Mb | Memory Used: 8.79 kb | Rows: 14 | 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 = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2094
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,const12Using 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.0002639 | Memory Before: 4.17 Mb | Memory After: 4.18 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2094
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const12Using where; Using index
0.0004730 | Memory Before: 4.17 Mb | Memory After: 4.18 Mb | Memory Used: 10.44 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 = 0 AND c.type_id = 'photo' AND c.item_id = 2094 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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 
0.0002372 | Memory Before: 4.2 Mb | Memory After: 4.2 Mb | Memory Used: 3.15 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 = 7280 AND c.type_id = 'photo' AND c.item_id = 2094 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004051 | Memory Before: 4.2 Mb | Memory After: 4.21 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 = 7280 AND c.type_id = 'photo' AND c.item_id = 2094 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_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 
0.0002520 | Memory Before: 4.2 Mb | Memory After: 4.21 Mb | Memory Used: 5.46 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 2094
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0002902 | Memory Before: 4.21 Mb | Memory After: 4.21 Mb | Memory Used: 5.45 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 2094
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0126781 | Memory Before: 4.22 Mb | Memory After: 4.23 Mb | Memory Used: 9.57 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 163
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0014589 | Memory Before: 4.21 Mb | Memory After: 4.22 Mb | Memory Used: 9.06 kb | Rows: 16 | 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 163
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 17Using index condition; 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.0003901 | Memory Before: 4.27 Mb | Memory After: 4.27 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 163
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 17Using where; Using index
0.0002410 | Memory Before: 4.27 Mb | Memory After: 4.28 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 163
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0004401 | Memory Before: 4.28 Mb | Memory After: 4.29 Mb | Memory Used: 6.94 kb | Rows: 16 | Slave: No
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
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'pages_comment' AND l.item_id = 163
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const16Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002551 | Memory Before: 4.3 Mb | Memory After: 4.31 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-comment" AND a.item_id = 163
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0007069 | Memory Before: 4.3 Mb | Memory After: 4.32 Mb | Memory Used: 12.29 kb | Rows: 1 | Slave: Yes
SELECT photo.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 643)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 2169
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0006199 | Memory Before: 4.3 Mb | Memory After: 4.31 Mb | Memory Used: 8.06 kb | Rows: 9 | 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 = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2169
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,const8Using 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.0002420 | Memory Before: 4.33 Mb | Memory After: 4.34 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2169
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const8Using where; Using index
0.0002711 | Memory Before: 4.34 Mb | Memory After: 4.34 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 2169
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0002649 | Memory Before: 4.35 Mb | Memory After: 4.35 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 2169
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0044580 | Memory Before: 4.36 Mb | Memory After: 4.37 Mb | Memory Used: 12.11 kb | Rows: 1 | Slave: Yes
SELECT photo.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 630)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 2128
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0006409 | Memory Before: 4.36 Mb | Memory After: 4.37 Mb | Memory Used: 8.06 kb | Rows: 9 | 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 = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2128
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,const8Using 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.0002542 | Memory Before: 4.39 Mb | Memory After: 4.4 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2128
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const8Using where; Using index
0.0160329 | Memory Before: 4.39 Mb | Memory After: 4.4 Mb | Memory Used: 10.56 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 = 0 AND c.type_id = 'photo' AND c.item_id = 2128 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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.0005150 | Memory Before: 4.42 Mb | Memory After: 4.42 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 = 6366 AND c.type_id = 'photo' AND c.item_id = 2128 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.0003681 | Memory Before: 4.42 Mb | Memory After: 4.43 Mb | Memory Used: 10.16 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 = 6366 AND c.type_id = 'photo' AND c.item_id = 2128 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.0002241 | Memory Before: 4.43 Mb | Memory After: 4.43 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 = 6334 AND c.type_id = 'photo' AND c.item_id = 2128 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.0003998 | Memory Before: 4.43 Mb | Memory After: 4.44 Mb | Memory Used: 10.07 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 = 6334 AND c.type_id = 'photo' AND c.item_id = 2128 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.0002532 | Memory Before: 4.43 Mb | Memory After: 4.43 Mb | Memory Used: 5.45 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 2128
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0002730 | Memory Before: 4.43 Mb | Memory After: 4.44 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 2128
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0004170 | Memory Before: 4.45 Mb | Memory After: 4.46 Mb | Memory Used: 12.17 kb | Rows: 1 | Slave: Yes
SELECT photo.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 623)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 2121
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0005159 | Memory Before: 4.44 Mb | Memory After: 4.45 Mb | Memory Used: 7.22 kb | Rows: 3 | 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 = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2121
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,const3Using 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.0002282 | Memory Before: 4.46 Mb | Memory After: 4.46 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2121
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const3Using where; Using index
0.0004690 | Memory Before: 4.46 Mb | Memory After: 4.47 Mb | Memory Used: 10.64 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 = 0 AND c.type_id = 'photo' AND c.item_id = 2121 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* 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.0002971 | Memory Before: 4.48 Mb | Memory After: 4.48 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 = 6365 AND c.type_id = 'photo' AND c.item_id = 2121 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.0003839 | Memory Before: 4.48 Mb | Memory After: 4.49 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 = 6365 AND c.type_id = 'photo' AND c.item_id = 2121 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.0002689 | Memory Before: 4.49 Mb | Memory After: 4.49 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 = 6335 AND c.type_id = 'photo' AND c.item_id = 2121 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.0004311 | Memory Before: 4.49 Mb | Memory After: 4.5 Mb | Memory Used: 10.13 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 = 6335 AND c.type_id = 'photo' AND c.item_id = 2121 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.0003090 | Memory Before: 4.49 Mb | Memory After: 4.49 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 2121
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0004139 | Memory Before: 4.49 Mb | Memory After: 4.5 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 2121
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0006390 | Memory Before: 4.49 Mb | Memory After: 4.49 Mb | Memory Used: 5.53 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
FROM phpfox_user AS u
WHERE user_id IN (178,178,178,178,178,178,178,178,178,178,178,178,178,178)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangePRIMARY,user_idPRIMARY4 1Using index condition
0.0004511 | Memory Before: 4.26 Mb | Memory After: 4.27 Mb | Memory Used: 5.43 kb | Rows: 0 | 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
FROM phpfox_pages_admin AS pa
     JOIN phpfox_user AS u
            ON(u.user_id = pa.user_id)

WHERE pa.page_id = 40
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEparefpage_id_2,page_id,user_idpage_id_24const1Using index
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.pa.user_id1 
0.0100992 | Memory Before: 4.29 Mb | Memory After: 4.29 Mb | Memory Used: 7.1 kb | Rows: 8 | Slave: Yes
SELECT s.shout_id, s.text, s.time_stamp, 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_pages_shoutbox AS s
     JOIN phpfox_user AS u
            ON(u.user_id = s.user_id)

WHERE item_id = 40
ORDER BY s.time_stamp DESC
LIMIT 40
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefuser_id,item_iditem_id4const8Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.s.user_id1 
Array
(
    [session] => a12d225c76cf758cdfe434f3c54becce
    [redirect] => /pages/40/
)