SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001642s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331070 LIMIT 1 [ RunTime:0.001864s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331070 [ RunTime:0.002069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151719,990980,127356,146020,792636,371003,1002093,10427,835284,1021766,639584,951888,1028030,51647,326373,717213,590622,449167,983689,354684,752526,512416,743922,953770,203152,523522,128516,884394,91617,116056,258956,828293,814410,653158,491215,716282,342342,409511,214017,397337,360772,322347,413203,883396,372129,499065,597518,670144,366925,21700,882575,874374,183542,950,389720,983991,816145,629806,940555,1031051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]