SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180510 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180510 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436575,325641,1046472,31202,113823,366745,89944,787014,736644,892034,423091,660413,538337,87824,965470,843513,527712,844669,283863,685379,145129,330512,909022,573663,20495,572551,324481,1035578,705662,619266,532982,497631,913256,373703,1043383,15775,404091,762951,138882,766320,941150,108777,8265,152306,850376,939797,62384,598687,1043727,557513,839607,486186,61393,324215,172457,209456,736414,6731,512734,490294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]