| 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.01331s | After: 0.01396s | Elapsed: 0.00065s
Affected rows: 0 | Before: 0.01855s | After: 0.02322s | Elapsed: 0.00467s
| 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.02450s | After: 0.02863s | Elapsed: 0.00412s
Before: 0.02900s | After: 0.05463s | Elapsed: 0.02562s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | raovat_sessions | | ALL | | | | | 30 | 3.33 | Using where |
Before: 0.05613s | After: 0.05728s | Elapsed: 0.00115s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | raovat_sessions | | ALL | | | | | 30 | 3.33 | Using where |
Before: 0.05823s | After: 0.05918s | Elapsed: 0.00095s
| 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.06090s | After: 0.06125s | Elapsed: 0.00035s
| 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.06301s | After: 0.06342s | 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.06456s | After: 0.06487s | Elapsed: 0.00030s
| 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.06578s | After: 0.06611s | 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.06716s | After: 0.06746s | Elapsed: 0.00030s
| 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.06834s | After: 0.06859s | 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.06932s | After: 0.06960s | 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.07076s | After: 0.07110s | 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.07204s | After: 0.07232s | 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.07334s | After: 0.07379s | Elapsed: 0.00044s
| 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.07481s | After: 0.07514s | 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.07621s | After: 0.07668s | Elapsed: 0.00047s
| 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.07803s | After: 0.07879s | Elapsed: 0.00076s
| 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.08063s | After: 0.08105s | Elapsed: 0.00042s
| 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.08288s | After: 0.08346s | Elapsed: 0.00058s
| 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.08579s | After: 0.08616s | Elapsed: 0.00037s
| 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.08703s | After: 0.08731s | Elapsed: 0.00028s
| 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.08828s | After: 0.08857s | Elapsed: 0.00029s
| 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.08929s | After: 0.08956s | Elapsed: 0.00027s
| 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.09028s | After: 0.09058s | Elapsed: 0.00031s
| 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.09150s | After: 0.09185s | Elapsed: 0.00036s
| 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.09283s | After: 0.09316s | Elapsed: 0.00033s
| 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.09395s | After: 0.09431s | Elapsed: 0.00036s
| 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.09503s | After: 0.09533s | Elapsed: 0.00030s
| 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.09607s | After: 0.09644s | 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.09734s | After: 0.09770s | Elapsed: 0.00036s
| 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.09855s | After: 0.09885s | Elapsed: 0.00030s
| 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.09967s | After: 0.10005s | 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.10087s | After: 0.10114s | Elapsed: 0.00027s
| 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.10187s | After: 0.10216s | Elapsed: 0.00029s
| 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.10286s | After: 0.10312s | Elapsed: 0.00026s
| 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.10400s | After: 0.10432s | Elapsed: 0.00032s
| 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.10525s | After: 0.10564s | Elapsed: 0.00040s
| 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.10631s | After: 0.10660s | Elapsed: 0.00029s
| 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.10726s | After: 0.10758s | Elapsed: 0.00032s
| 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.10849s | After: 0.10876s | Elapsed: 0.00027s
| 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.10948s | After: 0.10976s | Elapsed: 0.00028s
| 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.11049s | After: 0.11078s | Elapsed: 0.00029s
| 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.11157s | After: 0.11182s | Elapsed: 0.00025s
| 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.11255s | After: 0.11283s | Elapsed: 0.00027s
| 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.11353s | After: 0.11379s | Elapsed: 0.00026s
| 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.11460s | After: 0.11495s | Elapsed: 0.00035s
| 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.11567s | After: 0.11608s | 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 |
Before: 0.11684s | After: 0.11715s | Elapsed: 0.00031s
| 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.11788s | After: 0.11819s | Elapsed: 0.00031s
| 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.11888s | After: 0.11916s | Elapsed: 0.00029s
| 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.12012s | After: 0.12058s | Elapsed: 0.00046s
| 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.12146s | After: 0.12185s | Elapsed: 0.00039s
| 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.12286s | After: 0.12325s | Elapsed: 0.00039s
| 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.12420s | After: 0.12457s | Elapsed: 0.00037s
| 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.12530s | After: 0.12557s | Elapsed: 0.00026s
| 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.12630s | After: 0.12665s | Elapsed: 0.00036s
| 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.12749s | After: 0.12775s | Elapsed: 0.00027s
| 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.12872s | After: 0.12914s | 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 |
Before: 0.12992s | After: 0.13027s | Elapsed: 0.00036s
| 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.13124s | After: 0.13166s | Elapsed: 0.00043s
| 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.13259s | After: 0.13303s | Elapsed: 0.00044s
| 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.13401s | After: 0.13442s | Elapsed: 0.00042s
| 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.13541s | After: 0.13569s | Elapsed: 0.00028s
| 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.13653s | After: 0.13693s | Elapsed: 0.00040s
| 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.13785s | After: 0.13823s | Elapsed: 0.00037s
| 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.13913s | After: 0.13946s | Elapsed: 0.00033s
| 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.14033s | After: 0.14068s | Elapsed: 0.00036s
| 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.14148s | After: 0.14181s | Elapsed: 0.00033s
| 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.14275s | After: 0.14308s | Elapsed: 0.00033s
| 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.14401s | After: 0.14434s | Elapsed: 0.00033s
| 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.14551s | After: 0.14594s | Elapsed: 0.00043s
| 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.14678s | After: 0.14708s | Elapsed: 0.00031s
| 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.14782s | After: 0.14817s | Elapsed: 0.00035s
| 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.14894s | After: 0.14922s | Elapsed: 0.00027s
| 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.14989s | After: 0.15020s | Elapsed: 0.00031s
| 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.15109s | After: 0.15147s | Elapsed: 0.00038s
| 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.15464s | After: 0.15517s | Elapsed: 0.00053s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | PU | | range | user_id,package_id | package_id | 1 | | 135 | 100.00 | Using index condition; Using where; Using temporary; Using filesort | | 1 | SIMPLE | A | | ref | category_id,user_id | user_id | 4 | sanduan.PU.user_id | 7 | 0.73 | Using where | | 1 | SIMPLE | P | | eq_ref | PRIMARY | PRIMARY | 4 | sanduan.A.province_id | 1 | 100.00 | | | 1 | SIMPLE | PA | | ALL | PRIMARY | | | | 4 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
Before: 0.15948s | After: 0.17435s | Elapsed: 0.01487s
| 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.17860s | After: 0.17894s | Elapsed: 0.00034s
| 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.17994s | After: 0.18025s | Elapsed: 0.00030s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | A | | ALL | PRIMARY,category_id | | | | 9440 | 7.34 | 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.18269s | After: 0.60864s | Elapsed: 0.42596s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | A | | ALL | PRIMARY,category_id | | | | 9440 | 7.34 | Using where |
Before: 0.61347s | After: 0.63259s | Elapsed: 0.01912s |
Đặt làm trang chủ
