SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001561s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149808 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149808 [ RunTime:0.003399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529661,136735,509277,760743,899632,544181,80185,900093,901151,868342,140445,744121,427866,980866,796493,791350,180644,87222,745971,412862,138772,589666,427457,704695,575681,1035919,606772,175577,52717,28739,884658,659855,957527,365152,621965,668075,89800,913963,1011593,656391,529106,877814,76473,1764,791744,627049,121727,234401,38967,727145,866835,822742,826998,801943,150772,438574,772661,550698,1037005,340505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]