SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301106 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301106 [ RunTime:0.004145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294098,446978,798586,95007,319580,453198,201199,40855,611104,515343,722721,399056,596366,180468,70581,229204,520426,409641,323214,695643,566825,567626,1013745,736425,443374,489059,223313,101767,600929,445013,966786,506185,1011305,125523,458393,895689,540577,328997,682832,468651,144062,414069,373543,990728,193470,842541,50589,24052,236311,855657,113888,963076,503712,556114,737383,435918,39909,934749,614589,39402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000895s ]