Bán đất Yên Xá, Tân Triều, Thanh Trì, HN.(BDS-MB0165) - Mua bán Doanh nghiệp

SQL Report

Page generated in 0.0724 seconds with 33 queries

Time spent on MySQL queries: 0.03865s | Time spent on PHP: 0.03378s

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.00698s | After: 0.00729s | Elapsed: 0.00031s

Query #2
DELETE FROM raovat_sessions WHERE session_expiry <= 1762517572

Affected rows: 0 | Before: 0.00969s | After: 0.01195s | Elapsed: 0.00226s

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

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.01228s | After: 0.01247s | Elapsed: 0.00019s

Query #4
INSERT INTO raovat_sessions (session_id, session_ip, session_expiry, session_user_id, session_logged_in) VALUES ('vpvog4gt6mdb0ld2a61vkhfkg3', '216.73.216.85', 1762519012, 0, 0)

Before: 0.01262s | After: 0.01476s | Elapsed: 0.00215s

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

Before: 0.01518s | After: 0.01570s | Elapsed: 0.00052s

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

Before: 0.01602s | After: 0.01631s | Elapsed: 0.00029s

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.01693s | After: 0.01704s | Elapsed: 0.00011s

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.01772s | After: 0.01785s | 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.01839s | After: 0.01856s | Elapsed: 0.00017s

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.01900s | After: 0.01912s | Elapsed: 0.00012s

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.01950s | After: 0.01964s | 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.01999s | After: 0.02010s | 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.02044s | After: 0.02056s | 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.02094s | After: 0.02104s | Elapsed: 0.00011s

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.02138s | After: 0.02149s | 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.02182s | After: 0.02193s | Elapsed: 0.00011s

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.02225s | After: 0.02236s | Elapsed: 0.00011s

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.02277s | After: 0.02290s | Elapsed: 0.00013s

Query #19
SELECT question_id, question_title FROM raovat_poll_question WHERE question_enabled = 1 AND (question_startdate <= 1762517572 AND question_enddate >= 1762517572) 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.02353s | After: 0.02376s | Elapsed: 0.00023s

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.02427s | After: 0.02437s | Elapsed: 0.00011s

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.02511s | After: 0.02527s | Elapsed: 0.00016s

Query #22
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.02607s | After: 0.02628s | Elapsed: 0.00021s

Query #23
UPDATE raovat_ads SET ads_hits = ads_hits + 1 WHERE ads_id =5573

Affected rows: 1 | Before: 0.02695s | After: 0.02891s | Elapsed: 0.00195s

Query #24

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	A	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	P	const	PRIMARY	PRIMARY	4	const	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.03047s | After: 0.03094s | Elapsed: 0.00047s

Query #25
SELECT * FROM raovat_ads_image WHERE ads_id = 5573 ORDER BY image_id ASC LIMIT 5

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

Before: 0.03154s | After: 0.03281s | Elapsed: 0.00127s

Query #26
SELECT A.ads_id, A.ads_title, A.ads_image, A.ads_start_date, A.ads_type, A.ads_hits, P.province_name FROM raovat_ads AS A LEFT JOIN raovat_provinces AS P ON(A.province_id = P.province_id) WHERE A.ads_enabled = 1 AND A.ads_id != 5573 AND A.user_id=1134 ORDER BY A.ads_start_date DESC LIMIT 5

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

Before: 0.03342s | After: 0.03731s | Elapsed: 0.00389s

Query #27

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	PA	ALL	PRIMARY				4	25.00	Using where; Using temporary; Using filesort
1	SIMPLE	A	ALL	PRIMARY,user_id				9440	1.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	PU	ref	user_id,package_id	user_id	4	sanduan.A.user_id	1	5.00	Using where
1	SIMPLE	P	eq_ref	PRIMARY	PRIMARY	4	sanduan.A.province_id	1	100.00

Before: 0.03832s | After: 0.05960s | Elapsed: 0.02128s

Query #28
SELECT category_id, category_parent_id, category_title FROM raovat_categories WHERE category_id = 554

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_categories		const	PRIMARY	PRIMARY	4	const	1	100.00

Before: 0.06093s | After: 0.06106s | Elapsed: 0.00013s

Query #29
SELECT category_id, category_parent_id, category_title FROM raovat_categories WHERE category_id = 701

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_categories		const	PRIMARY	PRIMARY	4	const	1	100.00

Before: 0.06150s | After: 0.06163s | Elapsed: 0.00013s

Query #30
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.06203s | After: 0.06214s | Elapsed: 0.00011s

Query #31
SELECT image_id, image_title FROM raovat_ads_image WHERE ads_id =5573 ORDER BY image_id DESC LIMIT 1

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

Before: 0.06245s | After: 0.06351s | Elapsed: 0.00106s

Query #32
SELECT rating_value FROM raovat_ratings WHERE ads_id =5573

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_ratings		ref	ads_id	ads_id	4	const	1	100.00

Before: 0.06409s | After: 0.06433s | Elapsed: 0.00023s

Query #33
SELECT COUNT(*) as total FROM raovat_reviews WHERE ads_id =5573

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	raovat_reviews		ref	ads_id	ads_id	4	const	1	100.00	Using index

Before: 0.06504s | After: 0.06528s | Elapsed: 0.00024s