| 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.01370s | After: 0.01467s | Elapsed: 0.00098s
Affected rows: 0 | Before: 0.01982s | After: 0.02685s | Elapsed: 0.00703s
| 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.02820s | After: 0.02891s | Elapsed: 0.00071s
Before: 0.02915s | After: 0.03864s | Elapsed: 0.00949s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | raovat_sessions | | ALL | | | | | 191 | 3.33 | Using where |
Before: 0.04016s | After: 0.04173s | Elapsed: 0.00158s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | raovat_sessions | | ALL | | | | | 191 | 3.33 | Using where |
Before: 0.04279s | After: 0.04414s | Elapsed: 0.00135s
| 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.04640s | After: 0.04683s | Elapsed: 0.00043s
| 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.04908s | After: 0.04945s | Elapsed: 0.00037s
| 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.05095s | After: 0.05137s | Elapsed: 0.00042s
| 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.05271s | After: 0.05306s | Elapsed: 0.00034s
| 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.05444s | After: 0.05485s | Elapsed: 0.00042s
| 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.05600s | After: 0.05636s | Elapsed: 0.00036s
| 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.05797s | After: 0.05836s | Elapsed: 0.00039s
| 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.05963s | After: 0.06004s | Elapsed: 0.00041s
| 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.06131s | After: 0.06176s | Elapsed: 0.00045s
| 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.06291s | After: 0.06326s | Elapsed: 0.00036s
| 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.06479s | After: 0.06518s | Elapsed: 0.00039s
| 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.06631s | After: 0.06675s | Elapsed: 0.00043s
| 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.06899s | After: 0.06934s | Elapsed: 0.00035s
| 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.07117s | After: 0.07157s | Elapsed: 0.00040s
| 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.07360s | After: 0.07414s | Elapsed: 0.00054s
| 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.07670s | After: 0.07706s | Elapsed: 0.00037s
| 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.07962s | After: 0.08059s | Elapsed: 0.00097s
| 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.08584s | After: 0.08625s | Elapsed: 0.00041s
| 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.08796s | After: 0.08844s | Elapsed: 0.00048s
| 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.09084s | After: 0.56924s | Elapsed: 0.47840s
| 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.57291s | After: 0.57326s | Elapsed: 0.00035s |
Đặt làm trang chủ
