SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294323 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294323 [ RunTime:0.007032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703014,232325,165438,1039864,1012624,393707,310641,937146,819669,370033,351421,607688,426167,812867,665951,482153,365633,717148,234965,569950,922535,678557,935386,604858,943142,367070,153337,104742,586113,139513,163019,106486,864620,931419,86415,761704,550420,67299,170312,1025790,941818,645431,437720,1023856,223028,188685,622436,892710,128344,937995,550588,678364,784718,799582,510566,921524,554335,522608,401497,510380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]