SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438176 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438176 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435893,380299,161749,183943,565771,161051,238665,690518,389583,537379,922818,626224,37317,659933,831438,663384,456,680302,879005,604191,165739,910906,474093,977687,797043,725607,937162,306544,818224,579119,391845,140100,952576,714748,127453,365835,303848,850907,639230,924101,780971,967182,38416,504274,127747,568555,1005016,83869,14363,750264,61407,645133,55322,217228,939546,382197,804079,481490,493159,433374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002633s ]