SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244593 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244593 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40870,704377,991249,665204,892715,100803,192183,6554,827164,907864,839508,292423,333164,300352,388461,311665,707386,595656,645015,692387,841792,394213,940600,960208,132001,631938,724600,741482,355715,700917,847104,170857,930137,225419,30923,358664,52735,548321,582765,854930,347796,963829,1018754,836127,462108,106571,19341,325781,611517,68648,904348,270954,63319,521596,951626,322910,12317,165933,72914,277540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]