Dá»‹ch vá»¥ M&A - Mua bán Doanh nghiệp

SQL Report

Page generated in 0.0232 seconds with 17 queries

Time spent on MySQL queries: 0.00278s | Time spent on PHP: 0.02042s

Query #1
SELECT setting_name, setting_value FROM raovat_setting

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_setting		ALL					76	100.00

Before: 0.00554s | After: 0.00583s | Elapsed: 0.00029s

Query #2
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader = 1

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ALL					9	11.11	Using where

Before: 0.00801s | After: 0.00815s | Elapsed: 0.00013s

Query #3
SELECT dept_id, dept_name FROM raovat_support_departments WHERE dept_active = 1 ORDER BY dept_name ASC

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_departments		ALL					10	10.00	Using where; Using filesort

Before: 0.00880s | After: 0.00895s | Elapsed: 0.00015s

Query #4
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "help" OR user_page = "all") AND dept_id =6

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ref	dept_id	dept_id	1	const	1	11.11	Using where

Before: 0.00948s | After: 0.00965s | Elapsed: 0.00017s

Query #5
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "help" OR user_page = "all") AND dept_id =5

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ref	dept_id	dept_id	1	const	1	11.11	Using where

Before: 0.01013s | After: 0.01025s | Elapsed: 0.00013s

Query #6
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "help" OR user_page = "all") AND dept_id =2

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ref	dept_id	dept_id	1	const	1	11.11	Using where

Before: 0.01074s | After: 0.01092s | Elapsed: 0.00019s

Query #7
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "help" OR user_page = "all") AND dept_id =11

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ref	dept_id	dept_id	1	const	1	11.11	Using where

Before: 0.01136s | After: 0.01149s | Elapsed: 0.00013s

Query #8
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "help" OR user_page = "all") AND dept_id =8

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ref	dept_id	dept_id	1	const	1	11.11	Using where

Before: 0.01188s | After: 0.01201s | Elapsed: 0.00013s

Query #9
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "help" OR user_page = "all") AND dept_id =1

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ref	dept_id	dept_id	1	const	1	11.11	Using where

Before: 0.01238s | After: 0.01252s | Elapsed: 0.00014s

Query #10
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "help" OR user_page = "all") AND dept_id =10

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ref	dept_id	dept_id	1	const	1	11.11	Using where

Before: 0.01288s | After: 0.01301s | Elapsed: 0.00013s

Query #11
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "help" OR user_page = "all") AND dept_id =12

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ref	dept_id	dept_id	1	const	1	11.11	Using where

Before: 0.01343s | After: 0.01357s | Elapsed: 0.00014s

Query #12
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "help" OR user_page = "all") AND dept_id =9

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ref	dept_id	dept_id	1	const	1	11.11	Using where

Before: 0.01392s | After: 0.01407s | Elapsed: 0.00014s

Query #13
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "help" OR user_page = "all") AND dept_id =7

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_support_users		ref	dept_id	dept_id	1	const	1	11.11	Using where

Before: 0.01446s | After: 0.01462s | Elapsed: 0.00016s

Query #14
SELECT category_id, category_parent_id, category_title FROM raovat_categories_help WHERE category_id = 29

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_categories_help		ALL					28	10.00	Using where

Before: 0.01647s | After: 0.01671s | Elapsed: 0.00024s

Query #15
SELECT category_id, category_title FROM raovat_categories_help WHERE category_parent_id = 0 ORDER BY category_order

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_categories_help		ALL					28	10.00	Using where; Using filesort

Before: 0.01716s | After: 0.01733s | Elapsed: 0.00017s

Query #16
SELECT help_id, help_title FROM raovat_helps WHERE help_enabled = 1 AND category_id = 29 ORDER BY help_id ASC LIMIT 36

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_helps		ref	category_id	category_id	4	const	6	10.00	Using index condition; Using where; Using filesort

Before: 0.01830s | After: 0.01847s | Elapsed: 0.00017s

Query #17
SELECT COUNT(*) AS totalrows FROM raovat_helps WHERE help_enabled = 1 AND category_id = 29

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_helps		ref	category_id	category_id	4	const	6	10.00	Using where

Before: 0.01896s | After: 0.01912s | Elapsed: 0.00017s