SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199963 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199963 [ RunTime:0.002747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146715,201765,972779,276354,164647,578539,996051,584092,341610,513868,539627,926690,33621,398802,143404,476698,824847,419378,641288,279737,1043239,266319,400867,464524,614126,241811,600347,909952,690886,57775,358163,144621,1035394,286109,69607,307617,476956,518629,1023299,466190,425138,740428,897837,885791,660511,965324,861406,612626,96619,77032,206091,760054,352113,990571,58718,651582,833763,280812,671480,1022841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]