SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529401 LIMIT 1 [ RunTime:0.007979s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529401 [ RunTime:0.003902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628043,672110,594171,532988,345302,965849,97970,775416,693859,539327,572178,525513,608329,720805,1038784,466874,789276,450807,80661,53334,730691,307482,215596,70065,183040,682935,628132,109386,292262,345640,549956,355895,1038134,709024,438585,1020421,232545,935170,546164,300177,806219,385965,833910,434543,797132,438438,195472,560935,448933,519000,376192,974714,174296,785270,611800,222525,575132,62598,861208,958944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]