Росомаха»Фото

SELECT p.call_name, p.php_code
FROM `plugin` AS p
     JOIN `product` AS product
            ON(p.product_id = product.product_id AND product.is_active = 1)
     JOIN `plugin_hook` AS ph
            ON(ph.call_name = p.call_name AND ph.is_active = 1)
     JOIN `module` AS m
            ON(m.module_id = p.module_id AND m.is_active = 1)

WHERE p.is_active = 1
ORDER BY p.ordering ASC
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE				MISSING KEY						no matching row in const table

SELECT u.*, user_field.*, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured, p.photo_id as cover_photo_exists
FROM `user` AS u
     JOIN `user_group` AS ug
            ON(ug.user_group_id = u.user_group_id)
     JOIN `user_field` AS user_field
            ON(user_field.user_id = u.user_id)
     LEFT JOIN `photo` AS p
            ON(p.photo_id = user_field.cover_photo)
     LEFT JOIN `user_featured` AS uf
            ON(uf.user_id = u.user_id)

WHERE u.user_name = 'profile-1537'
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	uf		system	PRIMARY					0.00	const row not found
1	SIMPLE	u		ref	PRIMARY,user_name,user_group_id,user_id	user_name	403	const	1	100.00
1	SIMPLE	ug		eq_ref	PRIMARY,user_group_id	PRIMARY	1	danfa.u.user_group_id	1	100.00	Using index condition
1	SIMPLE	user_field		eq_ref	user_id	user_id	4	danfa.u.user_id	1	100.00
1	SIMPLE	p		eq_ref	PRIMARY,photo_id,photo_id_2	PRIMARY	4	danfa.user_field.cover_photo	1	100.00	Using index

SELECT user_id
FROM `user`
WHERE user_id = 1537 AND last_activity > 1787275352
LIMIT 1
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE				MISSING KEY						Impossible WHERE noticed after reading const tables

SELECT *
FROM `ban_data`
WHERE user_id = 1537 AND is_expired = 0
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	ban_data		ALL	MISSING KEY				16	6.25	Using where

SELECT user_id, user_privacy, user_value
FROM `user_privacy`
WHERE user_id = 1537
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	user_privacy		ref	user_id,user_id_2	user_id	4	const	1	100.00

SELECT *
FROM `user_blocked`
WHERE block_user_id = 0
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	user_blocked		ALL	MISSING KEY				3	33.33	Using where

SELECT COUNT(*)
FROM `photo_album`
WHERE view_id = 0 AND group_id = 0 AND user_id = 1537
LIMIT 1
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	photo_album		ref	user_id,view_id,view_id_2,view_id_3,view_id_4	view_id	9	const,const,const	2	100.00	Using index

SELECT COUNT(*)
FROM `photo_album`
WHERE view_id = 0 AND group_id = 0 AND user_id = 1537
LIMIT 1
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	photo_album		ref	user_id,view_id,view_id_2,view_id_3,view_id_4	view_id	9	const,const,const	2	100.00	Using index

SELECT COUNT(*)
FROM `photo` AS photo
     LEFT JOIN `pages` AS pages
            ON(pages.page_id = photo.group_id)
     LEFT JOIN `friend` AS friend
            ON(friend.user_id = pages.user_id AND friend.friend_user_id = 0)
     LEFT JOIN `privacy` AS privacy
            ON(privacy.module_id = 'pages' AND privacy.item_id = pages.page_id)
     LEFT JOIN `friend_list_data` AS fld
            ON(fld.list_id = privacy.friend_list_id AND fld.friend_user_id = 0)
     JOIN `user` AS u
            ON(u.user_id = photo.user_id)

WHERE photo.user_id = 1537 AND photo.privacy = 0 AND (pages.privacy IS NULL OR pages.privacy = 0)
LIMIT 1
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	u		const	PRIMARY,user_id	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	photo		ref	privacy,user_id	user_id	4	const	1	99.91	Using where
1	SIMPLE	pages		eq_ref	PRIMARY,page_id	PRIMARY	4	danfa.photo.group_id	1	19.00	Using where
1	SIMPLE	friend		eq_ref	user_check,user_id,top_friend,friend_user_id	user_check	8	danfa.pages.user_id,const	1	100.00	Using index
1	SIMPLE	privacy		ref	module_id	module_id	307	const,danfa.pages.page_id	1	100.00
1	SIMPLE	fld		eq_ref	list_id,list_id_2	list_id	8	danfa.privacy.friend_list_id,const	1	100.00	Using index

SELECT l.like_id as is_liked, photo.*, 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.originality, u.last_activity
FROM `photo` AS photo
     LEFT JOIN `pages` AS pages
            ON(pages.page_id = photo.group_id)
     LEFT JOIN `friend` AS friend
            ON(friend.user_id = pages.user_id AND friend.friend_user_id = 0)
     LEFT JOIN `privacy` AS privacy
            ON(privacy.module_id = 'pages' AND privacy.item_id = pages.page_id)
     LEFT JOIN `friend_list_data` AS fld
            ON(fld.list_id = privacy.friend_list_id AND fld.friend_user_id = 0)
     LEFT JOIN `like` AS l
            ON(l.type_id = "photo" AND l.item_id = photo.photo_id AND l.user_id = 0)
     JOIN `user` AS u
            ON(u.user_id = photo.user_id)

WHERE photo.user_id = 1537 AND photo.privacy = 0 AND (pages.privacy IS NULL OR pages.privacy = 0)
ORDER BY photo.photo_id DESC
LIMIT 20
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	u		const	PRIMARY,user_id	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	photo		ref	privacy,user_id	user_id	4	const	1	99.91	Using where
1	SIMPLE	pages		eq_ref	PRIMARY,page_id	PRIMARY	4	danfa.photo.group_id	1	19.00	Using where
1	SIMPLE	friend		eq_ref	user_check,user_id,top_friend,friend_user_id	user_check	8	danfa.pages.user_id,const	1	100.00	Using index
1	SIMPLE	privacy		ref	module_id	module_id	307	const,danfa.pages.page_id	1	100.00
1	SIMPLE	fld		eq_ref	list_id,list_id_2	list_id	8	danfa.privacy.friend_list_id,const	1	100.00	Using index
1	SIMPLE	l		ref	user_id,item_id,type_id	user_id	4	const	1	100.00	Using where

SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM `menu` AS m
     JOIN `module` AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'photo.index' AND m.is_active = 1
GROUP BY m.menu_id, mo.module_id
ORDER BY m.ordering ASC
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	m		ref	m_connection,parent_id	m_connection	229	const,const	1	88.57	Using where; Using temporary; Using filesort
1	SIMPLE	mo		ref	is_active,module_id,module_is_active	module_is_active	303	danfa.m.module_id,const	3	100.00	Using where; Using index

SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM `menu` AS m
     JOIN `module` AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'photo' AND m.is_active = 1
GROUP BY m.menu_id, mo.module_id
ORDER BY m.ordering ASC
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	m		ref	m_connection,parent_id	m_connection	229	const,const	1	88.57	Using where; Using temporary; Using filesort
1	SIMPLE	mo		ref	is_active,module_id,module_is_active	module_is_active	303	danfa.m.module_id,const	3	100.00	Using where; Using index

SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active
FROM `menu` AS m
     JOIN `module` AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)

WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	m		range	parent_id	parent_id	3		8	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	mo		ref	is_active,module_id,module_is_active	module_is_active	303	danfa.m.module_id,const	3	100.00	Using where; Using index