| 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.00952s | After: 0.01009s | Elapsed: 0.00058s
Affected rows: 0 | Before: 0.01429s | After: 0.01900s | Elapsed: 0.00470s
| 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.02064s | After: 0.02117s | Elapsed: 0.00054s
Before: 0.02139s | After: 0.02517s | Elapsed: 0.00378s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | raovat_sessions | | ALL | | | | | 284 | 3.33 | Using where |
Before: 0.02598s | After: 0.02706s | Elapsed: 0.00107s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | raovat_sessions | | ALL | | | | | 284 | 3.33 | Using where |
Before: 0.02781s | After: 0.02885s | Elapsed: 0.00104s
| 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.03021s | After: 0.03048s | Elapsed: 0.00027s
| 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.03204s | After: 0.03235s | Elapsed: 0.00031s
| 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.03344s | After: 0.03369s | Elapsed: 0.00025s
| 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.03457s | After: 0.03481s | Elapsed: 0.00025s
| 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.03585s | After: 0.03619s | Elapsed: 0.00033s
| 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.03700s | After: 0.03725s | Elapsed: 0.00025s
| 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.03801s | After: 0.03829s | Elapsed: 0.00028s
| 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.03915s | After: 0.03942s | Elapsed: 0.00027s
| 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.04027s | After: 0.04051s | Elapsed: 0.00025s
| 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.04142s | After: 0.04166s | Elapsed: 0.00024s
| 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.04261s | After: 0.04288s | Elapsed: 0.00027s
| 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.04382s | After: 0.04417s | Elapsed: 0.00036s
| 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.04552s | After: 0.04625s | Elapsed: 0.00072s
| 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.04771s | After: 0.04808s | Elapsed: 0.00037s
| 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.04958s | After: 0.04996s | Elapsed: 0.00038s
| 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.05179s | After: 0.05218s | Elapsed: 0.00039s
| 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.05381s | After: 0.05435s | Elapsed: 0.00055s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | PU | | ref | user_id,package_id | package_id | 1 | const | 115 | 100.00 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | A | | ref | category_id,user_id | user_id | 4 | sanduan.PU.user_id | 7 | 1.00 | Using where | | 1 | SIMPLE | PA | | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | | | 1 | SIMPLE | P | | eq_ref | PRIMARY | PRIMARY | 4 | sanduan.A.province_id | 1 | 100.00 | |
Before: 0.05861s | After: 0.08240s | Elapsed: 0.02379s
| 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.08433s | After: 0.08466s | Elapsed: 0.00033s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | A | | ALL | PRIMARY,category_id | | | | 9440 | 10.00 | Using where; Using temporary; 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 | | ALL | PRIMARY | | | | 4 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
Before: 0.08659s | After: 0.61778s | Elapsed: 0.53119s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | A | | ALL | PRIMARY,category_id | | | | 9440 | 10.00 | Using where |
Before: 0.61950s | After: 0.62858s | Elapsed: 0.00908s |
Đặt làm trang chủ
