ZS

Zenaida Staggs

Lives in Oulton, United Kingdom. Married.
About Me
Hello! My name is Williemae and I'm a 20 years old girl from Oulton. Also visit my website; toyot...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.0997219
PHP General Time:
0.0765306
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0231913
SQL Queries:
46
SQL Memory Usage:
807.88 Kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Database Connection:
0.00048422813415527

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

Load Balancing Enabled:
No
Requests From:
207.246.85.29


Server Time Stamp:
November 19, 2019, 1:01 am
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.0004389 | Memory Before: 4.31 Mb | Memory After: 4.33 Mb | Memory Used: 25.52 Kb | Rows: 34 | Slave: Yes
SELECT *
FROM phpfox_apps
WHERE is_active=1
0.0032802 | Memory Before: 7.28 Mb | Memory After: 7.28 Mb | Memory Used: 696 b | Rows: - | Slave: No
DELETE FROM phpfox_log_session WHERE id_hash = 'c56fb43d525078d2aaf85f739d93f298'
0.0025260 | Memory Before: 7.28 Mb | Memory After: 7.28 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 ('5cd64383f25ba131fa00220ef4e36465', 'c56fb43d525078d2aaf85f739d93f298', '0', '1574125260', '', '0', '0', '0', '34.231.21.123', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0004671 | Memory Before: 7.32 Mb | Memory After: 7.33 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.0013750 | Memory Before: 7.61 Mb | Memory After: 7.68 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 = 'ZenaidaStaggs'
0.0003920 | Memory Before: 7.94 Mb | Memory After: 7.96 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_blog AS b
WHERE b.user_id = 89 AND b.post_status = 1 AND b.is_approved = 1 AND b.module_id IN ("blog")
LIMIT 1
0.0002739 | Memory Before: 8.06 Mb | Memory After: 8.07 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_marketplace
WHERE view_id = 0 AND user_id = 89
LIMIT 1
0.0002768 | Memory Before: 8.07 Mb | Memory After: 8.09 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_music_song
WHERE view_id = 0 AND user_id = 89 AND item_id = 0
LIMIT 1
0.0001659 | Memory Before: 8.16 Mb | Memory After: 8.18 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 = 89
LIMIT 1
0.0003221 | Memory Before: 8.16 Mb | Memory After: 8.18 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 = 89)
     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.0004089 | Memory Before: 8.15 Mb | Memory After: 8.16 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 = 89)
     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.0002799 | Memory Before: 8.15 Mb | Memory After: 8.17 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 = 89
AND is_profile_photo IN(0)
AND is_cover_photo IN(0) AND type_id = 0 AND privacy IN (0)
LIMIT 1
0.0002570 | Memory Before: 8.24 Mb | Memory After: 8.25 Mb | Memory Used: 17.86 Kb | Rows: 15 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 89
0.0002170 | Memory Before: 8.25 Mb | Memory After: 8.27 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT CASE ub.user_id WHEN 89 THEN ub.block_user_id ELSE ub.user_id END as block_user_id
FROM phpfox_user_blocked AS ub
WHERE ub.user_id = 89 OR ub.block_user_id = 89
0.0003760 | Memory Before: 8.83 Mb | Memory After: 8.85 Mb | Memory Used: 17.2 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 89
0.0002689 | Memory Before: 8.85 Mb | Memory After: 8.87 Mb | Memory Used: 17 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_custom_group
WHERE group_id = 1
0.0002420 | Memory Before: 8.86 Mb | Memory After: 8.87 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 89
0.0005970 | Memory Before: 8.93 Mb | Memory After: 8.95 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 = 89) 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 = 89
GROUP BY u.user_id
ORDER BY friend.is_top_friend DESC , friend.ordering ASC, RAND()
LIMIT 6
0.0003150 | Memory Before: 8.94 Mb | Memory After: 8.95 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 = 89)
     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.0002990 | Memory Before: 8.94 Mb | Memory After: 8.95 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 = 89)
     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.0004559 | Memory Before: 8.94 Mb | Memory After: 8.96 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 = 89 AND (p.reg_method <> 2)
GROUP BY p.page_id
0.0011401 | Memory Before: 8.95 Mb | Memory After: 8.96 Mb | Memory Used: 17.18 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 = 89 AND (p.reg_method <> 2)
GROUP BY p.page_id
ORDER BY l.time_stamp DESC
LIMIT 10
0.0003850 | Memory Before: 8.95 Mb | Memory After: 8.97 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 = 89
GROUP BY p.page_id
0.0004709 | Memory Before: 8.95 Mb | Memory After: 8.97 Mb | Memory Used: 17.18 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 = 89
GROUP BY p.page_id
ORDER BY l.time_stamp DESC
LIMIT 10
0.0002439 | Memory Before: 8.96 Mb | Memory After: 8.98 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_friend_request
WHERE user_id = 89 AND friend_user_id = 0
LIMIT 1
0.0003910 | Memory Before: 8.98 Mb | Memory After: 9 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 = 89
GROUP BY egift_id
LIMIT 9

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

ORDER BY ei.time_stamp_paid DESC
0.0005078 | Memory Before: 8.99 Mb | Memory After: 9 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 = 89 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.0005190 | Memory Before: 8.99 Mb | Memory After: 9.01 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 = 89 AND (ms.module_id is NULL)
ORDER BY ms.ordering ASC, ms.time_stamp DESC
LIMIT 4
0.0003951 | Memory Before: 9.28 Mb | Memory After: 9.3 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: No
SELECT *
FROM phpfox_cache
WHERE file_name = 'user/avatar/89'
0.0002289 | Memory Before: 9.28 Mb | Memory After: 9.3 Mb | Memory Used: 17.2 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 0
0.0002182 | Memory Before: 9.29 Mb | Memory After: 9.31 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 = 104
LIMIT 1
0.0002592 | Memory Before: 9.3 Mb | Memory After: 9.31 Mb | Memory Used: 17 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 = 104
0.0002458 | Memory Before: 9.31 Mb | Memory After: 9.33 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT with_user.relation_data_id
FROM phpfox_custom_relation_data AS crd
     JOIN phpfox_user_field AS with_user
ON(with_user.user_id = crd.with_user_id)
     JOIN phpfox_user_field AS user
ON(user.user_id = crd.user_id AND with_user.relation_data_id = user.relation_data_id)

WHERE crd.relation_data_id = 104
LIMIT 1
0.0002019 | Memory Before: 9.32 Mb | Memory After: 9.34 Mb | Memory Used: 17.1 Kb | Rows: 1 | Slave: Yes
SELECT *
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 = 104 AND (crd.user_id = 89 OR crd.with_user_id = 89)
ORDER BY crd.relation_data_id DESC
LIMIT 1
0.0001490 | Memory Before: 9.33 Mb | Memory After: 9.34 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
FROM phpfox_user AS u
WHERE user_id = 0
0.0002000 | Memory Before: 9.33 Mb | Memory After: 9.34 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT with_user.relation_data_id
FROM phpfox_custom_relation_data AS crd
     JOIN phpfox_user_field AS with_user
ON(with_user.user_id = crd.with_user_id)
     JOIN phpfox_user_field AS user
ON(user.user_id = crd.user_id AND with_user.relation_data_id = user.relation_data_id)

WHERE crd.relation_data_id = 104
LIMIT 1
0.0002351 | Memory Before: 9.36 Mb | Memory After: 9.37 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.0001340 | Memory Before: 9.36 Mb | Memory After: 9.37 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.0015080 | Memory Before: 9.36 Mb | Memory After: 9.38 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 = 89) AND feed.privacy IN(0) AND type_id = 'friend' AND feed.user_id = 89
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 = 89) AND feed.privacy IN(0) AND type_id = 'feed_comment' AND feed.user_id = 89
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 = 89) AND feed.privacy IN(0) AND feed.user_id = 89 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 = 89) AND feed.privacy IN(0) AND feed.parent_user_id = 89
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.0002370 | Memory Before: 9.38 Mb | Memory After: 9.4 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 = 243
0.0002880 | Memory Before: 9.4 Mb | Memory After: 9.41 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 (243) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0004561 | Memory Before: 9.4 Mb | Memory After: 9.42 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 = 243 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.0004768 | Memory Before: 9.39 Mb | Memory After: 9.41 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 = 243 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.0004771 | Memory Before: 9.4 Mb | Memory After: 9.41 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 = 89 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.0003159 | Memory Before: 9.4 Mb | Memory After: 9.42 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 = 89
GROUP BY u.user_id
ORDER BY FIELD(u.user_id, 0) DESC , is_friend DESC , u.full_name ASC
0.0002730 | Memory Before: 9.4 Mb | Memory After: 9.41 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=243

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=89
Array
(
    [session] => 5cd64383f25ba131fa00220ef4e36465
    [redirect] => 
)