- Mua bán Doanh nghiệp - Mua bán Dự án

SQL Report

Page generated in 0.0949 seconds with 29 queries

Time spent on MySQL queries: 0.04872s | Time spent on PHP: 0.04616s

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.00620s | After: 0.00663s | Elapsed: 0.00043s

Query #2
DELETE FROM raovat_sessions WHERE session_expiry <= 1760372334

Affected rows: 0 | Before: 0.00881s | After: 0.02952s | Elapsed: 0.02070s

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

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

Before: 0.03023s | After: 0.03055s | Elapsed: 0.00032s

Query #4
INSERT INTO raovat_sessions (session_id, session_ip, session_expiry, session_user_id, session_logged_in) VALUES ('pjgtkfvmlrssn4gi38nk7upm07', '216.73.216.107', 1760373774, 0, 0)

Before: 0.03073s | After: 0.05231s | Elapsed: 0.02158s

Query #5
SELECT COUNT(*) AS online FROM raovat_sessions WHERE session_expiry >= 1760372334 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					52	3.33	Using where

Before: 0.05302s | After: 0.05352s | Elapsed: 0.00050s

Query #6
SELECT COUNT(*) AS online FROM raovat_sessions WHERE session_expiry >= 1760372334 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					52	3.33	Using where

Before: 0.05527s | After: 0.05568s | Elapsed: 0.00041s

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.05664s | After: 0.05677s | Elapsed: 0.00014s

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.05749s | After: 0.05774s | Elapsed: 0.00024s

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.05821s | After: 0.05838s | Elapsed: 0.00018s

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.05880s | After: 0.05894s | Elapsed: 0.00014s

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.05936s | After: 0.05949s | 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 = "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.05993s | After: 0.06009s | Elapsed: 0.00016s

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.06045s | After: 0.06057s | Elapsed: 0.00013s

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.06097s | After: 0.06111s | Elapsed: 0.00013s

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.06147s | After: 0.06160s | Elapsed: 0.00013s

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.06197s | After: 0.06211s | Elapsed: 0.00014s

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.06248s | After: 0.06261s | 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.06299s | After: 0.06314s | Elapsed: 0.00016s

Query #19
SELECT question_id, question_title FROM raovat_poll_question WHERE question_enabled = 1 AND (question_startdate <= 1760372334 AND question_enddate >= 1760372334) ORDER BY question_order ASC LIMIT 1

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

Before: 0.06390s | After: 0.06421s | Elapsed: 0.00031s

Query #20
SELECT * FROM raovat_counter WHERE counter_name IN("userstats","catstats","adsstats")

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_counter		ALL					4	50.00	Using where

Before: 0.06645s | After: 0.06659s | Elapsed: 0.00014s

Query #21
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.06734s | After: 0.06766s | Elapsed: 0.00032s

Query #22
SELECT category_id, category_parent_id FROM raovat_categories WHERE category_parent_id = 756

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

Before: 0.06856s | After: 0.06873s | Elapsed: 0.00017s

Query #23
SELECT category_id, category_title, ads_enabled_counter FROM raovat_categories WHERE category_parent_id = 756 ORDER BY category_order ASC

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

Before: 0.06911s | After: 0.06926s | Elapsed: 0.00014s

Query #24
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.06996s | After: 0.07025s | Elapsed: 0.00029s

Query #25

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

Before: 0.07208s | After: 0.07260s | Elapsed: 0.00052s

Query #26
SELECT category_id, category_parent_id, category_title FROM raovat_categories WHERE category_id = 756

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

Before: 0.07696s | After: 0.07713s | Elapsed: 0.00017s

Query #27
SELECT category_id, category_title, ads_enabled_counter FROM raovat_categories 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		ALL					87	10.00	Using where; Using filesort

Before: 0.07753s | After: 0.07765s | Elapsed: 0.00012s

Query #28

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	A	ref	category_id	category_id	4	const	1	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	PU	ref	user_id	user_id	4	sanduan.A.user_id	1	100.00
1	SIMPLE	PA	eq_ref	PRIMARY	PRIMARY	4	sanduan.PU.package_id	1	100.00	Using where

Before: 0.07842s | After: 0.07882s | Elapsed: 0.00040s

Query #29
SELECT COUNT(*) AS totalrows FROM raovat_ads AS A WHERE A.ads_enabled = 1 AND A.category_id IN(756)

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

Before: 0.08313s | After: 0.08351s | Elapsed: 0.00038s