{{title}}

{{message}}

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

محمد آقامیری

زندگی میکند در اصفهان, ایران · متولد 3 آبان, 1997
کد امنیتی
محمد آقامیری
الإمامُ الصّادقُ عليه السلام : أشَدُّ النّاسِ عَذابا عالِمٌ لا يُنتَفَعُ مِن عِلمِهِ بِشَيءٍ

امام صادق عليه السلام می فرمایند : در ميان مردمان [گنهكار ]سخت ترين عذاب را عالمى دارد، كه از علم خود كمترين سودى نبرد

بحارالانوار
محمد آقامیری
  • 19 مرداد, 1394
  • ·
  • احسنت!
محمد آقامیری
إلهی، از نماز و روزه ام توبه کردم، به حق اهل نماز و روزه ات توبۀ این نا اهل را بپذیر!

آیت الله حسن زاده

برگرفته از ghasedoon.blog.ir
محمد آقامیری
نیز
إلهی، لذت گرسنگی را در کامم برکت ده!
  • 14 تیر, 1394
  • ·
  • احسنت!
محمد آقامیری
Hrdhk Hf rxu ani hsj.
محمد امين زماني
ینی دیونه تر از من خودمم که نشستم متنای اینا رو دوبله کردم.. :|
  • 15 شهریور, 1393
  • ·
  • احسنت!
علی عباسی
hdkh v, fi [k'g ld ;kn!!!
  • 15 شهریور, 1393
  • ·
  • احسنت!
محمد امين زماني
:| ildks ;i is...
  • 16 شهریور, 1393
  • ·
  • احسنت!
محمدرضا بدیعی
Hrh [lua ;kdn hdk lqudjh
huwhfl,k o,vn an.
  • 17 شهریور, 1393
  • ·
  • احسنت!
علی صفار
odgd og isjdn1
  • 22 شهریور, 1393
  • ·
  • احسنت!
محمد آقامیری
شهادت امام صادق (ع) تسلیت باد
محمدسجاد احمدی
آخر یه روز شیعه برات حرم می سازه
  • 31 مرداد, 1393
  • ·
  • احسنت!
محمدسجاد احمدی
و ان شاء الله قبلش از گناه پاک می شویم که هر روز دل فرزندتان را خون نکنیم
  • 31 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری
محمد آقامیری
محمد آقامیری
شهادت رئيس مكتب جعفري امام ششم شيعيان "الصادق البارّ" تسليت باد
محمد آقامیری
سوره نساء

إِنَّ الَّذِينَ يَكْفُرُونَ بِاللّهِ وَرُسُلِهِ وَيُرِيدُونَ أَن يُفَرِّقُواْ بَيْنَ اللّهِ وَرُسُلِهِ وَيقُولُونَ نُؤْمِنُ بِبَعْضٍ وَنَكْفُرُ بِبَعْضٍ وَيُرِيدُونَ أَن يَتَّخِذُواْ بَيْنَ ذَلِكَ سَبِيلاً
(150)
أُوْلَـئِكَ هُمُ الْكَافِرُونَ حَقًّا وَأَعْتَدْنَا لِلْكَافِرِينَ عَذَابًا مُّهِينًا
(151)

"حسبنا ...."
محمد آقامیری
وَالَّذِينَ آمَنُواْ بِاللّهِ وَرُسُلِهِ وَلَمْ يُفَرِّقُواْ بَيْنَ أَحَدٍ مِّنْهُمْ أُوْلَـئِكَ سَوْفَ يُؤْتِيهِمْ أُجُورَهُمْ وَكَانَ اللّهُ غَفُورًا رَّحِيمًا

(152) نساء
  • 19 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری
حاج میثم مطیعی - شب پنجم محرم 92 - واحد (از زبان قبرستان بقیع): مرا می‌شناسی بقیعم، منم قبله گاه غریبان
8:28
محمد آقامیری
"....
پيشينه قبرستان بقيع

بقيع اولين مدفن و مزارى است که به دستور رسول‌اکرم(صلی الله علیه و آله و سلم) و به‌وسيله مسلمانان صدراسلام به‌وجودآمده است. در بقيع اولين کسى که از انصار دفن شده اسعدبن زراره و از مهاجرين عثمان بن مظعون مى‌باشد. سمهودى مى‌گويد: پس از فوت ابراهيم فرزند رسول خدا(صلی الله علیه و آله و سلم) آن حضرت به صحابه فرمودند:‌”ابراهيم رابه سلف ما عثمان لاحق کنيد و در کنار او به خاک بسپاريد.” او مى‌گويد پس از دفن شدن ابراهيم در بقيع، مردم مدينه علاقه‌مند شدند پيکر اقوام و عشيره خود را در آنجا دفن کنند و هر يک از قبايل مدينه درختان و ريشه‌هاى بخشى از بقيع را قطع و زمين آن را براى همين منظور آماده نمودند.
تخريب بقيع

روز هشتم شوال سال 1344هجرى قمرى روزى سياه براى مسلمانان جهان به‌شمار مى‌رود. در اين روزها وهابيان دين‌ناشناس حرم امامان معصوم بقيع را با خاک يکسان کردند. بنابر نقل مورخان آ...
محمد آقامیری
بخوانید در http://rasekhoon.net/article/show/107836/%D8%BA%D8... (%D8%B9%D9%84%DB%8C%D9%87%D9%85-%D8%A7%D9%84%D8%B3%D9%84%D8%A7%D9%85)/
  • 14 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری
هست کمیت اشغال جهان را میزان
هست کیفیت احکام فلک را معیار
محمد آقامیری
صدای آمدنت را به گوش ما برسان
زمان غیبت خود را به انتها برسان

نگاه نافذ خود را بر این گدا انداز
برای درد نهفته ام کمی دوا برسان

اگر چه بر ظهورت نکرده ام کاری
بیا و بر لب ما فرصت دعا برسان

به صبح جمعه ی موعود زائرم فرما
به خاکبوس روز فرج مرا برسان
محمد آقامیری
http://emam8.com/%D8%A7%D8%B4%D8%B9%D8%A7%D8%B1-%D... (%D8%B9%D8%AC)/15632-%D8%B4%D8%B9%D8%B1%DB%8C-%D8%AF%D8%B1-%D9%81%D8%B1%D8%A7%D9%82-%D8%A7%D9%85%D8%A7%D9%85-%D8%B2%D9%85% D8%A7%D9%86(%D8%B9%D8%AC)--(-%D8%B5%D8%AF%D8%A7%DB%8C-%D8%A2%D9%85%D8%AF%D9%86%D8%AA-%D8%B1%D8%A7-%D8%A8%D9%87-%DA%AF%D9%88%D8%B4-%D9%85%D8%A7-%D8%A8%D8%B1%D8%B3%D8%A7%D9%86-).html
  • 11 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری
نمیشه انگار لینکش رو گذاشت!
  • 11 مرداد, 1393
  • ·
  • احسنت!
علی انواری
بیت سوم ظاهرا این طوری بهتره:
اگر چه "محض" ظهورت نکرده ام کاری...
  • 11 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری
من اشتباه نوشتم درستش اینه:
اگر چه بهر ظهورت نکرده ام کاری
  • 14 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری
محمد آقامیری
دبیرستان شهید اژه ای است؟
  • 11 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری

إلهی، حسینِ شیرخوارِ حسن را به حسن ببخش و حسن را به شیرخوار حسین!
محمد آقامیری
حسن حسن زاده آملی (مد ظله)

برگرفته از http://ghasedoon.blog.ir/1392/12/13/%D9%85%D8%AA%D...
  • 10 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری
الهی نامه
  • 10 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری
بسم الله الرحمن الرحیم

إلهی، به حق خودت حضورم ده و از جمال آفتاب آفرینت نورم ده!

إلهی، راز دل را نهفتن دشوار است و گفتن دشوارتر.

إلهی، «یا مَن یعفو عن الکثیر و یعطی الکثیر بالقلیل»، از زحمت کثرتم وا رَهان، و رحمتِ وحدتم ده!

إلهی، سالیانی می‌پنداشتم که ما حافظ دین توایم، «أستغفِرُکَ اللهُمَّ !» در این لیل‍ة الرّغائب 1390 ه.ق. فهمیدم که دین تو حافظ ماست، «ألحمدک اللهُمّ!».

إلهی، چگونه خاموش باشم که دل در جوش و خروش است، و چگونه سخن گویم که خِرَد مدهوش و بیهوش است.

إلهی، ما همه بی‌چاره‌ایم و تنها تو چاره‌ای، و ما همه هیچ کاره‌ایم و تنها تو کاره‌ای.

إلهی، از پای تا فرقم، در نور تو غرقم. «یا نورَ السموات و الأرض، أنعَمْتَ فَزِدْ!»

إلهی، شأن این کلمۀکوچک که به این علوّ و عظمت است، پس «یا علی یا عظیم»، شأنِ متکلّمِ این همه کلمات شگفت لاتتناهی چون خواهد بود؟

إلهی، وای بر من اگر دانشم رهزنم شود و کتابم حجاب...
محمد آقامیری
آیت الله حسن زاده (مد ظله)
  • 9 مرداد, 1393
  • ·
  • احسنت!
علی عباسی
خیلی قشنگ اند! اما ای کاش هدفمند تر میذاشتیشون!
  • 9 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری
بی‌دل گمان مبر که نصیحت کند قبول
من گوش استماع ندارم لمن تقول؟
تا عقل داشتم نگرفتم طریق عشق
جایی دلم برفت که حیران شود عقول!
  • 9 مرداد, 1393
  • ·
  • احسنت!
محمد آقامیری
محمد آقامیری


فرزند آیت‌الله سیدرضا بهاءالدینی گفت : وقتی جوانان از پدر راهنمایی می‌خواستند ایشان بر دروغ نگفتن تأکید می‌کردند و می‌گفتند تارک محرمات و فاعل بر واجبات باشید.

 

به گزارش راسخون به نقل از تسنیم، حجت الاسلام سید عبدالله بهاءالدینی، فرزند آیت‌الله سید رضا بهاءالدینی در برنامه ضیافت شبکه قرآن و معارف سیما اظهار کرد: ایشان زندگی ساده‌ای داشتند و 50سال در خانه‌ای زندگی کردند که کوچکترین امکاناتی نداشت، اما با همین سادگی هرگاه که مهمانی می‌آمد و افرادی به نزد ایشان می‌آمدند تا ملاقاتشان کنند با روی باز پذیرای آنان بودند.

 

وی ادامه داد: ایشان یک سماور کوچک ذغالی داشتند که وقتی مهمان می‌آمد خودشان کنار سماور می‌نشستند و برای مهمان که مهم هم نبود چه کسی باشد چای می‌ریختند و اگر سؤالی داشتند با رویی باز پاسخگوی آنان بودند.

 

حجت الاسلام بهاءالدینی در رابطه با زندگی ساده آیت‌الله بهاءالدینی تصریح ک...

محمد آقامیری
یــا عـــلی یا مولـا ای نگار زهـــرا یا حیــــدر یا حیــــدر یا مرتضـــی
محمد آقامیری
ای به خاتم نگین ای امام المتقین ذکر هر مومن بود یا امیرالمومنین
  • 28 تیر, 1393
  • ·
  • احسنت!
محمد آقامیری
محمد آقامیری
امام علی (علیه السلام) فرمودند: خردمندترین مردم کسی است که به عواقب و فرجام کار بیشتر بنگرد. شهادت مولای متقیان بر آقا امام زمان (عج) و بر همه ی شیعیان و محبینشان تسلیت باد
محمد آقامیری
  • 28 تیر, 1393
  • ·
  • احسنت!
محمد آقامیری
محمد آقامیری
بی‌دل گمان مبر که نصیحت کند قبول
من گوش استماع ندارم لمن یقول
تا عقل داشتم نگرفتم طریق عشق
جایی دلم برفت که حیران شود عقول
آخر نه دل به دل رود انصاف من بده
چونست من به وصل تو مشتاق و تو ملول
یک دم نمی‌رود که نه در خاطری ولیک
بسیار فرق باشد از اندیشه تا وصول
روزی سرت ببوسم و در پایت اوفتم
پروانه را چه حاجت پروانه دخول
گنجشک بین که صحبت شاهینش آرزوست
بیچاره در هلاک تن خویشتن عجول
نفسی تزول عاقبه الامر فی الهوی
یا منیتی و ذکرک فی النفس لایزول
ما را بجز تو در همه عالم عزیز نیست
گر رد کنی بضاعت مزجاه ور قبول
ای پیک نامه بر که خبر می‌بری به دوست
یالیت اگر به جای تو من بودمی رسول
دوران دهر و تجربتم سر سپید کرد
وز سر به در نمی‌رودم همچنان فضول
سعدی چو پای بند شدی بار غم ببر
عیار دست بسته نباشد مگر حمول
نمایش بیشتر
phpFox Developers Debug Toggle JavaScript Console
Version:
3.7.7
Product Code Name:
Nebula

Total Time:
1.1089821
PHP General Time:
0.9929263
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.1160558
SQL Queries:
195
SQL Memory Usage:
1.27 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
4.66 Mb
Total Memory Usage (Including Debug):
5.22 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
185.55.227.64


Server Time Stamp:
January 22, 2018, 12:20 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.0022020 | Memory Before: 751.46 kb | Memory After: 752.81 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 ('78d450c2ebda643145220f7fc4ad63fd', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516580446', '/profile-86/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0002410 | Memory Before: 919.7 kb | Memory After: 925.07 kb | Memory Used: 5.38 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.0009501 | Memory Before: 1.23 Mb | Memory After: 1.27 Mb | Memory Used: 35.81 kb | Rows: 1 | Slave: Yes
SELECT p.photo_id as cover_photo_exists, u.*, user_space.*, user_field.*, user_activity.*, ls.user_id AS is_online, 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, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured
FROM phpfox_user AS u
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = u.user_group_id)
     JOIN phpfox_user_space AS user_space
            ON(user_space.user_id = u.user_id)
     JOIN phpfox_user_field AS user_field
            ON(user_field.user_id = u.user_id)
     JOIN phpfox_user_activity AS user_activity
            ON(user_activity.user_id = u.user_id)
     LEFT JOIN phpfox_theme_style AS ts
            ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
     LEFT JOIN phpfox_theme AS t
            ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_user_featured AS uf
            ON(uf.user_id = u.user_id)
     LEFT JOIN phpfox_log_session AS ls
            ON(ls.user_id = u.user_id AND ls.im_hide = 0)
     LEFT JOIN phpfox_photo AS p
            ON(p.photo_id = user_field.cover_photo)

WHERE u.user_name = 'profile-86'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefPRIMARY,user_name,user_group_id,user_iduser_name103const1Using index condition
1SIMPLEugeq_refPRIMARY,user_group_idPRIMARY1majmaih1_majma.u.user_group_id1Using index condition
1SIMPLEuser_spaceeq_refuser_iduser_id4majmaih1_majma.u.user_id1 
1SIMPLEuser_fieldeq_refuser_iduser_id4majmaih1_majma.u.user_id1 
1SIMPLEtsrefstyle_id,is_active,style_id_2style_id_22majmaih1_majma.user_field.designer_style_id1Using where
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2majmaih1_majma.ts.theme_id1 
1SIMPLEuser_activityeq_refuser_iduser_id4majmaih1_majma.u.user_id1 
1SIMPLEufeq_refPRIMARYPRIMARY4majmaih1_majma.u.user_id1Using index
1SIMPLElsrefuser_id,user_id_2,user_id_3user_id_24majmaih1_majma.u.user_id44411Using where
1SIMPLEpeq_refPRIMARY,photo_id,photo_id_2PRIMARY4majmaih1_majma.user_field.cover_photo1Using index
0.0004570 | Memory Before: 1.41 Mb | Memory After: 1.41 Mb | Memory Used: 4.13 kb | Rows: 14 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 86
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_privacyrefuser_id,user_id_2user_id_24const14 
0.0003650 | Memory Before: 1.53 Mb | Memory After: 1.54 Mb | Memory Used: 3.26 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo
WHERE view_id = 0 AND group_id = 0 AND user_id = 86
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photorefview_id_2,view_id,view_id_3,view_id_4,view_id_5,user_iduser_id4const48Using where
0.0001881 | Memory Before: 1.63 Mb | Memory After: 1.63 Mb | Memory Used: 3.14 kb | Rows: 1 | Slave: No
SELECT COUNT(sud.id)
FROM phpfox_ebooks_user_shelf AS sud
WHERE sud.user_id = 86
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsudALL MISSING KEY   19Using where
0.0006289 | Memory Before: 1.67 Mb | Memory After: 1.67 Mb | Memory Used: 3.27 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_event
WHERE view_id = 0 AND item_id = 0 AND user_id = 86 AND start_time > 1516579200
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_eventrefuser_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5user_id4const1Using where
0.0161881 | Memory Before: 2.77 Mb | Memory After: 2.78 Mb | Memory Used: 12.88 kb | Rows: 22 | Slave: Yes
SELECT feed.*, apps.app_title, 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 (
( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.type_id = 'friend' AND feed.user_id = 86
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN(0) AND type_id = 'feed_comment' AND feed.user_id = 86
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN(0) AND feed.user_id = 86 AND feed.feed_reference = 0 AND feed.parent_user_id = 0
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN(0) AND feed.parent_user_id = 86
/* OO Query */)) AS feed
     JOIN phpfox_user AS u
            ON(u.user_id = feed.user_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = feed.app_id)

GROUP BY feed.feed_id
ORDER BY feed.time_stamp DESC
LIMIT 22
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYappssystemPRIMARY,app_idMISSING KEY    const row not found
1PRIMARY<derived2>ALL MISSING KEY   640Using temporary; Using filesort
1PRIMARYueq_refPRIMARY,user_idPRIMARY4feed.user_id1 
2DERIVEDfeedreftype_id,user_idtype_id77const218Using index condition; Using where
3UNIONfeedrefprivacy_2,privacy_3,privacy_4,type_id,privacy,privacy_5,user_idtype_id77const100Using index condition; Using where
4UNIONfeedrefprivacy_2,privacy_3,privacy_4,privacy,privacy_5,user_idprivacy_39const,const,const286Using where
5UNIONfeedrefprivacy_2,privacy_3,privacy_4,privacy,privacy_5privacy_55const,const36 
 UNION RESULT<union2,3,4,5>ALL MISSING KEY    Using temporary
0.0014651 | Memory Before: 3.01 Mb | Memory After: 3.01 Mb | Memory Used: 6.95 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2594
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0018210 | Memory Before: 3 Mb | Memory After: 3.01 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2594
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 11Using 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.0003362 | Memory Before: 3.05 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 = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2594
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 11Using where; Using index
0.0025752 | Memory Before: 3.07 Mb | Memory After: 3.08 Mb | Memory Used: 10.45 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 = 'user_status' AND c.item_id = 2594 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.0005128 | Memory Before: 3.09 Mb | Memory After: 3.09 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 = 24719 AND c.type_id = 'user_status' AND c.item_id = 2594 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.0004280 | Memory Before: 3.09 Mb | Memory After: 3.1 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 = 24719 AND c.type_id = 'user_status' AND c.item_id = 2594 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.0002439 | Memory Before: 3.09 Mb | Memory After: 3.1 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 = "user-status" AND a.item_id = 2594
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.0002789 | Memory Before: 3.1 Mb | Memory After: 3.11 Mb | Memory Used: 5.47 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 = "user-status" AND a.item_id = 2594
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.0007291 | Memory Before: 3.11 Mb | Memory After: 3.12 Mb | Memory Used: 5.66 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2570
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0009692 | Memory Before: 3.1 Mb | Memory After: 3.11 Mb | Memory Used: 9.49 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2570
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 16Using 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.0003438 | Memory Before: 3.17 Mb | Memory After: 3.17 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2570
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 16Using where; Using index
0.0008650 | Memory Before: 3.17 Mb | Memory After: 3.18 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 = 'user_status' AND c.item_id = 2570 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.0001938 | Memory Before: 3.19 Mb | Memory After: 3.2 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 = 24412 AND c.type_id = 'user_status' AND c.item_id = 2570 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.0003760 | Memory Before: 3.19 Mb | Memory After: 3.2 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 = 24412 AND c.type_id = 'user_status' AND c.item_id = 2570 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.0002611 | Memory Before: 3.2 Mb | Memory After: 3.2 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 = "user-status" AND a.item_id = 2570
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.0002759 | Memory Before: 3.21 Mb | Memory After: 3.21 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 = "user-status" AND a.item_id = 2570
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.0009942 | Memory Before: 3.22 Mb | Memory After: 3.22 Mb | Memory Used: 5.62 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2179
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0006189 | Memory Before: 3.21 Mb | Memory After: 3.21 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2179
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_id4const2Using 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.0003309 | Memory Before: 3.22 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 = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2179
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_iditem_id4const2Using where
0.0019588 | Memory Before: 3.22 Mb | Memory After: 3.23 Mb | Memory Used: 10.9 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 = 'user_status' AND c.item_id = 2179 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,const3Using 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.0006220 | Memory Before: 3.24 Mb | Memory After: 3.25 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 = 19339 AND c.type_id = 'user_status' AND c.item_id = 2179 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: 3.25 Mb | Memory After: 3.26 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 = 19339 AND c.type_id = 'user_status' AND c.item_id = 2179 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.0002570 | Memory Before: 3.25 Mb | Memory After: 3.26 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 = 19234 AND c.type_id = 'user_status' AND c.item_id = 2179 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: 3.26 Mb | Memory After: 3.27 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 = 19234 AND c.type_id = 'user_status' AND c.item_id = 2179 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.0002298 | Memory Before: 3.26 Mb | Memory After: 3.27 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 = 19201 AND c.type_id = 'user_status' AND c.item_id = 2179 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.0005150 | Memory Before: 3.27 Mb | Memory After: 3.28 Mb | Memory Used: 10.42 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 = 19201 AND c.type_id = 'user_status' AND c.item_id = 2179 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.0002222 | Memory Before: 3.28 Mb | Memory After: 3.28 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 = 19204 AND c.type_id = 'user_status' AND c.item_id = 2179 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.0005488 | Memory Before: 3.28 Mb | Memory After: 3.29 Mb | Memory Used: 10.42 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 = 19204 AND c.type_id = 'user_status' AND c.item_id = 2179 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.0002348 | Memory Before: 3.29 Mb | Memory After: 3.3 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 = 19214 AND c.type_id = 'user_status' AND c.item_id = 2179 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.0003881 | Memory Before: 3.29 Mb | Memory After: 3.3 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 = 19214 AND c.type_id = 'user_status' AND c.item_id = 2179 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.0002410 | Memory Before: 3.28 Mb | Memory After: 3.29 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 = "user-status" AND a.item_id = 2179
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.0002780 | Memory Before: 3.28 Mb | Memory After: 3.29 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 = "user-status" AND a.item_id = 2179
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.0025289 | Memory Before: 3.3 Mb | Memory After: 3.31 Mb | Memory Used: 15.2 kb | Rows: 1 | Slave: Yes
SELECT 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, photo.*, l.like_id AS is_liked, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, pfeed.feed_id
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = photo.parent_user_id)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_like AS l
            ON((l.type_id = 'photo' OR l.type_id = 'advancedphoto') AND l.item_id = photo.photo_id AND l.user_id = 0)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 24381)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4744
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const unique row not found
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_285 2Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0009630 | Memory Before: 3.34 Mb | Memory After: 3.35 Mb | Memory Used: 7.95 kb | Rows: 8 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "advancedphoto")

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4744
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,const6Using 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.0002201 | Memory Before: 3.37 Mb | Memory After: 3.38 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4744
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const6Using where; Using index
0.0011299 | Memory Before: 3.38 Mb | Memory After: 3.39 Mb | Memory Used: 10.58 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 = 'advancedphoto' AND c.item_id = 4744 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.0002568 | Memory Before: 3.4 Mb | Memory After: 3.4 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 = 19065 AND c.type_id = 'advancedphoto' AND c.item_id = 4744 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.0003951 | Memory Before: 3.4 Mb | Memory After: 3.41 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 = 19065 AND c.type_id = 'advancedphoto' AND c.item_id = 4744 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.0002179 | 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 = 19064 AND c.type_id = 'advancedphoto' AND c.item_id = 4744 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.0004261 | Memory Before: 3.41 Mb | Memory After: 3.42 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 = 19064 AND c.type_id = 'advancedphoto' AND c.item_id = 4744 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.0001941 | Memory Before: 3.41 Mb | Memory After: 3.41 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 = "advancedphoto" AND a.item_id = 4744
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.0003150 | Memory Before: 3.41 Mb | Memory After: 3.41 Mb | Memory Used: 6.19 kb | Rows: 8 | 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 = 'advancedphoto' AND l.item_id = 4744
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.0002198 | Memory Before: 3.42 Mb | Memory After: 3.43 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 = "advancedphoto" AND a.item_id = 4744
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.0004849 | Memory Before: 3.43 Mb | Memory After: 3.44 Mb | Memory Used: 15.22 kb | Rows: 1 | Slave: Yes
SELECT 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, photo.*, l.like_id AS is_liked, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, pfeed.feed_id
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = photo.parent_user_id)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_like AS l
            ON((l.type_id = 'photo' OR l.type_id = 'advancedphoto') AND l.item_id = photo.photo_id AND l.user_id = 0)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 24380)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4743
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const unique row not found
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_285 2Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0004930 | Memory Before: 3.42 Mb | Memory After: 3.43 Mb | Memory Used: 7.38 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 = "advancedphoto")

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4743
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.0002339 | Memory Before: 3.44 Mb | Memory After: 3.44 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4743
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const3Using where; Using index
0.0002060 | Memory Before: 3.44 Mb | Memory After: 3.45 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 = "advancedphoto" AND a.item_id = 4743
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: 3.44 Mb | Memory After: 3.45 Mb | Memory Used: 5.82 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 = 'advancedphoto' AND l.item_id = 4743
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.0002301 | Memory Before: 3.45 Mb | Memory After: 3.46 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 = "advancedphoto" AND a.item_id = 4743
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.0004768 | Memory Before: 3.46 Mb | Memory After: 3.48 Mb | Memory Used: 15.07 kb | Rows: 1 | Slave: Yes
SELECT 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, photo.*, l.like_id AS is_liked, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, pfeed.feed_id
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = photo.parent_user_id)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_like AS l
            ON((l.type_id = 'photo' OR l.type_id = 'advancedphoto') AND l.item_id = photo.photo_id AND l.user_id = 0)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 24379)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4742
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const unique row not found
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_285 2Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0004759 | Memory Before: 3.45 Mb | Memory After: 3.46 Mb | Memory Used: 7.51 kb | Rows: 5 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "advancedphoto")

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4742
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,const4Using 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.0002940 | Memory Before: 3.47 Mb | Memory After: 3.48 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4742
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const4Using where; Using index
0.0002160 | Memory Before: 3.48 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 = "advancedphoto" AND a.item_id = 4742
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.0003641 | Memory Before: 3.48 Mb | Memory After: 3.49 Mb | Memory Used: 5.9 kb | Rows: 5 | 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 = 'advancedphoto' AND l.item_id = 4742
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.0002289 | 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 = "advancedphoto" AND a.item_id = 4742
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.0003409 | Memory Before: 3.5 Mb | Memory After: 3.51 Mb | Memory Used: 5.66 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2178
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0007370 | Memory Before: 3.49 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2178
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_id4const7Using 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.0003140 | 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 = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2178
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 7Using where; Using index
0.0002382 | Memory Before: 3.52 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 = "user-status" AND a.item_id = 2178
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.0002720 | Memory Before: 3.53 Mb | Memory After: 3.54 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 = "user-status" AND a.item_id = 2178
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.0007679 | Memory Before: 3.54 Mb | Memory After: 3.55 Mb | Memory Used: 5.61 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2144
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0007088 | Memory Before: 3.54 Mb | Memory After: 3.54 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2144
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.0003400 | Memory Before: 3.55 Mb | Memory After: 3.55 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2144
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 3Using where; Using index
0.0007341 | Memory Before: 3.55 Mb | Memory After: 3.56 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 = 'user_status' AND c.item_id = 2144 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.0004220 | Memory Before: 3.56 Mb | Memory After: 3.57 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 = 18813 AND c.type_id = 'user_status' AND c.item_id = 2144 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.0003841 | Memory Before: 3.57 Mb | Memory After: 3.58 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 = 18813 AND c.type_id = 'user_status' AND c.item_id = 2144 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.0002382 | Memory Before: 3.57 Mb | Memory After: 3.57 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 = "user-status" AND a.item_id = 2144
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.0002530 | Memory Before: 3.57 Mb | Memory After: 3.57 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 = "user-status" AND a.item_id = 2144
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.0010989 | Memory Before: 3.58 Mb | Memory After: 3.59 Mb | Memory Used: 10.61 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, link.*, p.app_id, a.image_path AS app_image_path, 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_link AS link
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'link' AND l.item_id = link.link_id AND l.user_id = 0)
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = link.parent_user_id)
     LEFT JOIN phpfox_pages AS p
            ON(p.page_id = u.profile_page_id)
     LEFT JOIN phpfox_app AS a
            ON(a.app_id = p.app_id)

WHERE link.link_id = 303
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEasystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLElinkconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEpeq_refPRIMARY,page_idPRIMARY4majmaih1_majma.u.profile_page_id1 
0.0008008 | Memory Before: 3.58 Mb | Memory After: 3.59 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 = "link")

WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 303
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,const2Using 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: 3.59 Mb | Memory After: 3.6 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 303
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const2Using where; Using index
0.0010161 | Memory Before: 3.59 Mb | Memory After: 3.6 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 = 'link' AND c.item_id = 303 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.0002110 | Memory Before: 3.61 Mb | Memory After: 3.61 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 18777 AND c.type_id = 'link' AND c.item_id = 303 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.0003941 | Memory Before: 3.61 Mb | Memory After: 3.62 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 = 18777 AND c.type_id = 'link' AND c.item_id = 303 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.0002298 | Memory Before: 3.61 Mb | Memory After: 3.62 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 = "link" AND a.item_id = 303
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.0002100 | Memory Before: 3.61 Mb | Memory After: 3.62 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 = "link" AND a.item_id = 303
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.0006139 | Memory Before: 3.63 Mb | Memory After: 3.64 Mb | Memory Used: 15.2 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2134
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0004821 | Memory Before: 3.64 Mb | Memory After: 3.64 Mb | Memory Used: 6.95 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2134
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.0003741 | Memory Before: 3.64 Mb | Memory After: 3.65 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2134
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using where; Using index
0.0004079 | Memory Before: 3.65 Mb | Memory After: 3.66 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 = 'user_status' AND c.item_id = 2134 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.0001881 | Memory Before: 3.66 Mb | Memory After: 3.67 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 = 18776 AND c.type_id = 'user_status' AND c.item_id = 2134 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.0003729 | Memory Before: 3.66 Mb | Memory After: 3.67 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 = 18776 AND c.type_id = 'user_status' AND c.item_id = 2134 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.0002282 | Memory Before: 3.67 Mb | Memory After: 3.67 Mb | Memory Used: 5.44 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 = "user-status" AND a.item_id = 2134
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.0002229 | Memory Before: 3.67 Mb | Memory After: 3.68 Mb | Memory Used: 5.44 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 = "user-status" AND a.item_id = 2134
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.0002589 | Memory Before: 3.69 Mb | Memory After: 3.69 Mb | Memory Used: 5.7 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2133
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0004580 | Memory Before: 3.68 Mb | Memory After: 3.69 Mb | Memory Used: 6.8 kb | Rows: 0 | 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2133
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.0003178 | Memory Before: 3.68 Mb | Memory After: 3.69 Mb | Memory Used: 3.14 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2133
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using where; Using index
0.0002251 | Memory Before: 3.69 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 = "user-status" AND a.item_id = 2133
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.0002382 | Memory Before: 3.69 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 = "user-status" AND a.item_id = 2133
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.0003419 | Memory Before: 3.71 Mb | Memory After: 3.71 Mb | Memory Used: 5.63 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2131
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0006471 | Memory Before: 3.7 Mb | Memory After: 3.7 Mb | Memory Used: 7.51 kb | Rows: 5 | 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2131
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.0003550 | Memory Before: 3.72 Mb | Memory After: 3.72 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2131
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 5Using where; Using index
0.0006530 | Memory Before: 3.72 Mb | Memory After: 3.73 Mb | Memory Used: 10.8 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 = 'user_status' AND c.item_id = 2131 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.0001981 | Memory Before: 3.75 Mb | Memory After: 3.75 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 = 18764 AND c.type_id = 'user_status' AND c.item_id = 2131 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.0003531 | Memory Before: 3.75 Mb | Memory After: 3.76 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 = 18764 AND c.type_id = 'user_status' AND c.item_id = 2131 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.0001709 | Memory Before: 3.76 Mb | Memory After: 3.77 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 = 18771 AND c.type_id = 'user_status' AND c.item_id = 2131 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.0003350 | Memory Before: 3.76 Mb | Memory After: 3.77 Mb | Memory Used: 10.09 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 18771 AND c.type_id = 'user_status' AND c.item_id = 2131 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.0001740 | Memory Before: 3.77 Mb | Memory After: 3.77 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 = 18763 AND c.type_id = 'user_status' AND c.item_id = 2131 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.0003250 | Memory Before: 3.77 Mb | Memory After: 3.78 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 = 18763 AND c.type_id = 'user_status' AND c.item_id = 2131 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.0001640 | Memory Before: 3.78 Mb | Memory After: 3.78 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 = 18762 AND c.type_id = 'user_status' AND c.item_id = 2131 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.0003381 | Memory Before: 3.78 Mb | Memory After: 3.79 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 = 18762 AND c.type_id = 'user_status' AND c.item_id = 2131 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.0002291 | Memory Before: 3.77 Mb | Memory After: 3.78 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 = "user-status" AND a.item_id = 2131
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.0002820 | Memory Before: 3.78 Mb | Memory After: 3.78 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 = "user-status" AND a.item_id = 2131
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.0016210 | Memory Before: 3.8 Mb | Memory After: 3.81 Mb | Memory Used: 11.24 kb | Rows: 1 | Slave: Yes
SELECT false as is_friend, l.like_id AS is_liked, p.*, pd.background, pd.percentage, pd.border, pr.user_id as voted, pr.answer_id, 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_poll AS p
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'poll' AND l.item_id = p.poll_id AND l.user_id = 0)
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_poll_design AS pd
            ON(pd.poll_id = p.poll_id)
     LEFT JOIN phpfox_poll_result AS pr
            ON(pr.poll_id = p.poll_id AND pr.user_id = 0)

WHERE p.poll_id = 153
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEpdconstPRIMARYPRIMARY4const unique row not found
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
1SIMPLEprrefpoll_id,user_voteduser_voted8const,const1 
0.0004761 | Memory Before: 3.81 Mb | Memory After: 3.81 Mb | Memory Used: 4.16 kb | Rows: 2 | Slave: Yes
SELECT pa.*
FROM phpfox_poll_answer AS pa
WHERE pa.poll_id = 153
ORDER BY pa.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEparefpoll_idpoll_id4const2Using where; Using filesort
0.0003419 | Memory Before: 3.95 Mb | Memory After: 3.95 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'metro' AND type_id = 'block' AND module_id = 'poll' AND name = 'vote.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0005908 | Memory Before: 3.9 Mb | Memory After: 3.9 Mb | Memory Used: 6.95 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 = "poll")

WHERE (l.type_id = 'poll' OR l.type_id = 'poll') AND l.item_id = 153
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,const1Using 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.0002210 | Memory Before: 3.9 Mb | Memory After: 3.91 Mb | Memory Used: 3.16 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'poll' OR l.type_id = 'poll') AND l.item_id = 153
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where; Using index
0.0008581 | Memory Before: 3.91 Mb | Memory After: 3.92 Mb | Memory Used: 10.46 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 = 'poll' AND c.item_id = 153 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.0002651 | Memory Before: 3.92 Mb | Memory After: 3.92 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 = 18757 AND c.type_id = 'poll' AND c.item_id = 153 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.0003960 | Memory Before: 3.92 Mb | Memory After: 3.93 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 = 18757 AND c.type_id = 'poll' AND c.item_id = 153 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.0002770 | Memory Before: 3.93 Mb | Memory After: 3.93 Mb | Memory Used: 5.44 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 = "poll" AND a.item_id = 153
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.0002580 | Memory Before: 3.92 Mb | Memory After: 3.93 Mb | Memory Used: 5.56 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 = 'poll' AND l.item_id = 153
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.0002739 | Memory Before: 3.93 Mb | Memory After: 3.93 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 = "poll" AND a.item_id = 153
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.0005050 | Memory Before: 3.94 Mb | Memory After: 3.95 Mb | Memory Used: 5.61 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2127
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0005620 | Memory Before: 3.93 Mb | Memory After: 3.94 Mb | Memory Used: 7.5 kb | Rows: 5 | 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2127
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_id4const5Using 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.0003560 | Memory Before: 3.95 Mb | Memory After: 3.96 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2127
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 5Using where; Using index
0.0006950 | Memory Before: 3.95 Mb | Memory After: 3.96 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 = 'user_status' AND c.item_id = 2127 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.0002298 | Memory Before: 3.98 Mb | Memory After: 3.98 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 = 18740 AND c.type_id = 'user_status' AND c.item_id = 2127 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.0003331 | Memory Before: 3.98 Mb | Memory After: 3.99 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 = 18740 AND c.type_id = 'user_status' AND c.item_id = 2127 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.0001888 | Memory Before: 3.99 Mb | Memory After: 3.99 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 = 18739 AND c.type_id = 'user_status' AND c.item_id = 2127 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.0003691 | Memory Before: 3.99 Mb | Memory After: 4 Mb | Memory Used: 10.09 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 18739 AND c.type_id = 'user_status' AND c.item_id = 2127 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.0002480 | Memory Before: 3.99 Mb | Memory After: 3.99 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 = "user-status" AND a.item_id = 2127
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.0002482 | Memory Before: 3.99 Mb | Memory After: 4 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 = "user-status" AND a.item_id = 2127
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.0005541 | Memory Before: 4 Mb | Memory After: 4.03 Mb | Memory Used: 30.7 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2125
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0007041 | Memory Before: 4.04 Mb | Memory After: 4.05 Mb | Memory Used: 7.25 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2125
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.0003188 | Memory Before: 4.06 Mb | Memory After: 4.06 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2125
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 3Using where; Using index
0.0005519 | Memory Before: 4.06 Mb | Memory After: 4.07 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 = 'user_status' AND c.item_id = 2125 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.0001791 | Memory Before: 4.08 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 = 18731 AND c.type_id = 'user_status' AND c.item_id = 2125 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.0004301 | Memory Before: 4.08 Mb | Memory After: 4.09 Mb | Memory Used: 10.42 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 = 18731 AND c.type_id = 'user_status' AND c.item_id = 2125 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.0001669 | Memory Before: 4.1 Mb | Memory After: 4.1 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 = 18732 AND c.type_id = 'user_status' AND c.item_id = 2125 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.0003848 | Memory Before: 4.1 Mb | Memory After: 4.11 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 = 18732 AND c.type_id = 'user_status' AND c.item_id = 2125 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.0001888 | 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 = 18730 AND c.type_id = 'user_status' AND c.item_id = 2125 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.0003550 | Memory Before: 4.1 Mb | Memory After: 4.11 Mb | Memory Used: 10.2 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 = 18730 AND c.type_id = 'user_status' AND c.item_id = 2125 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.0002580 | Memory Before: 4.1 Mb | Memory After: 4.11 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 = "user-status" AND a.item_id = 2125
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.0002432 | Memory Before: 4.1 Mb | Memory After: 4.11 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 = "user-status" AND a.item_id = 2125
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.0004821 | Memory Before: 4.12 Mb | Memory After: 4.13 Mb | Memory Used: 10.69 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, link.*, p.app_id, a.image_path AS app_image_path, 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_link AS link
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'link' AND l.item_id = link.link_id AND l.user_id = 0)
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = link.parent_user_id)
     LEFT JOIN phpfox_pages AS p
            ON(p.page_id = u.profile_page_id)
     LEFT JOIN phpfox_app AS a
            ON(a.app_id = p.app_id)

WHERE link.link_id = 290
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEasystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLElinkconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEpeq_refPRIMARY,page_idPRIMARY4majmaih1_majma.u.profile_page_id1 
0.0005200 | Memory Before: 4.11 Mb | Memory After: 4.12 Mb | Memory Used: 7.1 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 = "link")

WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 290
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,const2Using 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.12 Mb | Memory After: 4.13 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 290
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const2Using where; Using index
0.0002089 | Memory Before: 4.13 Mb | Memory After: 4.13 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 = "link" AND a.item_id = 290
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.0002222 | Memory Before: 4.13 Mb | Memory After: 4.14 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 = "link" AND a.item_id = 290
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.0007060 | Memory Before: 4.15 Mb | Memory After: 4.15 Mb | Memory Used: 5.63 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2110
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0006700 | Memory Before: 4.15 Mb | Memory After: 4.16 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2110
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.0002680 | Memory Before: 4.16 Mb | Memory After: 4.17 Mb | Memory Used: 3.14 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2110
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 3Using where; Using index
0.0002480 | Memory Before: 4.17 Mb | Memory After: 4.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 = "user-status" AND a.item_id = 2110
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.0002232 | Memory Before: 4.17 Mb | Memory After: 4.18 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 = "user-status" AND a.item_id = 2110
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.0005100 | Memory Before: 4.19 Mb | Memory After: 4.19 Mb | Memory Used: 5.62 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2105
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0005732 | Memory Before: 4.18 Mb | Memory After: 4.19 Mb | Memory Used: 6.82 kb | Rows: 0 | 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2105
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.0003898 | Memory Before: 4.18 Mb | Memory After: 4.19 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2105
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using where; Using index
0.0006700 | Memory Before: 4.18 Mb | Memory After: 4.19 Mb | Memory Used: 10.32 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 = 'user_status' AND c.item_id = 2105 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.0002122 | Memory Before: 4.2 Mb | Memory After: 4.2 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 = 18612 AND c.type_id = 'user_status' AND c.item_id = 2105 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.0004029 | Memory Before: 4.2 Mb | Memory After: 4.21 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 = 18612 AND c.type_id = 'user_status' AND c.item_id = 2105 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.0002339 | Memory Before: 4.2 Mb | Memory After: 4.21 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 = "user-status" AND a.item_id = 2105
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.0003381 | Memory Before: 4.2 Mb | Memory After: 4.21 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 = "user-status" AND a.item_id = 2105
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: 4.22 Mb | Memory After: 4.23 Mb | Memory Used: 10.63 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, link.*, p.app_id, a.image_path AS app_image_path, 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_link AS link
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'link' AND l.item_id = link.link_id AND l.user_id = 0)
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = link.parent_user_id)
     LEFT JOIN phpfox_pages AS p
            ON(p.page_id = u.profile_page_id)
     LEFT JOIN phpfox_app AS a
            ON(a.app_id = p.app_id)

WHERE link.link_id = 289
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEasystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLElinkconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEpeq_refPRIMARY,page_idPRIMARY4majmaih1_majma.u.profile_page_id1 
0.0004611 | Memory Before: 4.22 Mb | Memory After: 4.22 Mb | Memory Used: 6.8 kb | Rows: 0 | 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 = "link")

WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 289
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,const1Using 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.0002561 | Memory Before: 4.22 Mb | Memory After: 4.22 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 289
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where; Using index
0.0002139 | Memory Before: 4.22 Mb | Memory After: 4.23 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 = "link" AND a.item_id = 289
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.0003021 | Memory Before: 4.23 Mb | Memory After: 4.23 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 = "link" AND a.item_id = 289
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.0015321 | Memory Before: 4.24 Mb | Memory After: 4.26 Mb | Memory Used: 15.02 kb | Rows: 1 | Slave: Yes
SELECT 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, photo.*, l.like_id AS is_liked, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, pfeed.feed_id
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = photo.parent_user_id)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_like AS l
            ON((l.type_id = 'photo' OR l.type_id = 'advancedphoto') AND l.item_id = photo.photo_id AND l.user_id = 0)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 23922)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4649
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const unique row not found
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_285 2Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0006490 | Memory Before: 4.24 Mb | Memory After: 4.24 Mb | Memory Used: 7.79 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 = "advancedphoto")

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4649
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,const5Using 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.0002470 | Memory Before: 4.26 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 = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4649
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const5Using where; Using index
0.0006609 | Memory Before: 4.26 Mb | Memory After: 4.27 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 = 'advancedphoto' AND c.item_id = 4649 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.0002198 | Memory Before: 4.28 Mb | Memory After: 4.28 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 = 18611 AND c.type_id = 'advancedphoto' AND c.item_id = 4649 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.0003681 | Memory Before: 4.28 Mb | Memory After: 4.29 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 = 18611 AND c.type_id = 'advancedphoto' AND c.item_id = 4649 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.0001919 | Memory Before: 4.29 Mb | Memory After: 4.29 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 = "advancedphoto" AND a.item_id = 4649
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.0003119 | Memory Before: 4.28 Mb | Memory After: 4.29 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 = 'advancedphoto' AND l.item_id = 4649
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.0002089 | Memory Before: 4.29 Mb | Memory After: 4.3 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 = "advancedphoto" AND a.item_id = 4649
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.0004449 | Memory Before: 4.3 Mb | Memory After: 4.31 Mb | Memory Used: 10.63 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, link.*, p.app_id, a.image_path AS app_image_path, 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_link AS link
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'link' AND l.item_id = link.link_id AND l.user_id = 0)
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = link.parent_user_id)
     LEFT JOIN phpfox_pages AS p
            ON(p.page_id = u.profile_page_id)
     LEFT JOIN phpfox_app AS a
            ON(a.app_id = p.app_id)

WHERE link.link_id = 287
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEasystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLElinkconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEpeq_refPRIMARY,page_idPRIMARY4majmaih1_majma.u.profile_page_id1 
0.0004461 | Memory Before: 4.3 Mb | Memory After: 4.31 Mb | Memory Used: 6.81 kb | Rows: 0 | 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 = "link")

WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 287
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,const1Using 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.0002379 | Memory Before: 4.3 Mb | Memory After: 4.31 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 287
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where; Using index
0.0002370 | Memory Before: 4.31 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 = "link" AND a.item_id = 287
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.0002420 | Memory Before: 4.31 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 = "link" AND a.item_id = 287
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.0007331 | Memory Before: 4.33 Mb | Memory After: 4.33 Mb | Memory Used: 5.61 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 2091
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0005391 | Memory Before: 4.32 Mb | Memory After: 4.33 Mb | Memory Used: 6.95 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 = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2091
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.0003450 | Memory Before: 4.33 Mb | Memory After: 4.33 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2091
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using where; Using index
0.0002620 | Memory Before: 4.33 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 = "user-status" AND a.item_id = 2091
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.0002460 | Memory Before: 4.33 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 = "user-status" AND a.item_id = 2091
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.0001218 | Memory Before: 4.33 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_user AS u
WHERE user_id IN (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangePRIMARY,user_idPRIMARY4 1Using index condition
0.0076182 | Memory Before: 4.41 Mb | Memory After: 4.42 Mb | Memory Used: 6.74 kb | Rows: 45 | Slave: No
SHOW COLUMNS FROM phpfox_user_field
0.0001049 | Memory Before: 4.43 Mb | Memory After: 4.43 Mb | Memory Used: 3.17 kb | Rows: 1 | Slave: Yes
SELECT use_timeline
FROM phpfox_user_field AS uf
WHERE uf.user_id = 86
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEufconstuser_iduser_id4const1 
0.0022888 | Memory Before: 4.45 Mb | Memory After: 4.45 Mb | Memory Used: 3.17 kb | Rows: 1 | Slave: No
SELECT havadar
FROM phpfox_havadar
WHERE user_id = '86'
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_havadarconstPRIMARYPRIMARY4const1 
0.0005410 | Memory Before: 4.45 Mb | Memory After: 4.45 Mb | Memory Used: 3.62 kb | Rows: 0 | Slave: No
SELECT *
FROM phpfox_havadar_add
WHERE user_id = 0 AND hav_id =86
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0013771 | Memory Before: 4.48 Mb | Memory After: 4.48 Mb | Memory Used: 3.09 kb | Rows: 0 | Slave: Yes
SELECT count(f.user_id)
FROM phpfox_friend AS f
     JOIN phpfox_friend AS sf
            ON(sf.friend_user_id = f.friend_user_id AND sf.user_id = 86)
     JOIN phpfox_user AS u
            ON(u.user_id = f.friend_user_id)

WHERE f.is_page = 0 AND f.user_id = 0
GROUP BY f.friend_user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfrefuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2user_check4const1Using where
1SIMPLEsfeq_refuser_check,user_id,top_friend,friend_user_iduser_check8const,majmaih1_majma.f.friend_user_id1Using index
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.f.friend_user_id1Using index
0.0002661 | Memory Before: 4.46 Mb | Memory After: 4.47 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_friend AS f
     JOIN phpfox_friend AS sf
            ON(sf.friend_user_id = f.friend_user_id AND sf.user_id = 86)
     JOIN phpfox_user AS u
            ON(u.user_id = f.friend_user_id)

WHERE f.is_page = 0 AND f.user_id = 0
GROUP BY f.friend_user_id
ORDER BY f.time_stamp DESC
LIMIT 7
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfrefuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2user_check4const1Using where; Using temporary; Using filesort
1SIMPLEsfeq_refuser_check,user_id,top_friend,friend_user_iduser_check8const,majmaih1_majma.f.friend_user_id1Using index
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.f.friend_user_id1 
0.0014129 | Memory Before: 4.5 Mb | Memory After: 4.51 Mb | Memory Used: 6.54 kb | Rows: 7 | Slave: Yes
SELECT track.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_user_track AS track
     JOIN phpfox_user AS u
            ON(u.user_id = track.user_id AND u.profile_page_id = 0)

WHERE track.item_id = 86 AND track.user_id != 86
ORDER BY track.time_stamp DESC
LIMIT 7
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrackrangeitem_iditem_id8 61Using index condition; Using filesort
1SIMPLEueq_refPRIMARY,page_id,user_idPRIMARY4majmaih1_majma.track.user_id1Using where
0.0009291 | Memory Before: 4.57 Mb | Memory After: 4.57 Mb | Memory Used: 5.59 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_user AS u
     JOIN phpfox_havadar_add AS h
            ON(u.user_id = h.user_id)

WHERE h.hav_id = 86
LIMIT 30
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuALLPRIMARY,user_idMISSING KEY   336 
1SIMPLEhrefuser_iduser_id10majmaih1_majma.u.user_id,const1Using where; Using index
Array
(
    [session] => 78d450c2ebda643145220f7fc4ad63fd
    [redirect] => /profile-86/
)