SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586801 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586801 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783846,955341,241202,839776,922920,323777,960653,598011,596810,990746,741032,51039,42150,374064,287456,46216,460747,94073,317718,625454,342883,829645,436216,505453,98590,228510,28945,467579,658240,842934,931585,682704,74361,333092,110619,367253,392782,144791,344947,282460,232461,872773,250017,743220,261677,617827,404411,844190,814772,430910,120497,470136,663513,474910,485466,811388,943567,362691,687587,265129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]