SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198936 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198936 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840046,929403,1025067,987422,32993,391389,67291,435961,256644,929649,59880,609998,1015971,712334,363826,702093,973205,94590,1035195,532005,662114,890499,690469,331237,500382,668091,192475,868569,267009,374202,954751,414800,70792,250146,661534,744614,445880,496750,495560,940369,340442,816873,477616,701677,384965,861494,271882,124187,963009,581162,137331,44097,229175,236819,73515,474154,160690,446791,1044987,106723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]