{{title}}

{{message}}

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

علی رضا خاکسار

زندگی میکند در اصفهان, ایران · متولد 7 خرداد, 1998
کد امنیتی
علی رضا خاکسار
به شیشه های اتاقم دوباره ها کردم

و از نوشتن اسمت بر آن حیا کردم

به روی شیشه کشیدم عکس یک گنبد

به پای شیشه نشسته رضا رضا کردم .
علی رضا خاکسار
علی رضا خاکسار
عکس فرستاده شده توسط همکلاسی های ما که به صورت دو تیم از نمایندگان جمهوری اسلامی ایران در مسابقات تورنمنت شهر ها در روسیه هستند
دانیال پرورش فر
با همسراشون رفتند؟
  • 9 مرداد, 1394
  • ·
  • احسنت!
پیمان شهبازی
دکتر جوادی(استاد دانشکده ریاضی دانشگاه صنعتی و یکی از رفقای صمیمیمون)با خانمشون هستند
  • 10 مرداد, 1394
  • ·
  • احسنت!
علی
اون دختر وسطیه بهش نمیخوره خرخون باشه!!
  • 10 مرداد, 1394
  • ·
  • احسنت!
بنیامین ساربانی
مجبوری انقدر چرت وپرت بگی؟؟؟؟؟؟؟؟؟؟؟
اره؟؟؟
  • 10 مرداد, 1394
  • ·
  • احسنت!
علی
وظیفم همینه!
  • 10 مرداد, 1394
  • ·
  • احسنت!
محمدحسین
لا یکلّف الله نفسا الاّ وسعها.......
  • 10 مرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
تو برا چی به دختر مردم نگاه میکنی که آیا خرخون باشه یا نباشه؟؟؟
  • 10 مرداد, 1394
  • ·
  • احسنت!
محمدحسین
لا یکلّف الله نفسا الّا وسعها.....
  • 10 مرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
علی رضا خاکسار
علی رضا خاکسار
الله اکبر
الله اکبر
لا اله الا الله و الله اکبر
و لله الحمد
الحمد الله علی ما هدانا
من هر وقت خوشحالم اینو میگم
تبریک به پژمان
الهی .. هرکه شدت حلقه در زود برد حقه زر
علی رضا خاکسار
مفتخرم اولین کسی باشم که کسب رتبه دو کنکور سراسری رو به آقای میررضی تبریک بگم
سید متین سمبلستان
آقا یک نکته خیلی جالب اینه که رتبه 2 و3 انسانی از فقط یک کلاس 10، 20 نفره مدرسه درآمده.
این احتمالا بقیه مدارس تیزهوشان را ترغیب میکنه که رشته انسانی را وارد مدرسه شون کنن
خیلی درجه یکه
  • 29 تیر, 1394
  • ·
  • احسنت!
علی حمصی
20 نفر؟!
12 نفر بودن!
  • 29 تیر, 1394
  • ·
  • احسنت!
علی رضا خاکسار
هیچ وقت گول ظاهر کسیو نخورید
+
+
یه بار یکی گول ظاهر منو خورد
+
+
الان من گول ظاهر ندارم
محمدحسین
در امتداد با هم بودن غلطه!
در امتداد بودن!
  • 27 تیر, 1394
  • ·
  • احسنت!
علی رضا خاکسار
ولمون کن!
  • 27 تیر, 1394
  • ·
  • احسنت!
علی رضا خاکسار
سید مهدی اخوان
نخوایم باس کیو بی بی نیم؟
  • 7 تیر, 1394
  • ·
  • احسنت!
علی رضا خاکسار
احتمالا حالا که داره میره میخواد خاطره خوش به جا بزاره!!!
اینش مهم نیست خیلی لطف کردین آقای اخوان که تفقدی به پست بنده کردین سایه تون کم نشه!
  • 7 تیر, 1394
  • ·
  • احسنت!
علی رضا خاکسار
احتمالا حالا که داره میره میخواد خاطره خوش به جا بزاره!!!
اینش مهم نیست خیلی لطف کردین آقای اخوان که تفقدی به پست بنده کردین سایه تون کم نشه!
  • 7 تیر, 1394
  • ·
  • احسنت!
علی رضا خاکسار
اشک اماممان را در آوردند شش سال پیش خطبه نماز جمعه 29خرداد خطاب آخری هم عرض کنم به مولامان و صاحبمان، حضرت بقیةاللَّه (ارواحنا فداه) : ای سید ما! ای مولای ما! ما آنچه باید بکنیم، انجام میدهیم؛ آنچه باید هم گفت، هم گفتیم و خواهیم گفت. من جان ناقابلی دارم، جسم ناقصی دارم، اندک آبروئی هم دارم که این را هم خود شما به ما دادید؛ همه‌ی اینها را من کف دست گرفتم، در راه این انقلاب و در راه اسلام فدا خواهم کرد؛ اینها هم نثار شما باشد. سید ما، مولای ما، دعا کن برای ما؛ صاحب ما توئی؛ صاحب این کشور توئی؛ صاحب این انقلاب توئی؛ پشتیبان ما شما هستید؛ ما این راه را ادامه خواهیم داد؛ با قدرت هم ادامه خواهیم داد؛ در این راه ما را با دعای خود، با حمایت خود، با توجه خود، پشتیبانی بفرما.
علی رضا خاکسار
برای تمام کنکوری ها آرزوی موفقیت میکنیم.
حالادیگه کنکوریا مجمع ما هستیم.
با کسب اجازه از مقام معظم رهبری و با عنایت خاصه امام زمان،
من در اینجا رسما افتتاح کاف نود و پنج را اعلام میکنم
علی عباسی
هنوز 6 ساعت و 40 دیقه دیگه مونده!
  • 21 خرداد, 1394
  • ·
  • احسنت!
محمدحسین
هنوز ٤ ساعت و چل ديقه مونده.
  • 21 خرداد, 1394
  • ·
  • احسنت!
محمد مهدی پویان فر
کاف های زیادی از این به بعد میان و میرن!
ولی هیچی کاف94 نمیشه که! بقیشون گاف اند!!
  • 21 خرداد, 1394
  • ·
  • احسنت!
علی عباسی
صالح پور: گاف به زودی افتتاح خواهد شد!
  • 21 خرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
باژد!
  • 23 خرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
خواننده نه چندان ارزشی امیر تتلو در صفحه اینستاگرام خود با انتشاری عکسی از مقآم رهبری خود را سرباز ایشان نامید که بازخورد زیادی داشته است
امیرحسین لطفی
گویا رهبری هم این پست رو لایک کردن!
  • 24 خرداد, 1394
  • ·
  • احسنت!
محمد امين زماني
حتی به نقلی جمع کثیری از مجمعی ها هم این پستو لایک کردن..
  • 24 خرداد, 1394
  • ·
  • احسنت!
سیدمهدی مدینه آنلاین هست.
كفر متحرك به اسلام می رسد، ولى اسلام راكد، پدر بزرگِ كفر است.
سلمان‏ها در حالى كه كافر بودند، حركتشان آنها را به رسول منتهى كرد

و زبيرها در حالى كه با رسول بودند، ركودِشان آنها را به كفر پيوند زد.
كفرى كه با حركت ما همراه باشد، وحشتى ندارد، وحشت آنجايى است كه با ركودها پيوند خورده باشيم.

علی صفایی
  • 24 خرداد, 1394
  • ·
  • احسنت!
محمدحسین
به به.
  • 24 خرداد, 1394
  • ·
  • احسنت!
محمد امين زماني
یقولون بافواههم ما لیس فی قلوبهم..
  • 24 خرداد, 1394
  • ·
  • احسنت!
هاشم زنداني
شخصیت متغیر تر از تتلو ندیده م،هر روز یه شخصیت جدید داره!
اصی رو حرفا همچین کسی حساب نمیشه کرد
  • 1 تیر, 1394
  • ·
  • احسنت!
علی رضا خاکسار
بنیامین ساربانی
اقا چرا برا مردم حرف درمیارین؟؟؟؟
اقای عراقچی کی همچین حرفی زدن؟؟؟؟؟؟؟؟؟!!!!!!!
  • 17 خرداد, 1394
  • ·
  • احسنت!
سیدمهدی مدینه آنلاین هست.
می‏ ‏دونید‏ ‏مشکل‏ ‏کجاست؟
مشکل‏ ‏این‏ ‏جاست‏ ‏که‏ حتی‏ ‏‏با‏ ‏قبول‏ ‏کردن‏ ‏پروتکل‏ ‏الحاقی‏ ‏باز‏ ‏هم‏ ‏تحریم‏ ‏ها‏ ‏برداشته‏ ‏نمیشه‏!‏
به‏ ‏کدوم‏ ‏قول‏ ‏شون‏ ‏عمل‏ ‏کردند‏ ‏که‏ ‏این‏ ‏دومیش‏ ‏باشه؟
  • 18 خرداد, 1394
  • ·
  • احسنت!
سید جواد حسینی
منم با حرف شما در مورد عمل نکردن به تعهداتشون موافقم ولی به نظر من این مذاکرات بیشتر از اینکه برا رفع تحریم ها باشه برا نشون دادن چهره‌ی اصلی طرف‌های مذاکراتمونه و برا اینکه بعضی از آقایون متوجه بشن که آمریکا همه چیز نیست.
  • 18 خرداد, 1394
  • ·
  • احسنت!
سید جواد حسینی
آقای خاکسار بهتره قبل از انتشار هر پستی قبلش ببینید که آیا اصلا این پست با واقعیت سازگاری داره یا نه.
برا اطلاع عرض میکنم که آقای عراقچی تو مصاحبه‌شون چندین بار متذکر شدن که
اولا ما بازرسی از مراکز نظامی نداریم و به هیچ عنوان اجازه‌ی این کار را نمیدیم و به جاش دسترسی مدیریت شده (Management Access)!!! داریم
و ثانیا ما میتونیم چشم بازرسا ببندیم و فقط در نقطه‌ی درخواست شده باز کنیم
و ثالثا میتونیم روی همه‌ی وسایلمونا با هر چیزی که خواستیم بپوشونیم
و رابعا اگه نمیدونستید بدونید که ما یه شورایی برا مذاکرات داریم به نام شورای رهبری که خود آقا درست کردن و چهرچوب کلی و خط قرمز ها را برا تیم مذاکره کننده تع...
  • 18 خرداد, 1394
  • ·
  • احسنت!
سیداحسان مدنی
"و رابعا اگه نمیدونستید بدونید که ما یه شورایی برا مذاکرات داریم به نام شورای رهبری که خود آقا درست کردن و چهرچوب کلی و خط قرمز ها را برا تیم مذاکره کننده تعیین میکنه و تیم مذاکره کننده باید بهشون عمل کنه."
این ادعا واقعا عجیب ه و من برای اولین بار هست که می شنوم

امام خامنه ای به صورت صریح هرگونه بازرسی از مراکز نظامی رد کردن ولی متاسفانه برای پیچوندن این دستور از بازرسی مدیریت شده حرف می زنند و ادعاهای می کنند که به دور از عقل ه و بیشتر به رویاهای کودکانه شبیه هست تا واقعیت(بستن چشم و الباقی ماجرا)
"رهبر انقلاب يک نمونه از زياده خواهي هاي طرف مقابل در مذاکرات هسته اي را، درخواست براي بازرسي از م...
  • 18 خرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
بله میدونم پروتکل الحاقی چیه و بحث انهنسد اکسس رو ولی عکسش قشنگ بود گذاشتم ضمنا. طبق این پروتکل نگرانی های امنیتی ما رفع نمیشه
  • 18 خرداد, 1394
  • ·
  • احسنت!
علی انواری
حضرت آقا عید فرمودند که هیچ نظارت مستقیمی بر مذاکرات ندارند و فقط خطوط کلی رو ابلاغ و گوشزد می کنند. این تذکر برای این بود که عده ای بر این طبل می کوفتند که رهبر ناظر بر مذاکراته و اعتراض به مذاکرات، اعتراض به رهبری ست.
  • 18 خرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
فکر میکنین کی مهمون کرده؟
بنیامین ساربانی
کجاس؟
  • 15 خرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
رستوران اسپه مطهری
  • 15 خرداد, 1394
  • ·
  • احسنت!
امین امانی فر
کی هست؟با تجربی میری بیرون دیگه...
  • 15 خرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
دوشنبه سه شنبه.
ما دو تا ریاضی بودیم برآیندمون خنثی کردش
  • 15 خرداد, 1394
  • ·
  • احسنت!
سیدمهدی مدینه آنلاین هست.
این‏ ‏چه‏ ‏حرفیه‏ ‏میزنی؟‏!‏!!
یعنی‏ ‏برایند‏ ‏دو‏ ‏ریاضی‏ ‏و‏ ‏یک‏ ‏تجربی‏‏ ‏صفر‏ ‏میشه؟
یعنی‏ ‏یک‏ ‏تجربی‏ ‏دو‏ ‏برابر‏ ‏ریاضی‏ ‏حساب‏ ‏میشه؟
  • 16 خرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
زبونم لال ! منظورم اینه که بی اثرش کردیم!
  • 16 خرداد, 1394
  • ·
  • احسنت!
سید متین سمبلستان
بیشتر برا من سوال اینه که کی عکس را گرفته؟؟
  • 25 خرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
سوال بسیار خوبی بود! ولی از بچه ها نبود یه بنده خدایی بود گفتیم بگیر
  • 25 خرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
بارسای ایران ، سپاهان
امیرحسین قنبری
آخه اصی قهرمانیش ربطی به پرسپولیس و استقلال نداشت که
  • 27 اردیبهشت, 1394
  • ·
  • احسنت!
علی رضا خاکسار
نه یه اشاره ی کلی بود!
  • 27 اردیبهشت, 1394
  • ·
  • احسنت!
حمیدرضا بهرامی
بارسای ایران؟؟؟
خخخخخخخخخ
  • 30 اردیبهشت, 1394
  • ·
  • احسنت!
علی رضا خاکسار
علی رضا خاکسار
علی رضا خاکسار
علی رضا خاکسار
دانیال پرورش فر
این جا دوتا چیز مسئله است. 1: توهین که میشه در موردش صحبت کرد.
2: مسخره قرار دادن یک امر مقدس. بنده نیت طراح این کاریکاتور رو نمی دونم و البته برای افراد مختلف، برداشت های مختلفی هم دنبال داره. اما حرف آخرم فکر کنم حرف اول صادق(اگه اشتباه نکنم) باشه: شوخی با همه چی شوخی با پیامبر خدا هم شوخی؟
  • 31 اردیبهشت, 1394
  • ·
  • احسنت!
علی
منم معتقدم توهین شده...
نه سلفی گرفتنشا,کاریکاتورش...
  • 31 اردیبهشت, 1394
  • ·
  • احسنت!
محمدحسین
Webpage not found 404
  • 1 خرداد, 1394
  • ·
  • احسنت!
علی رضا خاکسار
ضیافت ناهار اژه ای دویی ها اژه ای یکیا پرچماتون تو وایتکس!
محمد رضایی
آیا چه خبر بوده؟!
یعنی موقع ناهار که میشه چهارما دانش آموز مدرسه نیستند؟!
  • 23 اردیبهشت, 1394
  • ·
  • احسنت!
علی
تازه،دلت بسوزه:
چلو جوجه+کباب+پلو اضافی+لیموناد!
  • 24 اردیبهشت, 1394
  • ·
  • احسنت!
محمدحسین
ما که تو تصویر فقط نوشابه می بینیم.اونم سیاه و نارنجی.البته چیزهایی شبیه نوشابه سبزا نیز دیده میشن.
  • 24 اردیبهشت, 1394
  • ·
  • احسنت!
علی
همونهاند دیگه!
  • 24 اردیبهشت, 1394
  • ·
  • احسنت!
مهدی رئیسی
این بودجه اژه ای دو رو اگه اژه ای یک داشت...
هعععیییییی
  • 25 اردیبهشت, 1394
  • ·
  • احسنت!
علی
آره،بیچاره می شد!چون بودجه اش از نصف هم کمتر می شد!
  • 25 اردیبهشت, 1394
  • ·
  • احسنت!
محمد رضایی
فک کنم با تقسیم بودجه بر متراژ مدرسه به نتایج خبی برسی...
  • 25 اردیبهشت, 1394
  • ·
  • احسنت!
علی
میخواستم یه چیزی بگم بعد دیدم چیز خاصی نمیتونم بگم!
پس حرفی ندارم...
  • 25 اردیبهشت, 1394
  • ·
  • احسنت!
علی رضا خاکسار
دانشگاه صنعتی شریف و اصفهان(نه امیرکبیر نه علم صنعت) به جمع 100دانشگاه برتر دنیا پیوستند
علی
صد داشنگاه برتر زیر چهل سال!
ینی توی این رده بندی نه داشنگاه های معروف امریکا،نه انگلیس،نه توکیو،و نه هیچ کدام از دانشگاه های دیگر دنیا نستند!
توی رده بندی کامل شریف،280 و اصفهان 300 و اندی است!
  • 11 اردیبهشت, 1394
  • ·
  • احسنت!
علی انواری
ای بابا! آقای حاجی احمدی! این بود جواب اعتماد ما؟!
  • 11 اردیبهشت, 1394
  • ·
  • احسنت!
احمدرضا بنایان
نخی کل دانشگاه ها هستن
  • 11 اردیبهشت, 1394
  • ·
  • احسنت!
علی رضا خاکسار
الان ساعت هشت وربع تازه فهمیدم امتحان حسابآن دارم از حد!اومدم درد دل کنم
هاشم زنداني
برو حيا كن.امتحان رياضي داشتم پارسال 5ديقه قبلش يادم افتاد!داشتم ميرفتم سر امتحان سرگروهدا تو كريدور ديدم.گفتم ميتوني تو 1ديقه كل مشتق و حدّا بم ياد بدي؟!از چهره ش فهميدم در توانش ني و در توان منم ني كه تو 1ديقه ياد بيگيرم!بعدم اصرار نكردم و نذاشمش تحت فشار!رفتم سر جلسه و با اقتدار يخته تراوشات ذهنما نوشتم رو برگه و اومدم بيرون...
  • 7 اردیبهشت, 1394
  • ·
  • احسنت!
نمایش بیشتر
phpFox Developers Debug Toggle JavaScript Console
Version:
3.7.7
Product Code Name:
Nebula

Total Time:
2.0069029
PHP General Time:
1.5653275
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.4415754
SQL Queries:
280
SQL Memory Usage:
1.92 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
5.51 Mb
Total Memory Usage (Including Debug):
6.36 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
185.55.227.64


Server Time Stamp:
January 22, 2018, 12:25 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.0004661 | 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 ('b08de35eb6bbfd6c6d254a90132dc75c', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516580716', '/profile-47/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0002391 | Memory Before: 919.85 kb | Memory After: 925.1 kb | Memory Used: 5.25 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.0033710 | Memory Before: 1.25 Mb | Memory After: 1.29 Mb | Memory Used: 35.98 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-47'
/* 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.0042770 | Memory Before: 1.69 Mb | Memory After: 1.7 Mb | Memory Used: 3.8 kb | Rows: 4 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 47
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_privacyrefuser_id,user_id_2user_id4const4 
0.0044341 | Memory Before: 1.82 Mb | Memory After: 1.82 Mb | Memory Used: 3.24 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo
WHERE view_id = 0 AND group_id = 0 AND user_id = 47
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_id4const228Using where
0.0005810 | Memory Before: 2.01 Mb | Memory After: 2.01 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: No
SELECT COUNT(sud.id)
FROM phpfox_ebooks_user_shelf AS sud
WHERE sud.user_id = 47
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsudALL MISSING KEY   19Using where
0.0006969 | Memory Before: 2.04 Mb | Memory After: 2.05 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_event
WHERE view_id = 0 AND item_id = 0 AND user_id = 47 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_id4const2Using where
0.0005560 | Memory Before: 2.31 Mb | Memory After: 2.31 Mb | Memory Used: 4.38 kb | Rows: 3 | Slave: Yes
SELECT *
FROM phpfox_user_design_order
WHERE user_id = 47
ORDER BY ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_design_orderrefuser_iduser_id4const2Using where; Using filesort
0.0002310 | Memory Before: 2.92 Mb | Memory After: 2.93 Mb | Memory Used: 11.3 kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 2480
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
0.0004270 | Memory Before: 2.98 Mb | Memory After: 2.99 Mb | Memory Used: 3.27 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'profile' AND name = 'logo.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0003629 | Memory Before: 3.05 Mb | Memory After: 3.05 Mb | Memory Used: 3.41 kb | Rows: 0 | Slave: Yes
SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 47
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0056801 | Memory Before: 3.07 Mb | Memory After: 3.08 Mb | Memory Used: 7.46 kb | Rows: 6 | Slave: Yes
SELECT uf.dob_setting, friend.friend_id, friend.friend_user_id, friend.is_top_friend, friend.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_friend AS friend
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 47) AS sf
            ON(sf.friend_user_id = friend.friend_user_id)
     JOIN phpfox_user AS u
            ON(u.user_id = friend.friend_user_id AND u.status_id = 0 AND u.view_id = 0)
     JOIN phpfox_user_field AS uf
            ON(u.user_id = uf.user_id)

WHERE friend.is_page = 0 AND friend.user_id = 47
GROUP BY u.user_id
ORDER BY friend.is_top_friend DESC , friend.ordering ASC, RAND()
LIMIT 6
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY<derived2>ALL MISSING KEY   104Using temporary; Using filesort
1PRIMARYfriendeq_refuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2user_check8const,sf.friend_user_id1Using where
1PRIMARYueq_refPRIMARY,user_status,status_id,public_feed,status_id_2,user_idPRIMARY4sf.friend_user_id1Using where
1PRIMARYufeq_refuser_iduser_id4sf.friend_user_id1 
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const104Using index
0.0003171 | Memory Before: 3.11 Mb | Memory After: 3.11 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: Yes
SELECT /*getListForProfile*/ fl.list_id, fl.name
FROM phpfox_friend_list AS fl
WHERE fl.user_id = 47 AND fl.is_profile = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEflrefuser_id,user_id_2user_id4const1Using where
0.0036049 | Memory Before: 3.19 Mb | Memory After: 3.19 Mb | Memory Used: 4.99 kb | Rows: 1 | Slave: Yes
SELECT cr.relation_id, crd.relation_data_id,crd.status_id, u.user_name, u.full_name, u.user_id, cr.phrase_var_name, cr.confirmation
FROM phpfox_custom_relation_data AS crd
     JOIN phpfox_custom_relation AS cr
            ON(cr.relation_id = crd.relation_id)
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = crd.with_user_id)

WHERE crd.relation_data_id = 109
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrdconstPRIMARYPRIMARY4const1 
1SIMPLEcrconstPRIMARYPRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const unique row not found
0.0182920 | Memory Before: 3.3 Mb | Memory After: 3.31 Mb | Memory Used: 12.98 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 = 47
/* 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 = 47
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN(0) AND feed.user_id = 47 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 = 47
/* 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   657Using 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,const331Using where
5UNIONfeedrefprivacy_2,privacy_3,privacy_4,privacy,privacy_5privacy_55const,const8 
 UNION RESULT<union2,3,4,5>ALL MISSING KEY    Using temporary
0.0035298 | Memory Before: 3.57 Mb | Memory After: 3.57 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 = 2591
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0181761 | Memory Before: 3.56 Mb | Memory After: 3.57 Mb | Memory Used: 8.91 kb | Rows: 15 | 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 = 2591
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 12Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0006189 | Memory Before: 3.62 Mb | Memory After: 3.62 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2591
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 12Using where; Using index
0.0004690 | Memory Before: 3.62 Mb | Memory After: 3.63 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "user-status" AND a.item_id = 2591
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.0003221 | Memory Before: 3.65 Mb | Memory After: 3.66 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "user-status" AND a.item_id = 2591
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.0003519 | Memory Before: 3.66 Mb | Memory After: 3.67 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 = 2589
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0005691 | Memory Before: 3.65 Mb | Memory After: 3.66 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 = 2589
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.0003331 | Memory Before: 3.65 Mb | Memory After: 3.66 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2589
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using where; Using index
0.0002451 | Memory Before: 3.66 Mb | Memory After: 3.66 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "user-status" AND a.item_id = 2589
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.66 Mb | Memory After: 3.66 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "user-status" AND a.item_id = 2589
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.0030599 | Memory Before: 3.68 Mb | Memory After: 3.69 Mb | Memory Used: 15.01 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 = 30547)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5746
/* 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.0012119 | Memory Before: 3.69 Mb | Memory After: 3.7 Mb | Memory Used: 9.62 kb | Rows: 20 | 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 = 5746
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const16Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002999 | Memory Before: 3.76 Mb | Memory After: 3.77 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 = 5746
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const16Using where; Using index
0.0029230 | Memory Before: 3.77 Mb | Memory After: 3.78 Mb | Memory Used: 10.65 kb | Rows: 2 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 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.0006001 | Memory Before: 3.8 Mb | Memory After: 3.81 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 = 24617 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const1Using index condition
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004590 | Memory Before: 3.81 Mb | Memory After: 3.82 Mb | Memory Used: 10.43 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 24617 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 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_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.0002160 | Memory Before: 3.82 Mb | Memory After: 3.82 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 = 24619 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const3Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0005898 | Memory Before: 3.82 Mb | Memory After: 3.83 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 = 24619 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const3Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002451 | Memory Before: 3.84 Mb | Memory After: 3.84 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 = 24621 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const4Using index condition
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0005221 | Memory Before: 3.84 Mb | Memory After: 3.85 Mb | Memory Used: 10.68 kb | Rows: 2 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 24621 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 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_id_286const,const,const,const4Using 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.0002239 | Memory Before: 3.86 Mb | Memory After: 3.86 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 = 24623 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 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.0003841 | Memory Before: 3.86 Mb | Memory After: 3.87 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 = 24623 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 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.0002379 | Memory Before: 3.87 Mb | Memory After: 3.87 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 = 24629 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const2Using index condition
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004461 | Memory Before: 3.87 Mb | Memory After: 3.88 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 = 24629 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 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_id_286const,const,const,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002170 | Memory Before: 3.88 Mb | Memory After: 3.88 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 = 24630 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004311 | Memory Before: 3.88 Mb | Memory After: 3.89 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 = 24630 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 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.0002401 | Memory Before: 3.87 Mb | Memory After: 3.88 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 = 24614 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const2Using index condition
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0005162 | Memory Before: 3.88 Mb | Memory After: 3.89 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 = 24614 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 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_id_286const,const,const,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002539 | Memory Before: 3.89 Mb | Memory After: 3.89 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 = 24615 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 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.0003779 | Memory Before: 3.89 Mb | Memory After: 3.9 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 = 24615 AND c.type_id = 'advancedphoto' AND c.item_id = 5746 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.0002680 | Memory Before: 3.89 Mb | Memory After: 3.89 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 = 5746
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.0004790 | Memory Before: 3.88 Mb | Memory After: 3.89 Mb | Memory Used: 7.31 kb | Rows: 20 | 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 = 5746
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,const19Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002651 | Memory Before: 3.91 Mb | Memory After: 3.92 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 = "advancedphoto" AND a.item_id = 5746
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.0138662 | Memory Before: 3.91 Mb | Memory After: 3.92 Mb | Memory Used: 15.19 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 = 30478)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5733
/* 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.0083148 | Memory Before: 3.9 Mb | Memory After: 3.91 Mb | Memory Used: 11.02 kb | Rows: 30 | 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 = 5733
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,const23Using 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.0002851 | Memory Before: 4 Mb | Memory After: 4 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 = 5733
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const23Using where; Using index
0.0002239 | Memory Before: 4 Mb | Memory After: 4.01 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 = 5733
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.0005021 | Memory Before: 4.01 Mb | Memory After: 4.02 Mb | Memory Used: 8.25 kb | Rows: 30 | 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 = 5733
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,const28Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002460 | Memory Before: 4.06 Mb | Memory After: 4.06 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 = 5733
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.0006111 | Memory Before: 4.04 Mb | Memory After: 4.05 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 = 30477)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5732
/* 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.0006640 | Memory Before: 4.03 Mb | Memory After: 4.04 Mb | Memory Used: 10.46 kb | Rows: 26 | 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 = 5732
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,const20Using 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.0002501 | Memory Before: 4.12 Mb | Memory After: 4.12 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 = 5732
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const20Using where; Using index
0.0002079 | Memory Before: 4.12 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 = "advancedphoto" AND a.item_id = 5732
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.0004990 | Memory Before: 4.13 Mb | Memory After: 4.14 Mb | Memory Used: 7.88 kb | Rows: 26 | 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 = 5732
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,const23Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002520 | 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 = "advancedphoto" AND a.item_id = 5732
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.0038462 | Memory Before: 4.16 Mb | Memory After: 4.16 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 = 2583
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0125370 | Memory Before: 4.15 Mb | Memory After: 4.16 Mb | Memory Used: 8.91 kb | Rows: 15 | 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 = 2583
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 13Using 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.0003810 | Memory Before: 4.2 Mb | Memory After: 4.2 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 = 2583
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 13Using where; Using index
0.0002720 | 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 = 2583
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.0002761 | 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 = "user-status" AND a.item_id = 2583
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.0133822 | Memory Before: 4.23 Mb | Memory After: 4.25 Mb | Memory Used: 15.04 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 = 30416)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5717
/* 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.0006578 | Memory Before: 4.22 Mb | Memory After: 4.23 Mb | Memory Used: 9.62 kb | Rows: 20 | 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 = 5717
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const16Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002680 | Memory Before: 4.29 Mb | Memory After: 4.3 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 = 5717
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const16Using where; Using index
0.0080402 | Memory Before: 4.29 Mb | Memory After: 4.3 Mb | Memory Used: 11.84 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 = 5717 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.0002270 | Memory Before: 4.32 Mb | Memory After: 4.32 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 = 24521 AND c.type_id = 'advancedphoto' AND c.item_id = 5717 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.0005000 | Memory Before: 4.32 Mb | Memory After: 4.33 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 = 24521 AND c.type_id = 'advancedphoto' AND c.item_id = 5717 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.0002830 | Memory Before: 4.33 Mb | Memory After: 4.34 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 = 24511 AND c.type_id = 'advancedphoto' AND c.item_id = 5717 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.0004191 | Memory Before: 4.33 Mb | Memory After: 4.34 Mb | Memory Used: 10.07 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 24511 AND c.type_id = 'advancedphoto' AND c.item_id = 5717 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.0002251 | Memory Before: 4.33 Mb | Memory After: 4.34 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 = 5717
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.0004430 | Memory Before: 4.33 Mb | Memory After: 4.34 Mb | Memory Used: 7.31 kb | Rows: 20 | 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 = 5717
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,const18Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002682 | Memory Before: 4.36 Mb | Memory After: 4.36 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 = 5717
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.0165040 | Memory Before: 4.35 Mb | Memory After: 4.36 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 = 2572
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0103171 | Memory Before: 4.34 Mb | Memory After: 4.35 Mb | Memory Used: 9.51 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 = 2572
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.0003829 | Memory Before: 4.41 Mb | Memory After: 4.41 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 = 2572
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 16Using where; Using index
0.0064950 | Memory Before: 4.41 Mb | Memory After: 4.42 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 = 2572 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.0002651 | Memory Before: 4.43 Mb | Memory After: 4.43 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 24486 AND c.type_id = 'user_status' AND c.item_id = 2572 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,const2Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0006361 | Memory Before: 4.43 Mb | Memory After: 4.44 Mb | Memory Used: 10.44 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 24486 AND c.type_id = 'user_status' AND c.item_id = 2572 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,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002539 | Memory Before: 4.45 Mb | Memory After: 4.45 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 = 24498 AND c.type_id = 'user_status' AND c.item_id = 2572 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.0004060 | Memory Before: 4.45 Mb | Memory After: 4.46 Mb | Memory Used: 10.1 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 = 24498 AND c.type_id = 'user_status' AND c.item_id = 2572 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.0002789 | Memory Before: 4.45 Mb | Memory After: 4.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 = "user-status" AND a.item_id = 2572
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.0003061 | 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_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 = 2572
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.0011070 | Memory Before: 4.47 Mb | Memory After: 4.48 Mb | Memory Used: 15.14 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 = 30179)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5673
/* 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.0037599 | Memory Before: 4.46 Mb | Memory After: 4.47 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 = "advancedphoto")

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 5673
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,const10Using 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.0003791 | Memory Before: 4.5 Mb | Memory After: 4.51 Mb | Memory Used: 3.13 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 = 5673
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const10Using where; Using index
0.0007472 | Memory Before: 4.5 Mb | Memory After: 4.51 Mb | Memory Used: 10.38 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 = 5673 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.0002799 | Memory Before: 4.52 Mb | Memory After: 4.53 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 = 24332 AND c.type_id = 'advancedphoto' AND c.item_id = 5673 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,const2Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0006330 | Memory Before: 4.53 Mb | Memory After: 4.54 Mb | Memory Used: 10.67 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 = 24332 AND c.type_id = 'advancedphoto' AND c.item_id = 5673 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,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002651 | Memory Before: 4.55 Mb | Memory After: 4.55 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 = 24334 AND c.type_id = 'advancedphoto' AND c.item_id = 5673 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.0003891 | Memory Before: 4.55 Mb | Memory After: 4.56 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 = 24334 AND c.type_id = 'advancedphoto' AND c.item_id = 5673 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002689 | Memory Before: 4.56 Mb | Memory After: 4.56 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 = 24335 AND c.type_id = 'advancedphoto' AND c.item_id = 5673 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.0004539 | Memory Before: 4.56 Mb | Memory After: 4.57 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 = 24335 AND c.type_id = 'advancedphoto' AND c.item_id = 5673 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.0002270 | Memory Before: 4.55 Mb | Memory After: 4.56 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 = 5673
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.0004380 | Memory Before: 4.55 Mb | Memory After: 4.56 Mb | Memory Used: 6.68 kb | Rows: 13 | 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 = 5673
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,const13Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002651 | Memory Before: 4.57 Mb | Memory After: 4.58 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 = "advancedphoto" AND a.item_id = 5673
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.0061848 | Memory Before: 4.57 Mb | Memory After: 4.59 Mb | Memory Used: 19.08 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 = 30097)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5658
/* 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.0010200 | Memory Before: 4.57 Mb | Memory After: 4.58 Mb | Memory Used: 9.22 kb | Rows: 17 | 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 = 5658
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,const13Using 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.0002410 | Memory Before: 4.63 Mb | Memory After: 4.64 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 = 5658
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const13Using where; Using index
0.0002131 | Memory Before: 4.64 Mb | Memory After: 4.64 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 = 5658
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.0004399 | Memory Before: 4.64 Mb | Memory After: 4.65 Mb | Memory Used: 7.02 kb | Rows: 17 | 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 = 5658
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const16Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002491 | Memory Before: 4.67 Mb | Memory After: 4.67 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 = 5658
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.0096130 | Memory Before: 4.67 Mb | Memory After: 4.67 Mb | Memory Used: 5.67 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 = 2547
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0184021 | Memory Before: 4.66 Mb | Memory After: 4.67 Mb | Memory Used: 9.2 kb | Rows: 17 | 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 = 2547
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 14Using 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.0003850 | Memory Before: 4.72 Mb | Memory After: 4.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 = 2547
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 14Using where; Using index
0.0144000 | Memory Before: 4.72 Mb | Memory After: 4.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 = 2547 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.0079830 | Memory Before: 4.75 Mb | Memory After: 4.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 = 24090 AND c.type_id = 'user_status' AND c.item_id = 2547 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const4Using index condition
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0073740 | Memory Before: 4.75 Mb | Memory After: 4.76 Mb | Memory Used: 10.67 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 = 24090 AND c.type_id = 'user_status' AND c.item_id = 2547 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_id_286const,const,const,const4Using 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.0002241 | Memory Before: 4.77 Mb | Memory After: 4.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 = 24092 AND c.type_id = 'user_status' AND c.item_id = 2547 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.0004158 | Memory Before: 4.77 Mb | Memory After: 4.78 Mb | Memory Used: 10.12 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 24092 AND c.type_id = 'user_status' AND c.item_id = 2547 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.0002091 | Memory Before: 4.78 Mb | Memory After: 4.79 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 = 24139 AND c.type_id = 'user_status' AND c.item_id = 2547 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.0004160 | Memory Before: 4.78 Mb | Memory After: 4.79 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 = 24139 AND c.type_id = 'user_status' AND c.item_id = 2547 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.0002048 | Memory Before: 4.78 Mb | Memory After: 4.79 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 = 24068 AND c.type_id = 'user_status' AND c.item_id = 2547 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.0003829 | Memory Before: 4.79 Mb | Memory After: 4.8 Mb | Memory Used: 10.12 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 24068 AND c.type_id = 'user_status' AND c.item_id = 2547 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.0002041 | Memory Before: 4.79 Mb | Memory After: 4.8 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 = 24067 AND c.type_id = 'user_status' AND c.item_id = 2547 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.0004511 | Memory Before: 4.8 Mb | Memory After: 4.81 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 = 24067 AND c.type_id = 'user_status' AND c.item_id = 2547 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.0002730 | Memory Before: 4.79 Mb | Memory After: 4.79 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 = 2547
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.0002699 | Memory Before: 4.8 Mb | Memory After: 4.81 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 = 2547
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.0011761 | Memory Before: 4.81 Mb | Memory After: 4.82 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 = 29751)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5616
/* 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.0027049 | Memory Before: 4.8 Mb | Memory After: 4.81 Mb | Memory Used: 7.68 kb | Rows: 6 | 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 = 5616
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.0002520 | Memory Before: 4.82 Mb | Memory After: 4.83 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 = 5616
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const5Using where; Using index
0.0052340 | Memory Before: 4.82 Mb | Memory After: 4.84 Mb | Memory Used: 10.92 kb | Rows: 3 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002718 | Memory Before: 4.85 Mb | Memory After: 4.86 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 = 24276 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 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.0004241 | Memory Before: 4.86 Mb | Memory After: 4.87 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 = 24276 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 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.0003021 | Memory Before: 4.87 Mb | Memory After: 4.87 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 = 24174 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const4Using index condition
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0005319 | Memory Before: 4.87 Mb | Memory After: 4.88 Mb | Memory Used: 10.67 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 = 24174 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 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_id_286const,const,const,const4Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002670 | Memory Before: 4.89 Mb | Memory After: 4.89 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 = 24180 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 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.0004342 | Memory Before: 4.89 Mb | Memory After: 4.9 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 = 24180 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 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.0002759 | Memory Before: 4.9 Mb | Memory After: 4.9 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 = 24183 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 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.9 Mb | Memory After: 4.91 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 = 24183 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 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.0002820 | Memory Before: 4.9 Mb | Memory After: 4.9 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 = 24171 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const2Using index condition
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004699 | Memory Before: 4.9 Mb | Memory After: 4.91 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 = 24171 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 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_id_286const,const,const,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002720 | Memory Before: 4.91 Mb | Memory After: 4.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 = 24182 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 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.0004270 | Memory Before: 4.92 Mb | Memory After: 4.93 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 = 24182 AND c.type_id = 'advancedphoto' AND c.item_id = 5616 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.0002370 | Memory Before: 4.91 Mb | Memory After: 4.91 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 = "advancedphoto" AND a.item_id = 5616
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.0003769 | Memory Before: 4.91 Mb | Memory After: 4.91 Mb | Memory Used: 6.02 kb | Rows: 6 | 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 = 5616
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,const5Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002279 | Memory Before: 4.92 Mb | Memory After: 4.92 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 = "advancedphoto" AND a.item_id = 5616
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.0005212 | Memory Before: 4.93 Mb | Memory After: 4.94 Mb | Memory Used: 15.21 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 = 29741)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5615
/* 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.0006731 | Memory Before: 4.92 Mb | Memory After: 4.93 Mb | Memory Used: 7.96 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 = 5615
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,const7Using 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.0002689 | Memory Before: 4.95 Mb | Memory After: 4.95 Mb | Memory Used: 3.13 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 = 5615
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const7Using where; Using index
0.0015581 | Memory Before: 4.95 Mb | Memory After: 4.97 Mb | Memory Used: 17.53 kb | Rows: 3 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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.0002980 | Memory Before: 4.99 Mb | Memory After: 4.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 = 23948 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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,const5Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0007119 | Memory Before: 4.99 Mb | Memory After: 5 Mb | Memory Used: 10.91 kb | Rows: 3 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 23948 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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,const5Using 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.0002351 | Memory Before: 5.02 Mb | Memory After: 5.02 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 = 23949 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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.0004051 | Memory Before: 5.02 Mb | Memory After: 5.03 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 = 23949 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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.0002310 | Memory Before: 5.04 Mb | Memory After: 5.04 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 = 23950 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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: 5.04 Mb | Memory After: 5.05 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 = 23950 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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.0002520 | Memory Before: 5.05 Mb | Memory After: 5.05 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 = 23959 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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.0004489 | Memory Before: 5.05 Mb | Memory After: 5.06 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 = 23959 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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.0003018 | Memory Before: 5.05 Mb | Memory After: 5.05 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 = 23946 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const3Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004599 | Memory Before: 5.05 Mb | Memory After: 5.06 Mb | Memory Used: 10.44 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 23946 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const3Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002460 | Memory Before: 5.06 Mb | Memory After: 5.06 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 = 23947 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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.0004511 | Memory Before: 5.06 Mb | Memory After: 5.07 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 = 23947 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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.0002630 | Memory Before: 5.07 Mb | Memory After: 5.07 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 = 23944 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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.0004642 | Memory Before: 5.07 Mb | Memory After: 5.08 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 = 23944 AND c.type_id = 'advancedphoto' AND c.item_id = 5615 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.0002120 | Memory Before: 5.06 Mb | Memory After: 5.07 Mb | Memory Used: 5.48 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 = 5615
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.0003600 | Memory Before: 5.06 Mb | Memory After: 5.07 Mb | Memory Used: 6.2 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 = 5615
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,const8Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002019 | Memory Before: 5.07 Mb | Memory After: 5.08 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 = "advancedphoto" AND a.item_id = 5615
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.0008979 | Memory Before: 5.08 Mb | Memory After: 5.1 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 = 29637)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5602
/* 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.0047369 | Memory Before: 5.07 Mb | Memory After: 5.08 Mb | Memory Used: 8.38 kb | Rows: 11 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "advancedphoto")

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 5602
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const9Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0003290 | Memory Before: 5.11 Mb | Memory After: 5.12 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 = 5602
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const9Using where; Using index
0.0168591 | Memory Before: 5.11 Mb | Memory After: 5.13 Mb | Memory Used: 10.91 kb | Rows: 3 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 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.0003018 | Memory Before: 5.15 Mb | Memory After: 5.15 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 = 24195 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const2Using index condition
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0005021 | Memory Before: 5.15 Mb | Memory After: 5.16 Mb | Memory Used: 10.43 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 24195 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 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_id_286const,const,const,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002639 | Memory Before: 5.16 Mb | Memory After: 5.17 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 = 24198 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 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.0004001 | Memory Before: 5.16 Mb | Memory After: 5.17 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 = 24198 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 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.0002930 | Memory Before: 5.17 Mb | Memory After: 5.17 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 = 23861 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const2Using index condition
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004690 | Memory Before: 5.17 Mb | Memory After: 5.18 Mb | Memory Used: 10.43 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 23861 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 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_id_286const,const,const,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002201 | Memory Before: 5.18 Mb | Memory After: 5.19 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 = 23867 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const2Using index condition
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0075381 | Memory Before: 5.19 Mb | Memory After: 5.2 Mb | Memory Used: 10.43 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 23867 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 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_id_286const,const,const,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002608 | Memory Before: 5.2 Mb | Memory After: 5.2 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 = 23872 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const3Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004919 | Memory Before: 5.2 Mb | Memory After: 5.21 Mb | Memory Used: 10.44 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 23872 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const3Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002370 | Memory Before: 5.21 Mb | Memory After: 5.22 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 = 23874 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 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.0004051 | Memory Before: 5.22 Mb | Memory After: 5.23 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 = 23874 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 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.0002630 | Memory Before: 5.21 Mb | Memory After: 5.22 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 = 23859 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const3Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004380 | Memory Before: 5.22 Mb | Memory After: 5.23 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 = 23859 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const3Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002391 | Memory Before: 5.23 Mb | Memory After: 5.23 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 = 23866 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 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.0004270 | Memory Before: 5.23 Mb | Memory After: 5.24 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 = 23866 AND c.type_id = 'advancedphoto' AND c.item_id = 5602 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.0002129 | Memory Before: 5.22 Mb | Memory After: 5.23 Mb | Memory Used: 5.49 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 = 5602
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.0004230 | Memory Before: 5.22 Mb | Memory After: 5.23 Mb | Memory Used: 6.48 kb | Rows: 11 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'advancedphoto' AND l.item_id = 5602
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const10Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002441 | Memory Before: 5.24 Mb | Memory After: 5.24 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 = 5602
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.0174029 | Memory Before: 5.24 Mb | Memory After: 5.26 Mb | Memory Used: 15.19 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 = 28977)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5503
/* 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.0009360 | Memory Before: 5.23 Mb | Memory After: 5.24 Mb | Memory Used: 8.37 kb | Rows: 11 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "advancedphoto")

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 5503
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const9Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0003228 | Memory Before: 5.27 Mb | Memory After: 5.28 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 = 5503
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const9Using where; Using index
0.0042849 | Memory Before: 5.27 Mb | Memory After: 5.28 Mb | Memory Used: 10.65 kb | Rows: 2 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'advancedphoto' AND c.item_id = 5503 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.0029149 | Memory Before: 5.3 Mb | Memory After: 5.3 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 23262 AND c.type_id = 'advancedphoto' AND c.item_id = 5503 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.0004349 | Memory Before: 5.3 Mb | Memory After: 5.31 Mb | Memory Used: 10.17 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 23262 AND c.type_id = 'advancedphoto' AND c.item_id = 5503 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