Route: profile.index ID: #profile_index CSS: theme_material _is_profile_view _is_guest_user material_html
Be the first person to like this.
Be the first person to like this.
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.1021140
PHP General Time:
0.0806499
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0214641
SQL Queries:
45
SQL Memory Usage:
790.47 Kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Database Connection:
0.00053215026855469

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

Load Balancing Enabled:
No
Requests From:
207.246.85.29


Server Time Stamp:
December 9, 2019, 2:29 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.0005240 | 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.0046160 | 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.0012071 | 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 ('925d643b44d4d660c59b4dadaeed9d7a', 'c56fb43d525078d2aaf85f739d93f298', '0', '1575901743', '', '0', '0', '0', '18.205.60.226', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0003591 | 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.0011890 | 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 = 'RockyHenson4589'
0.0003889 | 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 = 136 AND b.post_status = 1 AND b.is_approved = 1 AND b.module_id IN ("blog")
LIMIT 1
0.0003181 | 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 = 136
LIMIT 1
0.0003281 | 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 = 136 AND item_id = 0
LIMIT 1
0.0002251 | 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 = 136
LIMIT 1
0.0002410 | 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 = 136)
     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.0004709 | 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 = 136)
     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.0002429 | 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 = 136
AND is_profile_photo IN(0)
AND is_cover_photo IN(0) AND type_id = 0 AND privacy IN (0)
LIMIT 1
0.0002501 | Memory Before: 8.2 Mb | Memory After: 8.22 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 136
0.0003622 | Memory Before: 8.36 Mb | Memory After: 8.38 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT CASE ub.user_id WHEN 136 THEN ub.block_user_id ELSE ub.user_id END as block_user_id
FROM phpfox_user_blocked AS ub
WHERE ub.user_id = 136 OR ub.block_user_id = 136
0.0003040 | Memory Before: 8.96 Mb | Memory After: 8.98 Mb | Memory Used: 17.09 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 136
0.0002398 | Memory Before: 8.97 Mb | Memory After: 8.99 Mb | Memory Used: 17 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_custom_group
WHERE group_id = 1
0.0001960 | Memory Before: 8.98 Mb | Memory After: 8.99 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 136
0.0005829 | Memory Before: 9 Mb | Memory After: 9.02 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 = 136) 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 = 136
GROUP BY u.user_id
ORDER BY friend.is_top_friend DESC , friend.ordering ASC, RAND()
LIMIT 6
0.0002279 | Memory Before: 9 Mb | Memory After: 9.02 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 = 136)
     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.0002768 | Memory Before: 9.01 Mb | Memory After: 9.02 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 = 136)
     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.0003500 | Memory Before: 9.01 Mb | Memory After: 9.03 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 = 136 AND (p.reg_method <> 2)
GROUP BY p.page_id
0.0009251 | Memory Before: 9.02 Mb | Memory After: 9.03 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 = 136 AND (p.reg_method <> 2)
GROUP BY p.page_id
ORDER BY l.time_stamp DESC
LIMIT 10
0.0002499 | Memory Before: 9.02 Mb | Memory After: 9.04 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 = 136
GROUP BY p.page_id
0.0004179 | Memory Before: 9.02 Mb | Memory After: 9.04 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 = 136
GROUP BY p.page_id
ORDER BY l.time_stamp DESC
LIMIT 10
0.0002432 | Memory Before: 9.03 Mb | Memory After: 9.05 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_friend_request
WHERE user_id = 136 AND friend_user_id = 0
LIMIT 1
0.0003660 | Memory Before: 9.05 Mb | Memory After: 9.06 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 = 136
GROUP BY egift_id
LIMIT 9

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

ORDER BY ei.time_stamp_paid DESC
0.0004208 | Memory Before: 9.12 Mb | Memory After: 9.13 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 = 136 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.0003881 | Memory Before: 9.13 Mb | Memory After: 9.15 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 = 136 AND (ms.module_id is NULL)
ORDER BY ms.ordering ASC, ms.time_stamp DESC
LIMIT 4
0.0002251 | Memory Before: 9.35 Mb | Memory After: 9.37 Mb | Memory Used: 17.2 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 0
0.0002429 | Memory Before: 9.4 Mb | Memory After: 9.42 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.0001130 | Memory Before: 9.4 Mb | Memory After: 9.42 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.0013571 | Memory Before: 9.4 Mb | Memory After: 9.42 Mb | Memory Used: 18.41 Kb | Rows: 3 | 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 = 136) AND feed.privacy IN(0) AND type_id = 'friend' AND feed.user_id = 136
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 = 136) AND feed.privacy IN(0) AND type_id = 'feed_comment' AND feed.user_id = 136
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 = 136) AND feed.privacy IN(0) AND feed.user_id = 136 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 = 136) AND feed.privacy IN(0) AND feed.parent_user_id = 136
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.0002410 | Memory Before: 9.49 Mb | Memory After: 9.5 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 = 365
0.0002592 | Memory Before: 9.51 Mb | Memory After: 9.53 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 (365) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0004370 | Memory Before: 9.51 Mb | Memory After: 9.53 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 = 365 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.0003970 | Memory Before: 9.5 Mb | Memory After: 9.52 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 = 365 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.0001740 | Memory Before: 9.51 Mb | Memory After: 9.53 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 = 357
0.0002010 | Memory Before: 9.53 Mb | Memory After: 9.54 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 (357) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0003190 | Memory Before: 9.53 Mb | Memory After: 9.54 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 = 357 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.0003281 | Memory Before: 9.52 Mb | Memory After: 9.53 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 = 357 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.0001938 | Memory Before: 9.53 Mb | Memory After: 9.55 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 = 356
0.0001709 | Memory Before: 9.55 Mb | Memory After: 9.56 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 (356) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0003090 | Memory Before: 9.55 Mb | Memory After: 9.56 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 = 356 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.0003300 | Memory Before: 9.53 Mb | Memory After: 9.55 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 = 356 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.0002551 | Memory Before: 9.53 Mb | Memory After: 9.55 Mb | Memory Used: 17 Kb | Rows: 3 | 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=365

UNION ALL SELECT 1 as row_index, count(*) as total_share
FROM phpfox_feed AS f
WHERE parent_module_id='blog' AND parent_feed_id=357

UNION ALL SELECT 2 as row_index, count(*) as total_share
FROM phpfox_feed AS f
WHERE parent_module_id='blog' AND parent_feed_id=356
Array
(
    [session] => 925d643b44d4d660c59b4dadaeed9d7a
    [redirect] => 
)