SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588710 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588710 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267570,106032,171947,915621,177001,633130,576989,597047,159541,916137,940367,697698,937004,105518,879,561717,318347,300663,806228,359104,192973,652875,416604,905171,719710,279424,40748,761203,682580,984107,627988,769784,460558,734137,830386,120108,491564,913340,469666,825703,336503,17623,106476,652696,200768,454197,74523,746239,788188,325269,971741,741808,429492,364524,385739,142616,246279,15033,145785,957808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]