arraztalo

Inklusioa

Gaixo psikiko eta beren familiarren elkartea (Oiartzun)

Captcha
19124
Azaroak 20, 2025
Arraztalo Elkartea
(e)k gertaera bat argitaratu du.
Azaroak 20, 2025 5:30 pm
10826
Uztailak 24, 2020
Arraztalo Elkartea
(e)k gertaera bat argitaratu du.
Uztailak 16, 2020 2:00 am
18849
Irailak 7, 2025
Arraztalo Elkartea
Zure profileko informazioa eguneratu duzu.
Irailak 7, 2025 10:48 am
7589
Abenduak 4, 2018
Arraztalo Elkartea
(e)k gertaera bat argitaratu du.
Abenduak 4, 2018 9:15 pm
Gehiago ikusi
phpFox Developers Debug Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula

Total Time:
0.4741981
PHP General Time:
0.4322064
GZIP:
disabled

Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.0419917
SQL Queries:
80
SQL Memory Usage:
399.23 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
14.14 Mb
Total Memory Usage (Including Debug):
14.45 Mb
Memory Limit:
512 Mb (1024M)

Load Balancing Enabled:
No
Requests From:
192.168.100.222


Server Time Stamp:
June 18, 2026, 5:18 pm
PHP Version:
5.6.40
PHP Sapi:
fpm-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux

Cache:
file
SQL Queries
0.0002229 | Memory Before: 1.41 Mb | Memory After: 1.41 Mb | Memory Used: 4.78 kb | Rows: 5 | Slave: No
SELECT p.call_name, p.php_code
FROM phpfox_plugin AS p
     JOIN phpfox_product AS product
            ON(p.product_id = product.product_id AND product.is_active = 1)
     JOIN phpfox_plugin_hook AS ph
            ON(ph.call_name = p.call_name AND ph.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = p.module_id AND m.is_active = 1)

WHERE p.is_active = 1
ORDER BY p.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpALLis_activeMISSING KEY   5Using where; Using filesort
1SIMPLEphrefcall_namecall_name258sqlgipsol.p.call_name,const1Using where; Using index
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.p.module_id,const8Using index
0.0006030 | Memory Before: 2.42 Mb | Memory After: 2.43 Mb | Memory Used: 3.86 kb | Rows: 1 | Slave: No
SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = '75ef340419c1707711526d387ca6c4b7' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_hash,log_sessionsession_hash32const1Using index condition; Using where
0.0005929 | Memory Before: 2.43 Mb | Memory After: 2.43 Mb | Memory Used: 1.41 kb | Rows: - | Slave: No
UPDATE phpfox_log_session SET last_activity = '1781803088', user_id = '0', location = '/profile-2493/www.arraztalo.eus/elkartea', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.204', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '75ef340419c1707711526d387ca6c4b7'
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_log_sessionrefsession_hash,log_sessionsession_hash32const1Using index condition
0.0001900 | Memory Before: 3.75 Mb | Memory After: 3.76 Mb | Memory Used: 4.97 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_idPRIMARY2sqlgipsol.s.theme_id1 
0.0001180 | Memory Before: 3.75 Mb | Memory After: 3.76 Mb | Memory Used: 3.18 kb | Rows: 1 | Slave: No
SELECT folder AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_styleconststyle_id_2,style_idstyle_id_22const1 
0.0024240 | Memory Before: 5.21 Mb | Memory After: 5.25 Mb | Memory Used: 35.59 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-2493'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefPRIMARY,user_group_id,user_id,user_nameuser_name103const1Using index condition
1SIMPLEuser_fieldeq_refuser_iduser_id4sqlgipsol.u.user_id1 
1SIMPLEtseq_refstyle_id_2,style_id,is_activestyle_id_22sqlgipsol.user_field.designer_style_id1Using where
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2sqlgipsol.ts.theme_id1Using where
1SIMPLEugeq_refPRIMARY,user_group_idPRIMARY1sqlgipsol.u.user_group_id1Using index condition
1SIMPLEufeq_refPRIMARYPRIMARY4sqlgipsol.u.user_id1Using index
1SIMPLEuser_spaceeq_refuser_iduser_id4sqlgipsol.u.user_id1 
1SIMPLEuser_activityeq_refuser_iduser_id4sqlgipsol.u.user_id1 
1SIMPLElsrefuser_id,user_id_2,user_id_3user_id5sqlgipsol.u.user_id,const723Using index
1SIMPLEpeq_refPRIMARY,photo_id,photo_id_2PRIMARY4sqlgipsol.user_field.cover_photo1Using index
0.0008900 | Memory Before: 6.68 Mb | Memory After: 6.68 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 2493
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_feventrefuser_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5user_id4const11Using where
0.0002351 | Memory Before: 8.61 Mb | Memory After: 8.62 Mb | Memory Used: 3.75 kb | Rows: 3 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 2493
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_privacyrefuser_id,user_id_2user_id4const3 
0.0002260 | Memory Before: 10.09 Mb | Memory After: 10.1 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0002480 | Memory Before: 11.19 Mb | Memory After: 11.19 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002069 | Memory Before: 11.27 Mb | Memory After: 11.28 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'cabecera.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002570 | Memory Before: 11.42 Mb | Memory After: 11.42 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002241 | Memory Before: 11.44 Mb | Memory After: 11.44 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001469 | Memory Before: 11.46 Mb | Memory After: 11.46 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001440 | Memory Before: 11.47 Mb | Memory After: 11.47 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002041 | Memory Before: 11.81 Mb | Memory After: 11.83 Mb | Memory Used: 17.59 kb | Rows: 76 | Slave: Yes
SELECT cf.*, cmv.option_id as customValue, cg.user_group_id as cg_user_group_id
FROM phpfox_custom_field AS cf
     LEFT JOIN phpfox_user_custom_multiple_value AS cmv
            ON(cmv.field_id = cf.field_id AND cmv.user_id = 2493)
     JOIN phpfox_module AS m
            ON(m.module_id = cf.module_id AND m.is_active = 1)
     LEFT JOIN phpfox_custom_group AS cg
            ON(cg.group_id = cf.group_id)

WHERE cf.type_id IN ('user_main','user_panel','profile_panel') AND cf.is_active = 1 AND cf.user_group_id = 0
ORDER BY cf.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcfALL MISSING KEY   83Using where; Using filesort
1SIMPLEcgeq_refPRIMARYPRIMARY2sqlgipsol.cf.group_id1 
1SIMPLEcmvrefuser_iduser_id6const,sqlgipsol.cf.field_id1 
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.cf.module_id,const8Using index
0.0003250 | Memory Before: 12.07 Mb | Memory After: 12.1 Mb | Memory Used: 31.43 kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2493
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_customconstuser_iduser_id4const1 
0.0001500 | Memory Before: 12.1 Mb | Memory After: 12.11 Mb | Memory Used: 5.94 kb | Rows: 72 | Slave: Yes
SELECT *
FROM phpfox_custom_option
WHERE field_id IN(93,22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_custom_optionALLfield_idMISSING KEY   83Using where; Using filesort
0.0001171 | Memory Before: 11.87 Mb | Memory After: 11.87 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/header.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001311 | Memory Before: 12.25 Mb | Memory After: 12.26 Mb | Memory Used: 10.45 kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 4232
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
0.0001020 | Memory Before: 12.39 Mb | Memory After: 12.39 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/logo.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001178 | Memory Before: 12.57 Mb | Memory After: 12.58 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/pic.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001171 | Memory Before: 12.31 Mb | Memory After: 12.31 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001202 | Memory Before: 12.32 Mb | Memory After: 12.33 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001161 | Memory Before: 12.33 Mb | Memory After: 12.33 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0100589 | Memory Before: 12.92 Mb | Memory After: 12.93 Mb | Memory Used: 9.12 kb | Rows: 4 | 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.privacy IN(0) AND type_id = 'feed_comment' AND feed.user_id = 2493
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN(0) AND feed.user_id = 2493 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 = 2493
/* 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 4
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYappssystemPRIMARY,app_idMISSING KEY    Const row not found; Using temporary; Using filesort
1PRIMARY<derived2>ALL MISSING KEY   9 
1PRIMARYueq_refPRIMARY,user_idPRIMARY4feed.user_id1 
2DERIVEDfeedrefprivacy_2,privacy_3,privacy_4,type_id,privacy,privacy_5,user_idtype_id77const1Using index condition; Using where
3UNIONfeedrefprivacy_2,privacy_3,privacy_4,privacy,privacy_5,user_iduser_id8const,const7Using where
4UNIONfeedrefprivacy_2,privacy_3,privacy_4,privacy,privacy_5privacy_55const,const1 
 UNION RESULT<union2,3,4>ALL MISSING KEY     
0.0005531 | Memory Before: 13.05 Mb | Memory After: 13.06 Mb | Memory Used: 5.48 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_fevent AS e
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'fevent' AND l.item_id = e.event_id AND l.user_id = 0)
     LEFT JOIN phpfox_fevent_text AS et
            ON(et.event_id = e.event_id)

WHERE e.event_id = 11114
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEeconstPRIMARYPRIMARY4const1 
1SIMPLElref|filtertype_id,type_id_2,type_id_3,item_idtype_id_3|item_id81|4const,const1 (1%)Using where; Using rowid filter
1SIMPLEetrefevent_idevent_id4const1 
0.0007551 | Memory Before: 13.05 Mb | Memory After: 13.06 Mb | Memory Used: 6.7 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 = "fevent")

WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 11114
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEasystemtype_id,type_id_2,type_id_3,item_idMISSING KEY    Const row not found; Using temporary; Using filesort
1SIMPLElref|filtertype_id,type_id_2,type_id_3,item_iditem_id|type_id_34|77const1 (8%)Using where; Using rowid filter
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.l.user_id1 
0.0002420 | Memory Before: 13.05 Mb | Memory After: 13.06 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 11114
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where; Using index
0.0001969 | Memory Before: 13.06 Mb | Memory After: 13.06 Mb | Memory Used: 5.36 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 = "fevent" AND a.item_id = 11114
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001349 | Memory Before: 13.06 Mb | Memory After: 13.07 Mb | Memory Used: 5.36 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 = "fevent" AND a.item_id = 11114
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003910 | Memory Before: 13.32 Mb | Memory After: 13.33 Mb | Memory Used: 5.36 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 = "custom" AND a.item_id = 2493
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0005770 | Memory Before: 13.32 Mb | Memory After: 13.33 Mb | Memory Used: 6.7 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 = "custom")

WHERE (l.type_id = 'custom' OR l.type_id = 'custom') AND l.item_id = 2493
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEasystemtype_id,type_id_2,type_id_3,item_idMISSING KEY    Const row not found; Using temporary; Using filesort
1SIMPLElref|filtertype_id,type_id_2,type_id_3,item_iditem_id|type_id_34|77const1 (3%)Using where; Using rowid filter
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.l.user_id1 
0.0004880 | Memory Before: 13.33 Mb | Memory After: 13.33 Mb | Memory Used: 5.38 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 = 'custom' AND l.item_id = 2493
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,const1Using where; Using index; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.l.user_id1 
0.0001729 | Memory Before: 13.33 Mb | Memory After: 13.33 Mb | Memory Used: 5.36 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 = "custom" AND a.item_id = 2493
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0016959 | Memory Before: 13.34 Mb | Memory After: 13.35 Mb | Memory Used: 5.51 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_fevent AS e
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'fevent' AND l.item_id = e.event_id AND l.user_id = 0)
     LEFT JOIN phpfox_fevent_text AS et
            ON(et.event_id = e.event_id)

WHERE e.event_id = 5830
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEeconstPRIMARYPRIMARY4const1 
1SIMPLElref|filtertype_id,type_id_2,type_id_3,item_idtype_id_3|item_id81|4const,const1 (1%)Using where; Using rowid filter
1SIMPLEetrefevent_idevent_id4const1 
0.0009329 | Memory Before: 13.34 Mb | Memory After: 13.35 Mb | Memory Used: 6.7 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 = "fevent")

WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 5830
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEasystemtype_id,type_id_2,type_id_3,item_idMISSING KEY    Const row not found; Using temporary; Using filesort
1SIMPLElref|filtertype_id,type_id_2,type_id_3,item_iditem_id|type_id_34|77const1 (8%)Using where; Using rowid filter
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.l.user_id1 
0.0003641 | Memory Before: 13.34 Mb | Memory After: 13.35 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 5830
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where; Using index
0.0003161 | Memory Before: 13.35 Mb | Memory After: 13.35 Mb | Memory Used: 5.36 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 = "fevent" AND a.item_id = 5830
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001750 | Memory Before: 13.35 Mb | Memory After: 13.35 Mb | Memory Used: 5.36 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 = "fevent" AND a.item_id = 5830
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0014980 | Memory Before: 13.36 Mb | Memory After: 13.37 Mb | Memory Used: 5.49 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_fevent AS e
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'fevent' AND l.item_id = e.event_id AND l.user_id = 0)
     LEFT JOIN phpfox_fevent_text AS et
            ON(et.event_id = e.event_id)

WHERE e.event_id = 4514
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEeconstPRIMARYPRIMARY4const1 
1SIMPLElref|filtertype_id,type_id_2,type_id_3,item_idtype_id_3|item_id81|4const,const1 (1%)Using where; Using rowid filter
1SIMPLEetrefevent_idevent_id4const1 
0.0010049 | Memory Before: 13.36 Mb | Memory After: 13.37 Mb | Memory Used: 6.71 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 = "fevent")

WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 4514
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEasystemtype_id,type_id_2,type_id_3,item_idMISSING KEY    Const row not found; Using temporary; Using filesort
1SIMPLElref|filtertype_id,type_id_2,type_id_3,item_iditem_id|type_id_34|77const1 (8%)Using where; Using rowid filter
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.l.user_id1 
0.0005820 | Memory Before: 13.36 Mb | Memory After: 13.37 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 4514
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where; Using index
0.0003428 | Memory Before: 13.37 Mb | Memory After: 13.37 Mb | Memory Used: 5.36 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 = "fevent" AND a.item_id = 4514
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001161 | Memory Before: 13.37 Mb | Memory After: 13.37 Mb | Memory Used: 5.36 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 = "fevent" AND a.item_id = 4514
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003099 | Memory Before: 13.37 Mb | Memory After: 13.37 Mb | Memory Used: 5.36 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_user AS u
WHERE user_id IN (0,0,0,0)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurangePRIMARY,user_iduser_id4 1Using index condition
0.0002480 | Memory Before: 13.26 Mb | Memory After: 13.27 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT count(*)
FROM phpfox_feed
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Select tables optimized away
0.0002251 | Memory Before: 13.42 Mb | Memory After: 13.43 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0005040 | Memory Before: 13.43 Mb | Memory After: 13.44 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'display.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002170 | Memory Before: 13.44 Mb | Memory After: 13.45 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'display.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002270 | Memory Before: 13.72 Mb | Memory After: 13.72 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'captcha' AND name = 'form.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0005801 | Memory Before: 13.6 Mb | Memory After: 13.6 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'timeline.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0005500 | Memory Before: 13.77 Mb | Memory After: 13.77 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'content.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002351 | Memory Before: 13.93 Mb | Memory After: 13.93 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002289 | Memory Before: 14.03 Mb | Memory After: 14.03 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002241 | Memory Before: 14.11 Mb | Memory After: 14.12 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002248 | Memory Before: 14.06 Mb | Memory After: 14.06 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002301 | Memory Before: 13.72 Mb | Memory After: 13.72 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'timeline.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002949 | Memory Before: 13.89 Mb | Memory After: 13.89 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'content.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002580 | Memory Before: 13.97 Mb | Memory After: 13.97 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002270 | Memory Before: 14.07 Mb | Memory After: 14.07 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002239 | Memory Before: 14.13 Mb | Memory After: 14.13 Mb | Memory Used: 3.2 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002232 | Memory Before: 14.07 Mb | Memory After: 14.08 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0029421 | Memory Before: 14.1 Mb | Memory After: 14.11 Mb | Memory Used: 6.67 kb | Rows: 1 | 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 = 2493) 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)
     JOIN phpfox_user_field AS uf
            ON(u.user_id = uf.user_id)

WHERE friend.is_page = 0 AND friend.user_id = 2493
GROUP BY u.user_id
ORDER BY friend.is_top_friend DESC , friend.ordering ASC, RAND()
LIMIT 6
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_friendrefuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2is_page_25const,const1Using where; Using index; Using temporary; Using filesort
1SIMPLEfriendeq_refuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2user_check8const,sqlgipsol.phpfox_friend.friend_user_id1Using where
1SIMPLEueq_refPRIMARY,public_feed,status_id,status_id_2,user_id,user_statusPRIMARY4sqlgipsol.phpfox_friend.friend_user_id1Using where
1SIMPLEufeq_refuser_iduser_id4sqlgipsol.phpfox_friend.friend_user_id1 
0.0005951 | Memory Before: 14.11 Mb | Memory After: 14.11 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'friend' AND name = 'timeline.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002899 | Memory Before: 13.99 Mb | Memory After: 13.99 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'timeline.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002921 | Memory Before: 14.16 Mb | Memory After: 14.16 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'content.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002248 | Memory Before: 14.24 Mb | Memory After: 14.24 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002429 | Memory Before: 14.34 Mb | Memory After: 14.34 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002270 | Memory Before: 14.4 Mb | Memory After: 14.4 Mb | Memory Used: 3.21 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002232 | Memory Before: 14.34 Mb | Memory After: 14.34 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001750 | Memory Before: 14 Mb | Memory After: 14.01 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'timeline.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002921 | Memory Before: 14.18 Mb | Memory After: 14.18 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'content.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002382 | Memory Before: 14.26 Mb | Memory After: 14.26 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002241 | Memory Before: 14.35 Mb | Memory After: 14.36 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002780 | Memory Before: 14.42 Mb | Memory After: 14.42 Mb | Memory Used: 3.2 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002241 | Memory Before: 14.36 Mb | Memory After: 14.36 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0006201 | Memory Before: 14.24 Mb | Memory After: 14.25 Mb | Memory Used: 9.27 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "feed|display"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   12Using where
0.0006111 | Memory Before: 14.1 Mb | Memory After: 14.11 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'controller/index.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002339 | Memory Before: 14.13 Mb | Memory After: 14.13 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
Array
(
    [session] => 75ef340419c1707711526d387ca6c4b7
    [redirect] => /profile-2493/www.arraztalo.eus/elkartea
)
TOP