SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418070 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418070 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665254,361097,662541,914760,493199,449471,545616,835562,586697,943081,319399,634713,1031420,147603,426283,602133,542453,837548,66958,560843,969239,677356,654168,247584,109022,641981,551695,971504,33051,101950,566968,116447,1005542,116917,760426,680383,946315,711564,630624,495965,101739,798390,210060,716623,448482,873284,823017,316700,325665,12895,99169,650680,1034899,488115,520393,723166,935076,604319,48305,298239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]