{{title}}

{{message}}

عضویت
مجمعی ها
شهبازی

حسین اعتصامی

متولد 25 شهریور, 1997
کد امنیتی
حسین اعتصامی
حسین اعتصامی
انشاء الله شهدای آینده ی اسلام!
حسین اعتصامی
انشاء الله شهدای آینده ی اسلام!
هاشم زنداني
زیادی کنتراستش بالاس!اون بطریه درست پیدا نی
  • 12 مهر, 1392
  • ·
  • احسنت!
هاشم زنداني
انشاء ا... ...
  • 12 مهر, 1392
  • ·
  • احسنت!
محمد مهدی پویان فر
حسین کوجای چن وقته پیدات نیس
  • 13 مهر, 1392
  • ·
  • احسنت!
هاشم زنداني
خرخون شدس!
  • 14 مهر, 1392
  • ·
  • احسنت!
محمد مهدی پویان فر
آی آی آی آی ...
آخ آخ آخ آخ ...
نچ نچصحبت نکردن
  • 14 مهر, 1392
  • ·
  • احسنت!
حسین اعتصامی
کم کم داره وقتش میشه!
اگه ندیدیم همدیگه رو حلال کونین!

یا امام رضا:
زائری آمده با خویش رضا میخواند ...
حسین اعتصامی
محمد مهدی پویان فر
تازه تو دفتر پایینی که بری می بینی یه چندتا مومیایی دارن نگات می کنن!!
  • 2 شهریور, 1392
  • ·
  • احسنت!
علی حمصی
آقا این عکس نکته داره! نکته مهمش اینه که بعد از ازدواج کارا میفته رو غلتک و راحت میشه! میبینین که سرازیری شده!
  • 2 شهریور, 1392
  • ·
  • احسنت!
حسین اعتصامی
حسین اعتصامی
حسین اعتصامی
پیمان شهبازی
با این که ذکر شد به دوستان پیشنهاد میکنم کتاب های دنیای قشنگ نو و 1984 و فیلم equilibrium یا همون توازن را
  • 29 مرداد, 1392
  • ·
  • احسنت!
رضا کنگازیان
من تا آخر نخوندم ولي چون ديدم خيليه لايك ميكونم!!!
  • 3 شهریور, 1392
  • ·
  • احسنت!
سید علی سادات
دنیای قشنگ نو و 1984 از بهترین رمان هایی ان که تا حالا نوشته شده بوخونید خّبث....
  • 3 شهریور, 1392
  • ·
  • احسنت!
حسین اعتصامی
22 سال پیش یه همچین روزی ... . . . . . . . . . . . . . . . . . . تولد علی بود! Jگلگلگلگلقلبقلبقلبقلبگلگلگلگلگلگل1221221221226767676767گلگلگلگلگلگلگل بابت همه چی مچکریم!
حسین اعتصامی
تنب بزرگ و کوچک ما در خلیج فارس جزء کویت و مسقط و عمان نمی‌شود گر صرف و نحو خوانده‌ای این نکته گوش دار هرچند نکته حالی نادان نمی‌شود گر هر دو تنب را بگذاری به روی هم هرگز برای پای تو تنبان نمی‌شود!
حسین اعتصامی
تنب بزرگ و کوچک ما در خلیج فارس
جزء کویت و مسقط و عمان نمی‌شود
گر صرف و نحو خوانده‌ای این نکته گوش دار
هرچند نکته حالی نادان نمی‌شود
گر هر دو تنب را بگذاری به روی هم
هرگز برای پای تو تنبان نمی‌شود!
  • 24 مرداد, 1392
  • ·
  • احسنت!
هاشم زنداني
عربا که تنبون نمیپوشن!از این مانتو سفیدا میپوشن!
  • 27 مرداد, 1392
  • ·
  • احسنت!
حسین اعتصامی
... پس از سلام، جواب سلام لازم نيست؟ براي زخمي راه، التيام لازم نيست؟ رسيدنم به تو واجب ترين نيازم بود وگرنه باقي درخواست هام، لازم نيست براي حاجي احرام بسته ي حرمت دگر زيارت بيت الحرام لازم نيست كبوترانه، هواي تو را به پر دارم براي كفتر جلدت كه دام لازم نيست اگرچه زشت و سياهم، ولي مگر آقا در اين عمارت شاهي، غلام لازم نيست!؟ ... صابر خراسانی
حسین اعتصامی
سالی که ما صفری بودیم فقط من و مبین و احمد قائم پور رفتیم مشهد (البته از اژه ای 2) اووخ آقای فولادگر میگفتند اینا انگار چند ساله س که مجمعین! شاید یکی از دلایلش این باشه که ما از خیلی قبل پیش ها با هم رفیق بودیم و با عباس آقا! این عکس اردوی یزده. سال سوم راهنمایی. بهترین اردوی زندگیم قبل از ورود به مجمع و الان هم از بهترین ها!
حسین اعتصامی
بیبین قدیما من چه قدر چاغ بودما!
حالا جالبه س بدونین بنده بچه که بودم بحران لاغری داشتم و از بس لاغر بوده م ترس این بوده س که بیمیرم!
اصش دلیل چاقیم همین بوده س!
از بس لاغر بوده م هی داده ن خورده م و به این روز افتادم!
البته الان به شدت لاغر شدم.
در واقع یک سال و نیمه که وزنم تغییر نکرده و ماه رمضونیه حتی یک کیلو و نیم کم شد!
و از اونجای که قدم خیلی توی این دو ساله نسبت به قبل بلند شد خیلی لاغر شدم!
  • 16 مرداد, 1392
  • ·
  • احسنت!
محمد مهدی پویان فر
مبارک باشه!!
  • 16 مرداد, 1392
  • ·
  • احسنت!
حسین اعتصامی
سلامت باشین!
  • 16 مرداد, 1392
  • ·
  • احسنت!
حسین اعتصامی
راسی اینجا باغ دولت آبادس!
  • 17 مرداد, 1392
  • ·
  • احسنت!
حسین اعتصامی
حسین اعتصامی
رفقا فقط 20 روز دیگه تا پرواز مونده ...
حسین اعتصامی
از امروز شد 18 روز!ای
  • 17 مرداد, 1392
  • ·
  • احسنت!
حسین اعتصامی
16 روز ...
  • 19 مرداد, 1392
  • ·
  • احسنت!
محمد حسین حاجی احمدی
حسین جون
کوجایی که پرواز یه روزه از عرش برگشته ...
  • 13 شهریور, 1392
  • ·
  • احسنت!
حسین اعتصامی
خواستم به آقای پرورش بگم که شوما هم از این عکسا دارین و لازم نیست به کسی حسودی کونین!
حسین اعتصامی
گلگلگلگلگلگلگلجشن و شادیجشن و شادیجشن و شادیجشن و شادیجشن و شادیجشن و شادی
  • 17 مرداد, 1392
  • ·
  • احسنت!
حسین اعتصامی
گویا آقای پرورش هنوز هم اینو ندیده ن!
  • 19 مرداد, 1392
  • ·
  • احسنت!
حسین اعتصامی
سلام
امروز خیلی روز مهمی بود!
هم تولد ممد بود و هم سرگروهم برگشت!
ممنون از همه!
امین امانی فر
روحانی مچکریم
  • 16 مرداد, 1392
  • ·
  • احسنت!
حسین اعتصامی
حسین اعتصامی
دوستان چرا اینقدر دور ورداشتین؟
یاد یکی از حرفهای آقای قاسم زاده افتادم در "نشست ما و قاسم زاده" که خیلی طولانیه و حالشو ندارم تایپ کونم ولی مهم اینه که یادش افتادم!
حالا شوما بعد از 4 سال استقلالا تو لیگ بردین! خب این برای یه تیم قدرتمندی مثل سپاهان خیلی طبیعیه که بعد از 4 سال بالاخره بتونه استقلال رو ببره و این انتظار واقعا از این تیم میرفت!
حالا نمیخوام بگم که داور دو تا پنالتی برای ما نگرفت و یه دونه هم برای شوما نگرفت که اگه درست پنالتی میگرفت بازی 3-3 مساوی میشد.
همچنین نمیخوام بگم کهموقعیت های گل استقلال 11 تا دونه بود و چه قدر تن سپاهانیا لرزید تا این بازی تموم شه.
من موقعی که بازی تموم شد لااقل خیالم راحت بود که دیگه سپاهانیا خودشون میدونن چه گندی زده ن و نیمیان لقز بوخونن! ولی انگاری شوما از اینایی هستین که صرف نتیجه رو قبول دارین و اصلا به کیفیت بازی نگاه نیمیکونین. شدین عین این بازی...
علی کاغذگران
در جواب آقای فرهادی باید بگم من همچین منظوری نداشتم ولی در کل بابت حرفم عذر خواهی میکنم.چیزی که تو سایت مهمه دوستیه...
  • 15 مرداد, 1392
  • ·
  • احسنت!
حسین اعتصامی
اینو به خوددون بوگوین!
  • 16 مرداد, 1392
  • ·
  • احسنت!
هاشم زنداني
کاملا مخالفم
  • 16 مرداد, 1392
  • ·
  • احسنت!
عرفان فرهادی
فدای سرتون
  • 15 مرداد, 1392
  • ·
  • احسنت!
یوسف صرّامی
آقای پویان براچی وقتی اصن فوتبال نیگاه نیمیکونی میای اصن خودتو فوتبالی میدونی؟کارت واقعا زشت و جواده!
میدونستی اینا؟
خواهشا هر کی فوتبال می بینه بیاد کل کل.به خدا حوصلمون رو سر برد این!
  • 15 مرداد, 1392
  • ·
  • احسنت!
محمد مهدی پویان فر
حالا اگه می گفتی فوتبالت خوب نیست یه چیزی!
لطفا قبل از پست گذاشتن یکم به محتویش فک کنین! و مهمتر اینکه یکی رو که نمی شناسین درموردش نظر ندین!
کدوم ابلهی میاد سر بازی که ندیده کل کل راه بندازه؟
اصی انگار شوماوا کل کل بلد نیستین! هی کم میارین میگین طرف فلانه و بیساره! برو کل کل یاد بیگیر عاموجون!
  • 16 مرداد, 1392
  • ·
  • احسنت!
هاشم زنداني
من 4 ساله فوتبال نیگا نمیکونم.
اما بحثا و شانتاژایی که اینجا راه انداختین منا قانع کرد برم 90این هفته را ببینم و بیام شانتاژ کونم!
  • 16 مرداد, 1392
  • ·
  • احسنت!
عرفان فرهادی
خیلی عالیه!! با دیدن برنامه 90 مجوز داریم تا همه رو از دم مرغ و حیوون بنامیم! جای تبریک داره این کشفتون آقا مبین!
  • 16 مرداد, 1392
  • ·
  • احسنت!
حسین اعتصامی
حسین اعتصامی
این احمد از بچگیش دیونه بود!
عباس زاده
تو خُبی!
  • 6 مرداد, 1392
  • ·
  • احسنت!
علی رضا خاکسار
HGHK ALH COLHD ;IKV, SVFHC LsKD
  • 6 مرداد, 1392
  • ·
  • احسنت!
محمّد حسین مستمند
الان شما زخمای کهنرو سرباز منی
  • 7 مرداد, 1392
  • ·
  • احسنت!
هاشم زنداني
کودوم زخم؟
اصی تو اون موقع که این عکس انداخته شده داشته ی خر میزده ی برا کنکور سمپاد(اردیبهشت 91),اووخ منظورت از زخم چی چیه س؟
  • 7 مرداد, 1392
  • ·
  • احسنت!
با وضو وارد شوید (معطر به
از اونجای که مطالب درون صفحه ها با نظر دادن بالا نیمیاد و ممکنه همه ندیده باشن منم اشتراک گذاشتم!
با وضو وارد شوید (معطر به
نمایش بیشتر
phpFox Developers Debug Toggle JavaScript Console
Version:
3.7.7
Product Code Name:
Nebula

Total Time:
3.1745989
PHP General Time:
2.9212244
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.2533745
SQL Queries:
228
SQL Memory Usage:
1.55 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
5.29 Mb
Total Memory Usage (Including Debug):
5.98 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
185.55.227.64


Server Time Stamp:
January 22, 2018, 12:30 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.0022728 | 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 ('281ea865bddd84ef5971f4cc9b6b9c46', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516581039', '/profile-44/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0002282 | 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.0010221 | Memory Before: 1.25 Mb | Memory After: 1.29 Mb | Memory Used: 35.84 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-44'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefPRIMARY,user_name,user_group_id,user_iduser_name103const1Using index condition
1SIMPLEugeq_refPRIMARY,user_group_idPRIMARY1majmaih1_majma.u.user_group_id1Using index condition
1SIMPLEuser_spaceeq_refuser_iduser_id4majmaih1_majma.u.user_id1 
1SIMPLEuser_fieldeq_refuser_iduser_id4majmaih1_majma.u.user_id1 
1SIMPLEtsrefstyle_id,is_active,style_id_2style_id_22majmaih1_majma.user_field.designer_style_id1Using where
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2majmaih1_majma.ts.theme_id1 
1SIMPLEuser_activityeq_refuser_iduser_id4majmaih1_majma.u.user_id1 
1SIMPLEufeq_refPRIMARYPRIMARY4majmaih1_majma.u.user_id1Using index
1SIMPLElsrefuser_id,user_id_2,user_id_3user_id_24majmaih1_majma.u.user_id44411Using where
1SIMPLEpeq_refPRIMARY,photo_id,photo_id_2PRIMARY4majmaih1_majma.user_field.cover_photo1Using index
0.0002511 | Memory Before: 1.69 Mb | Memory After: 1.7 Mb | Memory Used: 3.98 kb | Rows: 10 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 44
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_privacyrefuser_id,user_id_2user_id4const9 
0.0006340 | Memory Before: 1.82 Mb | Memory After: 1.82 Mb | Memory Used: 3.28 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo
WHERE view_id = 0 AND group_id = 0 AND user_id = 44
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_id4const60Using where
0.0005660 | Memory Before: 2.01 Mb | Memory After: 2.01 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: No
SELECT COUNT(sud.id)
FROM phpfox_ebooks_user_shelf AS sud
WHERE sud.user_id = 44
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsudALL MISSING KEY   19Using where
0.0006878 | Memory Before: 2.04 Mb | Memory After: 2.05 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_event
WHERE view_id = 0 AND item_id = 0 AND user_id = 44 AND start_time > 1516579200
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_eventrefuser_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5user_id4const1Using where
0.0023119 | Memory Before: 2.3 Mb | Memory After: 2.31 Mb | Memory Used: 4.45 kb | Rows: 2 | Slave: Yes
SELECT *
FROM phpfox_user_design_order
WHERE user_id = 44
ORDER BY ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_design_orderrefuser_iduser_id4const1Using where; Using filesort
0.0002820 | Memory Before: 2.91 Mb | Memory After: 2.93 Mb | Memory Used: 11.23 kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 1290
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
0.0021100 | Memory Before: 2.99 Mb | Memory After: 2.99 Mb | Memory Used: 3.41 kb | Rows: 0 | Slave: Yes
SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 44
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0062401 | Memory Before: 3.01 Mb | Memory After: 3.02 Mb | Memory Used: 7.46 kb | Rows: 6 | Slave: Yes
SELECT uf.dob_setting, friend.friend_id, friend.friend_user_id, friend.is_top_friend, friend.time_stamp, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_friend AS friend
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 44) 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 = 44
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   76Using 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,const76Using index
0.0003021 | Memory Before: 3.05 Mb | Memory After: 3.05 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 = 44 AND fl.is_profile = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEflrefuser_id,user_id_2user_id4const1Using where
0.0009301 | Memory Before: 3.12 Mb | Memory After: 3.13 Mb | Memory Used: 4.93 kb | Rows: 1 | Slave: Yes
SELECT cr.relation_id, crd.relation_data_id,crd.status_id, u.user_name, u.full_name, u.user_id, cr.phrase_var_name, cr.confirmation
FROM phpfox_custom_relation_data AS crd
     JOIN phpfox_custom_relation AS cr
            ON(cr.relation_id = crd.relation_id)
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = crd.with_user_id)

WHERE crd.relation_data_id = 16
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrdconstPRIMARYPRIMARY4const1 
1SIMPLEcrconstPRIMARYPRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const unique row not found
0.0149541 | Memory Before: 3.22 Mb | Memory After: 3.23 Mb | Memory Used: 12.95 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 = 44
/* 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 = 44
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN(0) AND feed.user_id = 44 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 = 44
/* 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   437Using temporary; Using filesort
1PRIMARYueq_refPRIMARY,user_idPRIMARY4feed.user_id1 
2DERIVEDfeedreftype_id,user_idtype_id77const218Using index condition; Using where
3UNIONfeedrefprivacy_2,privacy_3,privacy_4,type_id,privacy,privacy_5,user_idtype_id77const100Using index condition; Using where
4UNIONfeedrefprivacy_2,privacy_3,privacy_4,privacy,privacy_5,user_idprivacy_39const,const,const105Using where
5UNIONfeedrefprivacy_2,privacy_3,privacy_4,privacy,privacy_5privacy_55const,const14 
 UNION RESULT<union2,3,4,5>ALL MISSING KEY    Using temporary
0.0015709 | Memory Before: 3.53 Mb | Memory After: 3.54 Mb | Memory Used: 4.58 kb | Rows: 1 | Slave: Yes
SELECT p.page_id, p.title, p.total_like, pu.vanity_url, l.like_id AS is_liked, p.image_path, p.image_server_id
FROM phpfox_pages AS p
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages' AND l.item_id = p.page_id AND l.user_id = 0)

WHERE p.page_id = 69
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0051591 | Memory Before: 3.55 Mb | Memory After: 3.56 Mb | Memory Used: 8.68 kb | Rows: 13 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "pages")

WHERE (l.type_id = 'pages' OR l.type_id = 'pages') AND l.item_id = 69
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_id_281const,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.0002441 | Memory Before: 3.61 Mb | Memory After: 3.61 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages' OR l.type_id = 'pages') AND l.item_id = 69
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const12Using where; Using index
0.0002720 | Memory Before: 3.61 Mb | Memory After: 3.62 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "pages-itemLiked" AND a.item_id = 69
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.0003090 | Memory Before: 3.62 Mb | Memory After: 3.62 Mb | Memory Used: 5.44 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 = 'pages_itemLiked' AND l.item_id = 69
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.0002530 | Memory Before: 3.64 Mb | Memory After: 3.64 Mb | Memory Used: 5.45 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

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

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

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

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

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

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 3096
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.0002911 | Memory Before: 3.79 Mb | Memory After: 3.8 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 = 3096
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const13Using where; Using index
0.0133610 | Memory Before: 3.81 Mb | Memory After: 3.82 Mb | Memory Used: 10.87 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 = 3096 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.0044050 | Memory Before: 3.84 Mb | Memory After: 3.84 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 = 11000 AND c.type_id = 'advancedphoto' AND c.item_id = 3096 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.0006220 | Memory Before: 3.84 Mb | Memory After: 3.85 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 = 11000 AND c.type_id = 'advancedphoto' AND c.item_id = 3096 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.0042281 | Memory Before: 3.86 Mb | Memory After: 3.86 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

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

WHERE c.parent_id = 11188 AND c.type_id = 'advancedphoto' AND c.item_id = 3096 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.0004420 | Memory Before: 3.87 Mb | Memory After: 3.88 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 = 11188 AND c.type_id = 'advancedphoto' AND c.item_id = 3096 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: 3.87 Mb | Memory After: 3.88 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

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

WHERE c.parent_id = 10914 AND c.type_id = 'advancedphoto' AND c.item_id = 3096 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.0002508 | Memory Before: 3.88 Mb | Memory After: 3.89 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 10907 AND c.type_id = 'advancedphoto' AND c.item_id = 3096 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004270 | Memory Before: 3.89 Mb | Memory After: 3.9 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 = 10907 AND c.type_id = 'advancedphoto' AND c.item_id = 3096 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.0002568 | Memory Before: 3.88 Mb | Memory After: 3.89 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 = 3096
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.0004070 | Memory Before: 3.88 Mb | Memory After: 3.88 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 = 3096
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.0002329 | Memory Before: 3.9 Mb | Memory After: 3.91 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 = 3096
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.0009291 | Memory Before: 3.9 Mb | Memory After: 3.91 Mb | Memory Used: 9.61 kb | Rows: 1 | Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.reg_method, e.page_id, apps.image_path AS app_image_path, e.title, e.app_id AS is_app, pu.vanity_url, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_pages_feed_comment AS fc
     JOIN phpfox_pages AS e
            ON(e.page_id = fc.parent_user_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = e.page_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = e.page_id)
     LEFT JOIN phpfox_app AS apps
            ON(apps.app_id = e.app_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)

WHERE fc.feed_comment_id = 183
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEappssystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLEfcconstPRIMARY,parent_user_idPRIMARY4const1 
1SIMPLEeconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEurefpage_idpage_id4const2 
0.0003879 | Memory Before: 3.91 Mb | Memory After: 3.91 Mb | Memory Used: 4.31 kb | Rows: 22 | Slave: Yes
SELECT *
FROM phpfox_pages_perm
WHERE page_id = 54
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_pages_permrefpage_idpage_id4const21 
0.0007710 | Memory Before: 3.91 Mb | Memory After: 3.92 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 = "pages-comment")

WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 183
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 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.0003622 | Memory Before: 3.94 Mb | Memory After: 3.94 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'pages_comment' OR l.type_id = 'pages-comment') AND l.item_id = 183
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id_281 9Using where; Using index
0.0002651 | Memory Before: 3.94 Mb | Memory After: 3.94 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 = "pages-comment" AND a.item_id = 183
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.0003719 | Memory Before: 3.94 Mb | Memory After: 3.95 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 = 'pages_comment' AND l.item_id = 183
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.0002780 | Memory Before: 3.96 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 = "pages-comment" AND a.item_id = 183
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.0010331 | Memory Before: 3.96 Mb | Memory After: 3.98 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 = 11802)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

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

WHERE c.parent_id = 0 AND c.type_id = 'advancedphoto' AND c.item_id = 2623 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.0007029 | Memory Before: 4.01 Mb | Memory After: 4.01 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 = 8458 AND c.type_id = 'advancedphoto' AND c.item_id = 2623 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004461 | Memory Before: 4.01 Mb | Memory After: 4.02 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 = 8458 AND c.type_id = 'advancedphoto' AND c.item_id = 2623 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.02 Mb | Memory After: 4.02 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 = 8456 AND c.type_id = 'advancedphoto' AND c.item_id = 2623 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.0004201 | Memory Before: 4.02 Mb | Memory After: 4.03 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 = 8456 AND c.type_id = 'advancedphoto' AND c.item_id = 2623 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.0003471 | Memory Before: 4.02 Mb | Memory After: 4.03 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 = 2623
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.0005839 | Memory Before: 4.02 Mb | Memory After: 4.03 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 = 2623
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.0002360 | Memory Before: 4.03 Mb | Memory After: 4.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 = 2623
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.0067332 | Memory Before: 4.04 Mb | Memory After: 4.05 Mb | Memory Used: 10.62 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, link.*, p.app_id, a.image_path AS app_image_path, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_link AS link
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'link' AND l.item_id = link.link_id AND l.user_id = 0)
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = link.parent_user_id)
     LEFT JOIN phpfox_pages AS p
            ON(p.page_id = u.profile_page_id)
     LEFT JOIN phpfox_app AS a
            ON(a.app_id = p.app_id)

WHERE link.link_id = 109
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEasystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLElinkconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEpeq_refPRIMARY,page_idPRIMARY4majmaih1_majma.u.profile_page_id1 
0.0007479 | Memory Before: 4.04 Mb | Memory After: 4.04 Mb | Memory Used: 6.95 kb | Rows: 1 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "link")

WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 109
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002570 | Memory Before: 4.04 Mb | Memory After: 4.05 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 109
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where; Using index
0.0008729 | Memory Before: 4.05 Mb | Memory After: 4.06 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 = 'link' AND c.item_id = 109 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.0002680 | Memory Before: 4.06 Mb | Memory After: 4.06 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 = 8481 AND c.type_id = 'link' AND c.item_id = 109 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.0004451 | Memory Before: 4.06 Mb | Memory After: 4.07 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 = 8481 AND c.type_id = 'link' AND c.item_id = 109 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.0003040 | Memory Before: 4.07 Mb | Memory After: 4.07 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 = "link" AND a.item_id = 109
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.0002682 | Memory Before: 4.07 Mb | Memory After: 4.07 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 = "link" AND a.item_id = 109
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.0008111 | Memory Before: 4.08 Mb | Memory After: 4.09 Mb | Memory Used: 5.63 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 750
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0031130 | Memory Before: 4.07 Mb | Memory After: 4.08 Mb | Memory Used: 6.8 kb | Rows: 0 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 750
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0003202 | Memory Before: 4.08 Mb | Memory After: 4.08 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 = 750
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using where; Using index
0.0002921 | Memory Before: 4.08 Mb | Memory After: 4.09 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 = 750
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.0002940 | Memory Before: 4.08 Mb | Memory After: 4.09 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "user-status" AND a.item_id = 750
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.0124800 | Memory Before: 4.1 Mb | Memory After: 4.13 Mb | Memory Used: 32.99 kb | Rows: 1 | Slave: Yes
SELECT b.blog_id, b.title, b.time_stamp, b.total_comment, b.total_like, bt.text_parsed AS text, b.module_id, b.item_id
FROM phpfox_blog AS b
     JOIN phpfox_blog_text AS bt
            ON(bt.blog_id = b.blog_id)

WHERE b.blog_id = 37
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEbconstPRIMARYPRIMARY4const1 
1SIMPLEbtconstPRIMARYPRIMARY4const1 
0.0022199 | Memory Before: 4.15 Mb | Memory After: 4.15 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 = "blog")

WHERE (l.type_id = 'blog' OR l.type_id = 'blog') AND l.item_id = 37
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.0002689 | Memory Before: 4.18 Mb | Memory After: 4.18 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'blog' OR l.type_id = 'blog') AND l.item_id = 37
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const8Using where; Using index
0.0014200 | Memory Before: 4.18 Mb | Memory After: 4.19 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 = 'blog' AND c.item_id = 37 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id_286const,const,const,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0040359 | Memory Before: 4.21 Mb | Memory After: 4.21 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 = 8545 AND c.type_id = 'blog' AND c.item_id = 37 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004461 | Memory Before: 4.21 Mb | Memory After: 4.22 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 = 8545 AND c.type_id = 'blog' AND c.item_id = 37 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.0002658 | Memory Before: 4.22 Mb | Memory After: 4.22 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 = 8510 AND c.type_id = 'blog' AND c.item_id = 37 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004361 | Memory Before: 4.22 Mb | Memory After: 4.23 Mb | Memory Used: 10.07 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

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

WHERE c.parent_id = 8287 AND c.type_id = 'blog' AND c.item_id = 37 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004461 | Memory Before: 4.23 Mb | Memory After: 4.24 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 = 8287 AND c.type_id = 'blog' AND c.item_id = 37 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.0002851 | Memory Before: 4.23 Mb | Memory After: 4.23 Mb | Memory Used: 5.53 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "blog" AND a.item_id = 37
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0002789 | Memory Before: 4.23 Mb | Memory After: 4.24 Mb | Memory Used: 5.45 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "blog" AND a.item_id = 0
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.0127590 | Memory Before: 4.25 Mb | Memory After: 4.26 Mb | Memory Used: 15.13 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 = 11518)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 2585
/* 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.0014701 | Memory Before: 4.24 Mb | Memory After: 4.25 Mb | Memory Used: 10.04 kb | Rows: 23 | 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 = 2585
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.0003719 | Memory Before: 4.32 Mb | Memory After: 4.32 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 = 2585
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const19Using where; Using index
0.0003331 | Memory Before: 4.32 Mb | Memory After: 4.33 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 = 2585
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.0007088 | Memory Before: 4.33 Mb | Memory After: 4.34 Mb | Memory Used: 7.59 kb | Rows: 23 | 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 = 2585
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.0005240 | Memory Before: 4.36 Mb | Memory After: 4.37 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 2585
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.0009520 | Memory Before: 4.35 Mb | Memory After: 4.37 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 = 11494)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

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

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 2582
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const9Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0005169 | Memory Before: 4.39 Mb | Memory After: 4.39 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 = 2582
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const9Using where; Using index
0.0013771 | Memory Before: 4.39 Mb | Memory After: 4.4 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 = 2582 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.0003710 | Memory Before: 4.41 Mb | Memory After: 4.41 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

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

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

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 2582
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.0006299 | Memory Before: 4.42 Mb | Memory After: 4.43 Mb | Memory Used: 6.48 kb | Rows: 11 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'advancedphoto' AND l.item_id = 2582
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const10Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0003741 | Memory Before: 4.44 Mb | Memory After: 4.44 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 2582
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.0015268 | Memory Before: 4.44 Mb | Memory After: 4.46 Mb | Memory Used: 15.15 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 = 11036)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

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

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

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 2495
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.0003788 | Memory Before: 4.47 Mb | Memory After: 4.47 Mb | Memory Used: 6.09 kb | Rows: 7 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'advancedphoto' AND l.item_id = 2495
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,const6Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002389 | Memory Before: 4.48 Mb | Memory After: 4.49 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 2495
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.0016930 | Memory Before: 4.49 Mb | Memory After: 4.5 Mb | Memory Used: 15.13 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 = 10988)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 2481
/* 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.0010130 | Memory Before: 4.48 Mb | Memory After: 4.49 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 = 2481
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.0002701 | Memory Before: 4.53 Mb | Memory After: 4.53 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 = 2481
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const10Using where; Using index
0.0021589 | Memory Before: 4.53 Mb | Memory After: 4.54 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 = 2481 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.0004859 | Memory Before: 4.55 Mb | Memory After: 4.55 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 7786 AND c.type_id = 'advancedphoto' AND c.item_id = 2481 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.0004420 | Memory Before: 4.55 Mb | Memory After: 4.56 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 = 7786 AND c.type_id = 'advancedphoto' AND c.item_id = 2481 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.0002739 | Memory Before: 4.56 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 = 7760 AND c.type_id = 'advancedphoto' AND c.item_id = 2481 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.0005260 | Memory Before: 4.57 Mb | Memory After: 4.58 Mb | Memory Used: 10.32 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 7760 AND c.type_id = 'advancedphoto' AND c.item_id = 2481 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002580 | Memory Before: 4.58 Mb | Memory After: 4.58 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 = 7763 AND c.type_id = 'advancedphoto' AND c.item_id = 2481 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.0005519 | Memory Before: 4.58 Mb | Memory After: 4.59 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 = 7763 AND c.type_id = 'advancedphoto' AND c.item_id = 2481 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.0002220 | Memory Before: 4.59 Mb | Memory After: 4.6 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 = 7764 AND c.type_id = 'advancedphoto' AND c.item_id = 2481 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.0004690 | Memory Before: 4.59 Mb | Memory After: 4.6 Mb | Memory Used: 10.09 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 7764 AND c.type_id = 'advancedphoto' AND c.item_id = 2481 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.0002761 | Memory Before: 4.59 Mb | Memory After: 4.59 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 = 2481
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.0005281 | Memory Before: 4.58 Mb | Memory After: 4.59 Mb | Memory Used: 6.58 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 = 2481
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,const12Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002980 | Memory Before: 4.6 Mb | Memory After: 4.61 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 = 2481
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.0012040 | Memory Before: 4.61 Mb | Memory After: 4.61 Mb | Memory Used: 5.52 kb | Rows: 1 | Slave: Yes
SELECT e.event_id, e.module_id, e.item_id, e.title, e.time_stamp, e.image_path, e.server_id, e.total_like, e.total_comment, et.description_parsed, l.like_id AS is_liked
FROM phpfox_event AS e
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'event' AND l.item_id = e.event_id AND l.user_id = 0)
     LEFT JOIN phpfox_event_text AS et
            ON(et.event_id = e.event_id)

WHERE e.event_id = 19
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEeconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEetrefevent_idevent_id4const1 
0.0004990 | Memory Before: 4.6 Mb | Memory After: 4.61 Mb | Memory Used: 7.29 kb | Rows: 3 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "event")

WHERE (l.type_id = 'event' OR l.type_id = 'event') AND l.item_id = 19
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_id_281const,const3Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0003269 | Memory Before: 4.61 Mb | Memory After: 4.62 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'event' OR l.type_id = 'event') AND l.item_id = 19
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_281const,const3Using where; Using index
0.0002840 | Memory Before: 4.62 Mb | Memory After: 4.62 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 = "event" AND a.item_id = 19
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.0003102 | Memory Before: 4.62 Mb | Memory After: 4.63 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 = "event" AND a.item_id = 19
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.0009229 | Memory Before: 4.64 Mb | Memory After: 4.65 Mb | Memory Used: 14.84 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.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = photo.parent_user_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 10961)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 2476
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0010800 | Memory Before: 4.64 Mb | Memory After: 4.65 Mb | Memory Used: 8.63 kb | Rows: 13 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2476
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.0002520 | Memory Before: 4.69 Mb | Memory After: 4.69 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2476
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const12Using where; Using index
0.0018311 | Memory Before: 4.69 Mb | Memory After: 4.7 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 = 'photo' AND c.item_id = 2476 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.0002840 | Memory Before: 4.72 Mb | Memory After: 4.72 Mb | Memory Used: 3.15 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 8693 AND c.type_id = 'photo' AND c.item_id = 2476 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.72 Mb | Memory After: 4.73 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 = 8693 AND c.type_id = 'photo' AND c.item_id = 2476 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.0002768 | Memory Before: 4.73 Mb | Memory After: 4.73 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 = 7870 AND c.type_id = 'photo' AND c.item_id = 2476 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.0004640 | Memory Before: 4.73 Mb | Memory After: 4.74 Mb | Memory Used: 10.07 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 7870 AND c.type_id = 'photo' AND c.item_id = 2476 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.0002220 | Memory Before: 4.74 Mb | Memory After: 4.74 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 = 7787 AND c.type_id = 'photo' AND c.item_id = 2476 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.0004442 | Memory Before: 4.74 Mb | Memory After: 4.75 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 = 7787 AND c.type_id = 'photo' AND c.item_id = 2476 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.0002849 | 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 = "photo" AND a.item_id = 2476
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.0002851 | Memory Before: 4.74 Mb | Memory After: 4.75 Mb | Memory Used: 5.45 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 2476
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.0004611 | Memory Before: 4.75 Mb | Memory After: 4.77 Mb | Memory Used: 14.91 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.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = photo.parent_user_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 10960)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 2475
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0009542 | Memory Before: 4.75 Mb | Memory After: 4.76 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 = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2475
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const16Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002389 | Memory Before: 4.81 Mb | Memory After: 4.82 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 2475
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const16Using where; Using index
0.0004981 | Memory Before: 4.81 Mb | Memory After: 4.82 Mb | Memory Used: 10.56 kb | Rows: 2 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'photo' AND c.item_id = 2475 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.0002611 | Memory Before: 4.84 Mb | Memory After: 4.84 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 = 7871 AND c.type_id = 'photo' AND c.item_id = 2475 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.84 Mb | Memory After: 4.85 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 = 7871 AND c.type_id = 'photo' AND c.item_id = 2475 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.0002239 | Memory Before: 4.85 Mb | Memory After: 4.85 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 = 7788 AND c.type_id = 'photo' AND c.item_id = 2475 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003691 | Memory Before: 4.85 Mb | Memory After: 4.86 Mb | Memory Used: 10.06 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 = 7788 AND c.type_id = 'photo' AND c.item_id = 2475 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.0002451 | Memory Before: 4.85 Mb | Memory After: 4.86 Mb | Memory Used: 5.45 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

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

WHERE a.item_type_id = "photo" AND a.item_id = 2475
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.0004239 | Memory Before: 4.87 Mb | Memory After: 4.88 Mb | Memory Used: 5.63 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 688
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0009818 | Memory Before: 4.86 Mb | Memory After: 4.87 Mb | Memory Used: 7.52 kb | Rows: 5 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 688
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_id4const8Using 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.0003581 | Memory Before: 4.88 Mb | Memory After: 4.88 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 = 688
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 6Using where; Using index
0.0010309 | Memory Before: 4.88 Mb | Memory After: 4.89 Mb | Memory Used: 10.41 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'user_status' AND c.item_id = 688 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.0002210 | Memory Before: 4.9 Mb | Memory After: 4.9 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 = 7709 AND c.type_id = 'user_status' AND c.item_id = 688 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003839 | Memory Before: 4.9 Mb | Memory After: 4.91 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 = 7709 AND c.type_id = 'user_status' AND c.item_id = 688 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.0002861 | Memory Before: 4.9 Mb | Memory After: 4.91 Mb | Memory Used: 5.45 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

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

WHERE a.item_type_id = "user-status" AND a.item_id = 688
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.0013239 | Memory Before: 4.92 Mb | Memory After: 4.93 Mb | Memory Used: 7.71 kb | Rows: 1 | Slave: Yes
SELECT fp.post_id, ft.thread_id, ft.group_id, ft.title, fp.user_id AS post_user_id, fp.total_like, fpt.text_parsed AS text, fp.time_stamp, fpt.text AS normal_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_forum_post AS fp
     JOIN phpfox_forum_thread AS ft
            ON(ft.thread_id = fp.thread_id)
     JOIN phpfox_user AS u
            ON(u.user_id = ft.user_id)
     JOIN phpfox_forum_post_text AS fpt
            ON(fpt.post_id = fp.post_id)

WHERE fp.post_id = 196
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfpconstPRIMARY,thread_id,thread_id_2PRIMARY4const1 
1SIMPLEftconstPRIMARY,thread_idPRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEfptconstpost_idpost_id4const1 
0.0009670 | Memory Before: 4.94 Mb | Memory After: 4.94 Mb | Memory Used: 6.8 kb | Rows: 0 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "forum-post")

WHERE (l.type_id = 'forum_post' OR l.type_id = 'forum-post') AND l.item_id = 196
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0005291 | 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 = 'forum_post' OR l.type_id = 'forum-post') AND l.item_id = 196
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using where; Using index
0.0003560 | Memory Before: 4.94 Mb | Memory After: 4.95 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 = "forum-reply" AND a.item_id = 196
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.0003331 | Memory Before: 4.95 Mb | Memory After: 4.95 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 = "forum-reply" AND a.item_id = 196
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.0007329 | Memory Before: 4.96 Mb | Memory After: 4.97 Mb | Memory Used: 5.62 kb | Rows: 1 | Slave: Yes
SELECT us.*, l.like_id AS is_liked
FROM phpfox_user_status AS us
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'user_status' AND l.item_id = us.status_id AND l.user_id = 0)

WHERE us.status_id = 678
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEusconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
0.0011790 | Memory Before: 4.96 Mb | Memory After: 4.96 Mb | Memory Used: 7.22 kb | Rows: 3 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "user-status")

WHERE (l.type_id = 'user_status' OR l.type_id = 'user-status') AND l.item_id = 678
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_iditem_id4const3Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,majmaih1_majma.l.user_id1Using where
0.0005031 | Memory Before: 4.97 Mb | Memory After: 4.97 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 = 678
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 4Using where; Using index
0.0015740 | Memory Before: 4.97 Mb | Memory After: 4.98 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 = 678 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.0003240 | Memory Before: 5 Mb | Memory After: 5 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 = 7679 AND c.type_id = 'user_status' AND c.item_id = 678 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.0008471 | Memory Before: 5 Mb | Memory After: 5.01 Mb | Memory Used: 10.66 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 = 7679 AND c.type_id = 'user_status' AND c.item_id = 678 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.0003378 | Memory Before: 5.02 Mb | Memory After: 5.03 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 = 7696 AND c.type_id = 'user_status' AND c.item_id = 678 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.0006371 | Memory Before: 5.02 Mb | Memory After: 5.03 Mb | Memory Used: 10.09 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 7696 AND c.type_id = 'user_status' AND c.item_id = 678 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.0003231 | Memory Before: 5.04 Mb | Memory After: 5.04 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

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

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

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

WHERE c.parent_id = 7766 AND c.type_id = 'user_status' AND c.item_id = 678 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: 5.05 Mb | Memory After: 5.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 = 7672 AND c.type_id = 'user_status' AND c.item_id = 678 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.0003722 | Memory Before: 5.05 Mb | Memory After: 5.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 = 7672 AND c.type_id = 'user_status' AND c.item_id = 678 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: 5.06 Mb | Memory After: 5.06 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 = 7670 AND c.type_id = 'user_status' AND c.item_id = 678 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.0004299 | Memory Before: 5.06 Mb | Memory After: 5.07 Mb | Memory Used: 10.63 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 = 7670 AND c.type_id = 'user_status' AND c.item_id = 678 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.0002279 | Memory Before: 5.08 Mb | Memory After: 5.08 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 7715 AND c.type_id = 'user_status' AND c.item_id = 678 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0004001 | Memory Before: 5.08 Mb | Memory After: 5.09 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 = 7715 AND c.type_id = 'user_status' AND c.item_id = 678 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002630 | Memory Before: 5.09 Mb | Memory After: 5.09 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 7744 AND c.type_id = 'user_status' AND c.item_id = 678 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idparent_id5const,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0003998 | Memory Before: 5.09 Mb | Memory After: 5.1 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 = 7744 AND c.type_id = 'user_status' AND c.item_id = 678 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.0003250 | Memory Before: 5.08 Mb | Memory After: 5.08 Mb | Memory Used: 5.65 kb | Rows: 2 | 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 = 678
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id_281const,const2Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0003560 | Memory Before: 5.08 Mb | Memory After: 5.09 Mb | Memory Used: 5.63 kb | Rows: 2 | 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 = 678
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id_281const,const2Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0011821 | Memory Before: 5.1 Mb | Memory After: 5.11 Mb | Memory Used: 10.66 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, link.*, p.app_id, a.image_path AS app_image_path, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_link AS link
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'link' AND l.item_id = link.link_id AND l.user_id = 0)
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = link.parent_user_id)
     LEFT JOIN phpfox_pages AS p
            ON(p.page_id = u.profile_page_id)
     LEFT JOIN phpfox_app AS a
            ON(a.app_id = p.app_id)

WHERE link.link_id = 97
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEasystemPRIMARY,app_idMISSING KEY    const row not found
1SIMPLElinkconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEpeq_refPRIMARY,page_idPRIMARY4majmaih1_majma.u.profile_page_id1 
0.0004411 | Memory Before: 5.1 Mb | Memory After: 5.11 Mb | Memory Used: 6.97 kb | Rows: 1 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "link")

WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 97
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002339 | Memory Before: 5.1 Mb | Memory After: 5.11 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 97
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where; Using index
0.0002329 | Memory Before: 5.11 Mb | Memory After: 5.11 Mb | Memory Used: 5.45 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "link" AND a.item_id = 97
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.0002449 | Memory Before: 5.11 Mb | Memory After: 5.12 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 = "link" AND a.item_id = 97
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.0012639 | Memory Before: 5.13 Mb | Memory After: 5.14 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 = 10034)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

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

WHERE (l.type_id = 'advancedphoto' OR l.type_id = 'advancedphoto') AND l.item_id = 2318
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.0003030 | Memory Before: 5.15 Mb | Memory After: 5.15 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 = 2318
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const6Using where; Using index
0.0012751 | Memory Before: 5.15 Mb | Memory After: 5.16 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 = 2318 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.0017099 | Memory Before: 5.17 Mb | Memory After: 5.17 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_comment AS c
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 6950 AND c.type_id = 'advancedphoto' AND c.item_id = 2318 AND c.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefuser_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const2Using index condition; Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1Using index
0.0005131 | Memory Before: 5.17 Mb | Memory After: 5.18 Mb | Memory Used: 10.66 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 = 6950 AND c.type_id = 'advancedphoto' AND c.item_id = 2318 AND c.view_id = 0
ORDER BY c.time_stamp ASC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcrefPRIMARY,user_id,type_id,parent_id,parent_id_2,view_idtype_id82const,const,const2Using index condition; Using where; Using filesort
1SIMPLEctrefcomment_idcomment_id4majmaih1_majma.c.comment_id1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,majmaih1_majma.c.comment_id,const1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.c.user_id1 
0.0002308 | Memory Before: 5.19 Mb | Memory After: 5.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 = 6962 AND c.type_id = 'advancedphoto' AND c.item_id = 2318 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.0003791 | Memory Before: 5.19 Mb | Memory After: 5.2 Mb | Memory Used: 10.1 kb | Rows: 0 | Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 6962 AND c.type_id = 'advancedphoto' AND c.item_id = 2318 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.0001931 | 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 = 6964 AND c.type_id = 'advancedphoto' AND c.item_id = 2318 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.0005472 | Memory Before: 5.21 Mb | Memory After: 5.21 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 = 6964 AND c.type_id = 'advancedphoto' AND c.item_id = 2318 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: 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 = 6946 AND c.type_id = 'advancedphoto' AND c.item_id = 2318 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.0003529 | Memory Before: 5.21 Mb | Memory After: 5.22 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 = 6946 AND c.type_id = 'advancedphoto' AND c.item_id = 2318 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.0002191 | Memory Before: 5.2 Mb | Memory After: 5.21 Mb | Memory Used: 5.47 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "advancedphoto" AND a.item_id = 2318
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.0003300 | Memory Before: 5.2 Mb | Memory After: 5.21 Mb | Memory Used: 6.09 kb | Rows: 7 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'advancedphoto' AND l.item_id = 2318
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,const6Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002542 | Memory Before: 5.21 Mb | Memory After: 5.22 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 = 2318
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.0005698 | Memory Before: 5.22 Mb | Memory After: 5.23 Mb | Memory Used: 8.41 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, fc.*, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_feed_comment AS fc
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = fc.parent_user_id)

WHERE fc.feed_comment_id = 92
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfcconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
0.0004680 | Memory Before: 5.21 Mb | Memory After: 5.22 Mb | Memory Used: 6.86 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 = "feed-comment")

WHERE (l.type_id = 'feed_comment' OR l.type_id = 'feed-comment') AND l.item_id = 92
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002398 | Memory Before: 5.22 Mb | Memory After: 5.22 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'feed_comment' OR l.type_id = 'feed-comment') AND l.item_id = 92
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using where; Using index
0.0002191 | Memory Before: 5.22 Mb | Memory After: 5.23 Mb | Memory Used: 5.47 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "feed" AND a.item_id = 92
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.0002489 | Memory Before: 5.22 Mb | Memory After: 5.23 Mb | Memory Used: 5.53 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 = "feed" AND a.item_id = 92
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.0002620 | Memory Before: 5.24 Mb | Memory After: 5.25 Mb | Memory Used: 8.3 kb | Rows: 1 | Slave: Yes
SELECT l.like_id AS is_liked, fc.*, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_feed_comment AS fc
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = fc.parent_user_id)

WHERE fc.feed_comment_id = 91
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfcconstPRIMARYPRIMARY4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
0.0004690 | Memory Before: 5.23 Mb | Memory After: 5.24 Mb | Memory Used: 6.8 kb | Rows: 0 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "feed-comment")

WHERE (l.type_id = 'feed_comment' OR l.type_id = 'feed-comment') AND l.item_id = 91
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002401 | Memory Before: 5.23 Mb | Memory After: 5.24 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'feed_comment' OR l.type_id = 'feed-comment') AND l.item_id = 91
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using where; Using index
0.0002139 | Memory Before: 5.24 Mb | Memory After: 5.24 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "feed" AND a.item_id = 91
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0002730 | Memory Before: 5.24 Mb | Memory After: 5.24 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "feed" AND a.item_id = 91
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.0002179 | Memory Before: 5.24 Mb | Memory After: 5.25 Mb | Memory Used: 5.53 kb | Rows: 1 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_user AS u
WHERE user_id IN (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,44,44)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangePRIMARY,user_idPRIMARY4 2Using index condition
0.0037899 | Memory Before: 6.11 Mb | Memory After: 6.12 Mb | Memory Used: 17.59 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, u2.user_id, u2.profile_page_id, u2.server_id, u2.user_name, u2.full_name, u2.gender, u2.user_image, u2.is_invisible, u2.user_group_id, u2.language_id, u2.last_activity, photo.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = photo.parent_user_id)
     JOIN phpfox_user AS u2
            ON(u2.user_id = photo.user_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 2222)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 2222
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2,user_idPRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEu2constPRIMARY,user_idPRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0002179 | Memory Before: 6.2 Mb | Memory After: 6.2 Mb | Memory Used: 3.19 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'feed' AND name = 'mini.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0006831 | Memory Before: 6.24 Mb | Memory After: 6.26 Mb | Memory Used: 17.55 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, u2.user_id, u2.profile_page_id, u2.server_id, u2.user_name, u2.full_name, u2.gender, u2.user_image, u2.is_invisible, u2.user_group_id, u2.language_id, u2.last_activity, photo.*, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name, l.like_id AS is_liked
FROM phpfox_photo AS photo
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = photo.parent_user_id)
     JOIN phpfox_user AS u2
            ON(u2.user_id = photo.user_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 2015)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 2015
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotoconstPRIMARY,photo_id,photo_id_2,user_idPRIMARY4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEu2constPRIMARY,user_idPRIMARY4const1 
1SIMPLEpiconstphoto_idphoto_id4const1 
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_285const,const,const1Using where
1SIMPLEpfeedreffeed_idfeed_id4const1 
1SIMPLEpaconstPRIMARY,album_idPRIMARY4const1 
0.0007119 | Memory Before: 5.05 Mb | Memory After: 5.05 Mb | Memory Used: 6.73 kb | Rows: 45 | Slave: No
SHOW COLUMNS FROM phpfox_user_field
0.0001159 | Memory Before: 5.06 Mb | Memory After: 5.07 Mb | Memory Used: 3.17 kb | Rows: 1 | Slave: Yes
SELECT use_timeline
FROM phpfox_user_field AS uf
WHERE uf.user_id = 44
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEufconstuser_iduser_id4const1 
0.0089319 | Memory Before: 5.11 Mb | Memory After: 5.11 Mb | Memory Used: 6.38 kb | Rows: 7 | Slave: Yes
SELECT track.time_stamp, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_user_track AS track
     JOIN phpfox_user AS u
            ON(u.user_id = track.user_id AND u.profile_page_id = 0)

WHERE track.item_id = 44 AND track.user_id != 44
ORDER BY track.time_stamp DESC
LIMIT 7
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtrackrangeitem_iditem_id8 61Using index condition; Using filesort
1SIMPLEueq_refPRIMARY,page_id,user_idPRIMARY4majmaih1_majma.track.user_id1Using where
0.0022941 | Memory Before: 5.13 Mb | Memory After: 5.14 Mb | Memory Used: 3.09 kb | Rows: 0 | Slave: Yes
SELECT count(f.user_id)
FROM phpfox_friend AS f
     JOIN phpfox_friend AS sf
            ON(sf.friend_user_id = f.friend_user_id AND sf.user_id = 44)
     JOIN phpfox_user AS u
            ON(u.user_id = f.friend_user_id)

WHERE f.is_page = 0 AND f.user_id = 0
GROUP BY f.friend_user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfrefuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2user_check4const1Using where
1SIMPLEsfeq_refuser_check,user_id,top_friend,friend_user_iduser_check8const,majmaih1_majma.f.friend_user_id1Using index
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.f.friend_user_id1Using index
0.0002279 | Memory Before: 5.13 Mb | Memory After: 5.14 Mb | Memory Used: 5.43 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_friend AS f
     JOIN phpfox_friend AS sf
            ON(sf.friend_user_id = f.friend_user_id AND sf.user_id = 44)
     JOIN phpfox_user AS u
            ON(u.user_id = f.friend_user_id)

WHERE f.is_page = 0 AND f.user_id = 0
GROUP BY f.friend_user_id
ORDER BY f.time_stamp DESC
LIMIT 7
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfrefuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2user_check4const1Using where; Using temporary; Using filesort
1SIMPLEsfeq_refuser_check,user_id,top_friend,friend_user_iduser_check8const,majmaih1_majma.f.friend_user_id1Using index
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.f.friend_user_id1 
0.0004928 | Memory Before: 5.16 Mb | Memory After: 5.16 Mb | Memory Used: 3.23 kb | Rows: 1 | Slave: No
SELECT havadar
FROM phpfox_havadar
WHERE user_id = '44'
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_havadarconstPRIMARYPRIMARY4const1 
0.0004129 | Memory Before: 5.16 Mb | Memory After: 5.16 Mb | Memory Used: 3.7 kb | Rows: 0 | Slave: No
SELECT *
FROM phpfox_havadar_add
WHERE user_id = 0 AND hav_id =44
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0007682 | Memory Before: 5.2 Mb | Memory After: 5.2 Mb | Memory Used: 5.63 kb | Rows: 2 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_user AS u
     JOIN phpfox_havadar_add AS h
            ON(u.user_id = h.user_id)

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