Bogdan - FaceZbok.pl

zaktualizował swój avatar

2018-08-10 21:51:03 -

Zaloguj się żeby polubić, udostępnić i skomentować! 5 0 0

Query	Count	All	AVG
SELECT * FROM banned_ips WHERE ip = %s	1	7.0E-5	7.0E-5
SELECT * FROM system_options	1	0.00027	0.00027
SELECT * FROM system_languages WHERE enabled = '1'	1	7.0E-5	7.0E-5
SELECT * FROM system_themes WHERE system_themes.default = '1'	1	5.0E-5	5.0E-5
SELECT page_url, page_title FROM static_pages WHERE in_footer = '1'	1	4.0E-5	4.0E-5
SELECT users.*, packages.name as package_name, packages.color as package_color FROM users LEFT JOIN packages ON users.user_subscribed = '1' AND users.user_package = packages.package_id WHERE users.user_name = %s	1	0.00041	0.00041
SELECT * FROM users WHERE user_banned = '1' AND user_id = %s	1	0.00025	0.00025
SELECT user_id FROM followings WHERE following_id = %s	2	0.00025	0.00012
SELECT * FROM custom_fields WHERE in_profile = '1'	1	0.00562	0.00562
SELECT user_privacy_friends FROM users WHERE user_id = %s	1	0.00013	0.00013
SELECT users.user_id, users.user_name, users.user_fullname, users.user_gender, users.user_picture FROM users JOIN (SELECT IF (user_one_id = %1$s, user_two_id, user_one_id) AS fid FROM friends WHERE user_one_id = %1$s OR friends.user_two_id = %1$s AND `status` = 1 ORDER BY id LIMIT %2$s, %3$s) AS ids ON users.user_id = ids.fid	1	0.0042	0.0042
SELECT users.user_id FROM friends INNER JOIN users ON (friends.user_one_id = users.user_id) OR (friends.user_two_id = users.user_id) WHERE status = 1 AND (user_one_id = %1$s OR user_two_id = %1$s)	1	0.00342	0.00342
SELECT user_privacy_photos FROM users WHERE user_id = %s	1	0.00756	0.00756
SELECT posts_photos.photo_id, posts_photos.source, posts.privacy FROM posts_photos INNER JOIN posts ON posts_photos.post_id = posts.post_id WHERE posts.user_id = %s AND user_type = 'user' AND posts.time < DATE_SUB(NOW(), INTERVAL 1 HOUR) ORDER BY posts_photos.photo_id DESC LIMIT %s, %s	1	0.00034	0.00034
SELECT user_privacy_pages FROM users WHERE user_id = %s	1	9.0E-5	9.0E-5
SELECT pages.* FROM pages INNER JOIN pages_likes ON pages.page_id = pages_likes.page_id WHERE pages_likes.user_id = %s LIMIT %s, %s	1	0.00815	0.00815
SELECT user_privacy_groups FROM users WHERE user_id = %s	1	0.00075	0.00075
SELECT groups.* FROM groups INNER JOIN groups_members ON groups.group_id = groups_members.group_id WHERE groups_members.user_id = %s GROUP BY groups.group_id ORDER BY groups.group_name LIMIT %s, %s	1	0.00145	0.00145
SELECT posts., users.user_name, users.user_fullname, users.user_gender, users.user_picture, users.user_picture_id, users.user_cover_id, users.user_verified, users.user_subscribed, users.user_pinned_post, pages., groups.group_name, groups.group_picture_id, groups.group_cover_id, groups.group_title, groups.group_admin, groups.group_pinned_post FROM posts LEFT JOIN users ON posts.user_id = users.user_id AND posts.user_type = 'user' LEFT JOIN pages ON posts.user_id = pages.page_id AND posts.user_type = 'page' LEFT JOIN groups ON posts.in_group = '1' AND posts.group_id = groups.group_id WHERE NOT (users.user_name <=> NULL AND pages.page_name <=> NULL) AND posts.post_id = %s	3	0.00129	0.00043
SELECT * FROM market_categories	1	3.0E-5	3.0E-5
SELECT post_id FROM posts_hidden WHERE user_id = %s	1	6.0E-5	6.0E-5
SELECT posts.post_id, posts.time FROM posts WHERE (posts.user_id = 33235 AND posts.user_type = 'user' AND posts.in_wall = '0' AND posts.privacy = 'public') ORDER BY posts.time DESC LIMIT %s, %s	1	0.00144	0.00144
SELECT * FROM posts_photos WHERE post_id = %s ORDER BY photo_id DESC	2	0.00087	0.00043

Query

Count

All

AVG

SELECT * FROM banned_ips WHERE ip = %s

7.0E-5

SELECT * FROM system_options

0.00027

SELECT * FROM system_languages WHERE enabled = '1'

7.0E-5

SELECT * FROM system_themes WHERE system_themes.default = '1'

5.0E-5

SELECT page_url, page_title FROM static_pages WHERE in_footer = '1'

4.0E-5

SELECT users.*, packages.name as package_name, packages.color as package_color FROM users LEFT JOIN packages ON users.user_subscribed = '1' AND users.user_package = packages.package_id WHERE users.user_name = %s

0.00041

SELECT * FROM users WHERE user_banned = '1' AND user_id = %s

0.00025

SELECT user_id FROM followings WHERE following_id = %s

0.00025

0.00012

SELECT * FROM custom_fields WHERE in_profile = '1'

0.00562

SELECT user_privacy_friends FROM users WHERE user_id = %s

0.00013

SELECT users.user_id, users.user_name, users.user_fullname, users.user_gender, users.user_picture FROM users JOIN (SELECT IF (user_one_id = %1$s, user_two_id, user_one_id) AS fid FROM friends WHERE user_one_id = %1$s OR friends.user_two_id = %1$s AND `status` = 1 ORDER BY id LIMIT %2$s, %3$s) AS ids ON users.user_id = ids.fid

0.0042

SELECT users.user_id FROM friends INNER JOIN users ON (friends.user_one_id = users.user_id) OR (friends.user_two_id = users.user_id) WHERE status = 1 AND (user_one_id = %1$s OR user_two_id = %1$s)

0.00342

SELECT user_privacy_photos FROM users WHERE user_id = %s

0.00756

SELECT posts_photos.photo_id, posts_photos.source, posts.privacy FROM posts_photos INNER JOIN posts ON posts_photos.post_id = posts.post_id WHERE posts.user_id = %s AND user_type = 'user' AND posts.time < DATE_SUB(NOW(), INTERVAL 1 HOUR) ORDER BY posts_photos.photo_id DESC LIMIT %s, %s

0.00034

SELECT user_privacy_pages FROM users WHERE user_id = %s

9.0E-5

SELECT pages.* FROM pages INNER JOIN pages_likes ON pages.page_id = pages_likes.page_id WHERE pages_likes.user_id = %s LIMIT %s, %s

0.00815

SELECT user_privacy_groups FROM users WHERE user_id = %s

0.00075

SELECT groups.* FROM groups INNER JOIN groups_members ON groups.group_id = groups_members.group_id WHERE groups_members.user_id = %s GROUP BY groups.group_id ORDER BY groups.group_name LIMIT %s, %s

0.00145

SELECT posts.*, users.user_name, users.user_fullname, users.user_gender, users.user_picture, users.user_picture_id, users.user_cover_id, users.user_verified, users.user_subscribed, users.user_pinned_post, pages.*, groups.group_name, groups.group_picture_id, groups.group_cover_id, groups.group_title, groups.group_admin, groups.group_pinned_post FROM posts LEFT JOIN users ON posts.user_id = users.user_id AND posts.user_type = 'user' LEFT JOIN pages ON posts.user_id = pages.page_id AND posts.user_type = 'page' LEFT JOIN groups ON posts.in_group = '1' AND posts.group_id = groups.group_id WHERE NOT (users.user_name <=> NULL AND pages.page_name <=> NULL) AND posts.post_id = %s

0.00129

0.00043

SELECT * FROM market_categories

3.0E-5

SELECT post_id FROM posts_hidden WHERE user_id = %s

6.0E-5

SELECT posts.post_id, posts.time FROM posts WHERE (posts.user_id = 33235 AND posts.user_type = 'user' AND posts.in_wall = '0' AND posts.privacy = 'public') ORDER BY posts.time DESC LIMIT %s, %s

0.00144

SELECT * FROM posts_photos WHERE post_id = %s ORDER BY photo_id DESC

0.00087

0.00043