SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 384543 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 384543 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611870,381937,135853,673955,1005304,507249,877460,20631,946479,252256,864830,131193,512100,506060,792923,526756,569616,335999,129944,992630,772160,683252,698511,12836,345039,847002,369240,649781,512493,478870,545726,302141,535075,184771,973104,431382,524083,290815,668212,445799,466060,276720,584060,627281,1035272,540233,742865,694463,624415,241569,365047,411619,1006169,502447,847059,162029,712847,716132,943739,409099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 384543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 384543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]