SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 832311 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 832311 [ RunTime:0.005427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717808,655121,137345,845864,238946,260200,114458,520049,704665,180375,245812,826560,523566,353747,847164,500358,344378,366025,654859,928608,480093,321791,317752,779988,207879,631085,1047661,822994,459895,259135,38842,1008547,828237,177739,573669,830783,416905,703246,153594,31687,426619,412322,766391,616613,241362,179184,629398,967562,152750,112104,580297,615926,732018,446733,657602,1019409,759651,359451,811872,861736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 832311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 832311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]