SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 181781 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 181781 [ RunTime:0.003232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502692,367316,910095,577307,175107,193961,139731,543523,450941,688453,596288,88157,202801,335397,878295,985688,305002,376136,584880,772718,762998,763030,818647,289366,919499,452457,117013,135796,504810,1045819,942648,413124,659500,503306,30642,621237,392332,485987,293253,325112,642952,539957,173560,569777,383747,578094,102799,529926,619802,587905,193290,536677,44952,226286,856390,752702,645542,934470,672790,166298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 181781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 181781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]