- 论坛徽章:
- 0
|
EXPLAIN SELECT * FROM `barcode_all`
---------------------------------------------------------------------------------------------
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY <derived2> ALL NULL NULL NULL NULL 159036
2 DERIVED barcode_2d_temp ALL NULL NULL NULL NULL 1
3 UNION barcode_2d ALL NULL NULL NULL NULL 146931
4 UNION barcode_2d_n ALL NULL NULL NULL NULL 1954
5 UNION barcode_2d_sep ALL NULL NULL NULL NULL 429
6 UNION barcode_2d_sep_temp ALL NULL NULL NULL NULL 1
NULL UNION RESULT <union2,3,4,5,6> ALL NULL NULL NULL NULL NULL |
|