SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012166 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012166 [ RunTime:0.003016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451716,592285,368001,857806,7423,795830,426754,425639,1015225,954157,470585,602129,159491,541600,266663,1028444,931907,221026,69978,755878,767555,692818,1048367,808402,27574,298440,114472,857556,942392,517198,441143,395452,278442,319241,579055,983209,552961,40390,913487,660936,103113,862451,683925,428916,881437,717376,155688,73241,342858,1033503,315389,721689,322844,440745,788130,537914,995315,281084,979632,1001682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000783s ]