SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201701 LIMIT 1 [ RunTime:0.001505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201701 [ RunTime:0.002679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545010,383740,467743,946354,662853,42200,969146,267109,1035955,176477,1013414,717020,809370,21345,49554,589862,691248,865805,998066,145324,202782,26674,184092,123990,788825,431213,81860,1046825,702872,783280,142444,704059,211852,71517,167907,237083,41057,248629,189275,1031144,287220,378686,810175,217717,353638,57216,119587,404028,200944,444830,168828,320601,137419,862686,979750,594521,1031488,711139,969695,609264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]