BG

Basil Gorham

Lives in Heilenbach, Germany.
About Me
Im addicted to my hobby Amateur geology. I also to learn Russian in my spare time. My site; شركة...View More
Route: profile.index ID: #profile_index CSS: theme_material _is_profile_view _is_guest_user material_html
posted a blog.
Be the first person to like this.
posted a blog.
Be the first person to like this.
posted a blog.
Be the first person to like this.
Be the first person to like this.
Be the first person to like this.
Be the first person to like this.
Be the first person to like this.
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.1308501
PHP General Time:
0.1003779
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0304722
SQL Queries:
75
SQL Memory Usage:
1.28 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Database Connection:
0.00056099891662598

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

Load Balancing Enabled:
No
Requests From:
207.246.85.29


Server Time Stamp:
November 11, 2019, 11:14 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.0004950 | Memory Before: 4.28 Mb | Memory After: 4.31 Mb | Memory Used: 25.52 Kb | Rows: 34 | Slave: Yes
SELECT *
FROM phpfox_apps
WHERE is_active=1
0.0038171 | 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.0012960 | Memory Before: 7.26 Mb | Memory After: 7.26 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 ('3138e748ef5926a22c4442586bc0bc46', 'c56fb43d525078d2aaf85f739d93f298', '0', '1573514046', '', '0', '0', '0', '3.227.208.153', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0004601 | Memory Before: 7.35 Mb | Memory After: 7.37 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.0015478 | Memory Before: 7.59 Mb | Memory After: 7.66 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 = 'BasilGorham2'
0.0004210 | Memory Before: 7.91 Mb | Memory After: 7.93 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_blog AS b
WHERE b.user_id = 79 AND b.post_status = 1 AND b.is_approved = 1 AND b.module_id IN ("blog")
LIMIT 1
0.0002940 | Memory Before: 8.03 Mb | Memory After: 8.05 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_marketplace
WHERE view_id = 0 AND user_id = 79
LIMIT 1
0.0003290 | Memory Before: 8.11 Mb | Memory After: 8.12 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_music_song
WHERE view_id = 0 AND user_id = 79 AND item_id = 0
LIMIT 1
0.0001819 | Memory Before: 8.2 Mb | Memory After: 8.22 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 = 79
LIMIT 1
0.0002730 | Memory Before: 8.2 Mb | Memory After: 8.22 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 = 79)
     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.0003710 | Memory Before: 8.18 Mb | Memory After: 8.2 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 = 79)
     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.0002782 | Memory Before: 8.19 Mb | Memory After: 8.2 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 = 79
AND is_profile_photo IN(0)
AND is_cover_photo IN(0) AND type_id = 0 AND privacy IN (0)
LIMIT 1
0.0002990 | Memory Before: 8.27 Mb | Memory After: 8.29 Mb | Memory Used: 17.86 Kb | Rows: 15 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 79
0.0002041 | Memory Before: 8.29 Mb | Memory After: 8.3 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT CASE ub.user_id WHEN 79 THEN ub.block_user_id ELSE ub.user_id END as block_user_id
FROM phpfox_user_blocked AS ub
WHERE ub.user_id = 79 OR ub.block_user_id = 79
0.0003130 | Memory Before: 8.87 Mb | Memory After: 8.88 Mb | Memory Used: 17.2 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 79
0.0002460 | Memory Before: 8.88 Mb | Memory After: 8.9 Mb | Memory Used: 17 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_custom_group
WHERE group_id = 1
0.0002370 | Memory Before: 8.89 Mb | Memory After: 8.91 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 79
0.0005879 | 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 = 79) 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 = 79
GROUP BY u.user_id
ORDER BY friend.is_top_friend DESC , friend.ordering ASC, RAND()
LIMIT 6
0.0002210 | 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 = 79)
     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.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 = 79)
     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.0003328 | Memory Before: 8.91 Mb | Memory After: 8.92 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 = 79 AND (p.reg_method <> 2)
GROUP BY p.page_id
0.0009980 | Memory Before: 8.91 Mb | Memory After: 8.93 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 = 79 AND (p.reg_method <> 2)
GROUP BY p.page_id
ORDER BY l.time_stamp DESC
LIMIT 10
0.0002739 | 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 = 79
GROUP BY p.page_id
0.0004399 | Memory Before: 8.92 Mb | Memory After: 8.94 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 = 79
GROUP BY p.page_id
ORDER BY l.time_stamp DESC
LIMIT 10
0.0002360 | 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 = 79 AND friend_user_id = 0
LIMIT 1
0.0003610 | Memory Before: 9.01 Mb | Memory After: 9.03 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 = 79
GROUP BY egift_id
LIMIT 9

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

ORDER BY ei.time_stamp_paid DESC
0.0004230 | Memory Before: 9.02 Mb | Memory After: 9.03 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 = 79 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.0004439 | Memory Before: 9.02 Mb | Memory After: 9.04 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 = 79 AND (ms.module_id is NULL)
ORDER BY ms.ordering ASC, ms.time_stamp DESC
LIMIT 4
0.0002868 | Memory Before: 9.25 Mb | Memory After: 9.26 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: No
SELECT *
FROM phpfox_cache
WHERE file_name = 'user/avatar/79'
0.0002069 | 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.0002182 | 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 = 92
LIMIT 1
0.0002651 | Memory Before: 9.36 Mb | Memory After: 9.38 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.0001171 | Memory Before: 9.36 Mb | Memory After: 9.38 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.0014620 | Memory Before: 9.37 Mb | Memory After: 9.39 Mb | Memory Used: 25.02 Kb | Rows: 10 | 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 = 79) AND feed.privacy IN(0) AND type_id = 'friend' AND feed.user_id = 79
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 = 79) AND feed.privacy IN(0) AND type_id = 'feed_comment' AND feed.user_id = 79
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 = 79) AND feed.privacy IN(0) AND feed.user_id = 79 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 = 79) AND feed.privacy IN(0) AND feed.parent_user_id = 79
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.0002320 | Memory Before: 9.41 Mb | Memory After: 9.43 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 = 256
0.0002980 | Memory Before: 9.42 Mb | Memory After: 9.44 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 (256) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0004900 | Memory Before: 9.42 Mb | Memory After: 9.43 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 = 256 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.0003879 | Memory Before: 9.41 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 = 256 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.0001869 | Memory Before: 9.42 Mb | Memory After: 9.44 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 = 255
0.0002151 | Memory Before: 9.43 Mb | Memory After: 9.45 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 (255) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0003519 | Memory Before: 9.43 Mb | Memory After: 9.45 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 = 255 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.0003390 | Memory Before: 9.42 Mb | Memory After: 9.44 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 = 255 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.0001931 | Memory Before: 9.43 Mb | Memory After: 9.45 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 = 254
0.0001760 | Memory Before: 9.44 Mb | Memory After: 9.46 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 (254) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0003331 | Memory Before: 9.44 Mb | Memory After: 9.46 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 = 254 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.0004661 | Memory Before: 9.43 Mb | Memory After: 9.45 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 = 254 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.0001912 | Memory Before: 9.45 Mb | Memory After: 9.46 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 = 249
0.0002229 | Memory Before: 9.46 Mb | Memory After: 9.47 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 (249) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0003340 | Memory Before: 9.46 Mb | Memory After: 9.47 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 = 249 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.0003710 | Memory Before: 9.45 Mb | Memory After: 9.46 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 = 249 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.0001912 | Memory Before: 9.46 Mb | Memory After: 9.48 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 = 248
0.0001750 | Memory Before: 9.47 Mb | Memory After: 9.48 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 (248) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0003769 | Memory Before: 9.47 Mb | Memory After: 9.48 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 = 248 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.0003350 | Memory Before: 9.46 Mb | Memory After: 9.47 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 = 248 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.0001771 | Memory Before: 9.47 Mb | Memory After: 9.49 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 = 247
0.0002480 | Memory Before: 9.48 Mb | Memory After: 9.5 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 (247) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0003359 | Memory Before: 9.48 Mb | Memory After: 9.5 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 = 247 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.0004480 | Memory Before: 9.47 Mb | Memory After: 9.49 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 = 247 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.0001838 | Memory Before: 9.48 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 = 235
0.0001740 | Memory Before: 9.49 Mb | Memory After: 9.51 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 (235) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0004120 | Memory Before: 9.49 Mb | Memory After: 9.51 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 = 235 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.0003750 | Memory Before: 9.48 Mb | Memory After: 9.5 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 = 235 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.0002029 | Memory Before: 9.5 Mb | Memory After: 9.51 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 = 233
0.0001969 | Memory Before: 9.51 Mb | Memory After: 9.52 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 (233) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0003290 | Memory Before: 9.51 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 = 233 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.0003650 | 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 = 233 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.0001879 | 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 = 228
0.0001788 | Memory Before: 9.52 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 (228) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0004280 | Memory Before: 9.52 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 = 228 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.0003669 | 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 = 228 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.0002229 | Memory Before: 9.53 Mb | Memory After: 9.54 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 = 212
0.0002170 | Memory Before: 9.54 Mb | Memory After: 9.55 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 (212) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC
0.0003419 | Memory Before: 9.54 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 = 212 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.0003581 | 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 = 212 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.0006211 | Memory Before: 9.51 Mb | Memory After: 9.53 Mb | Memory Used: 17.33 Kb | Rows: 10 | 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=256

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=255

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=254

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

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

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

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

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

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

UNION ALL SELECT 9 as row_index, count(*) as total_share
FROM phpfox_feed AS f
WHERE parent_module_id='blog' AND parent_feed_id=212
Array
(
    [session] => 3138e748ef5926a22c4442586bc0bc46
    [redirect] => 
)