GM

Gena Macghey

Lives in Foxley, United Kingdom.
About Me
I am Charline from Foxley. I am learning to play the Dobro. Other hobbies are Dog sport. Also visi...View More
Route: profile.index ID: #profile_index CSS: theme_material _is_profile_view _is_guest_user material_html
Be the first person to like this.
updated their profile information.
Be the first person to like this.
Load More
phpFox Developers Debug Toggle JavaScript Console
Version:
4.7.8
Product Code Name:
Neutron

Total Time:
0.0931468
PHP General Time:
0.0732069
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0199399
SQL Queries:
39
SQL Memory Usage:
689.3 Kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Database Connection:
0.00039911270141602

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

Load Balancing Enabled:
No
Requests From:
207.246.85.29


Server Time Stamp:
December 9, 2019, 2:25 pm
PHP Version:
7.3.9
PHP Sapi:
fpm-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux

Cache:
file
SQL Queries
0.0005281 | Memory Before: 4.28 Mb | Memory After: 4.3 Mb | Memory Used: 25.52 Kb | Rows: 34 | Slave: Yes
SELECT *
FROM phpfox_apps
WHERE is_active=1
0.0045562 | Memory Before: 7.25 Mb | Memory After: 7.25 Mb | Memory Used: 696 b | Rows: - | Slave: No
DELETE FROM phpfox_log_session WHERE id_hash = 'c56fb43d525078d2aaf85f739d93f298'
0.0019140 | Memory Before: 7.25 Mb | Memory After: 7.25 Mb | Memory Used: 696 b | 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 ('b04b9f4f8f31849431e05ed72919fa2e', 'c56fb43d525078d2aaf85f739d93f298', '0', '1575901553', '', '0', '0', '0', '18.205.60.226', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0004389 | Memory Before: 7.29 Mb | Memory After: 7.3 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT sp.*
FROM phpfox_subscribe_purchase AS sp
     JOIN phpfox_user_field AS uf
ON(uf.subscribe_id=sp.purchase_id)

WHERE sp.user_id=0
0.0013020 | Memory Before: 7.58 Mb | Memory After: 7.65 Mb | Memory Used: 68.06 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 = 'GenaMacghey643023'
0.0003281 | Memory Before: 7.91 Mb | Memory After: 7.92 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_blog AS b
WHERE b.user_id = 144 AND b.post_status = 1 AND b.is_approved = 1 AND b.module_id IN ("blog")
LIMIT 1
0.0002539 | Memory Before: 8.02 Mb | Memory After: 8.04 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_marketplace
WHERE view_id = 0 AND user_id = 144
LIMIT 1
0.0002830 | Memory Before: 8.04 Mb | Memory After: 8.05 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_music_song
WHERE view_id = 0 AND user_id = 144 AND item_id = 0
LIMIT 1
0.0001581 | Memory Before: 8.13 Mb | Memory After: 8.15 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT /* friend.is_friend */COUNT(*)
FROM phpfox_friend
WHERE user_id = 0 AND friend_user_id = 144
LIMIT 1
0.0002382 | Memory Before: 8.13 Mb | Memory After: 8.15 Mb | Memory Used: 16.86 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 = 144)
     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
0.0003579 | Memory Before: 8.11 Mb | Memory After: 8.13 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT uf.total_friend, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.birthday, u.country_iso
FROM phpfox_friend AS f
     JOIN phpfox_friend AS sf
ON(sf.friend_user_id = f.friend_user_id AND sf.user_id = 144)
     JOIN phpfox_user AS u
ON(u.user_id = f.friend_user_id)
     JOIN phpfox_user_field AS uf
ON(u.user_id = uf.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
0.0002470 | Memory Before: 8.12 Mb | Memory After: 8.13 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo
WHERE view_id = 0
AND group_id = 0
AND user_id = 144
AND is_profile_photo IN(0)
AND is_cover_photo IN(0) AND type_id = 0 AND privacy IN (0)
LIMIT 1
0.0002630 | Memory Before: 8.2 Mb | Memory After: 8.22 Mb | Memory Used: 17.86 Kb | Rows: 15 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 144
0.0002441 | Memory Before: 8.22 Mb | Memory After: 8.23 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT CASE ub.user_id WHEN 144 THEN ub.block_user_id ELSE ub.user_id END as block_user_id
FROM phpfox_user_blocked AS ub
WHERE ub.user_id = 144 OR ub.block_user_id = 144
0.0002582 | Memory Before: 8.81 Mb | Memory After: 8.83 Mb | Memory Used: 17.2 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 144
0.0002191 | Memory Before: 8.83 Mb | Memory After: 8.85 Mb | Memory Used: 17 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_custom_group
WHERE group_id = 1
0.0006211 | Memory Before: 8.9 Mb | Memory After: 8.91 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT uf.total_friend, 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.birthday, u.country_iso
FROM phpfox_friend AS friend
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 144) 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 = 144
GROUP BY u.user_id
ORDER BY friend.is_top_friend DESC , friend.ordering ASC, RAND()
LIMIT 6
0.0002320 | Memory Before: 8.9 Mb | Memory After: 8.92 Mb | Memory Used: 16.86 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 = 144)
     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
0.0002539 | Memory Before: 8.9 Mb | Memory After: 8.92 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT uf.total_friend, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.birthday, u.country_iso
FROM phpfox_friend AS f
     JOIN phpfox_friend AS sf
ON(sf.friend_user_id = f.friend_user_id AND sf.user_id = 144)
     JOIN phpfox_user AS u
ON(u.user_id = f.friend_user_id)
     JOIN phpfox_user_field AS uf
ON(u.user_id = uf.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 6
0.0003290 | Memory Before: 8.91 Mb | Memory After: 8.93 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT p.page_id
FROM phpfox_like AS l
     JOIN phpfox_pages AS p
ON(p.page_id = l.item_id AND p.view_id = 0 AND p.item_type = 1)
     JOIN phpfox_user AS u
ON(u.profile_page_id = p.page_id)

WHERE l.type_id = 'groups' AND l.user_id = 144 AND (p.reg_method <> 2)
GROUP BY p.page_id
0.0007761 | Memory Before: 8.91 Mb | Memory After: 8.93 Mb | Memory Used: 17.09 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.birthday, u.country_iso, p.*, pt.name as type_name, pc.name as category_name, ph.destination as cover_image_path, ph.server_id as cover_image_server_id, pu.vanity_url, u.server_id, ptxt.text_parsed
FROM phpfox_like AS l
     JOIN phpfox_pages AS p
ON(p.page_id = l.item_id AND p.view_id = 0 AND p.item_type = 1)
     JOIN phpfox_user AS u
ON(u.profile_page_id = p.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_photo AS ph
ON(ph.photo_id = p.cover_photo_id)
     LEFT JOIN phpfox_pages_type AS pt
ON(p.type_id = pt.type_id)
     LEFT JOIN phpfox_pages_text AS ptxt
ON(ptxt.page_id= p.page_id)
     LEFT JOIN phpfox_pages_category AS pc
ON(p.category_id = pc.category_id)

WHERE l.type_id = 'groups' AND l.user_id = 144 AND (p.reg_method <> 2)
GROUP BY p.page_id
ORDER BY l.time_stamp DESC
LIMIT 10
0.0002780 | Memory Before: 8.92 Mb | Memory After: 8.94 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT p.page_id
FROM phpfox_like AS l
     JOIN phpfox_pages AS p
ON(p.page_id = l.item_id AND p.view_id = 0 AND p.item_type = 0)
     JOIN phpfox_user AS u
ON(u.profile_page_id = p.page_id)

WHERE l.type_id = 'pages' AND l.user_id = 144
GROUP BY p.page_id
0.0003860 | Memory Before: 8.92 Mb | Memory After: 8.94 Mb | Memory Used: 17.09 Kb | Rows: 0 | Slave: Yes
SELECT p.*, pt.name as type_name, pc.name as category_name, ph.destination as cover_image_path, ph.server_id as cover_image_server_id, pu.vanity_url, u.server_id, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.birthday, u.country_iso
FROM phpfox_like AS l
     JOIN phpfox_pages AS p
ON(p.page_id = l.item_id AND p.view_id = 0 AND p.item_type = 0)
     JOIN phpfox_user AS u
ON(u.profile_page_id = p.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_photo AS ph
ON(ph.photo_id = p.cover_photo_id)
     LEFT JOIN phpfox_pages_type AS pt
ON(p.type_id = pt.type_id)
     LEFT JOIN phpfox_pages_category AS pc
ON(p.category_id = pc.category_id)

WHERE l.type_id = 'pages' AND l.user_id = 144
GROUP BY p.page_id
ORDER BY l.time_stamp DESC
LIMIT 10
0.0002391 | Memory Before: 8.93 Mb | Memory After: 8.94 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_friend_request
WHERE user_id = 144 AND friend_user_id = 0
LIMIT 1
0.0003400 | Memory Before: 8.95 Mb | Memory After: 8.96 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_egift AS e
     JOIN ( SELECT egift_id, MAX(time_stamp_paid) as time_stamp_paid
FROM phpfox_egift_invoice
WHERE status = 'completed' AND user_to = 144
GROUP BY egift_id
LIMIT 9

) AS ei
ON(ei.egift_id = e.egift_id)

ORDER BY ei.time_stamp_paid DESC
0.0003929 | Memory Before: 8.95 Mb | Memory After: 8.97 Mb | Memory Used: 17.2 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.birthday, u.country_iso,p.*, p.destination, p.server_id, p.title, p.mature, p.album_id, pa.name AS album_name
FROM phpfox_photo AS p
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = p.album_id)

WHERE p.view_id = 0 AND p.group_id = 0 AND p.user_id = 144 AND p.is_profile_photo IN (0) AND p.is_cover_photo IN (0) AND type_id = 0
ORDER BY p.photo_id DESC
LIMIT 3
0.0003922 | Memory Before: 8.96 Mb | Memory After: 8.98 Mb | Memory Used: 17.05 Kb | Rows: 0 | Slave: Yes
SELECT ms.*, ma.name AS album_url, u.user_name, mp.play_id AS is_on_profile, mp.user_id AS profile_user_id, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.birthday, u.country_iso
FROM phpfox_music_song AS ms
     JOIN phpfox_user AS u
ON(u.user_id = ms.user_id)
     LEFT JOIN phpfox_music_album AS ma
ON(ma.album_id = ms.album_id)
     LEFT JOIN phpfox_music_profile AS mp
ON(mp.song_id = ms.song_id AND mp.user_id = 0)

WHERE ms.view_id = 0 AND ms.user_id = 144 AND (ms.module_id is NULL)
ORDER BY ms.ordering ASC, ms.time_stamp DESC
LIMIT 4
0.0002398 | Memory Before: 9.25 Mb | Memory After: 9.26 Mb | Memory Used: 17.2 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 0
0.0001850 | Memory Before: 9.26 Mb | Memory After: 9.28 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT cr.confirmation
FROM phpfox_custom_relation_data AS crd
     JOIN phpfox_custom_relation AS cr
ON(cr.relation_id = crd.relation_id)

WHERE crd.relation_data_id = 171
LIMIT 1
0.0002301 | Memory Before: 9.3 Mb | Memory After: 9.32 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: No
SELECT hide_id
FROM phpfox_feed_hide
WHERE user_id = '0' AND type_id = 'feed'
LIMIT 1
0.0001168 | Memory Before: 9.3 Mb | Memory After: 9.32 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: No
SELECT hide_id
FROM phpfox_feed_hide
WHERE user_id = '0' AND type_id = 'user'
LIMIT 1
0.0012078 | Memory Before: 9.3 Mb | Memory After: 9.32 Mb | Memory Used: 17.77 Kb | Rows: 2 | Slave: Yes
SELECT feed.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.birthday, u.country_iso
FROM (
( SELECT DISTINCT feed.*
FROM phpfox_feed AS feed
WHERE (feed.parent_user_id=0 OR feed.parent_user_id = 144) AND feed.privacy IN(0) AND type_id = 'friend' AND feed.user_id = 144
ORDER BY feed.time_stamp DESC
LIMIT 10

) UNION ( SELECT DISTINCT feed.*
FROM phpfox_feed AS feed
WHERE (feed.parent_user_id=0 OR feed.parent_user_id = 144) AND feed.privacy IN(0) AND type_id = 'feed_comment' AND feed.user_id = 144
ORDER BY feed.time_stamp DESC
LIMIT 10

) UNION ( SELECT DISTINCT feed.*
FROM phpfox_feed AS feed
WHERE (feed.parent_user_id=0 OR feed.parent_user_id = 144) AND feed.privacy IN(0) AND feed.user_id = 144 AND feed.feed_reference = 0 AND feed.parent_user_id = 0
ORDER BY feed.time_stamp DESC
LIMIT 10

) UNION ( SELECT DISTINCT feed.*
FROM phpfox_feed AS feed
WHERE (feed.parent_user_id=0 OR feed.parent_user_id = 144) AND feed.privacy IN(0) AND feed.parent_user_id = 144
ORDER BY feed.time_stamp DESC
LIMIT 10

)) AS feed
     JOIN phpfox_user AS u
ON(u.user_id = feed.user_id)

ORDER BY feed.time_stamp DESC
LIMIT 10
0.0002120 | Memory Before: 9.32 Mb | Memory After: 9.34 Mb | Memory Used: 17.09 Kb | Rows: 1 | Slave: Yes
SELECT b.user_id, b.blog_id, b.title, b.time_stamp, b.total_comment, b.image_path, b.server_id, b.privacy, b.total_like, bt.text_parsed AS text, b.module_id, b.item_id, b.total_view
FROM phpfox_blog AS b
     JOIN phpfox_blog_text AS bt
ON(bt.blog_id = b.blog_id)

WHERE b.blog_id = 371
0.0002060 | Memory Before: 9.34 Mb | Memory After: 9.36 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT bc.parent_id, bc.category_id, bc.name
FROM phpfox_blog_category_data AS bcd
     JOIN phpfox_blog_category AS bc
ON(bc.category_id = bcd.category_id)

WHERE bcd.blog_id IN (371) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0004110 | Memory Before: 9.34 Mb | Memory After: 9.36 Mb | Memory Used: 16.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.birthday, u.country_iso, a.time_stamp as action_time_stamp, f.friend_id AS is_friend
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')
     LEFT JOIN phpfox_friend AS f
ON(f.friend_user_id = l.user_id AND f.user_id = 0)

WHERE (l.type_id = 'blog' OR l.type_id = 'blog') AND l.item_id = 371 AND l.user_id != 0
GROUP BY u.user_id, l.like_id, action_time_stamp
ORDER BY is_friend DESC , l.time_stamp DESC
LIMIT 2
0.0003290 | Memory Before: 9.33 Mb | Memory After: 9.35 Mb | Memory Used: 16.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.birthday, u.country_iso, a.time_stamp as action_time_stamp, f.friend_id AS is_friend
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')
     LEFT JOIN phpfox_friend AS f
ON(f.friend_user_id = l.user_id AND f.user_id = 0)

WHERE (l.type_id = 'blog' OR l.type_id = 'blog') AND l.item_id = 371 AND l.user_id != 0
GROUP BY u.user_id, l.like_id, action_time_stamp
ORDER BY is_friend DESC , l.time_stamp DESC
LIMIT 2
0.0003641 | Memory Before: 9.34 Mb | Memory After: 9.36 Mb | Memory Used: 16.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.birthday, u.country_iso, a.time_stamp as action_time_stamp, f.friend_id AS is_friend
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')
     LEFT JOIN phpfox_friend AS f
ON(f.friend_user_id = l.user_id AND f.user_id = 0)

WHERE (l.type_id = 'custom' OR l.type_id = 'custom') AND l.item_id = 144 AND l.user_id != 0
GROUP BY u.user_id, l.like_id, action_time_stamp
ORDER BY is_friend DESC , l.time_stamp DESC
LIMIT 2
0.0003622 | Memory Before: 9.34 Mb | Memory After: 9.36 Mb | Memory Used: 16.86 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.birthday, u.country_iso, f.friend_id AS is_friend
FROM phpfox_like AS l
     JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_friend AS f
ON(f.friend_user_id = l.user_id AND f.user_id =0)

WHERE l.type_id = 'custom' AND l.item_id = 144
GROUP BY u.user_id
ORDER BY FIELD(u.user_id, 0) DESC , is_friend DESC , u.full_name ASC
0.0002460 | Memory Before: 9.34 Mb | Memory After: 9.35 Mb | Memory Used: 16.95 Kb | Rows: 2 | Slave: Yes
SELECT 0 as row_index, count(*) as total_share
FROM phpfox_feed AS f
WHERE parent_module_id='blog' AND parent_feed_id=371

UNION ALL SELECT 1 as row_index, count(*) as total_share
FROM phpfox_feed AS f
WHERE parent_module_id='custom' AND parent_feed_id=144
Array
(
    [session] => b04b9f4f8f31849431e05ed72919fa2e
    [redirect] => 
)