SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991047 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991047 [ RunTime:0.004929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660838,421243,370407,546985,1045445,1040616,116461,388121,612891,362590,1039684,808946,26814,89324,833347,324914,872889,977633,713911,983345,197515,260961,435366,117493,451589,157715,49302,113914,815219,251351,584470,618545,917888,1042840,480164,839441,107157,1009883,726653,970348,769685,155752,376122,500264,633266,976674,754039,675372,994813,41984,833218,870443,538840,1018362,609895,475085,979979,101567,109853,424064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]