SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10471 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10471 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435008,678421,668967,546965,201096,390907,607492,596309,345684,194509,5612,753492,113854,730271,398918,70543,486738,150924,190453,738819,276042,614571,449959,694902,771196,1013712,890163,552623,272986,745744,10222,239514,120610,495350,833431,1045435,380318,820706,586520,830392,945972,107980,613844,776956,332900,40137,921097,485003,885864,847349,115749,143743,980252,875414,846609,413532,48902,428385,759528,1040791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]