SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490317 LIMIT 1 [ RunTime:0.002709s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490317 [ RunTime:0.012324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282366,358767,593271,620464,936278,816495,285013,718131,994614,767942,91192,81463,835386,157169,764033,151373,107496,770861,743610,103029,49683,390076,80040,668,159028,39201,133947,870083,616543,211223,207070,182442,147261,421956,1021207,25655,1020208,650819,350685,822101,967658,967295,233210,405181,250118,321499,63979,575795,322250,467568,753718,137432,421760,249712,253744,254684,18381,604661,648313,866415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006759s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006061s ]