SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 957231 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 957231 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998805,1042820,1033173,618803,846986,781187,564605,304417,584720,661897,403747,1012488,42916,282015,891803,14677,652436,212805,797443,461642,859667,838482,726340,961452,77154,78668,500155,24855,231857,150673,103881,484878,111990,1039907,558413,179835,55573,1003906,1043541,1021841,9756,516635,906958,708673,1002386,665508,742777,114341,346343,678495,499767,30587,560121,238150,466924,732995,259705,687318,783392,975113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 957231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 957231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001411s ]