SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325699 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325699 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720352,224015,798120,608806,484818,727847,10192,584672,411594,140740,167780,556660,52163,103505,898143,360418,334472,1044609,1023450,703812,276359,382029,259107,692067,1030738,974058,360795,12431,606984,720558,401859,44802,608415,623541,816481,329171,117751,1025366,242282,364528,712553,767983,902109,640641,80237,764444,525428,978420,688615,974993,819712,662750,923295,623577,468843,1013833,615318,1044404,898113,322869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]