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.00716s | After: 0.00744s | Elapsed: 0.00028s
Affected rows: 4 | Before: 0.01024s | After: 0.04641s | Elapsed: 0.03617s
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.04710s | After: 0.04740s | Elapsed: 0.00030s
Before: 0.04754s | After: 0.08728s | Elapsed: 0.03974s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | raovat_sessions | | ALL | | | | | 44 | 3.33 | Using where |
Before: 0.08797s | After: 0.08846s | Elapsed: 0.00049s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | raovat_sessions | | ALL | | | | | 44 | 3.33 | Using where |
Before: 0.08960s | After: 0.08992s | Elapsed: 0.00032s
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.09164s | After: 0.09195s | Elapsed: 0.00031s
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.09310s | After: 0.09330s | Elapsed: 0.00020s
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.09383s | After: 0.09399s | Elapsed: 0.00016s
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.09443s | After: 0.09458s | Elapsed: 0.00015s
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.09507s | After: 0.09527s | Elapsed: 0.00020s
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.09565s | After: 0.09580s | Elapsed: 0.00015s
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.09617s | After: 0.09631s | Elapsed: 0.00014s
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.09668s | After: 0.09682s | Elapsed: 0.00013s
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.09721s | After: 0.09735s | Elapsed: 0.00014s
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.09772s | After: 0.09786s | Elapsed: 0.00014s
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.09825s | After: 0.09838s | Elapsed: 0.00013s
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.09872s | After: 0.09887s | Elapsed: 0.00015s
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.09966s | After: 0.09996s | Elapsed: 0.00030s
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.10101s | After: 0.10117s | Elapsed: 0.00016s
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.10229s | After: 0.10251s | Elapsed: 0.00023s
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.10363s | After: 0.10389s | Elapsed: 0.00026s
Affected rows: 1 | Before: 0.10461s | After: 0.13943s | Elapsed: 0.03482s
Id | Select Type | Table | Partitions | 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.14172s | After: 0.14227s | Elapsed: 0.00054s
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.14321s | After: 0.14341s | Elapsed: 0.00020s
Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
---|
1 | SIMPLE | A | | ALL | PRIMARY | | | | 9440 | 1.00 | Using where; Using filesort | 1 | SIMPLE | P | | eq_ref | PRIMARY | PRIMARY | 4 | sanduan.A.province_id | 1 | 100.00 | |
Before: 0.14401s | After: 0.15443s | Elapsed: 0.01042s
Id | Select Type | Table | Partitions | 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 | | | | 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.15703s | After: 0.16660s | Elapsed: 0.00957s
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.16816s | After: 0.16833s | Elapsed: 0.00017s
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.16861s | After: 0.16873s | Elapsed: 0.00013s
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.16919s | After: 0.16934s | Elapsed: 0.00014s
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.17006s | After: 0.17027s | Elapsed: 0.00021s
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.17081s | After: 0.17094s | Elapsed: 0.00012s |