| 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.00613s | After: 0.00638s | Elapsed: 0.00024s
Affected rows: 16 | Before: 0.00869s | After: 0.01280s | Elapsed: 0.00411s
| 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.01320s | After: 0.01342s | Elapsed: 0.00022s
Before: 0.01356s | After: 0.01487s | Elapsed: 0.00131s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | raovat_sessions | | ALL | | | | | 509 | 3.33 | Using where |
Before: 0.01529s | After: 0.01584s | Elapsed: 0.00055s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | raovat_sessions | | ALL | | | | | 509 | 3.33 | Using where |
Before: 0.01625s | After: 0.01671s | Elapsed: 0.00046s
| 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.01774s | After: 0.01788s | Elapsed: 0.00015s
| 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.01851s | After: 0.01864s | 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.01920s | After: 0.01936s | 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.01972s | After: 0.01985s | 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.02026s | After: 0.02038s | Elapsed: 0.00012s
| 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.02073s | After: 0.02084s | Elapsed: 0.00011s
| 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.02116s | After: 0.02128s | Elapsed: 0.00012s
| 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.02164s | After: 0.02175s | Elapsed: 0.00012s
| 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.02209s | After: 0.02221s | Elapsed: 0.00012s
| 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.02255s | After: 0.02265s | Elapsed: 0.00010s
| 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.02299s | After: 0.02309s | Elapsed: 0.00011s
| 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.02342s | After: 0.02353s | Elapsed: 0.00011s
| 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.02411s | After: 0.02469s | Elapsed: 0.00058s
| 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.02566s | After: 0.02576s | Elapsed: 0.00010s
| 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.02656s | After: 0.02675s | Elapsed: 0.00020s
| 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.02770s | After: 0.02782s | Elapsed: 0.00012s
| 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.02846s | After: 0.02866s | Elapsed: 0.00020s
| 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.03073s | After: 0.03092s | Elapsed: 0.00019s
| 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.03181s | After: 0.03195s | Elapsed: 0.00014s
| 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.03274s | After: 0.33708s | Elapsed: 0.30434s
| 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.33973s | After: 0.33986s | Elapsed: 0.00013s |
Đặt làm trang chủ
