| 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.01259s | After: 0.01307s | Elapsed: 0.00048s
Affected rows: 0 | Before: 0.01587s | After: 0.02226s | Elapsed: 0.00639s
| 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.02329s | After: 0.02400s | Elapsed: 0.00071s
Before: 0.02435s | After: 0.02904s | Elapsed: 0.00469s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | raovat_sessions | | ALL | | | | | 37 | 3.33 | Using where |
Before: 0.03044s | After: 0.03171s | Elapsed: 0.00127s
| Id | Select Type | Table | Partitions | Type | Possible Keys | Key | Key Len | Ref | Rows | Filtered | Extra |
|---|
| 1 | SIMPLE | raovat_sessions | | ALL | | | | | 37 | 3.33 | Using where |
Before: 0.03267s | After: 0.03383s | Elapsed: 0.00117s
| 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.03616s | After: 0.03645s | Elapsed: 0.00029s
| 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.03827s | After: 0.03864s | 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.03990s | After: 0.04034s | 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.04153s | After: 0.04186s | Elapsed: 0.00032s
| 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.04320s | After: 0.04355s | Elapsed: 0.00035s
| 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.04460s | After: 0.04487s | 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.04587s | After: 0.04618s | 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.04727s | After: 0.04769s | 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.04869s | After: 0.04902s | 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.05006s | After: 0.05037s | 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.05137s | After: 0.05179s | 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.05274s | After: 0.05313s | Elapsed: 0.00040s
| 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.05511s | After: 0.05559s | Elapsed: 0.00047s
| 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.05762s | After: 0.05782s | Elapsed: 0.00020s
| 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.05896s | After: 0.05921s | 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.06076s | After: 0.06112s | 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.06177s | After: 0.06199s | Elapsed: 0.00022s
| 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.06257s | After: 0.06281s | Elapsed: 0.00024s
| 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.06332s | After: 0.06354s | Elapsed: 0.00022s
| 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.06407s | After: 0.06431s | Elapsed: 0.00023s
| 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.06486s | After: 0.06517s | 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.06565s | After: 0.06585s | 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.06637s | After: 0.06663s | 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.06724s | After: 0.06747s | Elapsed: 0.00023s
| 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.06798s | After: 0.06819s | Elapsed: 0.00021s
| 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.06865s | After: 0.06896s | 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.06953s | After: 0.06968s | Elapsed: 0.00015s
| 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.07002s | After: 0.07015s | 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 |
Before: 0.07055s | After: 0.07069s | Elapsed: 0.00014s
| 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.07104s | After: 0.07118s | Elapsed: 0.00014s
| 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.07144s | After: 0.07157s | 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 |
Before: 0.07199s | After: 0.07213s | Elapsed: 0.00014s
| 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.07255s | After: 0.07266s | Elapsed: 0.00011s
| 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.07318s | After: 0.07337s | 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 |
Before: 0.07377s | After: 0.07395s | Elapsed: 0.00018s
| 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.07427s | After: 0.07445s | Elapsed: 0.00018s
| 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.07481s | After: 0.07498s | Elapsed: 0.00018s
| 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.07538s | After: 0.07553s | Elapsed: 0.00015s
| 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.07586s | After: 0.07604s | 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.07635s | After: 0.07646s | Elapsed: 0.00012s
| 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.07675s | After: 0.07686s | Elapsed: 0.00011s
| 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.07713s | After: 0.07723s | Elapsed: 0.00011s
| 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.07757s | After: 0.07771s | Elapsed: 0.00014s
| 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.07810s | After: 0.07827s | Elapsed: 0.00016s
| 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.07868s | After: 0.07883s | Elapsed: 0.00015s
| 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.07922s | After: 0.07935s | Elapsed: 0.00014s
| 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.07976s | After: 0.07996s | 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.08035s | After: 0.08054s | 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.08106s | After: 0.08128s | Elapsed: 0.00023s
| 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.08171s | After: 0.08186s | Elapsed: 0.00015s
| 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.08234s | After: 0.08250s | Elapsed: 0.00016s
| 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.08285s | After: 0.08300s | Elapsed: 0.00015s
| 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.08329s | After: 0.08341s | Elapsed: 0.00012s
| 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.08367s | After: 0.08380s | 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 |
Before: 0.08424s | After: 0.08441s | Elapsed: 0.00016s
| 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.08481s | After: 0.08495s | Elapsed: 0.00014s
| 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.08527s | After: 0.08547s | 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.08605s | After: 0.08619s | Elapsed: 0.00015s
| 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.08659s | After: 0.08672s | 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 |
Before: 0.08710s | After: 0.08728s | Elapsed: 0.00018s
| 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.08767s | After: 0.08785s | Elapsed: 0.00018s
| 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.08824s | After: 0.08838s | Elapsed: 0.00014s
| 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.08878s | After: 0.08891s | 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 |
Before: 0.08929s | After: 0.08946s | Elapsed: 0.00016s
| 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.08980s | After: 0.08997s | 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.09036s | After: 0.09053s | 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.09086s | After: 0.09099s | 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 |
Before: 0.09135s | After: 0.09148s | Elapsed: 0.00012s
| 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.09177s | After: 0.09188s | Elapsed: 0.00011s
| 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.09223s | After: 0.09237s | 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 |
Before: 0.09266s | After: 0.09277s | Elapsed: 0.00012s
| 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.09325s | After: 0.09341s | Elapsed: 0.00017s
| 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.09515s | After: 0.09540s | Elapsed: 0.00025s
| 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.09866s | After: 0.10863s | Elapsed: 0.00997s
| 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.10997s | After: 0.11014s | 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; Using filesort |
Before: 0.11074s | After: 0.11088s | 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 | 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.11242s | After: 0.35077s | Elapsed: 0.23835s
| 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.35302s | After: 0.36318s | Elapsed: 0.01016s |
Đặt làm trang chủ
