SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304013 LIMIT 1 [ RunTime:0.000678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304013 [ RunTime:0.005082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692700,414966,271683,152605,753104,850419,107891,823153,843008,914573,983274,851577,682125,115667,734443,250031,56025,621083,895493,524504,124607,887023,966511,909047,787996,75608,919038,197922,234840,169508,153505,586761,252113,722352,603292,727092,645202,30969,786302,809794,563780,1009302,460746,742744,49267,380221,50590,318442,721329,406611,464685,276040,725019,871127,212558,476247,572514,1006968,592910,499329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]