Robert Vlad - FaceZbok.pl

zaktualizował swój avatar

2018-04-22 07:42:56 -

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

Query	Count	All	AVG
SELECT * FROM banned_ips WHERE ip = %s	1	6.0E-5	6.0E-5
SELECT * FROM system_options	1	0.00023	0.00023
SELECT * FROM system_languages WHERE enabled = '1'	1	6.0E-5	6.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	5.0E-5	5.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.00036	0.00036
SELECT * FROM users WHERE user_banned = '1' AND user_id = %s	1	0.00134	0.00134
SELECT user_id FROM followings WHERE following_id = %s	2	0.00017	9.0E-5
SELECT * FROM custom_fields WHERE in_profile = '1'	1	4.0E-5	4.0E-5
SELECT user_privacy_friends FROM users WHERE user_id = %s	1	0.00012	0.00012
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.00175	0.00175
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.00056	0.00056
SELECT user_privacy_photos FROM users WHERE user_id = %s	1	0.0003	0.0003
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.00023	0.00023
SELECT user_privacy_pages FROM users WHERE user_id = %s	1	0.00054	0.00054
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.0006	0.0006
SELECT user_privacy_groups FROM users WHERE user_id = %s	1	9.0E-5	9.0E-5
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.0019	0.0019
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	2	0.00042	0.00021
SELECT * FROM market_categories	1	3.0E-5	3.0E-5
SELECT post_id FROM posts_hidden WHERE user_id = %s	1	3.0E-5	3.0E-5
SELECT posts.post_id, posts.time FROM posts WHERE (posts.user_id = 27999 AND posts.user_type = 'user' AND posts.in_wall = '0' AND posts.privacy = 'public') ORDER BY posts.time DESC LIMIT %s, %s	1	0.00014	0.00014
SELECT * FROM posts_photos WHERE post_id = %s ORDER BY photo_id DESC	1	0.00035	0.00035

Query

Count

All

AVG

SELECT * FROM banned_ips WHERE ip = %s

6.0E-5

SELECT * FROM system_options

0.00023

SELECT * FROM system_languages WHERE enabled = '1'

6.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'

5.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.00036

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

0.00134

SELECT user_id FROM followings WHERE following_id = %s

0.00017

9.0E-5

SELECT * FROM custom_fields WHERE in_profile = '1'

4.0E-5

SELECT user_privacy_friends FROM users WHERE user_id = %s

0.00012

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.00175

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.00056

SELECT user_privacy_photos FROM users WHERE user_id = %s

0.0003

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.00023

SELECT user_privacy_pages FROM users WHERE user_id = %s

0.00054

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.0006

SELECT user_privacy_groups FROM users WHERE user_id = %s

9.0E-5

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.0019

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.00042

0.00021

SELECT * FROM market_categories

3.0E-5

SELECT post_id FROM posts_hidden WHERE user_id = %s

3.0E-5

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

0.00014

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

0.00035