{{title}}

{{message}}

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

مصطفی کمالی

متولد 27 مهر, 1998
کد امنیتی
مصطفی کمالی
مرد.....
سید متین سمبلستان
چمران مهمه...
  • 29 تیر, 1394
  • ·
  • احسنت!
مهدی علی خاصی
نیمه پنهان ماه- جلد اول- چمران...
  • 30 تیر, 1394
  • ·
  • احسنت!
مصطفی کمالی
مصطفی کمالی
خدایا ابراهیم را گفتی که عزیزترین فرزندش را قربانی کند و او اسماعیل را مهیای قربان کرد..... هنگامیکه پدر کارد را به گلوی فرزندش نزدیک میکرد،ندا آمد دست نگهدار...ابراهیم آزمایش خود را داد ولی اسماعیل هنوز به آن درجه تکامل نرسیده بود که قربان شود زمان زیادی گذشت تا قربانی کامل که عزیزترین فرزنداد آدم بود به درجهارزش قربانی شدن رسید و در همان راه خدا قربان شد و او حسین بود.....
مصطفی کمالی
قبول شهادت مرا آزاد کرده است من آزادی خود را به هیچ چیز حتی به حیات خود نمیفروشم....
مصطفی کمالی
تیم شهر من....س---------پاه----------انه...!
سیداحسان مدنی
هروقت ذوب آهن نبود بعد مزه بنداز
  • 26 اردیبهشت, 1394
  • ·
  • احسنت!
محمد امين زماني
:|
  • 27 اردیبهشت, 1394
  • ·
  • احسنت!
مصطفی کمالی
آخوندم آخوندای قدیم....!!!
مصطفی کمالی
مصطفی کمالی
بسم الله الرحمن الرحیم سبح باسم ربک الاعلی الذی خلق فسوی والذی قدر فهدی.....
محمد حسین مستاجران
یه حرف (( ب )) توی آیه اول، زیادی نوشته شده!!!
  • 20 آبان, 1393
  • ·
  • احسنت!
مصطفی کمالی
چی شده؟!!!
محمد حامد صادق زاده
بیا اینم حلقه مفقوده که پیدا شد
  • 25 آبان, 1393
  • ·
  • احسنت!
مصطفی کمالی
بسم الله الرحمن الرحیم سبح باسم ربک الاعلی الذی خلق فسوی والذی قدر فهدی.....
محمد حسین مستاجران
یه حرف (( ب )) توی آیه اول، زیادی نوشته شده!!!
  • 20 آبان, 1393
  • ·
  • احسنت!
مصطفی کمالی
و این مرد بزرگ چه کسی میتواند باشد....
دانیال پرورش فر
یعنی میخوای بگی اون روزا همراه اردو سمیروممون شهید چمران بودن؟
  • 29 مهر, 1393
  • ·
  • احسنت!
مصطفی کمالی
و اگر بگویند فقط یک روز باقی مانده است.....
مصطفی کمالی
نورً علی نور.....
محمدسجاد احمدی
یادم بچه که بودیم تلویزیون کلا دو تا کانل داشت
شبکه یک شب ها ساعت 10:30 -11 آیت الله جوادی آملی را می گذاشت و همیشه تا ایشان را می گذاشت، پای حرفهاشان خوابمان می برد
اصلا ایشان را نمی شناختیم
و یادم که می گفتیم، آقای خواب آور آمدن
و...
  • 23 شهریور, 1393
  • ·
  • احسنت!
محمدسجاد احمدی
سال اول دبیرستان هم با مجمع رفتیم قم
قصه مفصل و خوبی دارد
ولی شب تا نزدیک صبح بیدار بودیم
و بعد دو ساعتی خواب
رفتیم نماز صبح را پشت سر آیت الله بهجت خواندیم
نمازی که واقعا شلوغ بود
تا حالا نماز صبحی (در غیر از حرم ها) به این شلوغی ندیدم
و بماند گه بزرگان چه چیزهایی برای آن نمازها و آن مسجد می گن
ولی ما که فکر کنم با قواعد فقهی و... نمازمان را اعاده نکردیم
آخه به خاطر بیداریهای شب قبلش در آن نماز با حال و طولانی که حتی اشک آن مرد خدا جاری می شد، بارها چرتمان برد و...
  • 23 شهریور, 1393
  • ·
  • احسنت!
محمدسجاد احمدی
آیت الله بهجت از دنیا رفتن و آن تنها نمازم پشت سرشان بود
و طلبه شدم و فهمیدم، آقاب خواب آور در جهان اسلام بی نظیره و عجب بزرگ مردی ه

لذا بعضی وقت ها، خیلی مواظب باشید، چرا که
وَ الْفُرْصَةُ تَمُرُّ مَرَّ السَّحَابِ فَانْتَهِزُوا فُرَصَ الْخَيْر
  • 23 شهریور, 1393
  • ·
  • احسنت!
مصطفی کمالی
حیفا برای بعضیا نمیتونم پست بنویسم...البته اشکال هم نداره بعضیا جنبه نقد ندارن که حرفی که یه عامویی رو حالا به هر دلیلی زده و بعدش هم اظهار پشیمانی کرده و گفته با منتقدا نبوده،رو اینقدر بزرگ کنه و در موردش با خوشمزگی مزه بیاد..
واقعا متاسفم که همچین کسایی...
علی عباسی
خندهخندهخندهخنده
همینه که شوما میگید!!!
بله!!!
درستیه!!!
خندهخندهخندهخنده
  • 24 مرداد, 1393
  • ·
  • احسنت!
محمد مهدی پویان فر
کلا همینه...
این وریا برا اون وریا تاسف می خورن و اون وریا برا اون وریا!!
تهش هم هیچی...
  • 24 مرداد, 1393
  • ·
  • احسنت!
علی عباسی
تهش هیچی که نیس!!!
اول اونوریا یه چیزی مینویسند بعدش هی دو طرف برا هم تاسف می خورن!!!
  • 24 مرداد, 1393
  • ·
  • احسنت!
دانیال پرورش فر
سوال: هدف خود از ارسال این پست را بفرمایید.(20نمره)
  • 24 مرداد, 1393
  • ·
  • احسنت!
محمد مهدی عاصمی
سوال من از شما: هدف خود از نوشتن این کامنت در ذیل این پست و ننوشتن چنین نظرهایی در پست های قبل را بفرمایید.(20نمره)
  • 25 مرداد, 1393
  • ·
  • احسنت!
دانیال پرورش فر
سوال من از شما: مگه قراره من هر کامنتی زیر یه پست میذارم، زیر همه ی پست های دیگه هم بذارم؟؟ برو خب شو.
  • 25 مرداد, 1393
  • ·
  • احسنت!
محمد مهدی عاصمی
بنده منظورم پست های مشابه بود. ضمنا خودتون برین خب شین.
  • 25 مرداد, 1393
  • ·
  • احسنت!
محمد رضایی
احترام به بزرگتر.....
  • 25 مرداد, 1393
  • ·
  • احسنت!
دانیال پرورش فر
پست مشابهی خیلی نمی بینم. پستی که مستقیما و مستقلا داره به یه عده اعضای مجمعی عضو این طوری میشوره. و حیف و حیف میگه. و متأسفم که همچین کسایی ....
ضمنا جفتمون بریم خب شیم.
  • 25 مرداد, 1393
  • ·
  • احسنت!
دانیال پرورش فر
محمد، محمد بی احترامی نکرده. تو هم با ما بیا تا خب شیم.
  • 25 مرداد, 1393
  • ·
  • احسنت!
مصطفی کمالی
مصطفی کمالی
آقا کلا مسابقات ورزشی تیم ملی ایران تو صدا سیمای ما از سه حالت خارج نیست:
1.برد پیروزمندانه
2.مساوی ارزشمند
3.باختی که از ارزش های تیم چیزی کم نمیکنه!!!
مصطفی کمالی
صداسیمائه داریم؟!
  • 22 تیر, 1393
  • ·
  • احسنت!
مهدی علی خاصی
بهتر از صدا و سیمای کره ی شمالی که هست!
توی کره ی شمالی! صدا و سیما هرچی دلش میخواد میگه
مثلا دیروز اعلام کرد:بچه های کره ی شمالی به فینال جام جهانی رسیده اند و از اونجایی هم که توی کره، مثل ایران همه روی پشت بوم هاشون دوسه تا .... نیست و شبکه های .... ندارند و همه به دولت اعتماد دارند، همه باور میکنند این حرف هارا...
  • 23 تیر, 1393
  • ·
  • احسنت!
دانیال پرورش فر
شما از کره شمالی چی میدونی؟ غیر از همون مطالبی که همین رسانه ها مطرح می کنند؟
  • 23 تیر, 1393
  • ·
  • احسنت!
محمد جواد حاجی احمدی
البته این شایعه ای بیش نبوده...
  • 23 تیر, 1393
  • ·
  • احسنت!
محمد آقامیری
یه حرفایی میزنیا!
"مثل ایران همه روی پشت بوم هاشون دوسه تا ... نیست"
ما که یه دونش رو هم نداریم
حالا این آلت مشترکه چه قدر آگاهی داده چه قدر فساد داده
آگاهی اش که اثر منفی داشته
اما در مورد فساد بودنش مورد میشناسم، مورد میشنساما الکی نمیگم خیلی فساد داره مثلا بعد از یه مدت میبینی اصن نماز نمیخونه!

بعدش هم تشبیهی که زیاد صورت میگیره ایران به کره شمالی یعنی میان کره شمالی میگن خیلی افتضاحه بعد میگن ایران مث کره شمالی و ایران خیلی افتضاحه
تا وقتی یه کشور با "آمریکا" دوست و برادر نباشه همین حرفا براش هست...
  • 23 تیر, 1393
  • ·
  • احسنت!
امیررضا شیرازی
مطمئن باش اونی که با اینکار نماز نمی خونه از اول نمازش الکی و دروغی بوده
  • 24 تیر, 1393
  • ·
  • احسنت!
محمد آقامیری
میشناسمشون!خیلی میشناسمشون
خب من که نگفته همه این طوری احتمالا افرادی هم هستن که میبینن ولی تاثیر منفی روشون نداره!
  • 24 تیر, 1393
  • ·
  • احسنت!
علی انواری
مگه تو کره شمالی مردم می دونن جام جهانی چیه؟
  • 23 تیر, 1393
  • ·
  • احسنت!
محمد آقامیری
بله نقطه
  • 23 تیر, 1393
  • ·
  • احسنت!
محمد مهدی پویان فر
تصوری که ما از کره شمالی یا حتی پاکستان(!) داریم خیلی شباهت داره به تصوری که خیلیای دیگه از کشور ما دارن!
همش متاثر از رسانه ها و غالبا غلط!!
  • 24 تیر, 1393
  • ·
  • احسنت!
مصطفی کمالی
و وقتی عقاب به پرواز در می آید...
محمد امین شیرزادی
خیییلی حال کردم با این گل...
عالیییی ود...
  • 2 تیر, 1393
  • ·
  • احسنت!
مصطفی کمالی
مصطفی کمالی
مصطفی کمالی
حالا دوستان بیان ادعای هندوانه خوری و ...بکنند!
مردین هندونه این جوری باز کنید!!
  • 30 فروردین, 1393
  • ·
  • احسنت!
محمد حسین مستاجران
به به...!
دلم خواست...
بیاین بریم هندوانه بخوریم! نبود? رفتیما...
  • 30 فروردین, 1393
  • ·
  • احسنت!
امیرحسین لطفی
:
بخورید!
خورندگی و برازندگی...!
  • 30 فروردین, 1393
  • ·
  • احسنت!
علی عباسی
من میام!!!
کی و کجا؟؟؟
  • 30 فروردین, 1393
  • ·
  • احسنت!
محمد حسین مستاجران
به جا این کارا برو بشین حسابانتو بخون که فردا پوستتون کندس!!!
  • 30 فروردین, 1393
  • ·
  • احسنت!
علی عباسی
همون که آقای لطفی گفت:
بیا و خوبی کن
خواستم تنها نباشی!!!
  • 30 فروردین, 1393
  • ·
  • احسنت!
هاشم زنداني
مزه شم خب بود یا فقط قیافه داشت؟
  • 30 فروردین, 1393
  • ·
  • احسنت!
مصطفی کمالی
علی عباسی
نمیدونم چرا یاد این متن افتادم
متنی که تو نشریه ی هفته ی دفاع مقدس چاپ شد:
چند روز بیشتر نیست که چند تا داستان در مورد رفاقت بین شهدا خودم ولی... ولی این چند تا داستان ، از کل حرف هایی که در مورد آیین دوست یابی و دوست خوب کیه دوست بد کیه و فلان و بهمان بیشتر بوده. چون شهادت داستان نیست. شهدا شخصیت های داستان نیستند. واقعی اند.
چند وقت پیش داشتم به این فکر می کردم که خوش به حال پت و مت!!! با هم همیشه رفیق اند. هیچ وقت با هم جر و بحث نمی کنند. همیشه با هم اند. اما ما چی؟ ما تا یه کاری می کنیم به مذاق دوستمون خوش نمیاد سریع دعوا می کنیم . و البته سریع آشتی می کنیم!
داستان رفاقت بین شهدا رو خوندم. خیل...
  • 22 فروردین, 1393
  • ·
  • احسنت!
مصطفی کمالی
مصطفی کمالی
نمایش بیشتر
phpFox Developers Debug Toggle JavaScript Console
Version:
3.7.7
Product Code Name:
Nebula

Total Time:
1.5293710
PHP General Time:
1.2487697
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.2806013
SQL Queries:
241
SQL Memory Usage:
1.69 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
5.2 Mb
Total Memory Usage (Including Debug):
5.94 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
185.55.227.64


Server Time Stamp:
January 22, 2018, 12:26 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.0033200 | 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 ('0cd522c2d0ba40f642a40de8dcbe6e7b', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516580785', '/profile-75/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0007908 | 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.0048618 | Memory Before: 1.25 Mb | Memory After: 1.29 Mb | Memory Used: 35.69 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-75'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefPRIMARY,user_name,user_group_id,user_iduser_name103const2Using 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.0020249 | Memory Before: 1.69 Mb | Memory After: 1.7 Mb | Memory Used: 3.79 kb | Rows: 4 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 75
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_privacyrefuser_id,user_id_2user_id4const4 
0.0081110 | Memory Before: 1.81 Mb | Memory After: 1.82 Mb | Memory Used: 3.29 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo
WHERE view_id = 0 AND group_id = 0 AND user_id = 75
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_id4const62Using where
0.0006189 | Memory Before: 2 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 = 75
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsudALL MISSING KEY   19Using where
0.0004151 | Memory Before: 2.25 Mb | Memory After: 2.26 Mb | Memory Used: 4.34 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_user_design_order
WHERE user_id = 75
ORDER BY ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_design_orderrefuser_iduser_id4const1Using where; Using filesort
0.0003288 | Memory Before: 2.91 Mb | Memory After: 2.91 Mb | Memory Used: 3.43 kb | Rows: 0 | Slave: Yes
SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 75
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0215909 | Memory Before: 2.93 Mb | Memory After: 2.94 Mb | Memory Used: 7.45 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 = 75) 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 = 75
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   19Using 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,const19Using index
0.0003130 | Memory Before: 2.97 Mb | Memory After: 2.97 Mb | Memory Used: 3.35 kb | Rows: 0 | Slave: Yes
SELECT /*getListForProfile*/ fl.list_id, fl.name
FROM phpfox_friend_list AS fl
WHERE fl.user_id = 75 AND fl.is_profile = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEflrefuser_id,user_id_2user_id4const1Using where
0.0004179 | Memory Before: 3.04 Mb | Memory After: 3.05 Mb | Memory Used: 4.96 kb | Rows: 0 | 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 = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0212750 | Memory Before: 3.14 Mb | Memory After: 3.15 Mb | Memory Used: 12.91 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 = 75
/* 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 = 75
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN(0) AND feed.user_id = 75 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 = 75
/* 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   272Using temporary; Using filesort
1PRIMARYueq_refPRIMARY,user_idPRIMARY4feed.user_id1 
2DERIVEDfeedreftype_id,user_iduser_id4const127Using 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,const37Using where
5UNIONfeedrefprivacy_2,privacy_3,privacy_4,privacy,privacy_5privacy_55const,const8 
 UNION RESULT<union2,3,4,5>ALL MISSING KEY    Using temporary
0.0044560 | Memory Before: 3.41 Mb | Memory After: 3.42 Mb | Memory Used: 15.03 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 = 30412)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5715
/* 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.0063388 | Memory Before: 3.42 Mb | Memory After: 3.43 Mb | Memory Used: 9.34 kb | Rows: 18 | 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 = 5715
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,const14Using 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.0003719 | Memory Before: 3.49 Mb | Memory After: 3.5 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 = 5715
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const14Using where; Using index
0.0027049 | Memory Before: 3.5 Mb | Memory After: 3.51 Mb | Memory Used: 10.62 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 = 5715 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.0004799 | Memory Before: 3.54 Mb | Memory After: 3.54 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 = 24525 AND c.type_id = 'advancedphoto' AND c.item_id = 5715 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004430 | Memory Before: 3.54 Mb | Memory After: 3.55 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 = 24525 AND c.type_id = 'advancedphoto' AND c.item_id = 5715 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.0002589 | Memory Before: 3.55 Mb | Memory After: 3.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 = 24507 AND c.type_id = 'advancedphoto' AND c.item_id = 5715 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.0004580 | Memory Before: 3.55 Mb | Memory After: 3.56 Mb | Memory Used: 10.11 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 = 24507 AND c.type_id = 'advancedphoto' AND c.item_id = 5715 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002439 | Memory Before: 3.55 Mb | Memory After: 3.55 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 = 5715
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.0004830 | Memory Before: 3.54 Mb | Memory After: 3.55 Mb | Memory Used: 7.13 kb | Rows: 18 | 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 = 5715
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,const17Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002298 | Memory Before: 3.58 Mb | Memory After: 3.59 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 = 5715
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.0014429 | Memory Before: 3.57 Mb | Memory After: 3.57 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-photo" AND a.item_id = 5714
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.0009739 | Memory Before: 3.57 Mb | Memory After: 3.58 Mb | Memory Used: 6.81 kb | Rows: 0 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "user-photo")

WHERE (l.type_id = 'user_photo' OR l.type_id = 'user-photo') AND l.item_id = 5714
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_iditem_id4const1Using 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.0002792 | Memory Before: 3.57 Mb | Memory After: 3.58 Mb | Memory Used: 5.43 kb | Rows: 0 | 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 = 'user_photo' AND l.item_id = 5714
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002570 | Memory Before: 3.57 Mb | Memory After: 3.58 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-photo" AND a.item_id = 5714
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.0014551 | Memory Before: 3.59 Mb | Memory After: 3.61 Mb | Memory Used: 17.26 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 = 29462)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

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

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 5578
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.0002599 | Memory Before: 3.65 Mb | Memory After: 3.65 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 5578
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const13Using where; Using index
0.0002310 | Memory Before: 3.65 Mb | Memory After: 3.65 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 = 5578
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.0003588 | Memory Before: 3.66 Mb | Memory After: 3.66 Mb | Memory Used: 6.94 kb | Rows: 16 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'advancedphoto' AND l.item_id = 5578
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,const15Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002050 | Memory Before: 3.68 Mb | Memory After: 3.68 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 = 5578
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.0006771 | Memory Before: 3.68 Mb | Memory After: 3.69 Mb | Memory Used: 15.05 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 = 29461)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5577
/* 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.0006568 | Memory Before: 3.67 Mb | Memory After: 3.68 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 = "advancedphoto")

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 5577
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,const14Using 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.0002730 | Memory Before: 3.73 Mb | Memory After: 3.73 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 = 5577
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const14Using where; Using index
0.0002210 | Memory Before: 3.73 Mb | Memory After: 3.74 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 = 5577
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.0003710 | Memory Before: 3.74 Mb | Memory After: 3.75 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 = 5577
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.0002408 | Memory Before: 3.76 Mb | Memory After: 3.77 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 5577
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.0011320 | Memory Before: 3.76 Mb | Memory After: 3.78 Mb | Memory Used: 15.07 kb | Rows: 1 | Slave: Yes
SELECT u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity, photo.*, l.like_id AS is_liked, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, pfeed.feed_id
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = photo.parent_user_id)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_like AS l
            ON((l.type_id = 'photo' OR l.type_id = 'advancedphoto') AND l.item_id = photo.photo_id AND l.user_id = 0)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 29022)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

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

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

WHERE c.parent_id = 0 AND c.type_id = 'advancedphoto' AND c.item_id = 5511 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0004542 | Memory Before: 3.8 Mb | Memory After: 3.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 = 23063 AND c.type_id = 'advancedphoto' AND c.item_id = 5511 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003951 | Memory Before: 3.8 Mb | Memory After: 3.81 Mb | Memory Used: 10.11 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 = 23063 AND c.type_id = 'advancedphoto' AND c.item_id = 5511 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002301 | Memory Before: 3.81 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 = 23054 AND c.type_id = 'advancedphoto' AND c.item_id = 5511 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003788 | Memory Before: 3.81 Mb | Memory After: 3.82 Mb | Memory Used: 10.08 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 23054 AND c.type_id = 'advancedphoto' AND c.item_id = 5511 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002120 | Memory Before: 3.81 Mb | Memory After: 3.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 = "advancedphoto" AND a.item_id = 5511
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.0002921 | Memory Before: 3.81 Mb | Memory After: 3.81 Mb | Memory Used: 5.9 kb | Rows: 5 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'advancedphoto' AND l.item_id = 5511
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const4Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002220 | Memory Before: 3.81 Mb | Memory After: 3.82 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 = 5511
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.0013421 | Memory Before: 3.83 Mb | Memory After: 3.84 Mb | Memory Used: 15.09 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 = 26120)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

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

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 5043
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,const17Using 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.0002840 | Memory Before: 3.89 Mb | Memory After: 3.9 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 = 5043
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const17Using where; Using index
0.0001960 | Memory Before: 3.9 Mb | Memory After: 3.9 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 = 5043
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.0004051 | Memory Before: 3.9 Mb | Memory After: 3.91 Mb | Memory Used: 7.51 kb | Rows: 22 | 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 = 5043
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,const21Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002370 | Memory Before: 3.94 Mb | Memory After: 3.94 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 = 5043
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.0005360 | Memory Before: 3.93 Mb | Memory After: 3.94 Mb | Memory Used: 15.12 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 = 26119)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 5042
/* 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.0005150 | Memory Before: 3.92 Mb | Memory After: 3.93 Mb | Memory Used: 7.93 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 = 5042
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.0002432 | Memory Before: 3.95 Mb | Memory After: 3.95 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 = 5042
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const7Using where; Using index
0.0001941 | Memory Before: 3.95 Mb | Memory After: 3.96 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 = 5042
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.0003450 | Memory Before: 3.96 Mb | Memory After: 3.96 Mb | Memory Used: 6.19 kb | Rows: 8 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'advancedphoto' AND l.item_id = 5042
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const7Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002351 | Memory Before: 3.97 Mb | Memory After: 3.98 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 = 5042
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.0012300 | Memory Before: 3.98 Mb | Memory After: 3.99 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 = 25305)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4922
/* 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.0009849 | Memory Before: 3.97 Mb | Memory After: 3.98 Mb | Memory Used: 8.93 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 = "advancedphoto")

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

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

WHERE c.parent_id = 19861 AND c.type_id = 'advancedphoto' AND c.item_id = 4922 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0005791 | Memory Before: 4.05 Mb | Memory After: 4.06 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 = 19861 AND c.type_id = 'advancedphoto' AND c.item_id = 4922 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002260 | Memory Before: 4.05 Mb | Memory After: 4.05 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 = 4922
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.0004439 | Memory Before: 4.05 Mb | Memory After: 4.05 Mb | Memory Used: 6.84 kb | Rows: 15 | 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 = 4922
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,const14Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002339 | Memory Before: 4.07 Mb | Memory After: 4.07 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 = 4922
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.0005870 | Memory Before: 4.07 Mb | Memory After: 4.08 Mb | Memory Used: 15.17 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 = 25304)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

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

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4921
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.0003109 | Memory Before: 4.09 Mb | Memory After: 4.09 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 = 4921
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const7Using where; Using index
0.0005941 | Memory Before: 4.09 Mb | Memory After: 4.1 Mb | Memory Used: 10.39 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'advancedphoto' AND c.item_id = 4921 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002720 | Memory Before: 4.11 Mb | Memory After: 4.11 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 = 19902 AND c.type_id = 'advancedphoto' AND c.item_id = 4921 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003932 | Memory Before: 4.11 Mb | Memory After: 4.12 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 = 19902 AND c.type_id = 'advancedphoto' AND c.item_id = 4921 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002160 | Memory Before: 4.11 Mb | Memory After: 4.12 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 = 4921
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.0003779 | Memory Before: 4.11 Mb | Memory After: 4.12 Mb | Memory Used: 6.21 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 = 4921
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.0002170 | Memory Before: 4.12 Mb | Memory After: 4.13 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 = 4921
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.0007501 | Memory Before: 4.13 Mb | Memory After: 4.15 Mb | Memory Used: 15.16 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 = 25303)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

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

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4920
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.0002749 | Memory Before: 4.17 Mb | Memory After: 4.17 Mb | Memory Used: 3.24 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 = 4920
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const10Using where; Using index
0.0005851 | Memory Before: 4.17 Mb | Memory After: 4.18 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 = 4920 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002480 | Memory Before: 4.19 Mb | Memory After: 4.19 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 = 19857 AND c.type_id = 'advancedphoto' AND c.item_id = 4920 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004461 | Memory Before: 4.19 Mb | Memory After: 4.2 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 = 19857 AND c.type_id = 'advancedphoto' AND c.item_id = 4920 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002091 | Memory Before: 4.19 Mb | Memory After: 4.2 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 4920
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.0003488 | Memory Before: 4.19 Mb | Memory After: 4.2 Mb | Memory Used: 6.56 kb | Rows: 12 | 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 = 4920
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const11Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002551 | Memory Before: 4.21 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 = "advancedphoto" AND a.item_id = 4920
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.0022528 | Memory Before: 4.21 Mb | Memory After: 4.22 Mb | Memory Used: 15.18 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 = 25200)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4893
/* 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.0009320 | Memory Before: 4.2 Mb | Memory After: 4.21 Mb | Memory Used: 8.92 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 = "advancedphoto")

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

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

WHERE c.parent_id = 19805 AND c.type_id = 'advancedphoto' AND c.item_id = 4893 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0006611 | Memory Before: 4.28 Mb | Memory After: 4.29 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 = 19805 AND c.type_id = 'advancedphoto' AND c.item_id = 4893 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const1Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0003269 | Memory Before: 4.28 Mb | Memory After: 4.29 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 = 4893
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.28 Mb | Memory After: 4.29 Mb | Memory Used: 6.84 kb | Rows: 15 | 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 = 4893
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.0002351 | Memory Before: 4.3 Mb | Memory After: 4.31 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 4893
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.0011299 | Memory Before: 4.3 Mb | Memory After: 4.32 Mb | Memory Used: 15.16 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 = 24854)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4834
/* 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.0050371 | Memory Before: 4.29 Mb | Memory After: 4.3 Mb | Memory Used: 9.34 kb | Rows: 18 | 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 = 4834
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,const15Using 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.0002730 | Memory Before: 4.36 Mb | Memory After: 4.36 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 = 4834
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const15Using where; Using index
0.0002038 | 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 = 4834
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.0003870 | Memory Before: 4.37 Mb | Memory After: 4.37 Mb | Memory Used: 7.13 kb | Rows: 18 | 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 = 4834
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.0002031 | Memory Before: 4.39 Mb | Memory After: 4.4 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 4834
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.0009019 | Memory Before: 4.39 Mb | Memory After: 4.41 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 = 24626)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4800
/* 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.0010068 | Memory Before: 4.38 Mb | Memory After: 4.39 Mb | Memory Used: 10.31 kb | Rows: 25 | 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 = 4800
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,const19Using 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.0002761 | Memory Before: 4.47 Mb | Memory After: 4.47 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 = 4800
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const19Using where; Using index
0.0016289 | Memory Before: 4.47 Mb | Memory After: 4.48 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 = 'advancedphoto' AND c.item_id = 4800 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const3Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0005090 | Memory Before: 4.5 Mb | Memory After: 4.51 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 = 19357 AND c.type_id = 'advancedphoto' AND c.item_id = 4800 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.0004332 | Memory Before: 4.5 Mb | Memory After: 4.51 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 = 19357 AND c.type_id = 'advancedphoto' AND c.item_id = 4800 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002570 | Memory Before: 4.52 Mb | Memory After: 4.52 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 = 19356 AND c.type_id = 'advancedphoto' AND c.item_id = 4800 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004251 | Memory Before: 4.52 Mb | Memory After: 4.53 Mb | Memory Used: 10.08 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 19356 AND c.type_id = 'advancedphoto' AND c.item_id = 4800 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: 4.53 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 = 19355 AND c.type_id = 'advancedphoto' AND c.item_id = 4800 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.0003910 | Memory Before: 4.53 Mb | Memory After: 4.54 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 = 19355 AND c.type_id = 'advancedphoto' AND c.item_id = 4800 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.52 Mb | Memory After: 4.53 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 4800
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.0004332 | Memory Before: 4.52 Mb | Memory After: 4.53 Mb | Memory Used: 7.77 kb | Rows: 25 | 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 = 4800
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.0002480 | Memory Before: 4.56 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 = 4800
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.0084898 | Memory Before: 4.55 Mb | Memory After: 4.55 Mb | Memory Used: 5.69 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 = 2161
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0008471 | Memory Before: 4.54 Mb | Memory After: 4.54 Mb | Memory Used: 6.83 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 = 2161
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_iditem_id4const2Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0003390 | Memory Before: 4.54 Mb | Memory After: 4.54 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2161
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_iditem_id4const2Using where
0.0020521 | Memory Before: 4.54 Mb | Memory After: 4.55 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 = 'user_status' AND c.item_id = 2161 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.0003819 | Memory Before: 4.57 Mb | Memory After: 4.57 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 18877 AND c.type_id = 'user_status' AND c.item_id = 2161 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,const2Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0007260 | Memory Before: 4.57 Mb | Memory After: 4.58 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 = 18877 AND c.type_id = 'user_status' AND c.item_id = 2161 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,const2Using 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.59 Mb | Memory After: 4.59 Mb | Memory Used: 3.14 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 = 18883 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0006149 | Memory Before: 4.59 Mb | Memory After: 4.6 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 = 18883 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0002391 | Memory Before: 4.61 Mb | Memory After: 4.61 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 = 18889 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0003991 | Memory Before: 4.61 Mb | Memory After: 4.62 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 = 18889 AND c.type_id = 'user_status' AND c.item_id = 2161 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002460 | Memory Before: 4.62 Mb | Memory After: 4.62 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 = 18895 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0006671 | Memory Before: 4.62 Mb | Memory After: 4.63 Mb | Memory Used: 10.93 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 = 18895 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0002208 | Memory Before: 4.64 Mb | Memory After: 4.64 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 = 18896 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0003622 | Memory Before: 4.64 Mb | Memory After: 4.65 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 = 18896 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0002050 | Memory Before: 4.65 Mb | Memory After: 4.66 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

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

WHERE c.parent_id = 18913 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0002289 | Memory Before: 4.66 Mb | Memory After: 4.67 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 = 18914 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0004101 | Memory Before: 4.67 Mb | Memory After: 4.68 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 = 18914 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0002170 | Memory Before: 4.65 Mb | Memory After: 4.66 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 18876 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0004659 | Memory Before: 4.66 Mb | Memory After: 4.67 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 = 18876 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0003030 | Memory Before: 4.67 Mb | Memory After: 4.67 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 = 18878 AND c.type_id = 'user_status' AND c.item_id = 2161 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003929 | Memory Before: 4.67 Mb | Memory After: 4.68 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 = 18878 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0002360 | Memory Before: 4.68 Mb | Memory After: 4.68 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 = 18868 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0004551 | Memory Before: 4.68 Mb | Memory After: 4.69 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 = 18868 AND c.type_id = 'user_status' AND c.item_id = 2161 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.0004032 | Memory Before: 4.67 Mb | Memory After: 4.68 Mb | Memory Used: 5.55 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_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 = 2161
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0002820 | Memory Before: 4.67 Mb | Memory After: 4.68 Mb | Memory Used: 5.55 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_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 = 2161
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.0011890 | Memory Before: 4.69 Mb | Memory After: 4.71 Mb | Memory Used: 15.16 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 = 23940)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4657
/* 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.0007360 | Memory Before: 4.68 Mb | Memory After: 4.69 Mb | Memory Used: 7.94 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 = 4657
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const6Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002410 | Memory Before: 4.71 Mb | Memory After: 4.71 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 = 4657
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const6Using where; Using index
0.0002191 | Memory Before: 4.71 Mb | Memory After: 4.72 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 = 4657
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.72 Mb | Memory After: 4.73 Mb | Memory Used: 6.19 kb | Rows: 8 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'advancedphoto' AND l.item_id = 4657
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const7Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002601 | Memory Before: 4.73 Mb | Memory After: 4.74 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 = 4657
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.0007839 | Memory Before: 4.74 Mb | Memory After: 4.75 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 = 2099
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0009449 | Memory Before: 4.73 Mb | Memory After: 4.74 Mb | Memory Used: 8.06 kb | Rows: 9 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 2099
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 9Using 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.0003581 | Memory Before: 4.76 Mb | Memory After: 4.77 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 = 2099
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 9Using where; Using index
0.0009930 | Memory Before: 4.76 Mb | Memory After: 4.77 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 = 2099 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.0005388 | 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 = 18560 AND c.type_id = 'user_status' AND c.item_id = 2099 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,const2Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0005960 | Memory Before: 4.8 Mb | Memory After: 4.81 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 = 18560 AND c.type_id = 'user_status' AND c.item_id = 2099 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,const2Using 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.0002208 | Memory Before: 4.82 Mb | Memory After: 4.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 = 18563 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0003688 | Memory Before: 4.82 Mb | Memory After: 4.83 Mb | Memory Used: 10.11 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 = 18563 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0002232 | Memory Before: 4.83 Mb | Memory After: 4.83 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 = 18580 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0003719 | Memory Before: 4.83 Mb | Memory After: 4.84 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 = 18580 AND c.type_id = 'user_status' AND c.item_id = 2099 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.83 Mb | Memory After: 4.83 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 = 18559 AND c.type_id = 'user_status' AND c.item_id = 2099 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,const2Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0006220 | Memory Before: 4.83 Mb | Memory After: 4.85 Mb | Memory Used: 14 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 = 18559 AND c.type_id = 'user_status' AND c.item_id = 2099 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,const2Using 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: 4.86 Mb | Memory After: 4.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 = 18561 AND c.type_id = 'user_status' AND c.item_id = 2099 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.86 Mb | Memory After: 4.87 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 = 18561 AND c.type_id = 'user_status' AND c.item_id = 2099 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: 4.87 Mb | Memory After: 4.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 = 18562 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0004101 | Memory Before: 4.88 Mb | Memory After: 4.89 Mb | Memory Used: 10.13 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 18562 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0002501 | Memory Before: 4.88 Mb | Memory After: 4.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 = 18568 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0004401 | Memory Before: 4.89 Mb | Memory After: 4.9 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 = 18568 AND c.type_id = 'user_status' AND c.item_id = 2099 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002241 | Memory Before: 4.9 Mb | Memory After: 4.91 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 = 18582 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0004010 | Memory Before: 4.9 Mb | Memory After: 4.91 Mb | Memory Used: 10.13 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 18582 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0002029 | 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 = 18585 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0004141 | 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 = 18585 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0002272 | Memory Before: 4.91 Mb | Memory After: 4.91 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 = 18558 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0003700 | Memory Before: 4.91 Mb | Memory After: 4.92 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 = 18558 AND c.type_id = 'user_status' AND c.item_id = 2099 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.0002551 | Memory Before: 4.9 Mb | Memory After: 4.91 Mb | Memory Used: 5.46 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "user-status" AND a.item_id = 2099
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.0002911 | 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 = "user-status" AND a.item_id = 2099
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.0135109 | Memory Before: 4.92 Mb | Memory After: 4.93 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 = 23633)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4561
/* 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.0073929 | Memory Before: 4.91 Mb | Memory After: 4.92 Mb | Memory Used: 7.94 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 = 4561
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const6Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002398 | Memory Before: 4.94 Mb | Memory After: 4.94 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 = 4561
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const6Using where; Using index
0.0041549 | Memory Before: 4.94 Mb | Memory After: 4.95 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 = 0 AND c.type_id = 'advancedphoto' AND c.item_id = 4561 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.0002010 | Memory Before: 4.96 Mb | Memory After: 4.96 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 18370 AND c.type_id = 'advancedphoto' AND c.item_id = 4561 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.0003769 | Memory Before: 4.96 Mb | Memory After: 4.97 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 = 18370 AND c.type_id = 'advancedphoto' AND c.item_id = 4561 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.0001919 | Memory Before: 4.97 Mb | Memory After: 4.97 Mb | Memory Used: 5.46 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 4561
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.0003631 | Memory Before: 4.96 Mb | Memory After: 4.97 Mb | Memory Used: 6.23 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 = 4561
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const7Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002580 | Memory Before: 4.98 Mb | Memory After: 4.98 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 = 4561
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.0057740 | Memory Before: 4.98 Mb | Memory After: 5 Mb | Memory Used: 15.29 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 = 22588)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

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

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4348
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const8Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002620 | Memory Before: 5.01 Mb | Memory After: 5.02 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 = 4348
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const8Using where; Using index
0.0002098 | Memory Before: 5.02 Mb | Memory After: 5.02 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 = 4348
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.0003450 | Memory Before: 5.02 Mb | Memory After: 5.03 Mb | Memory Used: 6.38 kb | Rows: 10 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'advancedphoto' AND l.item_id = 4348
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,const9Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002000 | Memory Before: 5.04 Mb | Memory After: 5.04 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 = 4348
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.0005720 | Memory Before: 5.04 Mb | Memory After: 5.06 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 = 22586)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4347
/* 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.0006001 | Memory Before: 5.03 Mb | Memory After: 5.04 Mb | Memory Used: 9.36 kb | Rows: 18 | 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 = 4347
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,const14Using 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.0002599 | Memory Before: 5.1 Mb | Memory After: 5.1 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 = 4347
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const14Using where; Using index
0.0018818 | Memory Before: 5.1 Mb | Memory After: 5.11 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 = 'advancedphoto' AND c.item_id = 4347 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.0004330 | Memory Before: 5.13 Mb | Memory After: 5.13 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 = 17613 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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: 5.13 Mb | Memory After: 5.14 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 = 17613 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002060 | Memory Before: 5.14 Mb | Memory After: 5.14 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 17601 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0005689 | Memory Before: 5.14 Mb | Memory After: 5.15 Mb | Memory Used: 10.59 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 = 17601 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.16 Mb | Memory After: 5.16 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 = 17606 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0003870 | 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 = 17606 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0002372 | 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 = 17608 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0004649 | Memory Before: 5.17 Mb | Memory After: 5.18 Mb | Memory Used: 10.62 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 = 17608 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0002279 | Memory Before: 5.19 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 = 17609 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0004110 | Memory Before: 5.19 Mb | Memory After: 5.2 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 = 17609 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0002089 | Memory Before: 5.2 Mb | Memory After: 5.21 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 = 17610 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0003660 | Memory Before: 5.2 Mb | Memory After: 5.21 Mb | Memory Used: 10.14 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 17610 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0002511 | 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 = 17598 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0004120 | Memory Before: 5.2 Mb | Memory After: 5.21 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 = 17598 AND c.type_id = 'advancedphoto' AND c.item_id = 4347 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.0001960 | Memory Before: 5.19 Mb | Memory After: 5.2 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 4347
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.0004120 | Memory Before: 5.19 Mb | Memory After: 5.2 Mb | Memory Used: 7.13 kb | Rows: 18 | 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 = 4347
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,const17Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002460 | Memory Before: 5.22 Mb | Memory After: 5.22 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 = 4347
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.0009909 | Memory Before: 5.21 Mb | Memory After: 5.23 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 = 22378)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4294
/* 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.0060070 | Memory Before: 5.21 Mb | Memory After: 5.21 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 = "advancedphoto")

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 4294
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEl