SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195891 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195891 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490572,143325,871048,827387,673067,29015,544407,831303,732104,964984,559731,789579,476364,581289,419463,948348,548366,872945,868453,514802,138362,218180,291481,812177,1044416,651245,459984,774148,702320,295685,25795,572279,723780,807827,162920,652595,614569,281797,175521,765649,156699,134642,714553,78369,387258,408173,405521,845021,298073,758453,569794,452776,1034487,1018513,817693,201080,731413,582564,940229,339283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]