Tìm kiếm nâng cao - Mua bán Doanh nghiệp

SQL Report

Page generated in 0.0332 seconds with 22 queries

Time spent on MySQL queries: 0.00873s | Time spent on PHP: 0.02443s

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.00463s | After: 0.00495s | Elapsed: 0.00032s

Query #2
DELETE FROM raovat_sessions WHERE session_expiry <= 1762350445

Affected rows: 0 | Before: 0.00758s | After: 0.00954s | Elapsed: 0.00197s

Query #3
SELECT session_id FROM raovat_sessions WHERE session_id = 'tm7n53ind2ikp8c9ah9i6ibp73'

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_sessions		const	PRIMARY	PRIMARY	34	const	1	100.00	Using index

Before: 0.00997s | After: 0.01012s | Elapsed: 0.00015s

Query #4
UPDATE raovat_sessions SET session_ip = '216.73.216.47', session_expiry = 1762351885, session_user_id = 0, session_logged_in = 0 WHERE session_id = 'tm7n53ind2ikp8c9ah9i6ibp73'

Affected rows: 1 | Before: 0.01040s | After: 0.01265s | Elapsed: 0.00226s

Query #5
SELECT COUNT(*) AS online FROM raovat_sessions WHERE session_expiry >= 1762350445 AND session_logged_in = 0

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_sessions		ALL					103	3.33	Using where

Before: 0.01304s | After: 0.01337s | Elapsed: 0.00033s

Query #6
SELECT COUNT(*) AS online FROM raovat_sessions WHERE session_expiry >= 1762350445 AND session_logged_in = 1

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_sessions		ALL					103	3.33	Using where

Before: 0.01518s | After: 0.01546s | Elapsed: 0.00028s

Query #7
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.01625s | After: 0.01639s | Elapsed: 0.00013s

Query #8
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.01693s | After: 0.01706s | 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 = "home" 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.01741s | After: 0.01753s | Elapsed: 0.00013s

Query #10
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "home" 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.01793s | After: 0.01806s | 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 = "home" 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.01844s | After: 0.01855s | Elapsed: 0.00011s

Query #12
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "home" 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.01892s | After: 0.01903s | Elapsed: 0.00011s

Query #13
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "home" 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.01935s | After: 0.01947s | Elapsed: 0.00012s

Query #14
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "home" 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.01983s | After: 0.01999s | Elapsed: 0.00016s

Query #15
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "home" 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.02034s | After: 0.02045s | Elapsed: 0.00011s

Query #16
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "home" 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.02077s | After: 0.02090s | Elapsed: 0.00013s

Query #17
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "home" 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.02123s | After: 0.02135s | Elapsed: 0.00012s

Query #18
SELECT user_yahoo, user_skype, user_gtalk FROM raovat_support_users WHERE user_active = 1 AND user_leader= 0 AND (user_page = "home" 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.02169s | After: 0.02181s | Elapsed: 0.00011s

Query #19
SELECT province_id, province_name FROM raovat_provinces WHERE country_id = 230 AND province_active = 1 ORDER BY province_name ASC

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_provinces		ref	country_id	country_id	2	const	99	10.00	Using index condition; Using where; Using filesort

Before: 0.02222s | After: 0.02236s | Elapsed: 0.00014s

Query #20
SELECT adv_id, adv_name, adv_type, adv_image, adv_imagetype, adv_content, adv_url, adv_location FROM raovat_advs WHERE adv_enabled = 1 ORDER BY adv_startdate

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

Before: 0.02315s | After: 0.02340s | Elapsed: 0.00025s

Query #21

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	A	ref	user_id	user_id	4	const	21	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	P	eq_ref	PRIMARY	PRIMARY	4	sanduan.A.province_id	1	100.00
1	SIMPLE	U	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	PU	ref	user_id	user_id	4	const	1	100.00
1	SIMPLE	PA	eq_ref	PRIMARY	PRIMARY	4	sanduan.PU.package_id	1	100.00	Using where

Before: 0.02471s | After: 0.02586s | Elapsed: 0.00114s

Query #22
SELECT COUNT(*) AS totalrows FROM raovat_ads AS A WHERE A.ads_enabled = 1 AND A.user_id = 4268

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	A		ref	user_id	user_id	4	const	21	10.00	Using where

Before: 0.02762s | After: 0.02802s | Elapsed: 0.00040s