SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 702948 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 702948 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302875,635102,869897,577281,520905,82787,234294,506094,664007,992834,197599,801296,1045284,988501,856566,149902,142559,255258,42501,542924,535998,792931,888967,87935,461694,47555,76802,560647,138346,452911,966185,400399,297843,521502,282979,996207,693111,351517,693613,183048,824970,616279,18529,347401,694192,528170,995558,686948,657109,201811,550334,52905,56457,560569,469325,532458,998003,866112,987291,938933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 702948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 702948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]