SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434713 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434713 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193420,521542,954819,351665,19956,838718,286173,432207,871210,783900,882397,645907,802705,955933,649723,640401,42466,417863,500973,728214,970095,874367,37633,111892,743701,193083,515827,503597,767772,162913,568235,981465,480325,278674,984113,725066,967582,62394,1016647,51278,957177,444252,718328,890789,354937,807947,565681,483763,845648,1001157,206136,530275,432332,643917,848567,441267,232151,207830,957566,856154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]