SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540883 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540883 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131923,389959,245372,787066,887662,366341,854508,576135,704012,297785,150226,787266,237045,24057,946205,302953,966897,223414,122137,643461,695660,1016201,290566,470455,750827,800655,916384,373522,727848,74495,433388,483252,105004,466683,241696,567291,912826,100524,538095,46519,182021,906785,30,865165,308307,243447,953653,276087,321979,836656,1025455,774734,1030596,157238,419969,31940,766039,694237,429359,178164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]