SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517328 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517328 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480688,46019,743041,445388,118275,670986,994527,177615,955881,56417,28047,505156,221591,851865,364931,503621,123428,767886,72482,509166,111555,526199,803190,444950,483222,275123,949474,917700,1020218,157333,804605,961152,268800,85081,149365,11669,98800,238982,684930,643217,121850,410577,700279,767419,886893,536674,713875,580334,211738,244416,651014,200213,838867,55446,694484,385842,118476,919941,85622,268000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]