SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294041 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294041 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223939,968299,405553,391004,592905,814346,451454,68836,972124,70455,1012084,738981,329708,4907,858228,381694,232010,615788,590909,786414,571945,749274,620139,486170,963372,729418,501298,496447,116744,127160,30918,163247,357693,500068,616085,1040272,566309,197828,773282,157138,482105,296409,421704,446673,680961,245501,631494,527052,970802,241901,790226,412527,439880,412167,283798,537200,831458,873455,274336,272943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]