SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048317 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048317 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047301,308095,282306,500009,703779,415579,926554,241067,386401,93557,573428,785317,282583,438417,758494,324312,789088,773716,968835,122451,14612,1041772,449094,286555,796684,761901,706599,442606,432049,103739,333493,908381,7397,275262,258935,837325,1022859,135752,764817,635910,359001,201289,535678,352420,685629,925361,700216,1036256,880695,761389,18736,663624,449349,282821,986330,742945,871659,552392,319872,159136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]