SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547893 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547893 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139535,344345,1039895,662167,867751,37900,942965,348047,25568,167803,962805,220680,434595,975697,281302,201616,394445,290743,69238,574604,232887,45283,742972,20756,1026944,507476,527324,680022,66687,830830,257709,763282,621841,344426,786876,196960,377900,252986,867109,893603,178491,419381,496874,154422,81069,73031,399924,656361,782760,264211,682407,144295,167014,711133,799872,578456,833481,304237,645373,542532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]