SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455113 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455113 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950622,474895,616315,273497,954343,498155,564135,896348,396417,545942,246152,145793,58085,834787,366409,513667,14231,167153,221876,330525,929210,679004,1305,155042,265700,641861,109606,505354,818630,731753,618633,660094,772606,978139,829221,383389,487263,614038,618059,78482,763253,183429,562034,414607,385239,1003167,137503,100399,147065,540693,236819,639218,569481,538520,569051,192227,592779,978155,96990,267667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]